Applied Data Analytics Using Microsoft Power Tools (SIMnet)

126508940X · 9781265089405

By Casey Wilhelm, Brian Larson

Request Review Access

Request More Info

Instant access to SIMnet, our digital Microsoft Office training platform:

Part I: Definitions
Chapter 1: What is Data Analytics?
Chapter 2: The Data Analytics Process
Part II: Visualize
Chapter 3 (PBI): Descriptive Data Analytics - Power BI
Chapter 3 (EX): Descriptive Data Analytics - Excel Pivot Chart and Pivot Table
Chapter 4 (PBI): More Descriptive Data Analytics - Power BI
Chapter 4 (EX): More Descriptive Data Analytics - Excel Pivot Chart and Pivot Table
Chapter 5 (PBI): Diagnostic Data Analytics - Power BI
Chapter 5 (EX): Diagnostic Data Analytics - Excel Pivot Chart and Pivot Table
Chapter 6: Interactivity - Power BI
Chapter 7: More Interactivity - Power BI
Part III: Extract and Transform
Chapter 8: Data Gathering - Power Query in Excel and Power BI
Chapter 9: Transforming Data - Power Query in Excel and Power BI
Chapter 10: Row Manipulation - Power Query in Excel and Power BI
Chapter 11: Adding Columns - Power Query in Excel and Power BI
Chapter 12: Working with Queries- Power Query in Excel and Power BI
Chapter 13: Profiling and Troubleshooting - Power Query in Excel
Part IV: Model
Chapter 14 (PBI):Basic Data Modeling - Power BI
Chapter 14 (EX): Basic Data Modeling - Power Pivot in Excel
Chapter 15: Introduction to DAX Expressions - Excel and Power BI
Chapter 16: Advanced DAXExpressions - Excel and Power BI
Chapter 17 (PBI): Predictive, Prescriptive and Cognitive Analytics - Power BI
Part V: Share
Chapter 18 (PBI):Sharing Content- Power BI
Chapter 18 (EX): Sharing Content - Excel