Dear All,
Please i need assistance in solving the below questions in Power BI.
1. Given what you can discern about the data, set up the appropriate relationships between the tables
Create the following calculated fields
A field that calculates the Total number of Orders of a Product
2. Create the following measures
a measure that sums up the price before discount
a measures that sums up the price after discount
3. YoY of those measures
4. A list that ranks the biggest customer in the period
Create the following new calculated tables
a category table
5. A lookup table from the embedded JSON that lists the materials in each product
Create the following filter panes
Filter by date period
Filter by customer
Filter by category
Create the following visuals on one or more screens
A summary of sales in the period ($ and count)
A YOY comparison of sales in the same period ($ and count and percent delta using cards)
A list of sales in the period with appropriate info looked up
A drill-through that displays the information for a specific record
The 2 top selling products
A customer list with a ranking value so the customer that buys the most is listed on top
Review the project and try to make it look neat and “make sense”
Make sure everything above works
Make sure that existing naming conventions for new fields and m are followed. We would like you to prefix all measures with “meas.”, and all calculated columns with “col.”
Apply appropriate field formatting including conditional formatting
Align fields and boxes and put in minimal layout items like dividers and boxes (we’re not evaluating your “design skills” – just that you can organize a screen). Please use the attachment excel document as guide. Thanking you in advance.
Please i need assistance in solving the below questions in Power BI.
1. Given what you can discern about the data, set up the appropriate relationships between the tables
Create the following calculated fields
A field that calculates the Total number of Orders of a Product
2. Create the following measures
a measure that sums up the price before discount
a measures that sums up the price after discount
3. YoY of those measures
4. A list that ranks the biggest customer in the period
Create the following new calculated tables
a category table
5. A lookup table from the embedded JSON that lists the materials in each product
Create the following filter panes
Filter by date period
Filter by customer
Filter by category
Create the following visuals on one or more screens
A summary of sales in the period ($ and count)
A YOY comparison of sales in the same period ($ and count and percent delta using cards)
A list of sales in the period with appropriate info looked up
A drill-through that displays the information for a specific record
The 2 top selling products
A customer list with a ranking value so the customer that buys the most is listed on top
Review the project and try to make it look neat and “make sense”
Make sure everything above works
Make sure that existing naming conventions for new fields and m are followed. We would like you to prefix all measures with “meas.”, and all calculated columns with “col.”
Apply appropriate field formatting including conditional formatting
Align fields and boxes and put in minimal layout items like dividers and boxes (we’re not evaluating your “design skills” – just that you can organize a screen). Please use the attachment excel document as guide. Thanking you in advance.
