Adventure works- Sales Analysis

This is my Project for Sales analysis On Adventure works ( A Bike Company). The goal of the project is to improve internet sales reporting by transitioning from static reports to visual dashboards.

The focus of the dashboards is on tracking product sales, customer information and performance over time.

It should allow filtering of data by Sales, product, and customer. The budget has been included in a spreadsheet for comparison with sales numbers. The analysis of sales typically involves looking back two years in time.

Tools Used : Excel | SQLServer | PowerBI

• Utilized Excel to clean and organize sales data, ensuring accuracy and reliability.
• Leveraged SQL Server for in-depth Exploratory Data Analysis (EDA), uncovering valuable insights and trends in the sales data.
• Used Power BI for data modeling, creating a robust and efficient data structure to support the development of interactive dashboards.
• Developed visually appealing and interactive Power BI dashboards with with graphs and Key Performance Indicators (KPIs), providing Sales Team with detailed overviews of internet sales per customer and per product, Enabling targeted sales strategies and customer relationship management.
• Published the Power BI dashboards to the Power BI service, ensuring accessibility and real-time data updates for stakeholders.

Here's My Github Repo for the Source Code and other Files :-

https://github.com/Harsh-2412/Sales-Analysis-Adventureworks