Toy Store KPI Report

Steps:

1. Connecting to sales data (about 1M transactions) with some dimentinal tables: products, stores and calendar
2. Building a relational data model to obtain a star schema
3. Creating some metrics with DAX (Data Analysis Expression) like Total Orders, Revenue, Profit
4. Building an Exec dashboard displaying high-leve KPIS, Orders by category, Revenue trending, with the possibility for the user to filter data by location