Current State of the Business: Net Sales & Returns Pages
The Net Sales page is the first of two pages in the report that give the state of the business. At the top, two cards are being used to call out the most important KPI’s, which in this case is Net Sales and Units Sold.
Below the KPI’s, are three visuals: Category Breakdown, Store Breakdown, and a Q&A visual.
Category Breakdown shows the net sales of Microsoft themed skateboards, and the visual to the right of it shows net sales by store. When you hover over a data bar in Category Breakdown, a report page tooltip will show up and provide more information about that particular product.
The Category Breakdown and Store Breakdown visuals have buttons at the bottom where you can toggle between the visual and an alternate view. (In Category Breakdown, you can see a tabular view. In Store Breakdown, a map.) These alternate views have been created using bookmarks.
The map visual in this report is the Mapbox custom visual from AppSource. Visuals from AppSource work well with core Power BI visuals. You can still click on them and they will interact with other visuals to relevant cross highlighting or filtering.
The Q&A visual lets you dig deeper to find additional details in the data. It’s a useful tool for report authors to build reports and for report consumers to explore the data. You can follow this link to learn more about how to use the Q&A visual.
At the top of the page, you’ll also see a button that says Key Influencers
Clicking on it will open a view of the Key Influencers visual. In the context of this report, you can use it to analyze the demographics of customers.
There is also a button to see a Decomposition Tree visual.
You can use the Decomposition Tree to drill into any dimension to understand what is driving a key metric. The Decomposition Tree is currently in preview, so if you are viewing this report in Power BI Desktop, please turn on the Decomposition Tree preview feature.
The returns page is set up to have the same structure as the Net Sales page, but with information about returns. You can take the same actions displayed in the Net Sales page and explore the state of Returns.
The Net Sales and Returns pages were also designed for a mobile experience. When you create reports for executives or people who are always on the go, it’s important to think about how you can also optimize your report for mobile. To create a mobile view, go to the View tab in the ribbon, and press Phone layout.
Analysis: Return Rate & Market Basket Analysis Pages
As stated previously, this report can be used to find out the current state of the business and used for analysis to help you take action.
Starting from the Net Sales page, you can right-click on a data bar to find different insights.
Once you select “Find where this distribution is different”, another window will open as an analysis is being run on your data. This window lets you scroll to explore possible explanations for where the distribution is different, and the visuals in the window are interactive. You can click on data points in the suggested visuals and slice the data by pressing segment buttons.
Another way you can incorporate analysis into your report is to use drill through. Staying on the Net Sales page, if you right click on a data bar, you will see the option to Drill through to two other pages that have been set up for this report: Return Rate and Market Basket Analysis.
Note: In this report, you can also go to the Returns page, right-click on a data bar in “Category Breakdown” and see your drill through options.
Let’s say you want to learn more about XBOX skateboard sales. Once you drill through to the Market Basket Analysis page, on the left, you can learn more about how the XBOX skateboard is performing. On the right is a custom visual cluster map.
The cluster map shows that customers who buy XBOX skateboards are likely to buy XBOX One skateboards as well. Because this report was created for multiple audiences, someone who is in an operations role could even prepare for an influx in sales of a product by pressing “Open Power App” and ordering more skateboards.
Because Power Apps visuals can only be viewed by those who are in the same organization as you, when you press “Open Power App” we’ve embedded a video that shows an example of a Power App you could embed for your own organization.
This is just one of the ways you can use a Power App visual into your Power BI reports to bridge the gap between workflows in your organization. This report empowers its report viewers to take action based on the data in their organization.
Going back to the drill through options, you may have noticed that there was another drill through called “Return Rate”. If you right-click and drill through on the OneNote data bar, you are taken to a page that gives information about the returns of the OneNote skateboard.
The visual on the left tell says that the return rate of OneNote skateboards is 55%. The main two other visuals on the page show “What if” analysis. You can change the slicer towards the top of the page and ask, “What if the return rate changes?”
Changing the return rate in the slicer will change the forecast numbers that are projected and the associated visuals.
With “What if”, this skateboard company can learn how their profits can be affected. The “What If” Analysis Forecast visual can also help the skateboard company decide to order more OneNote skateboards in February but decrease their stock of OneNote skateboards in April. Toggling this visual to Extra Profit shows a stacked column chart that displays how much more the company can make by decreasing their return rate.
The large amount of purple in January shows that the company should increase their focus on reducing returns of OneNote skateboards in January and that June may not be impacted by returns of OneNote skateboards very much.