Maven Market

About this project

Thanks to Maven Market project I worked through the entire business intelligence workflow: connecting and shaping the data, building a relational model, adding calculated fields, and designing an interactive report.

PART 1: Connecting & Shaping the Data

The project started with some csv files containing informations about Customers, Products, Stores, Regions and Dates as "Dimension Tables" and Transactions and Retuns as "Data Tables".

Importing data from csv file was quite easy with Power Query, but I had to be careful that data type were accurate. Following the suggested steps, I added some attributes useful for subsequent analysis, using built in functionality for calculated colums.

PART 2: Creating the Data Model

Creating data model was a fundamental step: in this phase the tables were related to obtain a snowflake schema to allow filter flow correct behavior:

All relationships must follow one-to-many cardinality
Filters are all one-way (no two-way filters)
Filter context flows "downstream" from lookup tables to data tables
Data tables are connected via shared lookup tables (not directly to each other)

PART 3: Adding DAX Measures

A few new calculated column were added in this phase to enrich the model and better categorize informations: customers were labeled by priority, products were labelad by Price Tier, and much more.

A ton of measures were created, to calculate values as total transactions and returns, KPIs as revenue, cost, profit, using some of the most important DAX functions: SUM, SUMX, CALCULATE, ALL, DIVIDE, DISTINCTCOUNT, COUNTROWS and Time Intelligence functions used to calculate common date-based comparisons (DATESYTD, DATESADD, DATESINPERIOD).

PART 4: Building the Report

The final part of the project was dedicated to bring data to life, using a variety of visuals:

Matrix, to show the Top 30 product brands by total transactions
some KPI cards to show Transactions, Profits and Returns
a Map, with a slicer and a Treemap to navigate data by geography
a Column Chart to show weekly Revenue trending and a Gauge Chart to show Revenue vs. Target