Главная
Study mode:
on
1
) Introduction
2
) Sort
3
) Sorting one column
4
) Sorting multiple columns
5
) Sorting Mixed Data
6
) Filter feature
7
) Filter Drop-down Arrows to see Unique List
8
) Filter Different Data Types
9
) Filter to Extract Records
10
) OR Logical Test (OR Criteria) Discussion
11
) AND Logical Test (AND Criteria) Discussion
12
) BETWEEN and NOT Criteria
13
) PivotTable. Discussion of Crosstabulated tables and PivotTables as “Calculations with Criteria”, both AND Criteria and OR Criteria.
14
) PivotTable Basics: 1) Drag and Drop Field Names to add criteria to PivotTable, 2) Cross Tabulated Table, 3) Layout Formatting, 4) Number Formatting
15
) Adding Slicers
16
) Creating a Custom Style for a PivotTable
17
) Name PivotTable
18
) Create PivotTable using “Summarize Values By”, which allows us to change the Aggregate Functions like: SUM, COUNT, AVERAGE.
19
) Group Dates by Month and Year
20
) Create PivotTable using “Show Values As” to calculate “% of Column Total”.
21
) Hide items in Slicer
22
) Connect Multiple Slicers to Multiple PivotTables.
23
) Sort in PivotTable.
24
) Create multiple PivotTables with a single click using “Show Report Filter Pages”
25
) Why we need Power Query and Power Pivot Data Model
26
) Introduction to Power Query (Get & Transform)
27
) Power Query Example 1: Clean and Transform Data Table, Create PivotTable Based on Power Query Update, 3) Add new data to table and Refresh to update Query and PivotTable
28
) Power Query to Unpivot a Crosstabulated Table into a Proper Data Set.
29
) Introduction to Power Pivot and the Data Model
30
) Power Query to import multiple Text File tables with over one million records combine them into a single Table. We will use the “From File, From Folder” option.
31
) Load the million records in Power Query into the Power Pivot Data Model.
32
) Add an Excel Table into the Power Pivot Data Model
33
) Update Power Query
34
) Build a relationship between tables in the Power Pivot Data Model.
35
) Build PivotTable from Millions of Records from Two Tables
36
) Add new Text File to Folder and Update PivotTable.
37
) Summary
Description:
Dive into the fundamentals of data analysis and business intelligence in Excel 2016 with this comprehensive 1 hour 43 minute video tutorial. Master essential skills including sorting, filtering, and creating PivotTables. Explore advanced features like Power Query for data cleaning and transformation, and Power Pivot for handling large datasets. Learn to build custom styles, use slicers for dynamic filtering, and create relationships between tables in the Data Model. Practice importing and combining multiple text files with over a million records, and discover how to efficiently update and refresh your data analyses. By the end of this tutorial, you'll be equipped with powerful tools to manipulate, analyze, and visualize large datasets in Excel 2016.

Data Analysis Fundamentals - PivotTables, Power Query & Data Model

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Data Science #Data Analysis #Data Cleaning #Data Processing #Data Transformation #Power Query #Spreadsheets #PivotTables #Programming #Domain-Specific Languages (DSL) #SQL #Aggregate Functions
0:00 / 0:00
1 of 37

) Introduction