Power to the Pivot - Practical Intro to PowerPivot 2012
summary
Live demo shows how to use PowerPivot 2012 Excel add-in (Office 2010/2013) to build a timesheet-to-targets model: import tables, create concatenated composite keys and relationships, use DAX calculated columns (Related(), IF, CALCULATE, DatesBetween) to compute billable days, billable hours and a utilization measure, then surface a KPI and pivot/100% stacked charts. New UI features like diagram view and hierarchies and perspectives speed exploration; the workbook refreshes against the source and the visuals update as expected.
AI-written summary · about
chapters (23)
- 0:00PowerPivot intro
- 2:03What PowerPivot is
- 5:58BI Semantic Model
- 9:09Demo and interface
- 10:33Billable hours model
- 13:21Calculated columns
- 16:17Table relationships
- 17:43RELATED function
- 19:31Hours remaining with DAX
- 21:18Pivot tables and charts
- 23:47Billable hours progress
- 25:11PowerPivot 2012 features
- 25:55Diagram View and relationships
- 26:37Hierarchies for drill-down
- 28:50Advanced mode and perspectives
- 30:34Date table for time
- 33:02Import from SQL Server
- 34:49Mark date table
- 36:37Work and billable days
- 39:23Billable hours and utilization
- 41:09KPIs for resources
- 43:19Final utilization analysis
- 46:07New features summary
related talks
51mData modeling for experts with Power BI
01h 01mIntroducing the Reimagined Power BI Platform
43mPower BI Monitoring 101
01h 17mPower BI What's New 2019–2020 for Enterprise
16mGood Data Modeling & Effective Communication in Power BI
57mBillions of records: the real success story using Microsoft Power BI Embedded
40mSelf-Service ETL: The PowerBI Data Flows
52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution