Главная
Study mode:
on
1
) Introduction
2
) What is Data Analysis?
3
) Sorting and Filtering. Example 1 & 2
4
) FlashFill. Example 3.
5
) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4.
6
) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5.
7
) First look at Power Query’s Functional Language: M Code
8
) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6.
9
) Excel Line Chart Visualization based on PivotTable
10
) Data Modeling for Examples 7, 8 & 9
11
) XLOOKUP function, PivotTable and Excel Charts to build report and visualization. Example 7.
12
) Power Pivot, Data Model, Relationships and DAX Formulas to build Data Model PivotTable Reports. Power Query to import Excel data. Complete Introduction to Power Pivot. Example 8.
13
) Sort By Column Feature for Data Field in Data Table
14
) Filter Context for DAX Formulas in Data Model
15
) Implicit Measures and Automatic Date Grouping: Dangers of Data Models
16
) Mark As Date Table
17
) Send Data Model to Power BI Desktop to make Interactive & Sharable Dashboard. Example 9.
18
) Complete Introduction to Power BI Desktop, Including how to download free app
19
) Building Interactive Visuals
20
) Stacked Bar/Chart Vs. Clustered Bar/Chart
21
) Complete Introduction Power BI Online and Workspaces to share Power BI Desktop files, Excel files, dashboards and data models easily online.
22
) What is a Dashboard?
23
) Connect to Data Models stored at Power BI Online in Excel and Power BI Desktop
24
) Refresh Excel Power Pivot, Power BI Desktop and Power BI Online when Source Data Changes
25
) Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard. Example 10.
26
) What is a Columnar Database?
27
) Idea behind DAX Revenue Formula (Measure)
28
) Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop
29
) Build DAX Date Table
30
) Row Context in DAX Calculated Columns and DAX Iterator Functions
31
) Hide Fields in Report View
32
) Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions
33
) One-Step DAX Revenue Measure using SUMX DAX function
34
) Compare One-Step and Two-Step Measures. Which is better?
35
) Create four Remaining Measures in Report View
36
) What is Gross Profit? Two Measures for Gross Profit.
37
) Create Two Power BI Reports, including Map Report
38
) Map Visual
39
) Conclusion
40
) Closing and Video Links
Description:
Dive into a comprehensive 3-hour 44-minute video tutorial on Excel and Power BI data analysis, taught by Excel MVP and Highline College Professor Mike Girvin. Master essential skills including sorting, filtering, FlashFill, PivotTables, Power Query, M Code, XLOOKUP, Power Pivot, DAX formulas, and data modeling. Explore Power BI Desktop for creating interactive visualizations and dashboards, and learn to work with large datasets, including importing 7 million rows from SQL databases. Gain practical experience through multiple examples, covering topics from basic Excel functions to advanced Power BI techniques. Download accompanying files to follow along and enhance your learning experience.

Excel & Power BI Data Analysis Complete Class in One Video

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Business Intelligence #Microsoft Power BI #Programming #Databases #Database Design #Data Modeling #Power Query #Spreadsheets #Power Pivot #DAX Formulas #PivotTables
0:00 / 0:00
1 of 40

) Introduction