Click here for Ascend aviation dashboard
The dashboard above is based on a fictitious drone retail business that wishes to analyse their sales data and gain insights. The information focuses on key insights, profits and performance.
Usually, the first page of a dashboard contains the most important KPI’s. You can navigate through the dashboard using the page tabs on the bottom.
Each page shows the most important trends and figures.
This project also gave me an excellent opportunity to learn DAX(Data Analysis Expressions).
That’s Power BI’s formula expression language and is used to do brilliant calculations.
Key Insights dashboard
The Key insights dashboard looks at overall revenue trends, revenue by markets as well as the businesses top five customers and products.
Profit analysis dashboard
The second page is a dashboard looking at overall revenue trend as well as a customer table breakdown by revenue, revenue contribution, profit margin contribution and profit margin. The dashboard also has a chart section detailing the company’s most profitable towns in the UK market.
Performance dashboard
The third page is a dashboard looking at revenue contribution by markets which responds dynamically to the profit target percentage which can be adjusted using a slicer at the top of the page.
A revenue trend combo chart is also included showing & comparing the selected years revenue versus the previous years figures.
Local Installation
If you’d like to get the file working on your PC, you need to download the DroneSalesInsights.pbix file and install Power BI. It’s free and you can download it from Microsoft: https://www.microsoft.com/en-gb/download/details.aspx?id=58494
Make sure you download the proper 32Bit or 64bit file, depending on which version of Microsoft Office you are using.