Download Excel Zipped Folder with all files (including pdf notes): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/MECS04DownloadFiles.zip
Free YouTube Excel & Data Analysis class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3
In this video learn about the Excel Tool Power Pivot to build reports and visuals.
Topics:
1. (00:00) Introduction
2. (00:45) Emable Power Pivot in Excel
3. (01:51) What is Power Pivot?
4. (03:01) Understanding the data that we use in this example
5. (04:55) Visual to help understand Relationships
6. (06:01) Power Query to import data into Power Pivot Data Model
7. (12:44) Data Modeling: Add Relationships
8. (14:48) Data Modeling: Hide Fields
9. (16:20) Data Modeling: Create DAX Measures. See the DAV Functions: SUM, AVERAGE and COUNTROWS
10. (22:00) Finished Data Model
11. (23:06) Create Multiple Data Model PivotTables from the Data Model
12. (27:34) Sort By Column Feature for Data Field in Data Table
13. (29:13) Filter Context: How DAX Measures work
14. (33:52) Implicit Measures and Automatic Date Grouping: Dangers of Data Models
15. (36:01) Show Implicit Measures
16. (37:35) Mark Table as Data Table
17. (38:24) Advantages of Data Model PivotTables
18. (38:57) Preview of next video: Excel Basics 12: Power BI Desktop
19. (38:26) Practice Problem on the worksheet: HW(4)
20. (39:15) Closing
Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.
#excel #excelisfun #groupby #dataanalysis #Sort #powerpivot #dax #datamodeling #datamodelling #datamodel #dataanalysis #
#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions