DSA BUSINESS INTELLIGENCE WITH POWER BI CAPSTONE PROJECT

Adventure Works Bike Shop (Sales Report)

• Situation (Introduction)

You've just been hired as a Data Analyst at Adventure Works Bike Shop. Your first Job Order (JO) is to design and deliver an end-to-end data analytics solution for Sales Department from SCRATCH!

• Task (Problem)

The Sales Manager disseminate your key tasks to develop an end-to-end data analytics solution Sales Dashboard. All have you given are 7 datasets in CSV format named: Customer, Product, Reseller, Sales Territory, Sales Data, Sales Order Data, and Date Table.
You are expected to Prepare the data (extract, clean, and transform data), Model the data, Analyze and visualize, and Provide data-driven insights.

• Action (Objective & Solution)

Utilize Power BI Desktop to:
-     Prepare the data using Power Query, create new dimensions/ measures as required,

-     Model the data effectively,

-     Analyze data to discover patterns and trends,

-     And finally create data-driven insights through dashboard.

• Result (Benefits)

Streamlined data processing, enhanced data modeling, insightful analysis, and actionable insights through an intuitive dashboard interface at a glance.