I created a full Microsoft Power BI for beginners in January 2023, and I have covered 100+ topics in 11 hours.
You will step by step learn Power BI with topics like Installation, license, Create Measures, calculated columns, Power query functions, and DAX functions like a window, offset, index, calendar, summarize, and Time intelligence. Features like Bookmarks, Field Parameters, Drill through, service etc. Learn for free, how to use various power bi features
#powerbitutorial #powerbiforbeginners
Don’t forget to like, comment, and subscribe for more great content!
▶️Please Subscribe: https://www.youtube.com/@AmitChandak
▶️Data:
• Covid 19: https://covid19.who.int/WHO-COVID-19-…
• Get The data and Pbix files on Github: https://github.com/amitchandakpbi/powerbi
• DropBox files: https://www.dropbox.com/sh/90ycq7hpmngabe9/AABR_l_4sy3SSALA_U95gIkWa
▶️ Here is the timestamp of all the topics I have discussed in this tutorial:
00:00 Introduction, Basic Concepts
10:00 Download and Install Power BI, Quick Look at Power BI Desktop Dec 2022
18:00 Create Power Bi Login, Login/Sign in to Power BI
25:00 Power BI EcoSystem,Licenses, Desktop Overview
50:45 Options & Settings
57:22 Covid Data Analysis
01:19:00 Download the data,Overview of Data
01:24:00 Load Data into Power BI, Column Tools
01:38:20 Data Model Property Pane, Check No Join issue
01:51:00 Single Vs Bi-Directional Join
01:54:00 Update Theme
02:02:45 Create Calculated Columns and Measures, Calculate with and Without filter
02:40:00 Expression Functions SUMX,MINX, MAXX
02:48:30 isfiltered, hasonevalue
02:54:50 Table Visual
03:03:00 Conditional Formatting, Data Bars,URL Icon
03:11:00 Matrix, Bar, Pie, TreeMap, Scatter Visuals
04:40:00 Map, Shape Map, Filled Map, Security Settings
04:51:45 Decomposition Tree, Q&A Visual
04:57:00 DAX Earlier
05:03:00 Date Table,Date Table FY Columns
05:53:45 DAX Search, Find,containsstring, containsstringexact
06:03:55 Left, Right, Mid
06:12:25 calculatetable,Summarize,Summarize Vs Groupby, Summarize in Measures
06:28:00 SummarizeColumns, Except, Distinct, Generateseries, Generate, Cross join
06:44:30 all, allselected, removefilters,allexcept
07:07:07 rankx, topn, dynamic topn with numeric parameters
07:29:00 Firstnonblankvalue, Lastnonblankvalue
07:35:30 Distinct count using values/summarize
07:38:30 Time Intelligence Setup
07:47:00 totalmtd, datesmtd, datesqtd, datesytd, Last datesmtd, Last datesqtd, Last datesytd
08:12:30 Trailing Day, Week, Month, Qtr, Year, Year Week, Previousmonth, previousquarter, previousyear
08:30:00 Week on Week, WTD, Half(custom period) Till Date, HoH,Period on Period
08:53:00 DAX offset, isinscope, window, Index
09:37:00 Visual Interaction
09:44:00 Bookmarks
09:49:00 Field Parameter, Measure Slicer, Axis Slicer, Drill Through
10:04:00 Tooltip
10:06:30 Introduction to Power Query
10:08:10 Use First Row As a header, Remove Blank and Duplicates
10:11:00 Power Query UnPivot Data, Pivot Data, Transpose Data, Query Fill Up, Fill Down
10:18:00 Replace Values, Text Operations, Append Tables, Merge Tables
10:36:00 Power Query Custom Column, Extract Data
10:42:00 Column Quality, Profile, and Distribution
10:45:00 Clean File, Publish File, Analyze on Power Bi Service
11:07:00 Create Report in Power BI Service
11:11:00 Service Dashboard
11:12:00 Power Bi Service App, Power BI Dataflow
11:18:00 Live Connection
11:23:00 Tenant Setting
So, watch the video till the end and share your thoughts in the comments.
If you like this video, please SUBSCRIBE and don’t forget to press the bell 🔔, like, comment, and share.
🔵 What is Power BI?
Power BI is an application for data analysis that enables users to make better decisions by analyzing data. It applies to numerous disciplines, such as business intelligence and analytics. Additionally, Power BI can generate dashboards that present data from several sources.
Power BI is simple to learn as it is based on Microsoft Excel. This makes it easy for anyone to start using Power BI, even if they have no experience with data analysis or reporting. Instead, the user interface of Power BI makes it one of the most intuitive and user-friendly programs.
The user interface of Power BI is simple, especially if you are new to data visualization.
This tutorial will provide a step-by-step understanding of Power BI and demonstrate how to
———
▶️Follow me on:
• Medium: https://amitchandak.medium.com
• Twitter: https://twitter.com/amitchandak78
• LinkedIn: https://www.linkedin.com/in/amitchandak78/
———
▶️My Other Videos:
• Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
• Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
———
#AmitChandak #microsoftpowerbi #powerbifullcourse #whatispowerbi #powerbicourse #powerbitraining #learnpowerbi #powerbifree #powerbi
source