Sala de Sinais

Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰







* O link para o vídeo completo está no final desse artigo.
Saiba mais clicando em Robô IQ OPTION de AUTOMATIZAÇÃO de Lista de SINAIS
E conheça também sobre o Melhor Bot Para Opções Binárias 2021
Que tal um robo gratuito para IQ Option? Sistema Para IQ Option Grátis



This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. 👉 Download Power BI Files in Video at

✅ Subscribe to always get my latest videos:
🔴 Ask Questions LIVE on TalkPowerBI Fridays
👉 Join the Learn Power BI Family (Paid Power BI Training Program)

▶️Topics Covered◀️ (click to jump to topic)
02:27 1. Get Data (Query Editor)
21:42 2. Relationships
33:41 3. DAX
48:15 4. Visuals
56:13 5. PowerBI.com

▶️Detailed Topics Covered◀️ (click to jump to topic)
00:00 How to Use this Tutorial
02:27 1A Meet the Power BI Duo!
03:06 1B Get Data – Connectors and Get Simple Data
08:45 1C Get Data – Query Editor Overview
12:40 1D Get Data – Clean up Messy Data
15:52 1E Get Data – Query Editor vs Macros
17:29 1F Get Data – Clean up Continued
21:42 2A Relationships – Key Concepts 🗝️
24:10 2B Relationships – Creating Relationships
26:59 2C Relationships – Explore Data Using Visuals
32:42 2D Relationships – Analyzing Multiple Data Tables Together 🗝️
33:41 3A DAX – Writing DAX Measure (Implicit vs. Explicit Measures) 🗝️
37:00 3B DAX – Calculated Column
39:03 3C DAX – Measure vs. Calculated Column (Key Concept 🗝️)
44:26 3D DAX – More Measures and Magic!
46:20 3E DAX – Before and After Power BI 🗝️
48:15 4A Visuals – 80/20 Rule 🗝️
49:19 4B Visuals – Text, Image, Cards, Shape
51:28 4C Visuals – Bar/Column Chart, Drill Down
52:51 4D Visuals – Conditional Formatting 🗝️
53:38 4E Visuals – Line Chart, Bar Chart
54:11 4F Visuals – Top 10 Products/Customers
56:13 5A Power BI.com – Publish
57:28 5B PowerBI.com – Features In-Depth 🗝️
59:27 5C PowerBI.com – Everything About Dashboards 🗝️
01:02:19 5D PowerBI.com – Sharing Dashboards with Others 🗝️
01:02:46 Your 3 Crucial Next Steps to Power On!



▶️Next Step In Your Journey◀️
👉 Join the Learn Power BI Family (Paid Power BI Training Program)

▶️Slower Power BI Tutorial◀️

▶️Links to Other YouTube Videos◀️
You can watch ALL the videos mentioned in this Tutorial as part of this playlist
👉

This playlist includes:
• How to Download & Install Power BI
• 🗝️Power BI Licensing (Paid Power BI Options)
• 🗝️Ultimate Calendar Table
• 🗝️Power BI Data Modeling
• 🗝️DAX: Row Context and Filter Context In-Depth
• Data vs. Lookup Tables In-Depth
• Power BI Relationships In-Depth
• Using a Fiscal Calendar (See Ultimate Calendar)
• DAX: Implicit vs Explicit Measures
• DAX: Create Row Context in Measures Using X Functions (Coming Soon. Will be added to Playlist)
• DAX: Measures vs Calculated Columns In-Depth
• DAX: When Is It Right to Create a Calculated Column? (Coming Soon. Will be added to Playlist)
• PowerBI.com: Creating Excel Reports Connected to Power BI (Analyze In Excel In-Depth)
(Coming Soon. Will be added to Playlist)
• PowerBI.com: Setting up Automated Refresh (Coming Soon. Will be added to Playlist)
• Power BI Custom Visuals (Coming Soon. Will be added to Playlist)
• PowerBI.com: Different Ways of Sharing Your Reports (Coming Soon. Will be added to Playlist)
• PowerBI.com: How to Create a PowerBI.com Account (Coming Soon. Will be added to Playlist)
========================================

This Tutorial would take you step-by-step through a LIVE Demo as we
✔️Build a Power BI Model
✔️Create a Beautiful Power BI Report
✔️Publish it and Use it on PowerBI.com

You can follow along using the Download Files (link above).

The Tutorial would introduce you to【 Power BI Desktop 】– the “Authoring Tool” of Power BI. And teach you how to use:
✔️Query Editor
✔️Relationships
✔️DAX Measures
✔️Creating Beautiful & Interactive Reports
✔️and more…

Then we would continue our journey to the 【 PowerBI.com Platform 】- where you would learn:
✔️Publish a Report
✔️Create New Reports
✔️Create a Single Source of Truth for All Your Reporting
✔️Creating a Dashboard
✔️Sharing a Dashboard
✔️and more…

