Power BI Advanced Tutorial
HTML-код
- Опубликовано: 2 авг 2024
- Power BI Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/2W9iMvZ
Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.
What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.
What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
Enroll in our live, instructor-led Power BI classes:
bit.ly/3K9MMfh
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Creating Calculated Tables 2:08
Creating Calculated Columns - DATEDIFF 6:03
Creating Calculated Columns - RANKX Highest 9:32
Creating Calculated Columns - RANKX Lowest 12:54
Creating Calculated Columns - RANKX Dense 18:50
Creating Quick Measures 20:40
Creating Measures 26:54
Creating Date Tables 31:38
Time Intelligence Functions 41:59
Key Performance Indicators 46:13
Additional Key Performance Indicators 49:59
DAX Recap 53:44
Introduction to Optimizing Model Performance 54:41
Publishing Dataset to Service 57:16
Using DirectQuery on Power BI Dataset 59:48
DirectQuery vs Import File Size Comparison 1:01:46
Importance of Variables 1:05:09
Building a Measure to Use in a Measure 1:07:11
Building a Measure with Variables and Comments 1:09:06
Adding Measures to Multi-Row Card 1:16:59
Other Optimization Techniques 1:19:53
Conclusion 1:21:23
#PowerBI
Finished the first 3 tutorials. Excellent teaching style. Detailed explanations but still very simple. I would recommend this series to anyone who wants to get into Power BI. This series should be the first one before anyone decides to go to the next stage of other Power BI project available on the web.
I am using the Desktop Free license and I was under impression that Power BI Service is free for individual learner but it is not free! When I tried to create an account for the Service, I was asked a corporate e-mail address which I do not have and it did not accept my personal Yahoo e-mail address. In contrast, Tableau free version comes with a free cloud account where I can publish my visualizations.
Hi Umeash! Thank you so much for the kind words! We are working on getting some Tableau videos created as well!
the same thing happened to me.. how did u sign it to the Power BI service
45:43 I paused and tried to write the _End of Quarter_ function and ended up with
*End of Quarter = "Q"&QUARTER(ENDOFQUARTER(Orders[Order Date]))* which displayed _Q1, Q2, Q3..._
went back to the lesson and this wasn't done but I felt so good that I understood what I was doing on my own...
Thank You so much for this course...😊
Excellent Course.. An essential course for every Power BI learner.👌👍👏 . The hardworking of the instructor is much appreciable.
Thank for the kind words Zahoor! We appreciate it!
I am Amazed by your great Selfless Effort. You inspire me a lot on this Subject since i stumbled on this tutorial Trish Conner-Cato. You are highly appreciated. Bless up🙏👍
Thank you for the kind words!
You're welcome ma'am.
No doubt your teaching style is really amazing and easily understandable Appreciate-able
Thanks a ton!
I like the instructor's clear and articulate style. Unfortunately, the examples (at the 31 minute mark) regarding Average Sales Per Product Category returns the wrong result. There should not be an "ALLSELECTED" function at the end, because it removes the filters inside the query. Each category should have a different average not the same. To correct the DAX formula, remove the "ALLSELECTED" function, do small multiples with the product category, and you will then see the correct result.
Noted! Thank you for the tip!
I did this and now I can't see any results in the modelling view. It says there's a calculation error
THANKS FOR YOUR FREE COURSE WHICH IS WORTH THAN PAID COURSE.YOUR TEACHING STYLE IS OUTSTANDING.HATS OFF MAM......YOU MADE THE COURSE EASIER TO UNDERSTAND...
You are very welcome!
It’s a very powerful
, clear teaching lesson, best of RUclips channel, you guys help lots of people!
Thank you! 😃
Thank you for the Videos.
Question on Rank Function, can it rank with Multiple Partitions and Order by multiple fields?
Example: can it rank by Grouping the State, City, Product then Order by Sales Total and Cost by Goods?
Thank you!
I've finshed the third video right now. This channel became my second home. Thanks learnit.
You are welcome! Thank you so much for watching!
Awesome, concise and crystal clear!
Building Date table, is absolutely amazing. In addtion to year, quarter, month, I went on extracting the
"day of week as number", weekday([date]),
"week day as text", format([date], "ddd"), just the same logic with excel date time and text functions!
Glad it was helpful!
It's really amazing, I am not a native English speaker, however, I was able to understand everything because of your simple language.
You are welcome!
Thank you again for this session. Appreciate your detailed explanation!
Glad it was helpful!
@Learnit Training. It's a great tutorial, but next time, zoom in to increase the font size and sharpen the focus for better display
Noted!
Thanks for the comprehensive documents, datasets and links provided.
You are welcome!
Very clear and easy to follow, a really useful learning video!👍
Glad it was helpful!
Excellent tutorial and the very good communication by the tutor. I would suggest you to zoom in or enlarge the formula bar, sometimes the code you write at the formula bar looks to small - I have covered all sections and reviewing this now but my suggestions regards all parts.
Thank you for the tip!
Hi Trish, Thank you for this series of videos. They are very helpful and very detail.
You are so welcome!
Thanks a lot for the wonderful course. appreciated.
You are very welcome!
Your video is so good and explanatory. I have one question I want to learn how can we add more than one excel file from data source settings
Combining Multiple Excel Files:
If you want to combine data from multiple Excel files into one dataset, follow these steps:
Go to the Home tab in Power BI Desktop.
Select Get Data and choose Excel as your source.
Follow the prompts to select the files you want to import and set your data transformation options
I am Speechless how can she give so much valuable info i am delighted to share that i have just completed first two vidoes i am stunned right now I appreciated the effort that you put into the video Thank you 🙂
Wow, thank you!
Mam,You are just amazing,the way the tutorial is organized,the contents u have put in ,the speed with which you deliver, everything is fabulous,no words but just amazing...please make one on SQL also ....
Thank you for the kind words Jyothi! We do have a new SQL video coming soon!
@@LearnitTraining Waiting mam ...
Thanks for this excellent lecture
Most welcome!
In this video the fields related to customer and product are taken from the order-table. Why make dimension-tables for customers and products in the last video if they are not used?
Amazing! Thank you for sharing!
Our pleasure!
Hello, Madam, your teaching and explaining things is quite interesting and quite easy. So could you provide me the link to download the POWER BI into my windows.
www.microsoft.com/en-us/power-platform/products/power-bi
Awesome. Nicely explained.
Thank you 🙂
In the multi label card the category labels not showing, just the word Blank above the value?
QQQ: Date Table card is not showing in model view. Re-did Sample Superstore, everything is exactly as you have. Was able to edit relationship by right clicking Orders, making 1 to many relationship but Date Table catd still does not show in model view. Is there some setting that needs to be changed in order for it to show Date Table card? Please advise. Thanks.
Thanks so much. The training is wonderful and I learnt so much. Would appreciate if you do a consolidated FS presentation
We will look into that! Thank you for watching!
Hi, I appreciate your videos so much. Thank you for taking the time to make them. I have a small problem though, my PowerBI desktop application is apparently not compatible to open the Retail Analysis Sample file. I am having trouble moving forward with my learning due to this, can you please tell how I can fix this?
Thank you, the video was very helpful👍
Glad you learned so much!
Thank you 💕
Thank you for your continued support Ahmad!
This series is too good to be true
Thank you for watching!
This woman is a god send…my goodness…
Thank you for watching!
thanks so much for the for the excellent and clear way of teaching ............
i have question on Dax formula : End Of Quarter = ENDOFQUARTER(Orders[Order Date])
when i apply it the output is like (3/12/2004) , it does not giving me the (3/30/2024), as the same as the (ENDOFQUARTER) DAX formula ??!!
What was the reason to create the table with distinct orders?
If we only wanted the number of orders made, there should be a much simpler way of getting the count of distinct orders.
I really appretiate if you could explain and clarify this point.
thank you!
You are welcome!
Thanks for your video.
You are welcome!
Thank you for your hard work.
Can u please keep long distance in advertisement?
I m loosing focus due to too many ads within 5 min interval
Noted
@@LearnitTraining thanks a lot
If anyone is also getting this:
At 16:41 I got the error, "Loading blocked by failures with other queries." In one of the error prompts, the table that's responsible for the error can be seen as it's the one with more info. Opening PowerQuery and refreshing from there seemed to fix this problem for me. Was able to then "Close and Apply" in PQ and refresh again on desktop and it was fine...
Thank you for the tip!
Thank you...... Table "Orders by Region". Open the PowerQuery, select this and refresh.... Thankssssssssssssssssssss 🙂
@@TheMysterySolvedFox How good is your R programming?
Thank you Jude for this tip, I saved my excel before refreshing on Power query and it worked just fine.
@olamidelawal7468 Oh, no problem at all. All the best with your learning! 💪
Learning other programs as well?
while working with real world experience, will I get a place where I can read the functions ?
at 2:15, does anybody know why we started by clicking on the modeling tab instead of transform data?
and, creating the column w/ the distinct numbers looks like the Order ID column was copied... so I"m wondering whats a realistic reason for needing to know how many order id's there are?
Hello diamondsandlipgloss! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining not sure if you're a bot, but if you're an actual person, you've said that w/each of my comments, but no one answers me on that forum....
therefore my question is to other viewer who may answer here on RUclips 🙂
I guess somethings can be done without using power query so we didn’t click transform data,, not sure tho
However we didn’t copy the Order ID column, if you noticed the rows in the new column are 1746 while OrderID in Order table has 2428 rows. It basically shows the distinct values.
Several Products can be in the same order so they all will have the same OrderID and it will be repeated for each one.
So thee realistic reason would be to know how many orders were made!
I hope that made sense
cam on ban/ban rat nhieu xuat hien dung luc minh can yeu giong ban qua
Không có chi! Cảm ơn vì đã xem!
Hey, Where can I find documents you mentioned in the course? I cannot see them in Manuals
Exercise Files: bit.ly/2W9iMvZ
This course is helpful ❤
Glad you think so!
18:18 Unfortunately I don’t have a string Search when I try to sort datas in a column. In Transform Data it’s all right, but it’s useless for Days to ship etc. Though with text column non there is such problem.
Thanks for the tip!
Thanks a lot
Most welcome!
At 17:00 there is need to seach of numeric numbers from order id & sales ranking lowest column but there is no such search box appearing in numeric columns (available in string columns), is there any setting I need to do, plz tell If you know?
Well-Done
Thank you!
why for some years the end of July month (say) is 31 and for other years is 28 or 29? ... and what the point of a function like CALCULATE(SUM())? Isn't Sum by itself going to do it and we don't need the CALCAULTE function?
Good Afternoon mam... Your teaching method is very amazing it's really understandble I create powerbi report simultaneously ...I have one dought in verible chapter
Thank you for watching!
After declaring the variables in the meaures 2010 ,2011 and 2022 , once i use the multi row card visualization i recieve the following error ,
Cannot covert value 'January' of type text to type Date while processing column - dates[month] -> Orders[Orders date].
How to resolve this, where did i go wrong
Hi Buddhist! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
finished watching
Thanks for watching!
I believe your explanation for quick measure is wrong. We are not getting the averges by customer segment in the visualization.
What the measure did is - it took the base value i.e. average of total sales entirely, and then as we added totals per category, it made the category i.e the customer segment irrelevant, that is why you are seeing the distribution of that measure around customer segment showing the same value.
Thanks for the feedback!
finished practicing
Awesome! Keep it up!
can you please upload a project on power BI
Direct query doesn't bring data into power BI so how can we perform queries with data like Dax, modelling, data shaping etc? Pls elaborate
we can only work with the desktop files as we don't have an account for web files.
fingers crossed for PowerApps beginner to advanced videos
Hi Burak! Yes PowerApps and PowerAutomate are two videos scheduled for production soon!
@@LearnitTraining Thank you so much. I love the video it is very simple, plain, and easy to follow, understand and apply at the same time.
Can you share the file of tables used in Retail Analysis sample?
At 41:45, the Dates table is not showing up under relationships. What do I do?
Maybe it's on the far right side, try and scroll more to the right. That was my case, hope it helps!
@@klarawijs Resolved by closing and reopening file. Maybe it was a cache issue.
This whole playlist is enough to prepare full power bi?
Yes, it will give you a solid foundation to create all types of data visualizations.
Thank you so much
For me, trying to create the quick measure Average Sales by Customer Segment crashes Power BI when I bring up the dialog to change Sum of Sales to Average of Sales (as you do at 23:32). The dialog contents disappear and a blank grey box is shown, modal until I close it on the taskbar.
Hi Claire, I'm having exactly the same issue. Did you find a solution? Thank you, Mark
I found a solution to this provided by MS within the PowerBI community.
Options - Global - Preview Features - uncheck (disable) Power BI Desktop Infrastructure update. Restart Power BI.
This solved the issue for me.
Thanks
Mark
@@dbr2msf Thanks so much for digging this out, Mark - I shall try again!
@@dbr2msf Thanks, Mark. Problem solved for me also.
Hi Claire! You seem to have seen viewed PowerBI classes from both Chelsea Dohemann and from Trish Conner-Cato as well. I have only seen the 3 tutorial classes by Chelsea. Would you recommend me to watch these tutorials as well?
I need the lense of James web telescope to see what u write in Dax formula bar. Plz Increase zoom ratio.
Noted!
When I am create 2010 corporate segment total sales measure and similarly for 2011,2012,2013 years it's all values are same and values also not correct as per your report????
Hello Utkarsha! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hey can anyone tell me, does this video cover DAX topic?
We did quite a few shows on DAX - ruclips.net/user/livegj3xbZZEAcQ
Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population will come from measure. If I select any state from slicer , then in the table, respective district list should appear and there population.
Please advise how we can do this.
Hello Ravinder! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
at 17:03, why can't i see the search box while some other columns have it and some don't
Find any solution?
Can I get some help? I don't have the search bar on the Order ID's drop down menu.. 17:22
Hello Fernando! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Mam I was getting an error while opening retail analysis sample from power BI dataset as "We couldn't connect to your model in the Power BI Service. The dataset may have been deleted, renamed, moved, or it is possible that you don't have permission to access it".
Do I need a Power BI paid subscriptions at any point in this course?
No, you can do the whole video with the trial version.
@@LearnitTraining thank you for the response, I will be commencing lectures.
HI the vedio quality is very poor, I can hardly read any thing.
My vedio quality was set to low so in setting i adjusted it, now its working, please ignore my previous comment. thanks
Can't publish to the service. How do I get the service without the "work" email address?
Hello 2 Took! To publish in Power BI you will need a least a Power BI Pro license.
Why this irritating add again and again