The PL-300 Microsoft Power BI Data Analysis course, focuses on teaching methods and best practices for modelling, visualizing, and analysing data using Power BI. The course covers accessing and processing data from various sources, including both relational and non-relational databases.
I used the Labs on Skillable to familiarise myself with the Power BI, and learn content necessary to be able to sit the PL-900 exam.
While the course itself doesn't specify a single data set, it provides guidance on how to work with different types of data sources and scenarios. I learned how to prepare, model, visualize, and analyse data, as well as manage and secure Power BI reports and dashboards.
Adventure Works is a popular sample database used by Microsoft to demonstrate the capabilities of SQL Server and other Microsoft data-related technologies. It represents a fictitious bicycle manufacturing company, providing realistic data for various scenarios including product management, sales, and purchasing.
The dataset provided encompasses comprehensive sales data from VanArsdel, Ltd. and its competitors. This rich dataset spans seven years and includes daily transaction details by product and zip code for each manufacturer. My analysis will delve into data across seven different countries, providing a robust basis for insightful analysis and actionable conclusions.
The "Manufacturer Analysis" dashboard for VanArsdel, Ltd. provides a comprehensive overview of the company's revenue data, featuring prominently displayed logos for multiple companies including Fabrikam, Inc., Nod Publishers, Tailwind Traders, VanArsdel, Ltd., and Wide World Importers.
It includes a year selector with icons for play, pause, rewind, and fast forward, as well as a semi-circular gauge chart showing $47.13M out of a possible $94.27M for "Sum of Revenue and PY Sales".
A bar chart illustrates revenue by country, highlighting that the USA leads with $306.27M, followed by Australia, Japan, Germany, Nigeria, Mexico, and Canada. Detailed text analysis indicates a 197.07% increase in the "Sum of Revenue" while "% Growth" decreased by 71.19% between 2014 and 2021, with the USA accounting for 57.90% of the total revenue.
Additionally, a line graph shows "Sum of Revenue" and "% Growth" trends from 2014 to 2020, and a category table breaks down revenue, growth percentage, and PY sales by various product categories.
The dashboard also features interactive buttons labeled "Initial State," "USA Revenue," and "Australia Revenue," making it a powerful tool for understanding VanArsdel's financial performance and trends over time.
The image is a detailed "Global Tourism Insights" dashboard displaying various visualizations and data related to tourism. This comprehensive dashboard offers a clear and insightful overview of global tourism trends, highlighting key metrics like visitor numbers, revenue, and accommodation availability.
This "Store Sales Report" dashboard provides an insightful overview of sales performance. Key elements include this year's total sales of $22M, showing a slight decrease compared to last year's $23.1M, alongside the addition of 10 new stores. The sales distribution between chains is depicted with Fashions Direct contributing $6M (29%) and Lindseys $16M (71%).
This dashboard offers a comprehensive visual representation, helping stakeholders understand performance metrics, geographical distribution, and trends over time.