HomeОбразованиеRelated VideosMore From: ExcelIsFun

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

224 ratings | 8164 views
Download Power BI Desktop “EMT 1366” FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerBIDesktop/1366PowerBI-ReportFinished.pbix Download Power BI Desktop “MSPTDA Video #16 Power BI File” FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerBIDesktop/016-MSPTDA-IntroToPowerBIFinished.pbix Download Excel File from “MSPTDA Video #15 Power Pivot File” FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerBIDesktop/017-DashBoardAndPublishExcel.xlsx Download pdf Notes about video 16 & 17: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerBIDesktop/016and017-MSPTDA-IntoductionPowerBIDesktop.pdf 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). 7. (04:55) View Excel File Worksheets in Excel Online at powerbi.com web site. 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
Html code for embedding videos on your blog
Text Comments (86)
ExcelIsFun (4 months ago)
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).
Kartick Chakraborty (3 months ago)
Sir, I'm facing these two complicated problems. Please help me. 1) Return all the values that match the criteria but with leaving blank ("") every other cells: Sir, can you please make a video on how to return the values with leaving every other cells blank ("")? Suppose there are some sales in November. I have to show all the sales of November, but leaving every other cells as blank (""). 2) 4 ways Lookup but dealing with Merge Cells: Suppose like our Electric Bills, Name of the past 6 months are divided into 4 Columns each. For example, Last 6 months were June, July, August, September, October and November. Under each of these month contains previous year (2017) unit consumption and previous year (2017) billing charges & this year (2018) unit consumption and this year (2018) billing charges. Now, lets assume that there are 5 customers. A, B, C, D and E. Now my question is,- how to Lookup "How much units did customer "D" consumed and the charges that customer "D" had to pay in November of Previous Year (2017) and this year (2018)?"
tushar (4 months ago)
Or you can contact me on [email protected]
tushar (4 months ago)
ExcelIsFun hi sir can you please give your email id , i want to contact you for business purpose
Wajdi Welj (2 months ago)
Merci beaucoup Mike :)
ExcelIsFun (2 months ago)
Thanks for the french kindness, Wajdi : ) And: Thanks you for the support with your awesome comments, Thumbs ups and your Sub!!!!
ikar2k (2 months ago)
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!
ExcelIsFun (2 months ago)
You are welcome! Yes, the pdf notes sometimes take me longer to create than the videos. Together, they are a powerful one-two punch that delivers video teaching and reading & pictorial teaching. Please help support these free resources with comments and thumbs up on each video - it is a small way that you can support complete and detailed resources.
Ismail Ismaili (3 months ago)
hi Mr. Mike I'm so sorry I didn't watch the last 2 videos I don't know why I didn't receive notifications from your channel?
Abhishek Saraswat (3 months ago)
Please remove this video from your play lists "https://www.youtube.com/playlist?list=PLrRPvpgDmw0k_h8ORYyh7waGfuiiufu6H" because it is replicate two time in the same play list. BTW awesome Tutorial. I love this.
ExcelIsFun (3 months ago)
Thanks for the help in editing : ) I am glad that the videos help you, Abhishek!!!!
M. SZ. (3 months ago)
Thank you.
aqeel ahmad (3 months ago)
hi excel fun plz help me hre https://www.mrexcel.com/forum/excel-questions/1081697-cell-value-disruption.html
excel is fun (3 months ago)
Someone already posted an answer : )
Rob Michaels (3 months ago)
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!
ExcelIsFun (3 months ago)
You are weslome, Rob!!! I have been doing that since my first video (over 3000 ago) back in Feb of 2008 -- it just makes sense to give the files so everyone can follow along, learn and have fun!
Abdul Azeem (3 months ago)
hi i have to need your help, example we have 10 Customer so have daily sales. on 23-12-18 cust-1 collect 10 time or more each day, so we have 10-cust. they are also collecting every day. i want make them separate like each customer how much collecting each day. so if there any video kinnda this please send the like to me...
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
Paul Tony (3 months ago)
i have some of kind of chart can you please found next value
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
Paul Tony (3 months ago)
i need you help ..... sir
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
Wayne Edmondson (3 months ago)
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!
Esther k! (3 months ago)
+Wayne Edmondson you took the words right out of my mouth. Been watching the videos for just a bit over a year and I can't believe how much I've learnt in that period. I'm like a different person. I only wish I'd discovered this channel years ago but better late than never. Thank you Mr Girvin. You are guaranteed a thumbs up and comment from me for every video I see. Happy holidays!!!
excel is fun (3 months ago)
+Wayne Edmondson , Go team!!!!! I so agree: We are part of a Team that can help to make the world a better place with Excel : ) As for learning, most all the tricks that we need in Excel are taught in a logical order with the Excel Basics Playlist (Busn 216) and then Advanced Excel Playlist (Busn 218). Thanks so much for your support : ) : )
Wayne Edmondson (3 months ago)
Hi Mike.. count me as one guy who is very grateful. I only wish I had become more proactive 10 years ago when you started to post. Like most people, I taught myself Excel on the job and thought.. hey.. I know what I'm doing. It wasn't until I found the resources offered by you, Leila, Bill J., Oz, Mynda, Jon A., Alan M. and many others that I realized how much I didn't know. It really lit a fire under me. I wish I had the time to watch all your videos.. guess I would have to take a year off.. haha!! I'm working through your various series in order.. Busn 216, Busn 218, etc. and then watching all the daily videos and blog posts that hit my inbox. It really works.. the time invested pays off immediately in my work.. not to mention the satisfaction of gaining new knowledge each day. You will always get my thumbs up and recommendation to colleagues and friends. I've already told dozens of people.. you want to get better at EXCEL, head on over to ExcelIsFun! A side benefit is feeling a part of the larger community lead by you and all the other MVPs.. sharing the knowledge and passion for something we all like and use every day. So.. many thanks again. Looking forward to new adventures in 2019. Cheers and Thumbs up!
ExcelIsFun (3 months ago)
You are welcome Wayne!!! It was all the way back in Feb of 2008 that I started posting over 3,000 videos, all with the idea of providing all the resources in videos, Excel Files, Notes and so on. I am glad that it helps you and so many others. You can show sincere gratitude by simply clicking that Thumbs Up and leave a small comment on each video you watch : ) Thanks for your full and kind comment above, and happy holidays : ) : )
aqeel ahmad (3 months ago)
hi excel fun i have a question i have a table like PO QTY qty avaible a 2 4 a 4 b 6 6 b 8 b 4 c 3 7 c 2 c 5 ---------------------------------------------------------------- Result i want with formula PO QTY qty avaible result a 2 4 2 a 4 2 b 6 6 6 b 8 b 4 c 3 7 3 c 2 2 c 5 2 ---------------------------------------------------------------------------------- with formula
aqeel ahmad (3 months ago)
+ExcelIsFun plz make a video about my question
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
TeckHindi (3 months ago)
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 me.....
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
John Borg (3 months ago)
Thanks Mike :)
ExcelIsFun (3 months ago)
You are welcome, John!!!!
Malina C. (3 months ago)
Amazing! Thanks for video and Merry Christmas, Mike!
ExcelIsFun (3 months ago)
You are welcome for the video Teammate! Happy Holidays to you : )
Rafiqul Islam (3 months ago)
Hi Mike , i have list of 20 person income in Column "a" & i want intimidate next lower in come in cell "b2" base on value in cell " a2" . example as below INCOME RANK NEXT INCOME $8,555.00 7  8TH  VALUE HERE $9,540.00 2 3RD VALUE HERE $8,560.00 6  7 TH VALUE HERE $9,535.00 4 5TH VALUE HERE $8,553.00 8 $9,558.00 1 2ND  VALUE HERE $9,538.00 3 4TH VALUE HERE $9,531.00 5 6TH VALUE HERE
ExcelIsFun (3 months ago)
For back and forth dialog about Excel questions try this amazing Excel Question site: mrexcel.com/forum
NoShadowOfDoubt (4 months ago)
Looking forward to watch MSPTDs 16 to 17 this weekend. ..more focused!
ExcelIsFun (3 months ago)
Cool! Thanks for watching and supporting, NoShadowOfDoubt!!!!
Fox News (4 months ago)
My macBookAir can’t open Power BI Desktop ?? help please
ExcelIsFun (4 months ago)
I do not know how to use a MAC. And I am pretty sure that Power Pivot, Power QUery, the Data Model are not in a Mac...
Tulsidas Jamnani (4 months ago)
Mike sir , I have a Formula sheet ..... Which converts number to words..... With Vlookup nd Len..... Etc... Formulas...
ExcelIsFun (4 months ago)
That is cool!!!!
Chris Mancinelli (4 months ago)
So cool Mike, great video!!
ExcelIsFun (4 months ago)
I agree: it is cool! Thanks for the support : )
Thanks Mike. This is beautiful
ExcelIsFun (4 months ago)
Yes, it is pretty cool, Syed!!! Thanks for your support : )
Tulsidas Jamnani (4 months ago)
There is app available in Google play store for power Bi... Power BI Android app: https://youtu.be/GKG_A0tu-Kg
ExcelIsFun (4 months ago)
Thanks for the tip!
Jim S (4 months ago)
Sir. Thank you for everything you do. You are becoming impactful in my personal career as I approach the business intelligence field. Thank you!
ExcelIsFun (4 months ago)
Glad it is impactful for you, Jim S! Thanks for the support : )
ED MARA (4 months ago)
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.
ED MARA (3 months ago)
+ExcelIsFun I probably did it incorrectly then. And I'm glad too 😀😁 Thanks!
ExcelIsFun (3 months ago)
+ED MARA I am glad that you found Excel Online!!!!
ExcelIsFun (3 months ago)
+ED MARA I did not see the file. I am sorry I can not find it... : (
ED MARA (4 months ago)
+ExcelIsFun I had no idea there was an Excel Online!! It's exactly what I was looking for. I searched many places but had no luck, this left me stuck using Google Sheets in the Drive which I personally don't like as much as excell. I can't thank you enough for it was thanks to your MSPTDA group that I came across this. THANK YOU!!! 😀😀👌
ED MARA (4 months ago)
+ExcelIsFun I was a ble to upload a document (it's blank though). Hadn't noticed your e-mail until now.
Excel Bear (4 months ago)
wooo another MSPTDA video. love it
ExcelIsFun (4 months ago)
Glad you love it Excel Bear! Thanks for the support : )
George Kariuki (4 months ago)
Awesome teaching style!Keep up the great work Mike!👊
ExcelIsFun (4 months ago)
Glad it is awesome for you, George! Thanks for the support : )
K B (4 months ago)
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.
Geert Delmulle (3 months ago)
+K B I know (and use) that button myself, too. The way I see it: there is one "Scenario"-button (no icon) and one "Scenario Manager"-button (no icon) for the QAT. And of course it's the Scenario-button we want. It does this "replace" suggestion only the first time you invoke the button after opening a file. So you need to answer: "No" (once). After that you're good to go. The way I see it, it's not a bug, it's a feature. ;-)
K B (4 months ago)
+ExcelIsFun Yes the button on the QAT, I added the scenario button(as per your video on the scenario analysis), but i don't know what's going on
ExcelIsFun (4 months ago)
Are you talking about the button you can add to the QAT? If so, then maybe you added the wrong button. There are two buttons.
fatjan paloja (4 months ago)
Thnx Mike
ExcelIsFun (4 months ago)
You are welcome, fatjan!!!!
pa beader (4 months ago)
Not just WHOLE pages but you can pick just particular visuals to pin...
pa beader (4 months ago)
+ExcelIsFun That is the desired effect. The idea behind the dashboard is a place to put key things from the underlying reports. Then if something catches your interest, you click on it to get the whole report.
ExcelIsFun (4 months ago)
+pa beader , Thanks, Teammate!!!! Very cool, but when I pin the visual (a single element in a page) to a Dashboard, when I click on it in the Dashboard it always sends me back to the original Page or Tab. Whereas, when I click on an element in a pinned Page (Tab) it will filter the other visuals in the pinned page, and it will not send me back to the original Page or Tab. Is that your experience also?
pa beader (4 months ago)
+ExcelIsFun As you move your cursor around a visual you will notice a little pushpin, click on it and it will give you a similar dialog to work with. (I'm here to serve ;) )
ExcelIsFun (4 months ago)
Thanks for the hot tip, pa!!!!
Finance in 5 Minutes (4 months ago)
1 of the Most Authentic You tube channel For Excel videos. I learned Most of my Excel knowledge From this channel. Thanks sir
ExcelIsFun (4 months ago)
You aer welcome, Finance in 5 minutes!
trevor m (4 months ago)
Same here
trevor m (4 months ago)
By popular demand 😃😃👊🏾
ExcelIsFun (4 months ago)
Glad you like it, trevor!!!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.