Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Having an assignment in Power Bi can anyone tells me how should I group my information which columns should be grouped in which categories and

Having an assignment in Power Bi can anyone tells me how should I group my information which columns should be grouped in which categories and what should be my dim tables and my fact tables for The star scheme?image text in transcribed

- Order_IDSegment Product_ID Product_Name Supplier Order_001 Government H001 Fork Lift 4-Wheel Jansen Order_002 Government H001 Fork Lift 4-Wheel Jansen Order_003 Midmarket H001 Fork Lift 4-Wheel Jansen Order_004 Midmarket H001 Fork Lift 4-Wheel Jansen Order_005 Midmarket H001 Fork Lift 4-Wheel Jansen Order_006 Government H001 Fork Lift 4-Wheel Jansen Order_007 Midmarket H002 Stacker Pietersen Order_008 Channel Partners H002 Stacker Pietersen Order_009 Government H002 Stacker Pietersen Order_010 Channel Partners H002 Stacker Pietersen Order_011 Midmarket H002 Stacker Pietersen Order_012 Enterprise H002 Stacker Pietersen Order_013 Small Business H002 Stacker Pietersen Order_014 Government H002 Stacker Pietersen Supplier_Country Discount Sales Quantity Cost Price Sales Price Gross Revenue Discount Net_Revenue Total Cost Gross_Profit Gross_Profit_%Date Month Great Britain None 1619 10.00 20.00 32,380.00 32,380.00 16,190.00 16,190.00 50% 01/01/2019 1 Great Britain None 1321 10.00 20.00 26,420.00 26,420.00 13,210.00 13,210.00 50% 01/01/2019 1 Great Britain None 2178 10.00 15.00 32,670.00 32,670.00 21,780.00 10,890.00 33% 01/06/2019 6 Great Britain None 888 10.00 15.00 13,320.00 13,320.00 8,880.00 4,440.00 33% 01/06/2019 6 Great Britain None 2470 10.00 15.00 37,050.00 37,050.00 24,700.00 12,350.00 33% 01/06/2019 6 Great Britain None 1513 260.00 350.00 529,550.00 529,550.00 393,380.00 136,170.00 26% 01/12/2019 12 Germany None 921 10.00 15.00 13,815.00 13,815.00 9,210.00 4,605.00 33% 01/03/2019 3 Germany None 2518 3.00 12.00 30,216.00 30,216.00 7,554.00 22,662.00 75% 01/06/2019 6 Germany None 1899 10.00 20.00 37,980.00 37,980.00 18,990.00 18,990.00 50% 01/06/2019 6 Germany None 1545 3.00 12.00 18,540.00 18,540.00 4,635.00 13,905.00 75% 01/06/2019 6 Germany None 2470 10.00 15.00 37,050.00 37,050.00 24,700.00 12,350.00 33% 01/06/2019 6 6 Germany None 2665.5 120.00 125.00 333,187.50 333,187.50 319,860.00 13,327.50 4% 01/07/2019 7 Germany None 958 250.00 300.00 287,400.00 287,400.00 239,500.00 47,900.00 17% 01/08/2019 8 Germany None 2146 5.00 7.00 15,022.00 15,022.00 10,730.00 4,292.00 29% 01/09/2019 9 - - - - - Order_IDSegment Product_ID Product_Name Supplier Order_001 Government H001 Fork Lift 4-Wheel Jansen Order_002 Government H001 Fork Lift 4-Wheel Jansen Order_003 Midmarket H001 Fork Lift 4-Wheel Jansen Order_004 Midmarket H001 Fork Lift 4-Wheel Jansen Order_005 Midmarket H001 Fork Lift 4-Wheel Jansen Order_006 Government H001 Fork Lift 4-Wheel Jansen Order_007 Midmarket H002 Stacker Pietersen Order_008 Channel Partners H002 Stacker Pietersen Order_009 Government H002 Stacker Pietersen Order_010 Channel Partners H002 Stacker Pietersen Order_011 Midmarket H002 Stacker Pietersen Order_012 Enterprise H002 Stacker Pietersen Order_013 Small Business H002 Stacker Pietersen Order_014 Government H002 Stacker Pietersen Supplier_Country Discount Sales Quantity Cost Price Sales Price Gross Revenue Discount Net_Revenue Total Cost Gross_Profit Gross_Profit_%Date Month Great Britain None 1619 10.00 20.00 32,380.00 32,380.00 16,190.00 16,190.00 50% 01/01/2019 1 Great Britain None 1321 10.00 20.00 26,420.00 26,420.00 13,210.00 13,210.00 50% 01/01/2019 1 Great Britain None 2178 10.00 15.00 32,670.00 32,670.00 21,780.00 10,890.00 33% 01/06/2019 6 Great Britain None 888 10.00 15.00 13,320.00 13,320.00 8,880.00 4,440.00 33% 01/06/2019 6 Great Britain None 2470 10.00 15.00 37,050.00 37,050.00 24,700.00 12,350.00 33% 01/06/2019 6 Great Britain None 1513 260.00 350.00 529,550.00 529,550.00 393,380.00 136,170.00 26% 01/12/2019 12 Germany None 921 10.00 15.00 13,815.00 13,815.00 9,210.00 4,605.00 33% 01/03/2019 3 Germany None 2518 3.00 12.00 30,216.00 30,216.00 7,554.00 22,662.00 75% 01/06/2019 6 Germany None 1899 10.00 20.00 37,980.00 37,980.00 18,990.00 18,990.00 50% 01/06/2019 6 Germany None 1545 3.00 12.00 18,540.00 18,540.00 4,635.00 13,905.00 75% 01/06/2019 6 Germany None 2470 10.00 15.00 37,050.00 37,050.00 24,700.00 12,350.00 33% 01/06/2019 6 6 Germany None 2665.5 120.00 125.00 333,187.50 333,187.50 319,860.00 13,327.50 4% 01/07/2019 7 Germany None 958 250.00 300.00 287,400.00 287,400.00 239,500.00 47,900.00 17% 01/08/2019 8 Germany None 2146 5.00 7.00 15,022.00 15,022.00 10,730.00 4,292.00 29% 01/09/2019 9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Authors: Francesca Cesarini ,Silvio Salza

1st Edition

3540179429, 978-3540179429

More Books

Students also viewed these Databases questions

Question

=+ Have they changed the way employers view IP?

Answered: 1 week ago