Microsoft Excel Big Data Analysis with Power Tools Part 1

Microsoft Excel® Power Pivot

We live in the age of big data. Information is being collected all the time for increasingly detailed transactions. Without the proper tools and training this can lead to an overwhelming amount of data and missed opportunities.

Excel Power Tools helps organize, manipulate, data model, and report on your data in the best way possible. Gain a solid understanding of Power Tools to maximize your speed and effectiveness when analyzing data.

Note: This course does not include Power BI. Watch for Microsoft Excel Big Data Analysis with Power Tools, Part 2 coming soon.


Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.

You will:

  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.


To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following Logical Operations courses:


1:00 pm - 5:00 pm

Discount Information
Refund Policy


This course is not yet scheduled, but we can notify you when it is.

Send Me Updates  

Lesson Content

  • Enable and Navigate Power Pivot
  • Manage Data Relationships
  • Create a Power Pivot Report
  • Create Calculations in Power Pivot
  • Create a Key Performance Indicator
  • Work with Dates and Time in Power Pivot

Appendix A: Commonly Used DAX Functions