Events

Loading Courses

« All Courses

  • This course has passed.

Microsoft® Excel 2016: Data Analysis with PowerPivot

November 19, 2019 @ 8:30 am - 4:15 pm

$395.00

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Course Description:

This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models that permit the connection to multiple data tables invariably linked by way of a relational join. Pivot Tables, thus, can be much more robust as they can be derived from a variety of data source tables. In addition, there are very powerful calculations that can be created from functions categorized as Data Analysis Expressions, or DAX functions. The Excel power user can also create both calculated fields as well as summary calculations known as Measures. These Measures can also be expressed ironically in the form of KPI’s, or Key Performance Indicators, which essentially are graphics depicted by logical conditions.

Course Objectives:

  • Review of Pivot Table basics
  • Understanding Relational Databases
  • Creating a Data Model in Power Pivot
  • Developing Data Relationships
  • Creating Pivot Tables from the Power Pivot data model
  • Creating calculated fields
  • Creating summary calculations (measures)
  • Using DAX functions
  • Utilizing Key Performance Indicators (KPI’s)

Details

Date:
November 19, 2019
Time:
8:30 am - 4:15 pm
Cost:
$395.00
Courses Categories:
,

Locations

Knowledge Source Inc.
3100 Smoketree Court, Suite 200
Raleigh, NC 27604 United States
+ Google Map
Phone
919-878-7100
View Locations Website

Leave a Comment

Your email address will not be published. Required fields are marked *