X
ODT

Building BI with Pivot Tables
On-Demand Training

Starting At: $195.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Unlimited Elite Pack
$995
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize tens to thousands of rows of data. 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 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, cleansing, and analyzing data through pivot tables and dashboards.

What Will You Learn?

  • How to develop Excel Pivot Table reports and modify their aesthetics
  • How to leverage tools like Power Query and Power Pivot to enhance what’s possible with Pivot Tables
  • How to refresh Pivot Table local and external data

Prerequisites


This is a course aimed squarely at beginner/intermediate Excel users looking to take their skills to the next level. Before starting this course, you should be comfortable working in Excel. Knowledge of a variety of formulas can be helpful, although is by no means necessary. While those comfortable with Pivot Tables are likely to pick up new tricks to make their lives easier, the course is designed to take someone with absolutely no Pivot Table knowledge and teach them how to collect, clean and set up the data, present it in Pivot Tables and build dashboards using Pivot Charts. A basic understanding of Excel functions is helpful, but not necessary for this course. The target audience of this course is for power users who are learning DAX for the first time.

System Requirements


Curriculum For This Course

Image

Ken Puls

Chartered Professional Accountant, Author and Trainer

Microsoft Excel MVP Ken Puls is a Chartered Professional Accountant, author and trainer. With 20 years of experience as a corporate controller and business owner, he has been exposed to many business systems, databases, and analysis tools, leading to a career of building Excel-driven applications to harness data and turn it into management information.



Related Courses

Course Info
8 Comprehensive Modules
30 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
6h 51m
Download Syllabus
Enrollment Price:
$195/Year
Share this course with your friends