[[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit
Вставка
- Опубліковано 23 лип 2024
- [[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit
Subscribe our UA-cam Channel and press the bell icon to get regular updates👇: bit.ly/3tt2eNY
🔴 Code: github.com/pik1989/PBI-DAX
(Power BI DAX)
- Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models.
In this video, we will be learning all the important DAX functions in just under 1.5 hours
Join our Telegram Channel For Exclusive Data Science Resources👍 :
bit.ly/3FzObsk
Check Out Our Other Helpful Videos:😍
➮ Data Analyst vs Data Scientist vs Data Engineer - Roles || Responsibilities & Skills
bit.ly/3qsg2pL
➮Live Implementation of End To End Machine Learning Project With Deployment | Customer Churn
bit.ly/3FqPQjF
➮ Build your own Alexa in 30 minutes using Python | NLP | Data Science
bit.ly/3FFBWdP
…………………………………………………………………..
Follow us on: ✌️
FACEBOOK: bit.ly/3I89SB4
INSTAGRAM: bit.ly/3tsVpf9
LINKEDIN: bit.ly/3fmwmCa
Hello Friends , I am Satyajit Pattnaik, In my channel you will find every information about Data Science & Analytics which will help you become an expert Data Scientist or a Data Analyst along with which you would enjoy a loads of interesting and useful projects.
More & more great stuffs coming soon, keep supporting & learning 🎓
THANKS FOR WATCHING 😊
#powerbidax #powerbi #dax #satyajitpattnaik
![Power BI DAX Tutorial - Beginner to Advanced [Full Course]](http://i.ytimg.com/vi/4rC9Ow76n0U/mqdefault.jpg)
Awesome! I like that you talk about and show examples from SQL and Python. Hope you keep it in your videos :)
Awesome way of teaching DAX .😊 We are waiting for your next video
I have understood these concepts earlier but somewhere I was lacking to learn it, now it's more clear bcz ur teaching style gives clarity on each topics. In today's class, I understood the implementation and application - why, where & when to use those concepts. Thanks a lot for this session... Love you❤🤟 God bless you
Thanks a lot for this comment 🔥🔥
Thanks for your dax video, Its very easy to understand.
way of teaching amazing.tq sir
Thank you so much for the video. I am preparing for Power BI interview a guide would be helpful like what all we need to know means the topics and scenario. This was great video
It is Awesome. Waiting for your Advance and complex DAX calculation video.
Amazing video for beginers
Very informative content, Thanks for the wonderful session!
I am glad you liked!! 🔥
interesting n informative session. Thankyou sir...learnt many many things today in BI
I am glad you liked 🔥
Very informative video👏❤
super nice explanation.
It was really an awesome explanation on this topic!! It literally cleared my doubts, thankyou sir for such an amazing content! Please make more such videos on powerbi ;))
I was looking for same and finally you uploded it. Really Amazing Video. Keep Growing🙂
😎😎
Cannot thank you enough for making such a crisp video on DAX🙏
😍😍
Thank you sir for uploading it, it's really helpful.
Welcome
Thae way of teaching is very impressive and reliable. could plz provide interview quation and answers as a pdf plz.
Very informative and useful video sir, appreciate your work 👏👏, please if you can make a detailed video on power query in PBI also, it will be great, thank you sir
I already have a detailed end to end video, search power bi Satyajit, you will get it..
@@SatyajitPattnaik yes sir found the video 🙂
00:03 DAX is about data analysis expressions and using functions like sum, average, min, max, count, count rows, calculate, and filter.
02:23 Differentiating between measures and calculated columns
06:59 Understanding the difference between calculated column and measure
09:13 Power BI DAX functions make data manipulation simple
13:49 DAX is good at two things: aggregations and filtering.
16:14 Understanding and validating DAX measure assignments
20:32 Creating measures for minimum and maximum salary using DAX functions
22:52 Understanding different DAX functions
26:53 Power BI DAX functions for date and time analysis
29:15 Creating calculated tables and adding/subtracting dates in Power BI using DAX
33:15 Creating relationships between tables and adding new tables in Power BI
35:23 Creating a calendar table in Power BI for a specific date range and sorting the data based on month numbers.
39:24 Creating filter context in SQL and Power BI using calculate keywords.
41:29 Creating measures and filter context in Power BI DAX
45:47 Filtering a table using different methods
47:57 Understanding if-else and nested if blocks
52:20 Creating conditional columns in Power BI using DAX
54:38 Time intelligence functions help manipulate data using time periods.
58:47 Creating and understanding total year-to-date (YTD) in Power BI DAX
1:00:54 Explanation of Year to Date (YTD) concept
1:04:59 Using DAX measures for time intelligence in Power BI
1:07:00 Time intelligence functions for comparing previous and current values.
1:11:20 Reducing columns to optimize memory consumption.
1:13:25 Creating DAX expression for calculating total
1:18:12 Understanding the difference between average and average a in Power BI DAX
1:20:22 Using the x function saves memory and CPU utilization
Crafted by Merlin AI.
Thanks 😊👍
Welcome 😊
Very informative video, but while I was trying to practice ,in report view col name are coming as 'Sum of estimated salary' for all whole numbers and decimal numbers.
Thank you for this video. It was really helpful. Can you also make a video on data modeling in power bi?
Yes can be done
Thank you sir !!!
Welcome 🔥🔥
Hello Sir,
Could you also make a video on how to prepare for Pl-300 certification for Power BI beginners?
U better become pro at powerbi that's only how u can crack it.otherwise there is no chance of cracking it
Best option is to share the data set to practice along
@@RK-wf7re please check description of the video 😀
If I am Nurvous about Job then I saw your videos. Then I get confidence to start study
Such a huge compliment 🙏
53:52 - Time Intelligence
1:08:12 - X and nonX
Awesome video just one feedback some places content was hiding by your picture.
super video....if you have any full course ob power bi
I have most of the videos on my channel, for a more structured learning you can enroll my course , it costs INR 999/-
It helps me to understand dax...one feedback please dont use bgm it distracts
Sir pls made same video for SQL for data analyst means from beginning to advanced level
There's already a SQL video, check my playlists.
Very nice. Do you have example file to download? thanks
bro superb i am also interested in teaching , can u guide how your recording and which softwer are using and editing can i know and mic part can u say just for growing my channel im asking
Hi Satyajit, Thanks for this wonderful session. I have one doubt. At 51:45 , when you are calculating age bins, there is a row which has age 103, ideally the age bin should be "greater than 60". Why does it show 20-40?
Not clearly visible, can you try the same and let me know if you are able to get the same problem or not
@@SatyajitPattnaik Hi Satyajit, I'm still getting the same. Also, at 50:29 when you sorted Age in descending order, first record shows a person with age 706 which is not possible. When I opened the csv file in excel, max age I can find is 92. Not sure why in power BI it shows something weird. Am I missing something?
@@gauthama4092 Age might be getting summarized, click on the Viz, go to the fields, and click on Age and see if it is in Don't summarize mode or something else, must be a minor problem
@@SatyajitPattnaik Sure. BTW this is an excellent tutorial. Thank you for this great video.
In real time scenarios do we really need to create the tables in power bi level, because we will have all the required tables in backend right?
@@RK-wf7re in interviews, you will given some industry level scenarios and real time issues or difficulties you faced in Power BI and how did you come over that, also focus on static/dynamic rls, dataflows etc
Plzz send the raw data set .... I want to practice...
Can you help me with the link to download datasets
Though it is very informatic, but at 9:56 48/12 is giving me 6 (Tenure in years) which seem incorrect. Have doubt
Could you provide the raw dataset what are you using in this video??
could you please provide the data for practice
Pls provide the data set link which you used in this vedio
When i tried to pull columns to canvas why those columns are getting summarized with aggregate functions like sum, count etc. But in your demo its not happening, could you advise how to avoid summarization?
kindly provide the Dataset Sir
At 9:09 the "Tenure" measure I created is not working for me. Error: Cannot find name ["Tenure"]. Some please help even though I have that column.
I don't have drill through option in power bi.I tried many times but failed.what to do please tell me
kindly provide us the dataset
Background music is annoying. Content is good.
i am niy able to set quality of the video.. can somebody pls help to set it upto 1080p or is it not avaiable for that format.
click on settings button, quality and advanced
Is it enough to get a job ? Or have to learn something?
It's enough
At vedio duration - 29.56
For DateAdd why there is Blank rows showing and what do u mean by the dates are not available?
I mean how is this possible that dates are not available?
Will be glad if u clear my doubts.
Kindly reply something
@@AmitKumar-ft9go oh sorry, I thought I answered.
DateAdd basically will show those values that are in the range of the original Date column, infact that's how all Time Intelligence functions work.
Just imaging a scenario, if X is derived from Y, how can X have new values that are present in Y
at 26:36
why you wrote AirPassengers[Month],Today(),year
why not AirPassengers[Year],Today(),year
Are u from Odisha
@@pritishparida29dec83 yes
@@SatyajitPattnaik Bhaina mote tike top 50 Dax functions kahibe jouta power bi re frequently use huye
You need raise your voice loud enough otherwise you'll be successful
Thanks
Increase ur voice... Else shutdown the background noise
Background Music
background sound is not good
Turn on the cc’s
please dont put any music in your videos
This is a 2 year old video, I stopped putting music on my recent videos 😀
keep shut down background music
Screen is not clear, do the needful
Not clear
Its not that crisp and clear... and I do not understand why you are using PDF to explain the concepts.
Did you go through the entire video?
I hardly used the presentation for less than 5% of the entire time to show the DAX functions and then explained it on Power BI, pls go through the videos before commenting 😀
there is no need for that background music. already your microphone is not that good
Apologies
Plzz send the raw data set .... I want to practice...
Check description