I will fix and optimize your slow power bi report, data model and dax
Data and BI Analyst specialized in Power BI, DAX and SQL
About this Gig
Is your Power BI report slow, wrong or impossible to maintain? I fix it.
I am a data and BI analyst with 8 years of experience in reporting and analytics, working every day with Power BI, DAX, Power Query and SQL. Most performance problems come from the same places: a flat table instead of a star schema, calculated columns doing the work of measures, bidirectional relationships, DAX written with FILTER where a filter argument would do, and queries that stop folding back to the source.
What you get:
- A written diagnosis of your file, with problems ranked by impact
- - A star schema data model with clean relationships
- - DAX measures rewritten to be faster and easier to read
- - Power Query steps reorganised so query folding is preserved
- - Refresh and rendering times measured before and after
- - A short summary of what was changed and why
I work with .pbix files connected to Excel, CSV, SQL Server, PostgreSQL and other relational sources.
Not sure which package fits? Write me a short description of your file and I will tell you honestly what it needs.
Analysis type:
Descriptive Analysis
•
Diagnostic Analysis
Expertise:
Business Insights
•
Trends
Technology:
Excel
•
Power BI
Programming language:
Python
•
SQL
•
DAX
