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

  • @kemalt.4389
    @kemalt.43892 жыл бұрын

    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

    @LearnitTraining

    2 жыл бұрын

    You're very welcome!

  • @ankitakumari4270

    @ankitakumari4270

    8 ай бұрын

    Sir aftr paying on this course is it again ask money

  • @user-pz5rb4xs7p
    @user-pz5rb4xs7p7 ай бұрын

    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

    @LearnitTraining

    6 ай бұрын

    You are very welcome!

  • @waheedbuk7856
    @waheedbuk78562 жыл бұрын

    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

    @LearnitTraining

    2 жыл бұрын

    Fantastic!

  • @judechidozieezenyi9493
    @judechidozieezenyi9493 Жыл бұрын

    31:04 For new PBI versions, settings can be found in the format area of the Visualizations pane... under "visual".

  • @mix_remix
    @mix_remix2 жыл бұрын

    Thank You Learnit Training team in advance,

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Our pleasure!

  • @Eternal_Truth8
    @Eternal_Truth8 Жыл бұрын

    thanks for the upload! 25:25, 51:25

  • @abeerattia4523
    @abeerattia45232 жыл бұрын

    Thanks for this excellent lecture, excellent instructor , Abeer from Egypt

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You are welcome!

  • @eleazarmontano9715
    @eleazarmontano97152 жыл бұрын

    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

    @LearnitTraining

    2 жыл бұрын

    Thanks for the info!

  • @coolkuku012

    @coolkuku012

    Жыл бұрын

    @@LearnitTraining oooooooo 🙏🏻ooooo

  • @coolkuku012

    @coolkuku012

    Жыл бұрын

    Po on po for your ooooo oooooooo 🙏🏻 ok love to ooooo

  • @digigoliath
    @digigoliath2 жыл бұрын

    Awesome!!! TQVM!!

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You are very welcome digigoliath!

  • @KanasProject
    @KanasProject11 ай бұрын

    Great course for beginners! thank you!

  • @LearnitTraining

    @LearnitTraining

    11 ай бұрын

    You're very welcome!

  • @prabadal
    @prabadal7 ай бұрын

    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

    @LearnitTraining

    6 ай бұрын

    Thank you so much Prasad! Your support helps us continue to make new videos each week!

  • @odianosenmasade8150
    @odianosenmasade815010 ай бұрын

    Great course as usual. However, the Supplier Quality Analysis files aren't in the exercise files.

  • @boubekeurabdellatif6695
    @boubekeurabdellatif66952 жыл бұрын

    excellent instructor

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Thank you kindly!

  • @angietoros
    @angietoros2 жыл бұрын

    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?

  • @edems93
    @edems936 ай бұрын

    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

    @LearnitTraining

    6 ай бұрын

    Thank you for the great tip!

  • @anibalceballoshurtado
    @anibalceballoshurtado2 жыл бұрын

    Where can I get the “Supplier Quality Analysis Sample” from? I didn’t find it on the exercise files.

  • @not_amanullah
    @not_amanullah5 ай бұрын

    This course is helpful ❤

  • @LearnitTraining

    @LearnitTraining

    5 ай бұрын

    Glad to hear that!

  • @muhammedbaldeh8126
    @muhammedbaldeh81262 жыл бұрын

    Thanks Again.

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're welcome

  • @user-lm6qm6rc3i
    @user-lm6qm6rc3i Жыл бұрын

    Thank you, the video was very helpful👍

  • @LearnitTraining

    @LearnitTraining

    Жыл бұрын

    You are very welcome, thank you for the support!

  • @firdausjahan8261
    @firdausjahan82612 жыл бұрын

    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

    @LearnitTraining

    2 жыл бұрын

    Good point!

  • @mtcheung
    @mtcheung2 жыл бұрын

    謝謝!

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    不客氣!

  • @khiljik
    @khiljik2 жыл бұрын

    Appreciated

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Thank you for watching Akhtar!

  • @tdouble4387
    @tdouble43875 ай бұрын

    Can anyone help with the Histogram visualisation? I couldn't find the one she used on this video.

  • @yassinechritt8816
    @yassinechritt881611 ай бұрын

    You truly are a great teacher, thank you 🙂

  • @LearnitTraining

    @LearnitTraining

    11 ай бұрын

    You're very welcome!

  • @akundi100
    @akundi10011 ай бұрын

    great, really informative.

  • @LearnitTraining

    @LearnitTraining

    11 ай бұрын

    Glad it was helpful!

  • @quishzhu
    @quishzhu5 ай бұрын

    excellent! thanks!

  • @LearnitTraining

    @LearnitTraining

    5 ай бұрын

    You are welcome!

  • @ezekielolusanya8980
    @ezekielolusanya89802 жыл бұрын

    Great job. Pls. Review the file download link. I couldn't complete the downloading of the data files after so many attempt.

  • @yashgonnade4494
    @yashgonnade44942 жыл бұрын

    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

    @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.

  • @farzoq1
    @farzoq12 жыл бұрын

    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

  • @rezshaja6023
    @rezshaja60232 жыл бұрын

    Very interestinf

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Glad you think so!

  • @pefhra
    @pefhra2 жыл бұрын

    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

    @DennisFalade

    11 ай бұрын

    did you ever get it? the supplier quality file?

  • @user-hj4qr4zx2q
    @user-hj4qr4zx2q4 ай бұрын

    There is no power bi in the manual link

  • @nurudeenazeez8270
    @nurudeenazeez82702 жыл бұрын

    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

    @LearnitTraining

    2 жыл бұрын

    Hi Nurudeen! You can get started here - powerbi.microsoft.com/en-us/

  • @kavishshah5586
    @kavishshah5586 Жыл бұрын

    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.

  • @nurudeenazeez8270
    @nurudeenazeez82702 жыл бұрын

    Please how can I move from Power BI Desktop to workspace where the reports can be published?

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Hi Nurudeen! You can get started here - powerbi.microsoft.com/en-us/

  • @moonnguyenmt
    @moonnguyenmt6 күн бұрын

    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?

  • @DennisFalade
    @DennisFalade11 ай бұрын

    very educative and easy to understand definitely recommend this but where can i get the supply quality analysis file please?

  • @LearnitTraining

    @LearnitTraining

    11 ай бұрын

    Exercise Files: learnitanytime.com/p/exercise-files-power-bi-full-course-tutorial

  • @maiguelguti6818
    @maiguelguti681827 күн бұрын

    Alt+Shift+F11 to get a table is crazy 54:30

  • @judechidozieezenyi9493
    @judechidozieezenyi9493 Жыл бұрын

    1:33:40 Anyone else had to get PBI Pro before new workspace could be created? (Trial version at least...)

  • @kavishshah5586

    @kavishshah5586

    Жыл бұрын

    Yes.

  • @shailja2060

    @shailja2060

    7 ай бұрын

    I used the same "my workspace"

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa3 ай бұрын

    How can we create drill through for individual data points of Matrix visual in power BI?

  • @LearnitTraining

    @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! 😊

  • @tommylub
    @tommylub2 жыл бұрын

    How to download excercise files? I can see them as files but cannot open them up or download any of them.

  • @LearnitTraining

    @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

    @tommylub

    2 жыл бұрын

    @@LearnitTraining Indeed, it worked. Thank you so much for useful tip :)

  • @jaydeepsatyani
    @jaydeepsatyani2 жыл бұрын

    Maps & Filled Maps are not supporting...requires tenant admin permission... can someone please help me on this?

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Hi Jaydeep! You can get your question answered at Offsite, our online community - offsitebylearnit.com

  • @jaydeepsatyani

    @jaydeepsatyani

    2 жыл бұрын

    @@LearnitTraining also @ 1:39:10 I am not able to see the globe (Map) in my Power BI service visualization pane.

  • @farzoq1

    @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