Overview of the main Power BI dashboard¶
This dashboard shows the key metrics you need to quickly assess traffic, costs, and profit - the business as a whole.
You can view the R7K12 demo dashboard at this link.
At the top of the dashboard are the totals for Visits, Cost, Net profit, and Average order value.
Next to them is the “From requests to sales” sales funnel. It is convenient because you can immediately see how many requests there were, how many sales there were, and the request-to-sale conversion rate as a percentage under the bar with the number of sales.
This data, like everything else on the dashboard, can be viewed for any period of accumulated statistics. To do this, in the “Dates” block in the upper-left corner, move the slider to select the period you need, or select the start and end dates of the period in the cells.
The entire dashboard is interactive. That is, if we change the period, the key metrics at the top, the sales funnel, all charts, and the graph will be rebuilt according to the data for that period.
Donut chart¶
Here, data by source is shown as shares of the quantitative value. The chart is designed to compare a particular part with the whole. Using the arrows in the upper-left corner, you can drill down into the chart to level 1 sources (that is, to utm-source), and further down to campaigns. In the same way, you can return to the original view (to the source names) with the up arrow. Each slice of the donut chart has a description next to it: the name, the quantitative value, and the percentage. If you click a part of the chart at any level, the entire dashboard is interactively rebuilt for the selected data.
Treemap¶
The space inside each rectangle is allocated based on the measured quantitative value. For example, when analyzing visits, top-level rectangles will be created for the source names: Yandex Direct, Google AdWords, Facebook, VK, and others. If you click any of these rectangles, the report is filtered by that source. The treemap has nested levels, the same as the donut chart.
Graph¶
It has three options for presenting data over time: by month, by week, and by day. It is convenient and informative for viewing changes in metrics over different time intervals. You can control it with the arrows at the top left.
By month:
By week:
By day:
You can select the values of several metrics on one graph. For example: cost and visits, or requests and net profit. This lets you see certain dependencies or gaps in your advertising strategies.
On the left there is a “control panel”, the so-called slicers. If you select another metric on the “Metric” slicer, for example “Cost”, the graph shows cost by day, week, and month. Just above the donut chart there is a label that tells you which metric is currently selected and that it is its quantitative value that is shown on the charts. If you specify another metric, its values will appear on the charts and the graph instead of the previous one.
On the “Sources” slicer, we can select a specific source to view the metrics we need for it. For example, if you select Yandex Direct and select cost on the metrics slicer, the dashboard shows how the cost changed by month, week, and day on the graph. You can see the totals for visits, cost, net profit, requests, sales, and average order value specifically for Yandex Direct. For example, suppose you want to view the net profit for Yandex. You select the Net profit metric, uncheck “Cost”, and the entire dashboard is rebuilt.
In this way, by combining slicers, you can analyze the state of your business quite quickly.