Answered step by step
Verified Expert Solution
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?
- 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 9Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started