Rohit transforms complex data into clear, actionable insights — driving real business decisions with precision and speed.
Built a full data warehouse in SQL within 6 months covering Finance, Procurement, CRM, and HR analytics. Data ingested from Dynamics 365 via Azure Services for two major UAE enterprises.
Designed and deployed Power BI dashboards to monitor daily taxi operations across Dubai — visualizing 100+ KPIs including live revenue, trip volume, idle time for CXO, Fleet Admin, Finance, and Operations teams.
Constructed an end-to-end data pipeline using Azure Data Factory and Databricks, integrating D365, Oracle Fusion, Salesforce CRM, and MoHRE data sources into a unified analytics layer.
Executed the full transition of a data platform from AWS to Microsoft Fabric using Medallion Architecture (Bronze, Silver, Gold layers), enabling scalable and structured data processing.
Developed star and snowflake schema models with complex T-SQL queries in Power BI for HR and Shared Services, reducing government penalties by 30% for the Ministry of Human Resources and Emiratization compliance.
Automated driver penalty, commission and performance reporting pipelines using scheduled Power BI refresh and AWS services — reducing manual reporting efforts by over 70%.
Fabric Analytics Engineer Associate
Microsoft CertifiedFabric Data Engineer Associate
Microsoft CertifiedPower BI Data Analyst Associate
Microsoft CertifiedFabric Analytics Engineer Associate
Microsoft CertifiedFabric Data Engineer Associate
Microsoft CertifiedPower BI Data Analyst Associate
Microsoft CertifiedPower BI, DAX, KPIs, dashboards, and data storytelling
3 ArticlesAzure pipelines, Databricks, Fabric, and architecture patterns
3 ArticlesTips on breaking into data, certifications, and consulting life
2 ArticlesA deep dive into DAX patterns that transformed my Power BI reports — covering CALCULATE, time intelligence, and context transitions.
Lessons learned from designing the Dubai Taxi Operations dashboard — how to design for C-suite audiences without overwhelming them.
How I implemented RLS to reduce unauthorized data access by 50% — static roles, dynamic RLS, and managing it at scale.
Why Medallion Architecture changed how I think about data platforms — and how we migrated from AWS to Microsoft Fabric using it.
A practical guide from real-world projects — choosing between ADF orchestration and Databricks transformation for different data needs.
The complete playbook for delivering a production data warehouse — from requirements gathering to star schema design to Power BI deployment.
My study strategy, resources, and mindset for passing DP-600, DP-700, and PL-300 — simultaneously working full-time as a consultant.
My experience navigating the data consulting landscape in the UAE — the opportunities, the challenges, and what I learned along the way.
DAX (Data Analysis Expressions) is the formula language of Power BI — and mastering it separates good analysts from great ones. In this article, I'll walk you through the patterns I use daily.
Full article coming soon. Stay tuned!
From my experience designing the Dubai Taxi Operations dashboard — a real-world project serving CXO, Fleet Admins, Finance, and Operations — I learned how to balance depth with clarity.
Full article coming soon. Stay tuned!
RLS reduced unauthorized data access by 50% in one of my projects. Here's how to implement it properly at enterprise scale.
Full article coming soon. Stay tuned!
Medallion Architecture is how modern data platforms are built. I used it to migrate a production data platform from AWS to Microsoft Fabric — here's everything I learned.
Full article coming soon. Stay tuned!
ADF or Databricks? After using both extensively in production pipelines, here's my practical breakdown.
Full article coming soon. Stay tuned!
I built a full enterprise data warehouse in 6 months for a real estate giant. Here's the complete playbook.
Full article coming soon. Stay tuned!
PL-300, DP-600, DP-700 — three Microsoft certifications while working full-time as a consultant. Here's my strategy.
Full article coming soon. Stay tuned!
Moving from Mumbai to Dubai as a data professional was one of the best decisions I made. Here's an honest look at the journey.
Full article coming soon. Stay tuned!