Power BI & Tableau Essentials
Move from static charts to governed, interactive BI. Learn the Power BI and Tableau workflows, write core DAX measures and calculated fields, and apply performance and governance practices for production reports.
The BI Tool Workflow
Both tools follow the same loop, even though the interfaces differ:
- Connect — Import data or use a live/DirectQuery connection to the warehouse.
- Model — Define relationships between fact and dimension tables.
- Calculate — Create reusable measures (DAX in Power BI, calculated fields in Tableau).
- Visualize — Build charts and arrange them on a canvas.
- Publish — Share to a service with row-level security and scheduled refresh.
Core DAX Measures in Power BI
DAX measures are evaluated in the context of filters on the report. `CALCULATE` is the most important function — it changes that context:
Total Revenue = SUM ( fact_orders[revenue] )
Revenue LY =
CALCULATE (
[Total Revenue],
SAMEPERIODLASTYEAR ( dim_date[full_date] )
)
Revenue YoY % =
DIVIDE ( [Total Revenue] - [Revenue LY], [Revenue LY] )
Revenue YTD =
TOTALYTD ( [Total Revenue], dim_date[full_date] )
Top Segment Revenue =
CALCULATE (
[Total Revenue],
TOPN ( 1, VALUES ( dim_customer[segment] ), [Total Revenue] )
)Calculated Fields in Tableau
Tableau uses row-level calculations and Level of Detail (LOD) expressions to control aggregation granularity:
// Profit margin
SUM([Profit]) / SUM([Sales])
// Customer lifetime value using a FIXED LOD
{ FIXED [Customer ID] : SUM([Sales]) }
// Share of region total
SUM([Sales]) / { FIXED [Region] : SUM([Sales]) }
// Year-over-year growth (table calculation)
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1))
/ ABS(LOOKUP(ZN(SUM([Sales])), -1))Performance and Governance
Production reports must be fast and trustworthy:
- Prefer a star schema with one-to-many relationships; avoid wide flat imports.
- Remove unused columns and use incremental refresh for large tables.
- Create measures instead of calculated columns to save memory.
- Apply row-level security so users see only their own region or team.
- Certify shared datasets and document metric definitions.
- Limit the number of visuals per page; each one issues a query.
Choosing Between the Two
Power BI is usually the better fit for Microsoft-centric organizations and cost-sensitive teams with strong modeling needs. Tableau excels at flexible visual exploration and highly customized design. Many companies run both — the transferable skill is good data modeling and metric design.
Key Takeaways
- Both tools follow connect, model, calculate, visualize, publish.
- CALCULATE changes filter context and powers most DAX.
- LOD expressions control aggregation granularity in Tableau.
- Star schemas, row-level security and certified datasets make BI production-ready.
Contact Us
Have a question or feedback? Fill out the form below or reach us directly at support@nvaitraining.com