Blog
Practical, cited articles on Power BI, SSRS, data modeling, Microsoft Fabric, data pipelines, custom dashboards, governance and what generative AI really changes in analytics.
-
Advanced Power BI Modeling: Calculation Groups, Field Parameters and DAX That Scales
Most Power BI models fail at scale for the same three reasons: a shape that is not a star schema, measures copied dozens of times, and reports that…
-
SSRS Is Not Dead: Where Paginated Reports Still Beat Power BI Visuals
Interactive dashboards did not replace the invoice, the statement or the regulatory filing. Here is where SQL Server Reporting Services and Power BI paginated reports still win, how…
-
Beyond the BI Tool: Custom Dashboards with D3, Node.js, Tailwind and Python
Sometimes the packaged BI tool is the wrong shape: a customer portal, a 50-inch operations wall, a visualization no chart library draws. Here is a reference architecture for…
-
OLTP vs OLAP: Designing Models That Serve Transactions and Analytics Without Compromise
The same SQL Server cannot be tuned for 2,000 writes a second and a ten-table aggregate at once. Understanding why OLTP and OLAP pull in opposite directions is…
-
Dimensional Modeling in 2026: Kimball Still Wins, and Where It Needs Help
Lakehouses, Direct Lake and AI agents did not retire the star schema; they made it more important. What still holds from the Kimball toolkit, what has changed, and…
-
Microsoft Fabric for SQL Server Shops: OneLake, Medallion Lakehouses and Direct Lake
If your estate is SQL Server, SSIS and Power BI, Fabric is less a migration than a reorganization: one storage layer, familiar T-SQL, and a semantic model that…
-
Azure Data Factory to Fabric Data Factory: Pipelines That Survive Change
Microsoft calls Fabric Data Factory the next generation of Azure Data Factory. The concepts carry over; the operating habits that make pipelines survive source changes, failed runs and…
-
Prefect + dbt: Code-First Orchestration and Transformation for Small Data Teams
A two-person data team can run a tested, scheduled, observable analytics stack with two open-source tools: Prefect to orchestrate Python, dbt to transform in SQL. The division of…
-
What Generative AI Actually Changes in BI: Copilot, Data Agents and the Semantic Layer
Generative AI does not remove the need for data modeling; it raises the cost of skipping it. A grounded look at what Copilot in Power BI and Fabric…
-
Data Governance for Mid-Size Companies: RLS, Lineage and Quality Tests You Can Run Monthly
Governance programs fail in mid-size companies because they are designed for large ones. Here is a governance cadence a two-person data team can keep: dynamic row-level security, lineage…
