topic Re: Data modelling in QlikView

Data modelling

Fri, 08 Jan 2016 08:43:59 GMT

After loading all tables i got this data model please help me to do data model

Re: Data modelling

MayilVahanan — Fri, 08 Jan 2016 09:00:23 GMT

Change the Customer table information by adding Customer prefix in Address, city, postal code and country.

ex: Customer_Address

Same thing applicable for supplier. ex:Supplier_Address

In shipper table, rename the phone as "Shipper_phone". Shipper ID is join with order table. So you can able to get the shipper phone and name information.

Re: Data modelling

jagan — Fri, 08 Jan 2016 09:04:35 GMT

Hi Naveen,

Things to follow while creating datamodel.

1. Load only the required fields. I think fields like Phone, ContactNumber, Address, Postal Code, Country is not going to use for Analysis. If you really require rename the fields like below

Customer Table:

ContactNumber AS CustomerContactNumber

Address AS CustomerAddress

City AS CustomerCity

PostalCode AS CustomerPostalCode

Country AS CustomerCountry

Supplier Table:

ContactNumber AS SupplierContactNumber

Address AS SupplierAddress

City AS SupplierCity

PostalCode AS SupplierPostalCode

Country AS SupplierCountry

2. Load only the required tables.

This will solve most of your datamodel issues.

Hope this helps you.

Regards,

jagan.

Re: Data modelling

PrashantSangle — Fri, 08 Jan 2016 09:12:19 GMT

Hi,

Rename your suppliers attributes from Supplier Table except SupplerID will resolve your issue.

Regards

Re: Data modelling

tulasiram_bitra — Fri, 08 Jan 2016 10:01:27 GMT

Hi Sai,

Use below Script. It may useful.

Category:

LOAD CategoryID,

CategoryName,

Description

FROM

(ooxml, embedded labels, table is Category);

Customer:

LOAD CustomerID,

ContactNumber as Customer_ContactNumber,

Address as Customer_Address,

City as Customer_City,

PostalCode as Customer_PostalCode,

Country as Customer_Country,

CustomerName

FROM

(ooxml, embedded labels, table is Customer);

Employee:

LOAD EmployeeID,

LastName,

FirstName,

BirthDate,

Photo,

Notes

FROM

(ooxml, embedded labels, table is Employee);

Order:

LOAD EmployeeID,

ShipperID,

CustomerID,

OrderID,

OrderDate

FROM

(ooxml, embedded labels, table is Order);

OrderDetail:

LOAD OrderID,

ProductID,

OrderDetailID,

Quantity

FROM

(ooxml, embedded labels, table is OrderDetail);

Product:

LOAD CategoryID,

ProductID,

SupplierID,

ProductName,

Unit,

Price

FROM

(ooxml, embedded labels, table is Product);

Shipper:

LOAD ShipperID,

Phone,

ShipperName

FROM

(ooxml, embedded labels, table is Shipper);

Supplier:

LOAD SupplierID,

Phone as Supplier_Phone,

ContactNumber as Supplier_ContactNumber,

Address as Supplier_Address,

City as Supplier_City,

PostalCode as Supplier_PostalCode,

Country as Supplier_Country,

SupplierName

FROM

(ooxml, embedded labels, table is Supplier);

Re: Data modelling

PradeepReddy — Fri, 08 Jan 2016 10:05:16 GMT

Use Qualify/Unqualify options during Suppliers/Customers tables load.

qualify *;

Unqualify CustomerID,CustomerName;

Customers:

Load * from Customers;

Unqualify *;

qualify *;

Unqualify SupplierID,SupplierName;

Supplier:

Load * from Supplier;

Unqualify *;

Re: Data modelling

Fri, 08 Jan 2016 10:14:09 GMT

Thanks for ur valuable time.........here i don't have any fact table.... should i create it or no need?

Re: Data modelling

Fri, 08 Jan 2016 10:17:47 GMT

9666982227 please ping me in whats app bro...i need ur help

Re: Data modelling

jagan — Mon, 11 Jan 2016 00:26:25 GMT

If there is no fact table, then no need to load any tables.

My suggestion for you is, before learning Qlikview you have to study some basic concepts of Datawarehousing like Dimension, Measure, Fact Table, Dimension etc.

This helps you in understanding the Qlikview concepts easily.

Regards,

Jagan.