Advanced PivotTable for Analyzing Data

Summarize, Analyze, and Visualize all types of data on PivotTable and PivotChart easily and effectively.

4.45 (12 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
1,420
students
1 hour
content
Mar 2023
last update
$19.99
regular price

What you will learn

Build PivotTable or PivotChart from worksheet data

Connect PivotTables from other sources and Power BI

Work with PivotTable Values and play around the design and formatting

Utilize a PivotTable Slicer to filter data and Organize PivotTable Timeline to filter date

Utilize a PivotTable with the Data Model to analyze data in multiple tables

Analyze and Visualize data by using PivotTable and PivotChart allowing you to readily observe comparisons, patterns, and trends

Description

Why need PivotTable and PivotChart?

A PivotTable may be used to summarize, analyze, explore, and show summary data. PivotCharts provide visuals to the summary data in a PivotTable, allowing you to readily observe comparisons, patterns, and trends. PivotTables and PivotCharts both allow you to make informed decisions regarding crucial data in your organization. You may also build PivotTables by connecting to other data sources just like SQL Server tables, SQL Server Analysis Services cubes, Azure Marketplace, Office Data Connection (.odc) files, XML files, Access databases, and text files, or by using existing PivotTables.

What will you learn?

1. Build PivotTable and Pivot Chart

  • Create a PivotTable from worksheet data

  • Refresh PivotTables

  • Work with PivotTable Values

  • Work with calculating values in a PivotTable

  • Create Calculated Fields

  • Create a PivotChart

2. Field Arrange, Slicer and Timeline

  • Use slicers to filter PivotTable data

  • Create a PivotTable timeline to filter dates

3. Connect to other data source

  • Connect PivotTables from other sources

  • Change the source data for a PivotTable

  • Use another PivotTable as a data source

  • Create a PivotTable connected to Power BI Datasets

Who need the course?

  • This course is useful for all people who are working in data sector such as data engineer, data analyst and data scientist.

  • This course is also useful for M&E specialist to increase additional capacity

  • Everyone who is willing to understand about the data analysis.

Content

Introduction

Introduction to Advanced PivotTable for Analyzing Data

Build PivotTable and PivotChart

Creating a PivotTable from worksheet data
Refreshing PivotTables when Dataset are updated
Working with PivotTable Values
Working with calculating values in a PivotTable
Creating Calculated Field on PivotTable
Creating a PivotChart

Work With Field Arrangement, Slicer and Timeline

Use slicers to filter PivotTable data
Create a PivotTable timeline to filter dates

Working With Pivot Table Data Sources

Connecting PivotTables from other sources

Resources for practices

Resources for real practice

Screenshots

Advanced PivotTable for Analyzing Data - Screenshot_01Advanced PivotTable for Analyzing Data - Screenshot_02Advanced PivotTable for Analyzing Data - Screenshot_03Advanced PivotTable for Analyzing Data - Screenshot_04

Reviews

Paul
December 29, 2022
I enjoyed this useful course, which especially made me re-think some of the ways I currently use Excel and how better pivot table usage would make my analysis more efficient!

Charts

Price

Advanced PivotTable for Analyzing Data - Price chart

Rating

Advanced PivotTable for Analyzing Data - Ratings chart

Enrollment distribution

Advanced PivotTable for Analyzing Data - Distribution chart
4999900
udemy ID
11/28/2022
course created date
12/7/2022
course indexed date
Bot
course submited by