Conducted advanced analysis on the AdventureWorks sample database to explore sales, product, and customer data.
Key tasks included:
Writing complex SQL Server queries to analyze sales by region and time period.
Designing interactive Power BI dashboards to track KPIs such as total sales, top-selling products, and sales representative performance.
Performing data cleaning and transformation using Power Query.
Identifying purchasing trends and opportunities to boost sales and reduce inactive inventory.
Value Added:
Transformed raw AdventureWorks data into actionable insights that could improve marketing and sales strategies.