I loaded the AdventureWorks 2019 Database and modified it to match the current year. Using SQL Server Management Studio, I cleaned the data and extracted only the necessary tables and columns to meet the Sales Manager's requirements. I adjusted the data types for each column, gave them easy-to-read names, and saved them as CSV files.
Afterward, I imported the files into Power BI and loaded them. Then, I started creating measures, which allowed me to analyze data for all customers or individual customers, including their favorite products and the best-selling ones.