Power BI Dashboard

A dashboard is a canvas on which you bring different elements or visualizations representing datasets together. It will give you an overview of the story that lies in the detailed BI report as it contains all the important elements from a report. A dashboard is always a single page whereas a report can be many pages long.

Benefits:

• Enhanced visibility
• Timesaving efficiency
• Better forecasting
• Key performance indicators
• Inventory control
• Real-time customer analytics
• Better decision-making

Limitations:

• Flashy or cluttered design, with users attempting to incorporate too much information without understanding constraints or considering their specific needs from the range of different measurables detailed data analyses provides.
• Difficulty in attaching supporting data to a dashboard and the failure of data to refresh automatically means that both these tasks must be done manually.
• The technology used in the development of BI dashboards differs from other software solutions already employed in organizations and can be initially difficult to understand.

Getting started with process of making dashboard:

Step-1 Importing data

Step 2: Formatting

Step 3: Modeling

Step 4: Creating a KPI for Total Sales and Gross profit

Step 5: Creating a chart showing Sales by State and Category

Step 6: Creating a chart showing Sales and Gross profit by Year

Step 7: Creating a chart showing Sales by month

Step 8: Creating a multi-row card

Step 9: Creating a map showing total units sold by state

Step 10: Adding a Slicer for Sub-categories of products

Step 11: Finish the final dashboard

Step 12: Publish the dashboard