Learn Power BI Tutorial/training for Beginners, full/complete course- 11 hours. DAX, Power Query, and Power Platform overview, Load Data, Calculated Column, Measure, Visuals, Field Parameters, Bookmarks, Offset, Window, Index Functions, Time Intelligence, Interactions, Drill Through, Tooltip, Publish file, Pivot data, Unpivot data, Transpose data, Delete Blank and Duplicates.
Data: Covid 19: https://covid19.who.int/WHO-COVID-19-global-data.csv
Get The data and Pbix files https://github.com/amitchandakpbi/powerbi/tree/main/Data%20for%20Learn%20Power%20BI%20Full%20Video
Other File at GitHub https://github.com/amitchandakpbi/powerbi
More Videos that you should watch
How to create a login at app.powerbi.com: https://youtu.be/VW130u7u-G0
Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE
On-Premise Gateway and configure it on service: https://youtu.be/lObMRofpbQ8
Dataflows and Dataset Design Pattern: https://youtu.be/zwhJ1hWPcrA
Power BI- How to create Datamarts: https://youtu.be/8tskWsJTEpg
Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Following are the 100+ Topics
1. Introduction
2. Basic Concepts
3. Download and Install Power BI
4. Quick Look at Power BI Desktop Dec 2022
5. Create Power Bi Login
6. Login/Sign in to Power B
7. Power BI EcoSystem
8. Power Bi Licenses
9. Power Bi Desktop Overview
10. Power BI Options & Settings
11. Covid Data Analysis
12. Download the data
13. Overview of Data
14. Load Data into Power BI
15. Column Tools
16. Data Model Property Pane
17. Check No Join issue
18. Single Vs Bi-Directional Join
19. Update Power BI Theme
20. Create Calculated Columns and Measures
21. Calculate with and Without filter
22. Expression Functions SUMX,MINX, MAXX
23. isfiltered, hasonevalue
24. Table Visual
25. Gradient Conditional Formatting
26. Rule based Conditional Formatting
27. Data Bars
28. URL Icon
29. Matrix Visual
30. Switch Values to Row
31. Stepped Layout off
32. Desc Sort on Matrix Column
33. Bar Visual
34. Concatenate Label off
35. Measure Based Conditional Formatting
36. Pie/Donut Visual
37. Line Visual
38. Area Visual
39. Tree Map Visual
40. Stacked Visual
41. Combo Visual
42. Small Multiples
43. Card Visual
44. Multi Row Card
45. Scatter Visual
46. Scatter Visual with quadrants conditional formatting
47. Map, Shape Map, Filled Map, Security Settings
48. Decomposition Tree
49. Q&A Visual
50. DAX Earlier
51. Date Table
52. Date Table FY Columns
53. DAX Search, Find
54. DAX containsstring, containsstringexact
55. DAX Left, Right, Mid
56. calculatetable
57. Summarize
58. Summarize Vs Groupby
59. Summarize in Measures
60. SummarizeColumns, Except, Distinct
61. Generateseries
62. Generate, Cross join
63. all, allselected, removefilters
64. allexcept
65. rankx, topn
66. dynamic topn with numeric parameters
67. Firstnonblankvalue, Lastnonblankvalue
68. Distinct count using values/summarize
69. Power BI Time Intelligence Setup
70. totalmtd, datesmtd, datesqtd, datesytd
71. Last datesmtd, Last datesqtd, Last datesytd
72. Trailing Day, Week, Month, Qtr, Year, Year Week
73. Previousmonth, previousquarter, previousyear
74. Week on Week, WTD
75. Half(custom period) Till Date, HoH,Period on Period
76. DAX offset
77. DAX isinscope
78. DAX window
79. DAX Index
80. Power BI Visual Interaction
81. Power BI Bookmarks
82. Field Parameter, Measure Slicer, Axis Slicer
83. Drill Through
84. Tooltip
85. Introduction to Power Query
86. Use First Row As a header, Remove Blank and Duplicates
87. Power Query UnPivot Data
88. Power Query Pivot Data
89. Power Query Transpose Data
90. Power Query Fill Up, Fill Down
91. Power Query Replace Values
92. Power Query Text Operations
93. Power Query Append Tables
94. Power Query Merge Tables
95. Power Query Custom Column
96. Power Query Extract Data
97. Column Quality, Profile and Distribution
98. Clean Power BI File
99. Publish Power BI File, Analyze on Power Bi Service
100. Create Report in Power BI Service
101. Power Bi Service Dashboard
102. Power Bi Service App
103. Power BI Dataflow
104. Power BI Live Connection
105. Power Bi Tenant Setting
watch?v=cN8AO3_vmlY
