Build a Power BI model and dashboard based on raw data that reflects the company's key financial, marketing, and user metrics (KPI).
I will share the assignment later.
The task is aimed at assessing the ability to perform data preparation, modeling, and conversion, create calculated metrics (DAX), and dashboards.
1. Data preparation (Power Query) - Import CSV files. - Build a star-schema: facts f_payments, f_subscriptions, f_sessions; dimensions d_date, d_user, d_campaign.
- Convert all amounts to USD (according to fxRates; if there is no rate for the date, use the last available rate).
- Remove duplicate payments and sessions (±60 sec for one user and the same action).
- Provide keys for relationships between facts and dimensions.