Power BI Portfolio

By Richa Bajaj

1. Management Insights Dashboard  – The report contains key measures 

– Create a Date Table

– Create a Quarter Slicer

– Create 3 cards with line chart showing the Total Sales, Profit and % Profit.

– Show the sales Comparison between Cumulative Performance vs Cumulative Performance LY using a area chart.

– Show the top 7 products using a stacked bar chart

– Performance sales per city using a stacked bar chart

2. Cost Insights Dashboard – The report contains cost Requirement Analysis e.g.

 – Total Purchase by Buying Package( Donut Chart)

 – Total PoS of Buying Package (Donut Chart)

 – Total Purchase by Colour (Vertical Bar Graph)

 – Total Purchases & PoS by Month (Line & Cluster Column Chart)

– Table Showing Supplier,Total Purchase, Total PoS, Total Quantity (Matrix Table)

– Table Showing Top 10 Items ordered as Stock Item and Total Purchase as Sales(Matrix Table)

3. Retail Dashboard – Summary of all the business unit and their performance.

– Show the sales by State

– Sales & Gross Margin by financial Year quarters

– Sales by Chain

– How diff state are performing through map

– Sales by catagory and chain

 4. International Organisations Dashboard –  The report contains information on international organisations around the world.  

  Power BI Learning Path