Building BI with Pivot Tables

Master BI with Pivot Tables in our online course. Perfect for report building, summarizing large datasets efficiently. Learn data sourcing, cleaning, tabular and visual presentation for easy analysis. Level up your BI skills.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data quickly. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing data, cleansing it, and analyzing it through pivot tables and dashboards.

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Building BI with Pivot Tables - What you need to get started

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Industry Expert

Learn More

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

All PivotTable tasks can be performed in any version of Excel. Tasks related to Power Query require installation of the free Power Query tools in some versions of Excel. Tasks related to Power Pivot can only be performed if Power Pivot is installed in your product. Details to activate these tools can be found below: **Excel 2010:** Power Pivot: Can be downloaded and installed in any SKU of Office 2010. Ensure that your Power Pivot version is version 11.0 or higher (not version 10.5.x) The most recent version can be downloaded free from https://www.microsoft.com/en-us/download/details.aspx?id=29074 Power Query: The most recent version can be downloaded free [here](https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=767e3fce-b355-4f78-96b1-18379e431c5b) **Excel 2013:** Power Pivot: Requires Excel 2013 Professional PLUS, Excel Pro PLUS (subscription) or a standalone Excel license Power Query: The most recent version can be downloaded free [here](https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=767e3fce-b355-4f78-96b1-18379e431c5b) **Excel 2016:** Power Pivot: Requires Excel 2016 Professional PLUS, Excel Pro PLUS (subscription) or a standalone Excel license Power Query: Built in to all versions of Excel

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion