Data modelling

[#1]

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

[MayilVahanan]

HI

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.

[jagan · Accepted solution]

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.

[PrashantSangle]

Hi,

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

Regards

[tulasiram_bitra]

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);

[PradeepReddy]

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 *;

[#7]

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

[#8]

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

[jagan]

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.