Data engineering · Business intelligence · Data security
Better, faster, more relevant insight from the data and systems you already own.
I am David A. Fantin, a South Florida data engineering, Power BI and data security professional with nearly two decades on the Microsoft data platform across regulated industries. I build semantic models, pipelines, dashboards and governance that executives trust and auditors accept.
Three problems I solve
Reports nobody trusts
Power BI semantic models on a real star schema, with reconciled measures, calculation groups and dynamic security, plus paginated reports for the documents that must print right.
Data that arrives late or wrong
OLTP and OLAP design, SQL Server warehouses, and pipelines in Azure Data Factory, Microsoft Fabric, Prefect and dbt that are tested, monitored and documented.
Security and AI without a plan
Row-level security, governance and quality tests a small team can keep, custom dashboards when the tool is the wrong shape, and a grounded path to Copilot and data agents.
12+
years building the reporting that operations, finance and executive teams run on
8
regulated and high-volume industries, from healthcare to federal and DoD
2
ransomware incidents recovered with zero data loss on the platforms I owned
USN
US Navy veteran, Cryptologic Technician, 2001–2007
Latest articles
-
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…
-
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…
-
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…
-
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…
Have a data problem that is costing you decisions?
Tell me the decision, the systems and what has been tried. I reply within one business day.
