Adventure Works: Power Bi
Jay Mistry
Analytical Professional | Transforming Data into Actionable Insights for Optimal Operations
For this project, I visualized the sales and returns data from a bike shop called Adventure Works using Power BI. I visualized global data spanning time periods, goods, and customers using methods I learnt in the course.
I chose to utilize this project solely as a way to learn visualization and analysis techniques.
The Data:
I began by organizing the tables, connecting and structuring the data, and performing basic data quality assurance. Then, after learning about relational models, cardinality, and filter flow, I made my own data model.
Here, I am attaching the data model for better understanding of the available datasets.
Following to this, I used some of the interesting DAX functions to create new measures which will be useful for further analysis.
Some of my favorites' and very powerful DAX functions are,
CALCULATE() : it allows you to overrule existing report filters and “force” new filter context.
RELATED() : Returns related values in each row of a table based on relationships with other tables.
ALL(): Returns all rows in a table, or all values in a column, ignoring any filters that have been applied.
Iterator Functions: Iterator (or “X”) functions allow you to loop through the same expression on each row of a table, then apply some sort of aggregation to the results (SUM, MAX, etc.)
After Creating A new separate tables for created measures, finally comes the visualization part.
I created 4 dashboards and 1 Decomposition tree which are pretty much required depth knowledge of visualization skills. I am attaching screenshots of dashboards to share details and findings.
1)???Executive Dashboard – A high level summary of the entire data set.?
领英推荐
Key Insights:
2) Map – A visual to learn about using geospatial data & tooltips.
3) Product Details Dashboard: This dashboard is drill through Type, Which shows more details for particular products shown in the top 10 table of executive dashboard.
4) Customer Details: This dashboard displays customer level KPIs.
5 ) Decomposition Tree: I added decomposition tree using AI features available in Power Bi to show data (total orders) across different categories and subcategories.
Thank you, for reading the article.
Data Analyst | Business Analyst | BI Analyst | Data Visualization | SQL | Python | Power BI | Business Intelligence | Data Analytics | Process Analyst | Lean Six Sigma Consultant | Lean Six Sigma Green Belt
9 个月Hi Jay, Thank you for sharing your project, Your use of drill-through functionality and the decomposition tree to provide detailed insights is impressive.What additional challenges did you face while creating these dashboards, and how did you overcome them?
Analytical Professional | Transforming Data into Actionable Insights for Optimal Operations
1 年Live dashboard link : https://app.powerbi.com/view?r=eyJrIjoiODMxNDg3YTctZGFkMi00ZmViLWJkYjgtNWY5YzVmZGNjNzgyIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9
Great work on this, Jay Mistry! What are you tackling next?