You would also understand the Power BI Process
✔️Author
✔️Publish
✔️Consume

You would learn fundamental Power BI Concepts
✔️Difference Between Creating Models vs. Reports
✔️Implicit vs. Explicit Measures
✔️Measures vs. Calculated Columns
✔️80-20 Rule of Power BI Model Authoring
✔️and more…

⚡Power On!⚡
-Avi Singh

#PowerBI #PowerBITutorial #PowerBIPro

Vídeo

46 Comentários

  1. If you get stuck anywhere in the Tutorial or when applying these principles using your own data, then subscribe & join me LIVE on TalkPowerBI Fridays and bring in all your questions!
    ⚡ Link to Live Stream: https://www.youtube.com/PowerBIPro/live
    ⚡Upcoming Live Stream Schedule: https://www.youtube.com/user/ModernExcel/videos?view=2&sort=dd&live_view=502&shelf_id=17
    ⚡ Recording of Past TalkPowerBI LIVE https://www.youtube.com/playlist?list=PL7GQQXV5Z8efJcW9AYK-4s3YMQg2EMjkO

  2. sir ,you suddenly changed the values in sales amount and txnamt and y? before($3578+$286) and after ($9+$1)

  3. The data files are not being emailed to me. I have completed the form twice, nada.

  4. Hello All, a question. @29:25, after don't summarize the year, contents in the year column disappear (e.g. no sum of the years nor the breakdown of each year) and the SaleAmount is still a lump sum of $29m without the breakdown by each year as it shows in the video. Could anyone advise what the issue is in my situation, please? Thank you very much in advance.

  5. Question. Can we link the sales and budget table if keys were present? That way we could compare all tables side by side

  6. If there’s anyone in here that can send me the downloadable files so I can follow along, I would greatly appreciate it. I filled out the little form to receive the files and follow along in the video but I haven’t gotten them yet.

  7. you super good. I will repeat this video 6 times before I do anything else

  8. Avi, I love your approach to mastering PBI – that Visualization is important, but more important for a true PBI master is to know the backstage -> Query and Model. Thank you for putting all this together, now will be learning by watching your videos.

  9. Can we download the same datasource you use? Is it all right if you provide as a link to download it so we could practice along with the video?

    thank you

  10. Hi, thank you for this awesome tutorial. I would like to ask you how I could make calculations among different tables

  11. I have downloaded the latest (APRIL,2021) version and there are not the same options present as shown in this tutorial. Could anyone help pls ?

  12. Impressive and breathtaking! Thanks a bunch for the thorough introduction to Power BI!

  13. The best Power BI video seen yet. The concept of modelling and how important it is for PowerBI visuals is well explained. Thanks for this video.

  14. Hi Mr. Singh,
    First I want to thank you for the great job you are doing with your tutorials. they are really very helpful and interessting.
    I just wanted to ask for a little bit of help :
    I have a table with data like this :
    AgentName | DateOfBirth | Q1 | score of Q1 | Q2 | Score of Q2 | Q3 | Score of Q3
    Name1 | Date1 | What | 10 |WhO | 8 | When| 9
    Name2 | Date2 | Who | 9 |What | 8 | When| 9
    Name1 | Date1 | What | 10 |WhO | 8 | When| 9
    Name3 | Date3 | What | 10 |where | 8 | Who | 9
    Name1 | Date1 | What | 10 |WhO | 8 | When| 9
    Name1 | Date1 | Where | 10 |WhO | 8 | When| 9
    Name2 | Date2 | Who | 9 |What | 8 | When| 9
    I want to have for each name (distinct row) the type of question in a column and the score under it (Like a matrix where the rows are the names and the columns are the type of questions not the questions number).
    Thank you for your help.

  15. Hi thanks for the video, may I ask you how can I access the files which you used in the video?

  16. I am still watching your video brother. Wola that one tip about unpivot in PowerBI Editor just bought me into this. Thanks. I have been looking for that feature for a year now. Awesome work. Please keep sharing your cool findings. I am now an official subscriber to your channel

  17. tq so much, it really easy to understand, using the layman terms. may God bless you by sharing this knowledge.

  18. thumbs up! one of the best tutorials I have ever seen. keep on the good work, greetings from Germany

  19. modeling tab options like "format" and "sort column" are missing in my PowerBI Desktop, is there any shortcut key to make it display in Power BI Desktop? @Avi Singh – PowerBIPro

  20. Unfortunately class is outdated – I would like to watch same tutoring but with using 2021 Power BI

  21. I was focused and happy until the moment this „remember to subscribe“ notification popped up with sound. After that I was busy cleaning up the coffee i spit at my screen.

  22. This has thought me everything I need to get started with Power BI. So glad I found you!!!

  23. How do I calculate Percentage contribution of one specific one's to the sum of one specific range

Comentários estão fechados.