MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets.

NO HOMEWORK for this video.
This video teaches about Power BI Online. How to upload Excel Files. Create Online Dashboard.

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Topics:
1. (00:15) Introduction.
2. (01:00) Logging in to Power BI Web Site to view reports.
3. (01:48) Introduction to Dashboards, Reports, Workbooks and Data Sets.
4. (02:48) Create Workspace.
5. (03:19) Upload Power BI Report Files.
6. (03:45) Upload Excel Power Pivot Workbook File. Two Methods: 1) Upload Workbook (to see sheets), 2) Upload Workbook Data (upload Data Model from Excel).
8. (05:17) Look at the four sections (Dashboards, Reports, Workbooks and Data Sets) after we created a Workspace and uploaded items.
9. (05:43) Create Online Dashboard in Power BI Online.
10. (07:01) Create Power BI Report Based on the Data Model in a Published Excel File.
11. (07:56) Summary for Dashboards, Reports, Workbooks and Data Sets

[excelisfun]

Note: In the Video we pinned Pages or Tabs to Dashboards, but you can also pin individual visuals from a Page to a Dashboard or Highlight a range in an Excel Sheet and Pin it to a Dashboard. When you pin individual elements like this, when you click on them they take you back to the original Page (Tab) that you copied the visual from (link back to original Page).

[simfinso]

1 of the Most Authentic You tube channel For Excel videos. I learned Most of my Excel knowledge From this channel. Thanks sir

[wayneedmondson]

Hey Mike.. can't let the year end without expressing my sincere gratitude to you for all the resources you make available to the Excel community. Your videos are not only highly informative in content, but very entertaining and engaging, as well. Your generosity in sharing the various series and topic oriented playlists is very much appreciated. For anyone who takes the time and has the patience to watch, you can rapidly and greatly up your game in EXCEL, as well as learn new things about finance, accounting, statistics, data handling and more. It's like a one-stop-shop for the knowledge worker of any kind.. and.. all for free.. amazing! I can't wait to sink my teeth into your new MSPTDA series next year. Once again, thanks for being my go-to Excel resource in 2018. You, Leila and a few others are outstanding MVPs and deserve all your success and more. Looking forward to more of the same in 2019. Cheers.. Happy Holidays.. and Thumbs up!

[jackiezhang]

It is a really educational video. Easy to understand and very useful at various work reports. Why I am only seeing it now? Waste so much time before.

[RobMichaels]

It is great to be able to use your example MSPTDA files and one's own Power BI account to "follow-along". It is the best way to learn. Thanks again!

[jimjs]

Sir. Thank you for everything you do.

You are becoming impactful in my personal career as I approach the business intelligence field. Thank you!

[NoShadowOfDoubt]

Looking forward to watch MSPTDs 16 to 17 this weekend. ..more focused!

[georgekariuki]

Awesome teaching style!Keep up the great work Mike!👊

[pabeader]

Not just WHOLE pages but you can pick just particular visuals to pin...

[ikark]

Great video, as always! At the last you are revealing a mastering of PowerBI Art! :) Thanks, espeсialy for scrupulous pdf notes, it's so helpful!

[kamranb]

Thanks Mike, really looking forward to iterator functions and calculate :-) I have a question about excel scenario analysis as well, when I use the scenario button to run scenarios I get a pop up "Redefine scenario based on current cell values?" Any idea how to fix it. I don't get the pop up when I run scenario using the scenario manager.

[MalinaC]

Amazing! Thanks for video and Merry Christmas, Mike!

[Sbudarh_P]

Hello, everyone, I would really appreciate your assistance, I need to log in PowerBI online since the Machine I have doesn't have enough space to run powerBI desktop and the PowerBI online doesn't take a Gmail account as a username. what is the alternative method to log in?

[brwoodlands]

This is great. Thank you. Question: if I share this report with another user can the user be able to refresh data when I update the data (I am the owner of data)

[opowerplatform]

When will PBI online and PBI Teams have more designer and data modeling features so we don't need to install and run PBI desktop and windows so often? For example, why did MSFT roll out PBI Teams, but not allow it to connect to DataVerse for Teams tables without having to get the data PBI desktop and publish it? Seems backwards to have to do that. Anybody else agree this is kind of a miss and should at some point show up? Looking forward to being 100% cloud including a desktop that is just a browser. just saying...

[celinexu]

Hi, sorry for stupid questions: 1. the excel you mention also using the online version opening? I am not able to find the 'publish' option for my desktop excel(i am use Mac version though). And 2. seems only PowerBI pro can create working space right? if I have premium version, does that work?
thank you!

[tulsidasjamnani]

Mike sir,
I have a Formula sheet
Which converts number to
With Vlookup nd Etc... Formulas...

[keepcalmuvlbn]

Why these Wonderful Videos are not in Order ?

[teckhindi]

Hello sir, how r u ?
I do work like an accountant..
I want to do ..Show all items of an invoice... Randomly in row wise., Not in single row....If I use vlookup formula...It show only one item in one row....
I want that as I put invoice no. In a cell, it show all sold items serial wise in different rows...Like a Bill...
So that...When I put next invoice no. It show another invoice 's items details....
I hope u understood my problem..
Please help

[Ed-yjep]

Can multiple people edit at the same time? Google sheets allows this in the Google drive but I highly prefer excel. Or do I have the wrong idea about Power Bi?
Thanks for all your 'excel'lent teaching, greatly appreciate it. Learned many things and built awsome stuff even though I'm a total noob at this.