Data Analysis with Power Pivot in Excel

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

COURSE CONTENT

GETTING STARTED WITH POWER PIVOT

• Enable and Navigate Power Pivot

• Manage Data Relationships

 

VISUALIZING POWER PIVOT DATA

• Create a Power Pivot Report

• Create Calculations in Power Pivot

WORKING WITH ADVANCED FUNCTIONALITY IN POWER PIVOT

• Create a KPI

• Work with Dates and Times in Power Pivot

BONUS IF TIME PERMITS

• Commonly used DAX Functions overview

PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL

• Visualize Data with PivotCharts

• Filter Data Using Slicers and Timelines

• Create a Dashboard in Excel

CREATING GEOSPATIAL VISUALIZATIONS IN EXCEL

• Create Map Charts in Excel

• Customize Map Charts in Excel

PERFORMING STATISTICAL ANALYSIS

• Visualize Trendlines and Sparklines with Excel

• Analyze Data with the Data Analysis ToolPak

GETTING AND TRANSFORMING DATA

• Connect to Data with Queries

• Clean and Combine Data

• Shape and Transform Data

MODELING AND ANALYZING DATA WITH POWER PIVOT

• Create Data Models with Power Pivot

• Create Power Pivots

• Perform Advanced Data Analysis and Visualization

PRESENTING INSIGHTS WITH REPORTS

• Plan a Report

• Create a Report

Register
Prix
Qté
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event