Mexico Toy Store Sales

For the toy store project, I began by pre-cleaning data from various sources (calendar.csv, inventory.csv, sales.csv, stores.csv, and products.csv) using Excel. Afterward, I uploaded these CSV files into Power BI for further cleaning and formatting.

I then constructed a comprehensive data model utilizing a star schema, with the "sales" table serving as the Fact Table and the other tables as Dimension Tables, ensuring seamless data analysis.

In the sales table, I created measures for total orders, total revenue, and total profit. These measures were used to create KPIs for Orders by Month, Revenue by Month, and Profit by Month.

To visualize the data, I designed a Bar Chart to display Orders by Product Category and a Line Chart to illustrate Revenue by Month. Additionally, I incorporated a Slicer filter for Store Location, enhancing the interactivity of the report.

Click to view in GitHub