Excel PowerPivot and Interactive Visualizations (Live Online)

via CourseHorse

Overview

Enhance your data analysis skills with Excel's advanced tools designed for big data insights and interactive visualizations. Learn how PowerPivot extends traditional pivot tables with a comprehensive data model, offering enhanced summarization, cross-tabulation, and complex calculations. Power Query allows data retrieval from various sources with pre-model cleanup. Discover how Power View creates interactive dashboards and Power Map offers 3D visualization through map charts and dynamic tours.

Excel Versions: The PowerPivot, Power Query, Power View, and Power Map tools are available as add-ins for Excel 2010 and 2013 and are fully integrated into Excel 2016, the platform used in this course. The interface variations among versions are explained.

Target Student: This course is tailored for individuals responsible for complex Excel reports and advanced analytics, providing them the knowledge to efficiently use Excel's powerful tools.

Prerequisites: Introductory Excel skills are a must, while familiarity with pivot tables is advantageous but not essential.

Lesson 1 – Understanding Power Pivot and the Power BI Tools
- Introduction to Power Pivot, Power Query, Power View, and Power Map
- Benefits of Power BI Tools
- Comparison: Excel vs. Power Pivot
- Pivot Table and Power Pivot Data Model Examples
- Explore Power View and Power Map
Lesson 2 – Working with Data
- Managing Excel Lists and Tables
- Using Vlookup for Helper Columns
- Cleanup and Normalization of Tables
Lesson 3 – Importing Data into Power Pivot
- Data Type Compatibility
- Integrating Excel and Access Tables
- File Handling and Data Management in Power Pivot
Lesson 4 – Creating the Data Model
- Introduction to Data Models
- Establishing Key Fields and Relationships
- Utilizing Linked Tables and Hierarchies
Lesson 5 – Using Calculations in Power Pivot
- Diverse Calculation Types
- Crafting Calculated Fields and Columns
- DAX Measure Rules and Best Practices
- Key Performance Indicators (KPIs) Implementation
Lesson 6 - Using Data Analysis Expressions
- DAX Formula Fundamentals and Syntax
- Applying DAX in Operations
Lesson 7 – Working with DAX Formulas
- Filter and Time Intelligence Functions
- Complex Formula Construction
Lesson 8 – Data Analysis with Pivot Tables and Pivot Charts
- Pivot Table Creation and Filtering
- Adding Visual Elements and Chart Formatting
Lesson 9 – Working with Power View
- Building Reports and Enhancements
- Chart and Visualization Techniques
Lesson 10 – Building Interactive Reports with Power View
- Data Organization and Filtering
- Dashboard Exposure Techniques
Syllabus
Taught by

Tags