Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize your ssas tabular models and complex dax queries
Senior Technical Architect , BI and ETL Performance Expert
I am a Senior Technical Architect and BI Lead with over 17 years of experience delivering enterprise-scale data solutions for global leaders like Shell, Centrica, and Lloyd's of London. I specialize i...
About this Gig
Is your SSAS Cube taking hours to process or your Power BI dashboard freezing? The problem isn't the visualization - it's your underlying data model.
Whether you run legacy SSAS Multidimensional Cubes or modern Tabular models, poor architecture will throttle your engine and consume massive RAM.
I am a Senior Technical Architect with 17+ years of experience in the MSBI Stack. I specialize in deep-dive performance tuning and structural modifications for SSAS, ensuring your data serves the business instantly.
What I optimize and modify:
- Cube & Model Architecture: Adding/modifying Dimension (DIM) and Fact tables without breaking existing reports.
- Query Tuning: Rewriting inefficient DAX iterators and resolving complex MDX bottlenecks.
- Structural Design: Converting wide tables into optimized Star Schemas and fixing bi-directional relationships.
- Storage: Implementing partitions and aggregations for massive datasets.
Why hire an Architect? I implement enterprise-grade best practices that I've used to manage 100+ TB environments for global leaders like Shell and Lloyd's of London.
- IMPORTANT: Please message me before ordering to discuss your environment and data volume.
_sp0yfq.jpg)
Technology:
Excel
•
Power BI
•
Tableau
•
VBA
•
MySQL
Expertise:
Business intelligence
Programming language:
Python
•
SQL
•
NoSQL
•
DAX
My Portfolio
FAQ
Do you work with both legacy Multidimensional Cubes and new Tabular Models?
Yes. With 17+ years in the MSBI stack, I am highly proficient in both legacy Multidimensional (MDX) cube architectures and modern Tabular (DAX) models, including Power BI Premium and Azure Analysis Services.
Do I need to send you my actual company data?
No. I strictly follow enterprise data security protocols. To optimize your model or rewrite queries, I usually only need the metadata/schema (e.g., a .bim, .sln, or .pbix file with the data cleared). Alternatively, we can work securely via a live screen-share on Teams or Zoom.
I need to add new Fact and Dimension tables. Will this break my existing reports?
No. As a Senior Architect, I don't just "hack" tables together. I perform a full impact analysis and dependency check before modifying your Data Source View (DSV) or model to ensure your existing SSRS and Power BI reports remain fully intact.
Can you help us migrate our old Multidimensional Cube to a modern Tabular Model?
Yes, this is a very common enterprise request. Because cube migrations vary wildly in complexity depending on your custom MDX calculations, please send me a direct message so we can scope out a custom project timeline. Click Save & Continue once you add these!
