Excel PowerPivot and PowerBI Tools

Excel Solutions Team|Computer Training Centers

>	Course Listings
Course Schedules

Houston Schedule
>	View Houston Training Calendar

San Antonio Schedule
>	View San Antonio Training Calendar


Registration Info
>	Registration
>	Contact Us
>	Locations

Excel PowerPivot and PowerBI Tools
(3 days)

Boot Camp Dates: Quarter 2 2016

PowerPivot is quickly becoming the reporting tool of choice by Excel experts. Why?

PowerPivot uses familiar but enhanced PivotTables and PivotCharts for its reporting
PowerPivot allows you to import a few rows of data up to many millions (yes millions) of rows of data from multiple data sources into a single workbook
PowerPivot eliminates the need for VLOOKUPS in the source data by allowing you to create relationships between data similar to a database
PowerPivot simplifies PivotTable formats, by using data types and user selected number formats for your fields
PowerPivot gives you the ability to create custom calculated columns and measures using formulas
PowerPivot makes it easy to analyze the data so that you can make timely business decisions without requiring IT assistance

Do you have large amounts of data that needs to be summarized? Do you use PivotTables regularly to summarize your source data? Do you have multiple sources of related data? Do you feel that repetitive PivotTables require too much setup? If you answered yes to any of these questions, this course is designed for you.

Training Course Overview and Highlights:

In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report. Students will enhance the report with custom calculations and charting. in addition, you will learn basic functionality of PowerPivot's related BI tools - PowerQuery and PowerView - to enhance your PowerPivot skills.

Explore the PowerPivot Application Refresh Data from a Data Source Learn to use Mail Merge to automatically produce letters, labels, and even emails to your clients

Import Data from Various Data Sources and add criteria to limit what is being brought into the Data Model

Create Linked Tables and Relationships

Organize and Format Tables

Sort and Filter PowerPivot Data using standard data filter methods as well as visual tools for filtering the data

Work with Table Relationships and the Data Model

Create Calculated Columns, Calculated Fields and Measures (DAX)

Create Date and Time Sensitive Calculations

Handle Fiscal and Calendar Periods in Time Intelligence Functions

Produce a PowerView Interactive Visualization Report

Use PowerQuery to Clean and Prepare Source Data

Excel 2013 Training Class Outlines:

Excel 2013 Level 1: Fundamentals of Excel
Excel 2013 Level 2: Intermediate Functions and Features
Excel 2013 Level 3: Advanced Tools and Collaboration Features
Excel 2013 Level 4: Advanced Formulas and Functions
Excel 2013 Level 5: Introduction To VBA Macros
Excel 2013 Level 6: Advanced VBA Macros