Power BI Expert Tutorial
Power BI Expert 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/3IgyKaf
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 Reports with Pie Charts 2:09
Adding Tooltips to Reports 4:00
Formatting Reports with Pie Charts 6:25
Filtering and Sorting Reports 10:34
Sync Slicers 18:16
Creating Drill Through Pages 25:18
Creating Source Reports with Slicers 28:27
Using Drill Through 32:40
Formatting Drill Through Pages 35:52
Formatting Two Objects at Once 40:53
Conditional Formatting 42:45
Bookmarks 47:47
Accessibility Features 51:13
Accessibility - Alt Text-Data Table-Focus View 53:00
Accessibility - Tab Order 58:07
Accessibility - Colorblind Friendly Theme 1:00:08
Adding the Histogram Visualization 1:01:17
Creating Histograms 1:03:55
Copy Visual 1:11:16
Reports Recap 1:13:58
Introduction to Creating Dashboards 1:14:32
Creating Dashboards - Editing Published Reports and Pinning to a New Dashboard 1:16:57
Introduction to Real-Time Dashboards 1:24:33
Creating Forms for Pushing Data 1:27:18
Creating Push Datasets 1:33:01
Creating Reports for Real-Time Dashboards 1:37:38
Creating Dashboards for Streaming Data 1:41:58
Accessing Power Automate 1:44:15
Creating a Flow to Push Form Data into Dataset 1:46:14
Respond to Survey 1:52:51
Viewing Real-Time Dashboards 1:53:48
Enhancing Dashboards with Custom Themes 1:56:59
Enhancing Dashboards with Videos 2:00:08
Configuring Dashboard Tile Alerts 2:02:31
Using Q and A and Quick Insights and Add to Dashboard 2:05:16
More Dashboard Features 2:11:48
Conclusion 2:17:48
#PowerBI
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 79
Thank you very much! Although I've been working with Power BI for a long time, I've discovered a lot of useful functions thanks to you.
@LearnitTraining
2 жыл бұрын
You're very welcome!
@ankitakumari4270
8 ай бұрын
Sir aftr paying on this course is it again ask money
Even in 2023 this is still very helpful as a series. Thank you! Things might look a bit different, but everything is easy to follow with a bit of searching.
@LearnitTraining
6 ай бұрын
You are very welcome!
Thank you, I have learned a lot for past couple of days. My favorite one was creating Form and then set-up push dataset power automate to generating flow.
@LearnitTraining
2 жыл бұрын
Fantastic!
31:04 For new PBI versions, settings can be found in the format area of the Visualizations pane... under "visual".
Thank You Learnit Training team in advance,
@LearnitTraining
2 жыл бұрын
Our pleasure!
thanks for the upload! 25:25, 51:25
Thanks for this excellent lecture, excellent instructor , Abeer from Egypt
@LearnitTraining
2 жыл бұрын
You are welcome!
Hi Thank you for sharing your experience on power BI. A collaboration from me for all viewing this video, On minute 42.30 approx.., You can select the left visualization when personalized and then go to format painter icon and then select destination visualization in which you want the same properties. At least in this case it worked for me.
@LearnitTraining
2 жыл бұрын
Thanks for the info!
@coolkuku012
Жыл бұрын
@@LearnitTraining oooooooo 🙏🏻ooooo
@coolkuku012
Жыл бұрын
Po on po for your ooooo oooooooo 🙏🏻 ok love to ooooo
Awesome!!! TQVM!!
@LearnitTraining
2 жыл бұрын
You are very welcome digigoliath!
Great course for beginners! thank you!
@LearnitTraining
11 ай бұрын
You're very welcome!
Thanks! Though this couse is slightly dated, i am impressed at the minute detail oriented way of explaining every detail, that helps an absolute beginner. i give up on most TLDR stuff but not this one.
@LearnitTraining
6 ай бұрын
Thank you so much Prasad! Your support helps us continue to make new videos each week!
Great course as usual. However, the Supplier Quality Analysis files aren't in the exercise files.
excellent instructor
@LearnitTraining
2 жыл бұрын
Thank you kindly!
Help!!!! From today The filter was deconfigured in the drop-down menu selection, that is, when opening the drop-down the position of the filter data appears in another part of the screen and not under the menu, this happens when uploading the report and opening it on the Web. ¿ also happens to them?
Great tutorial video, thank you very much! A little help if someone is doing it in Hungarian and gets stuck with the drill-through: A Drill through magyarul Részletezésre lett fordítva. Én csak úgy találtam meg ezt a funkciót, hogy rá kattintottam a vizualizációmra, legfelül megjelenik az Adatok/Részletek fül, ezen belül rá kattintottam a részletezésre, ezzel azt bekapcsolva. Ezután jobb oldalt az adatoknál kikerestem a Category-t, arra jobb klikk és a legalsó lehetőség a "hozzáadás a részletezéshez". Sehol máshol nem találtam a megoldást, csak így. Remélem valakinek segítettem ezzel és nem megy rá egy órája, hogy megtalálja a megoldást. Wishing you a good study!
@LearnitTraining
6 ай бұрын
Thank you for the great tip!
Where can I get the “Supplier Quality Analysis Sample” from? I didn’t find it on the exercise files.
This course is helpful ❤
@LearnitTraining
5 ай бұрын
Glad to hear that!
Thanks Again.
@LearnitTraining
2 жыл бұрын
You're welcome
Thank you, the video was very helpful👍
@LearnitTraining
Жыл бұрын
You are very welcome, thank you for the support!
Nice for beginners. Thanks for sharing. But the use of variables is highly inefficient. Variables are temporary storage, don't forget this fact. We can do single line calculations with the "Calculate" function.
@LearnitTraining
2 жыл бұрын
Good point!
謝謝!
@LearnitTraining
2 жыл бұрын
不客氣!
Appreciated
@LearnitTraining
2 жыл бұрын
Thank you for watching Akhtar!
Can anyone help with the Histogram visualisation? I couldn't find the one she used on this video.
You truly are a great teacher, thank you 🙂
@LearnitTraining
11 ай бұрын
You're very welcome!
great, really informative.
@LearnitTraining
11 ай бұрын
Glad it was helpful!
excellent! thanks!
@LearnitTraining
5 ай бұрын
You are welcome!
Great job. Pls. Review the file download link. I couldn't complete the downloading of the data files after so many attempt.
I've started learning PowerBI since 2-3 days, and so far I've learnt is merging files, transforming data and other basics. Should I consider this video as a level above that for more learning about the software? Also I want to be familiar with the whole software so that I can do independent Projects, So I just to know if I'm going in the right direction or not ?
@LearnitTraining
2 жыл бұрын
Hi Yash - This video series was made to get certified in Power BI via the DA-100 Exam offered by Microsoft so you are definitely going in the right direction.
hey, is anyone else facing the same problem..... when i open a new form in MS forms... it keeps processing but the form never opens despite trying many times
Very interestinf
@LearnitTraining
2 жыл бұрын
Glad you think so!
Super informative. Couple quick notes: The Supplier Quality data used in the end of the video is not part of the downloads package. Because my business is supplier quality, I'd like to review this data. Can I get it? Also, the link to manuals doesn't seem to have any info about PBI, Automator, Forms, and a few others. Looks like just older stuff. Is there an update?
@DennisFalade
11 ай бұрын
did you ever get it? the supplier quality file?
There is no power bi in the manual link
Please , can someone help me out on how to move from Power BI desktop to Power BI service. How can I access the platform where the reports will be published on the web, in the workspace. Thanks as am standing by....
@LearnitTraining
2 жыл бұрын
Hi Nurudeen! You can get started here - powerbi.microsoft.com/en-us/
I am learning and enjoying a lot through these Power BI videos. However, in this video I guess the instructor has not exactly explained the data present in the tables and is just dragging and dropping it to the Visualization pane.
Please how can I move from Power BI Desktop to workspace where the reports can be published?
@LearnitTraining
2 жыл бұрын
Hi Nurudeen! You can get started here - powerbi.microsoft.com/en-us/
I do not know why after adding a new histogram to my visual, the default Microsoft histogram chart (version 2.1.1) disappeared. I had to find the histogram chart file to import into the software. Is anyone related to this issue?
very educative and easy to understand definitely recommend this but where can i get the supply quality analysis file please?
@LearnitTraining
11 ай бұрын
Exercise Files: learnitanytime.com/p/exercise-files-power-bi-full-course-tutorial
Alt+Shift+F11 to get a table is crazy 54:30
1:33:40 Anyone else had to get PBI Pro before new workspace could be created? (Trial version at least...)
@kavishshah5586
Жыл бұрын
Yes.
@shailja2060
7 ай бұрын
I used the same "my workspace"
How can we create drill through for individual data points of Matrix visual in power BI?
@LearnitTraining
2 ай бұрын
Certainly! To create drill-through functionality for individual data points in a Matrix visual in Power BI, follow these steps: Create a New Page: First, create a new page in your Power BI report where you want to display the detailed information when users drill through. You can do this by clicking on the “New Page” button in the Pages pane. Add the Field to Drill Through: Drag the field (column) that you want to use for drill-through into the “Drill Through” fields well on the new page. This field will be the basis for filtering the detailed data. Configure the New Page: Customize the new page to show the data in more detail. You can add visuals, tables, charts, and other elements relevant to the drill-through context. Create a Visual Trigger: Add a visual (e.g., a button, text box, or image) that users will click to trigger the drill-through action. This visual will take them to the detailed page. Select the visual, go to the “Action” section in the Visualizations pane, and set it up to drill through to the new page you created. Test the Drill-Through Functionality: Save your report and test the drill-through functionality by right-clicking on a data point in the Matrix visual on another report page. Users should be able to drill through to the detailed page filtered by the selected data point. Remember that drill-through pages allow you to focus on specific entities (e.g., suppliers, customers, or manufacturers) and provide context-specific details. Enjoy exploring your data! 😊
How to download excercise files? I can see them as files but cannot open them up or download any of them.
@LearnitTraining
2 жыл бұрын
Hi Tomasz! In the upper left of the browser you should see an arrow pointing downwards. Click that to begin the download
@tommylub
2 жыл бұрын
@@LearnitTraining Indeed, it worked. Thank you so much for useful tip :)
Maps & Filled Maps are not supporting...requires tenant admin permission... can someone please help me on this?
@LearnitTraining
2 жыл бұрын
Hi Jaydeep! You can get your question answered at Offsite, our online community - offsitebylearnit.com
@jaydeepsatyani
2 жыл бұрын
@@LearnitTraining also @ 1:39:10 I am not able to see the globe (Map) in my Power BI service visualization pane.
@farzoq1
2 жыл бұрын
actually once you sign in you will not be able to see the maps.. what you can do is sign out for a minute and then go to settings and enable the maps