Data Mining with Power Pivot in Excel

Data Mining with Power Pivot - Uncover Insights in Seconds!

Description

When you have huge tables of data that need to be connected, compared, and analyzed, the new Power Pivot functionality in Excel can't be beaten. Create Pivot Tables that connect multiple related tables, and even combine multiple years or regions of data in seconds. Then, add custom calculations to find useful data points with a new language, DAX.

These tools make Excel twice as powerful, and also teach you skills to get ready for Power BI. This session covers a critical skillset for data analysts.

Similar events

File Triage: Working Smarter, Not Harder

More Information

Office Speed Tips: Shortcuts, Macros, and Hacks for Word, Excel, or PowerPoint

More Information

Office Polish Tips: Professional Formatting in Word, Excel, or PowerPoint

More Information

Outlook and OneNote Integrations for Information Management

More Information

Professional Microsoft Word: Core Skills

More Information

Document Control: Creating Complex Documents in Word

More Information

Automation in Word: Macros, Shortcuts, and Hacks

More Information

Word for Legal Practices

More Information

Professional Microsoft Excel: Core Skills

More Information

Modern Data Handling: Introduction to Power Query in Excel

More Information

Pivot Tables for Data Analysis and Visualization

More Information

Building Bulletproof Spreadsheets

More Information

Data Visualization Essentials in Excel

More Information

Advanced Data Visualization Hacks in Excel

More Information

Automation in Excel: Macros, Shortcuts, and Hacks

More Information

Lookup Functions and Table Relationship in Excel

More Information

Better Data and Reporting with Excel Functions

More Information

Logical Test in Excel

More Information

Professional PowerPoint: Core Skills

More Information

Polished Presentation Design

More Information

Essential Motion Design in Professional Presentations

More Information

Nonlinear Presentation Design

More Information

Outlook Automation: Rules, Quick Steps, and Macros

More Information

Information Management with Microsoft OneNote

More Information

Understanding Microsoft 365: An Overview of Teams, SharePoint, and OneDrive

More Information

Integrations between Teams and SharePoint

More Information

Creating a Collaboration Hub in Teams

More Information

Teams Meetings: Best Practices

More Information

SharePoint File Management

More Information

Planner and To-Do: Modern Task Management

More Information

Modern Data Handling with Power Query in Excel

More Information

Pivot Tables for Data Analysis and Visualization

More Information

Advanced Data Visualization Hacks in Excel

More Information

Data Storytelling in PowerPoint

More Information

Upgrade: Why Should I Learn Power BI?

More Information

Data Preparation: Power Query Tricks

More Information

Advanced Charting Techniques in Excel

More Information

Presentation Design Essentials

More Information

Theme Design for Office

More Information

Design Principles for Business Professionals

More Information