Events

Loading Courses

« All Courses

  • This course has passed.

Microsoft® Excel 2016: Data Analysis With PowerPivot

December 5, 2023 @ 8:00 am - December 6, 2023 @ 12:00 pm

|Recurring Courses (See all)

One event on December 6, 2023 at 8:00 am

$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 not yet available

Microsoft® Excel 2016: Data Analysis With PowerPivot 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)

Course Outline:

Getting Started with Power Pivot
Review of Pivot Tables
Data Normalization

Exploring a Relational Data Diagram
Developing a Data Model in Power Pivot
Creating Data Relationships
Creating a Pivot Table from the Data Model

Working with Calculations
Creating a Calculated Column
Creating a Summary Calculation Measure

Exploring Data Analysis Expressions
Creating a DAX function
Using DAX functions in Pivot Table reports

Working with Advanced Functionality in Power Pivot
Adding an Excel table to the Data Model
Work with Dates and Time in Power Pivot

Creating Key Performance Indicators (KPI’s)
Visualizing Measures
Exploring various KPI options

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Details

Start:
December 5, 2023 @ 8:00 am
End:
December 6, 2023 @ 12:00 pm
Cost:
$395.00
Courses Categories:
,

Locations

Virtual Live

Leave a Comment

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