Advanced PivotTable for Analyzing Data

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.