PQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery03Files.zipFree Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj
Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ or Mr Excel: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/
Download Power BI Desktop: https://powerbi.microsoft.com/en-us/desktop/
Topics:
1. (00:00) Intro Clip
2. (11:30) What is in this video
3. (01:01) Download files correctly
4. (02:25) pdf notes: Free book
5. (02:59) 5 main Power Query features that are different in Power BI Desktop from Excel
6. (04:54) Overview of video #3 project
7. (06:36) Open Start File
8. (06:43) Tour of Power BI Desktop
9. (07:21) Where is Power Query in Power BI Desktop?
10. (07:43) Import CSV Fact Table file
11. (08:10) Power Query Editor
12. (09:18) Advanced Editor
13. (09:25) let expression and how it works
14. (10:00) Close Power Query Editor without Applying query steps and loading to the Data Model
15. (10:26) What to do with this message: There are pending changes in your queries that haven’t been applied
16. (10:33) Import an Excel Table from an Excel file
17. (11:46) Import Access Database table
18. (12:36) Transform Data: Split by Dash Delimiter to get lookup values
19. (12:52) Efficient M Code: Delete repetitious query steps
20. (13:17) Split By Delimiter feature
21. (13:55) Edit M Code in Formula Bar
22. (15:10) Clean Data: Convert ISO Date to Real Serial Number Date
23. (15:31) Watch M Code change LIVE as you use the user interface
24. (15:52) Why you NEVER drag and drop data fields into Data Model Driven Visuals
25. (16:39) Intentionally forget important M Code Query step
26. (17:10) Load all 3 queries to Data Model using Close & Apply button
27. (17:24) Look at loaded tables in Table View & Model View
28. (17:58) Create Relationships
29. (19:41) Introduction to REALTED DAX lookup function
30. (20:29) DAX Measures and DAX Calculated Columns. One-Step or Two-Step DAX Measure Methods?
31. (21:32) Create DAX Calculated COLUMN
32. (22:23) Row Context and how it works in a Calculated Column and X Iterator functions such as SUMX
33. (23:27) Validate that returned lookup values are correct, discover a problem, and fix it in the Power Query Editor
34. (24:42) Use Transform Data button to open Power Query
35. (24:54) Replace feature in Power Query to fix mismatched lookup values
36. (25:17) Apply Changes to Data Model
37. (25:51) Create Net Sales DAX Calculated Column Formula
38. (26:19) Row Context
39. (28:21) DO NOT create Implicit Measures. Create Explicit Measures
40. (28:45) Create Explicit Measure with SUM function that adds values from Calculated Column (Two-Step Measure Method)
41. (29:24) What Icon looks like for Measure in Power BI
42. (29:37) Compare Preview of Grand Total for Measure in: Worksheet, Power Pivot, and Power BI
43. (29:56) Use Report View to Preview the results from a Measure using a Matrix Visualization
44. (30:57) One-Step Measure Method using the SUMX function
45. (31:05) DAX formulas: Data Analysis eXpressions
46. (31:42) Copy Calculated Column formula
47. (31:53) SUMX Function
48. (33:10) Test SUMX Measure in Report View
49. (33:24) Compare and contrast One-Step Measure to the Two-Step Measure
50. (34:17) Hide Fields that you do not want in the Reporting Area
51. (35:36) Create Dashboard visuals: Matrix and Stacked Column
52. (36:20) Filter Context and how it works with Measures
53. (38:32) How Filter Context & Row Context work together in the SUMX function
54. (39:14) Edward Tufte “No Chart Junk” Rule
55. (40:41) Interactive Visuals
56. (41:23) Summary
57. (41:53) Mike excelisfun Girvin’s Power Query M Code book
58. (42:02) Closing
This video has subtitles or audio translations a 137 languages, some of them are listed here: Afrikaans, Albanian, Amharic, Arabic, Armenian, Assamese, Aymara, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Catalan, Chinese, Corsican, Croatian, Czech, Danish, Dogri, Dutch, Estonian, Faroese, Fijian, Filipino, Finnish, French, Georgian, German, Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Maithili, Malagasy, Malay, Maltese, Mongolian, Nepali, Norwegian, Persian, Polish, Portuguese, Romanian, Russian, Samoan, Sanskrit, Santali, Scottish Gaelic, Serbian, Sicilian, Slovak, Slovenian, Somali, Spanish, Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language.
#excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis
View Power Query Video pdf notes: https://excelisfun.net/files/PowerQuery-03.pdf Receive SMS online on sms24.me
TubeReader video aggregator is a website that collects and organizes online videos from the YouTube source. Video aggregation is done for different purposes, and TubeReader take different approaches to achieve their purpose.
Our try to collect videos of high quality or interest for visitors to view; the collection may be made by editors or may be based on community votes.
Another method is to base the collection on those videos most viewed, either at the aggregator site or at various popular video hosting sites.
TubeReader site exists to allow users to collect their own sets of videos, for personal use as well as for browsing and viewing by others; TubeReader can develop online communities around video sharing.
Our site allow users to create a personalized video playlist, for personal use as well as for browsing and viewing by others.
@YouTubeReaderBot allows you to subscribe to Youtube channels.
By using @YouTubeReaderBot Bot you agree with YouTube Terms of Service.
Use the @YouTubeReaderBot telegram bot to be the first to be notified when new videos are released on your favorite channels.
Look for new videos or channels and share them with your friends.
You can start using our bot from this video, subscribe now to PQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing
What is YouTube?
YouTube is a free video sharing website that makes it easy to watch online videos. You can even create and upload your own videos to share with others. Originally created in 2005, YouTube is now one of the most popular sites on the Web, with visitors watching around 6 billion hours of video every month.
