Power BI Revenue Analysis Model
Budget: $15 – $25 USD
I have a set of raw transactional records sitting in several CSV files. I need them imported into Power BI, cleaned, and reshaped into a star-style model. The core relationships I must see are Customer → Orders and Region → Revenue; anything else you add for best practice is welcome provided it remains documented.
Once the model is in place, create DAX measures for:
• Total revenue
• Number of orders
• Distinct customers
• Return rate
With those measures, build visuals that show:
• Revenue distribution by region
• Seasonal revenue patterns (month and quarter)
• Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share
• Key performance trends over time
I will consider the job complete when I receive a PBIX file that:
1. Loads directly from my CSVs with no manual fixes required,
2. Shows the specified relationships in the model view,
3. Contains well-named, commented DAX measures, and
4. Presents an insight-driven report page (or pages) covering the analyses above.
Please keep your solution inside Power BI only; no external ETL tools are necessary. Let me know if you need a small sample extract to begin.
Once the model is in place, create DAX measures for:
• Total revenue
• Number of orders
• Distinct customers
• Return rate
With those measures, build visuals that show:
• Revenue distribution by region
• Seasonal revenue patterns (month and quarter)
• Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share
• Key performance trends over time
I will consider the job complete when I receive a PBIX file that:
1. Loads directly from my CSVs with no manual fixes required,
2. Shows the specified relationships in the model view,
3. Contains well-named, commented DAX measures, and
4. Presents an insight-driven report page (or pages) covering the analyses above.
Please keep your solution inside Power BI only; no external ETL tools are necessary. Let me know if you need a small sample extract to begin.
Related categories:
Python
Visual Basic
Excel
SQL
Statistics
Statistical Analysis
Data Visualization
Data Analysis
Power BI
Data Modeling