A sample Power BI dashboard template using a supermarket as a guide, created by the editors of Solutions Review.
Microsoft Power BI is one of the most used business intelligence and data analytics platforms in the world. Power BI is cloud-based and delivered on the Azure cloud. On-premises functionality also exists for individual users or when power users create complex data mashups using internal data sources. Power BI is unique because it allows users to perform data preparation, data discovery, and dashboards with the same design tool. The platform integrates with Excel and Office 365 and has a very active user community that extends the capabilities of the tool.
To build dashboards, you can connect to Power BI gateways, SQL Server databases, analytical services, and other data sources. To give you a unified experience, reporting portals integrate Power BI dashboards and reports. A Power BI dashboard, also called a canvas, is a page that uses visualizations to tell a story. A well-designed dashboard contains only the most essential elements of this story because it is only one page. A dashboard is more than a pretty picture. It is interactive and customizable. As the data changes, the tiles will update.
Tiles are used to describe visualizations on the dashboard. These tiles can be pinned to the dashboard using reports. Each report is responsible for the visualizations displayed on a dashboard. One way to view a dashboard is to view it as an entry point to the underlying datasets and reports. Clicking on a visualization takes you to the report and dataset used to create it.
Dashboards can be a great way to track your business, find answers, and see the most important metrics all in one place. A dashboard can be derived from one or more underlying datasets or from one or more underlying reports. A dashboard can combine on-premises data with data from the cloud to provide a single view, regardless of location.
Sample Power BI dashboard template
A sample Power BI dashboard with multiple data types can help you understand the benefits of Power BI. Each type of data has the potential to provide valuable business insights. Consider the example of a retail supermarket, where data can be used to unlock insights into regional sales, individual store transactions, and product categories.
The following points are relevant to the business perspective of the use case:
- Which region is more profitable than others?
- What customer segments should you focus on?
- Identify segments that can reduce investments.
To better understand the above points, you will need to change the way data is processed. The objective is to increase the productivity and profitability of the company. Let’s see what insights we can glean from supermarket data.
- Supermarket sales and performance: This is the first step in understanding the performance of the hypermarket over time. We need data on Sales for different regions each quarter. It is also essential to determine which regions are more profitable than others.
- Performance of the different states: Once we have regional profit and loss information, it is possible to create a A cloud of dots of “sales to profit” at the national and regional levels, where sales and profit are X and Y, respectively. To understand different situations, these states can be mapped. A company may decide to invest more in a state where sales are lower but profits are higher. If sales increase but profits decline, another state could be reported.
- Performance of the different customer segments: It is also essential for a business to identify which customer segment generates sales in different areas. A pie chart showing customer segments and sales/profits can be used to help businesses plan their future strategies. For example, the B2B consumer segment may generate the highest profits, but make very few sales. There is a huge opportunity to grow the B2B segment.
- Revenue generation by category: We may obtain data on specific product categories in specific regions or customer segments and compare them (in terms of sales and profits). Valuable information can be obtained to help you plan for the future.
Total sales and profit
The screenshot below shows that I have used the map representation and given status and “profit” fields. This visualization shows us state-specific “profit leaders”. The large bubbles represent them.
This visualization can be saved or published immediately. Instead, I would add a page for each visualization and publish the entire report. This will allow you to easily pin visualizations to the Power BI dashboard and avoid cluttering a page with multiple visualizations.
You can do this easily by clicking on the plus sign at the bottom left of the screen. Your new page will be created. This will allow me to create the following visualization.
I selected a line chart to visualize the profit, sales, and order date fields. After creating the visualization, I changed the timeline to show “quarterly” instead of “yearly”. This can be done by clicking on the navigation located in the upper right corner. The same is true for the image below.
The image above clearly shows that sales increased in the second quarter. Interactive visualizations can be used. The graph will display statistics if you hover the mouse pointer over it, as it does in the image.
Performance of the different states
The following visualization shows me creating a scatter plot, with the X axis representing sales and Y representing profit. I have selected a few for the profit and sales axis.
This visualization can be used to help us divide states into three strategic activity areas: Conserve. To develop. Strip. States in the upper right corner have high sales and profits, and companies would like to maintain this position. The company can view states to the right or in the middle line as an opportunity. This is where sales growth could help increase company profits – Develop a strategy. States with low sales, low profits, or higher sales but lower profits are not areas where the company should focus on divestment. It’s a great way to formulate a business investment strategy.
Performance of different customer segments
We can now see which consumer segments are driving sales and profits at the state and regional level and determine which segment to target (corporate, customer, and corporate).
We can see, for example, that the consumer segment of the Central region contributes 50% of sales, but has a low share of profits. However, the business segment has a higher profit share and a lower sales contribution. The company should increase the contribution of the company’s sales to improve its profitability.
Revenue generation by category
Then we can get information at the product category level. It is possible to determine which product has the highest sales and profits in each region or consumer segment. How different product categories have performed in terms of sales and profits.
Power BI lets you add multiple filters to your data to get the precise information you’re looking for. To change the representation of the data, click on the zoom button located in the upper left corner. To view supermarket sales, you can view them by category or subcategory according to your needs.