Introduction to Power BI Desktop

[@farooqmuhammad5983]

I am using latest version of power BI and enjoying preparing different reports, analysis and Dashboards as well. All these documents are very easy to make on Power BI.

[@ShereMcClamb]

Investing this app for a business unit that requires reporting from excel files. I think it might be a winner!

[@DustinRyan]

Good morning, friends. I'm loving the new #PowerBI desktop. Anyone else addicted to building #dashboard reports in Power BI? #businessintelligence FTW!

[@danieladjei-nyarko4788]

Fantastic Video Dustin . Really help full

[@kevingrant6334]

That's a really cool demonstration Ryan. I can't understand why someone would give it the thumbs down.

[@JasonYousef]

moving the mouse erratically really drove me crazy!! nice work, thanks for sharing :)

[@DustinRyan]

I'll work on my mouse skills. :) Glad you found it helpful.

[@imkvivek]

Hello Dustin, Thanks a lot, this is very good video for beginners. I am experienced guy into MSBI development. Now I want to learn POWER BI, this is my first video to start.

[@mmimpositive]

Imparting your knowledge to others very nicely, which helps everyone to start on this

[@kennethluong3584]

Great presentation. Been doing DW/DM/BI For over a decade and found your tutorial very useful. I think after this tutorial, I can work on my own without any additional help.

[@anarubio9981]

Hello, Dustin! Thank you for the video, it was quite useful. I am using PowerBI in order to make financial reports and I needed some light.

[@ladyashephd727]

Looking forward to advancing my career through Power Business Analytics in Excel, Microsoft BI, Tableau and Qlik

[@johnrobert1982]

I've just started using this Power Bi and this video is brilliant. Thank You

[@DustinRyan]

John Bowman-Yard You're welcome!

[@parthomandal6704]

Thanks & well done Dustin. Perhaps at a later version you have talked about how the data can be updated?

[@vraogopal5981]

Thanks Ryan! Excellent stuff, looking forward to install it and generate some meaningful reports

[@chicagorealtynow]

Dustin, I really liked your video. I've worked as a Microsoft Trainer for a few years and also consulting with SQL Server. You were very easy to follow and understand. I have also worked with QlikSense and QlikView. It seems that his product does a lot of the same type of stuff. I wanted to be able to talk about the product if someone asks me and with your video, I can more than do that. Thanks for putting it up :)

[@BillAdams001]

Very nice introduction to PowerBI. I hope to completely watch it but the first fifteen minutes were definitely interesting and useful. Thank you!

[@santoksingh6099]

Ll

[@santoksingh6099]

Llll

[@santoksingh6099]

L

[@gong4amer914]

Thanks Dustin for a great introduction on how to use PowerBI. Brilliant!

[@Lixia123]

After your video I can start build my own dashboard, very practical and useful guide. Thanks.

[@DustinRyan]

+Lixia Zhang You are most welcome!

[@korova2000]

This is one of the best BI intro video Thank you

[@DustinRyan]

You're welcome! Glad it was helpful. :)

[@aspnerd]

Good video, but the DateAdd function for the previous year isn't working in the current version of the tool it seems.

[@fethbraham2971]

Great! Many Thanks! But same question as Yehudit Mahalal.

[@PrakashRPatel]

Very well explained. Awesome job Dustin.

[@leonmiles1705]

Hi Dustin. Must confess one the better Intro vids for Power BI I've come across! Like your sample data and how you used it to it's full capacity. Worthwhile signing up to Opusdata to get that sample file. Thanks, keep up the good work!

[@DustinRyan]

Thanks, Leon. I'm glad you enjoyed it. I've been toying with the idea of redoing the video with a more publically available dataset that I made available for download. I don't normally like to redo what I've already done, but I would if it was beneficial to the community. In your opinion, would that be worth the effort?

[@leonmiles1705]

Please REDO! Yes Dustin. Even if I now speak on behalf of the community. The DAX functions you've covered is interesting and fits in with the overall theme you had going there. Now that's what you call a proper Power BI Introduction. The visuals as well speaks to the data and represents it quite well. I'm looking forward to your next installment. THANK YOU for your dedication in contributing to the success of the Power BI Desktop app!

[@DustinRyan]

Thanks for the feedback, Leon. It's very helpful to me personally. Any suggestions for good datasets to use?

[@leonmiles1705]

I think for me personally, Financial samples showing products, units sold, manufacturer, sales price, gross sales, profits would work. I do not work with Finances, but think it's great to use them in Power BI. Seems to me one can be more flexible with visuals and DAX functions. Thanks for following up Dustin!

[@DustinRyan]

Ok cool, I can probably find some data based on retail data that fits that criteria.

[@palliraotalend6723]

This video is so nice gives me good understand about Power Bi in very short time also requesting to post the advanced topics in PowerBI.. Thanks a lot :)

[@vijayswamy2564]

Thanks Dustin. Very useful and learnt quite a lot. Specially the DAX stuff.

[@nitinmore7686]

Dear Sir, What should be the minimum hard ware requirement for running Power BI, for the speed which we can see in published Power Bi videos...?

[@heck0272]

Great work Dustin.Thanks for all the detailed info

[@SqldustyHome]

+Hector Marcia Thank you, Hector! Glad you found it useful!

[@charismashines]

Good introductory to beginners like me! Thanks!

[@dumisibanda]

@Dustin Ryan, thanks a lot for your insightful video. you just made clear to me the relationship between Power BI desktop and Power Pivot. I learnt a lot and also connected the missing dots by watching your video

[@DustinRyan]

Great, glad you found it helpful.

[@euleralencar]

Hi Dustin. Your work is fenomenal. I saw this days your report in PowerBI about NFL. You should make a vide explaining how you did that. Thanks for the tips.

[@sunnybunny565]

That's really a nice tutorial.. From this i have learnt what power bi can do. Thanks.

[@Slash1066]

Really cool, thanks for this walk through, looking forward to playing with it

[@absar66]

Great demo .... would be glad if you can give some pros/cons in relation to tableau.. 😊

[@sachinkadam9779]

thanks for the video i was knowing nothing about power bi but now m sure i know much.

[@-asrial-]

Great video, thank you! This makes me want to play with this software! Hardest part is just finding something to use :D

[@gopinathsunduru8921]

Great Work Dustin!! Could please assist me with below question:- How to connect SAP BO Universe In power BI desktop? How to Create Alias In Power BI Desktop? Does Power-BI has any restriction on the number of columns & Rows while Importing? How is Report Performance in Power BI if number of users are more ? Thanks,

[@andres7476]

Hello, great intro video. Do you know where I may download the data files used in presentation? Thank you!

[@venkattaramanan8012]

How can we achieve the conditional COLOR formatting of Line chart based on some rules in power bi ?

[@AkshuGotuDance]

Great Demo, Thanks for taking time, uploading and explaining in detail end to end.

[@BIElite]

Great intro. Clear and to the point. Thanks!

[@bw6155]

Is there anyway to create a dashboard just on Power BI Desktop for in house sharing? Or must all dashboards be published before you can link the visualizations to reports

[@16arvisva]

I never seen this type of report video which is really amaze

[@alvarogarciaherrero8240]

Could be possible to get the data model or the excel sheet to do the exercise with the video, please? Thanks !

[@nileshgupta8221]

great video.....how can we make paramater like tableau in powerbi

[@davemesh_]

This is great. It was indeed helpful to my career in Power BI

[@Sarabjitsethi]

Is there any way to change the position of X-axis in a cluster bar chart, by default it's position down but i wanted to on upper side of chart.

[@sebastianmolero1703]

Thanks Ryan. Excelent presentation and great explanation. Greetings from Buenos Aires

[@DustinRyan]

+Sebastian Molero Thank you! Glad you found it beneficial!

[@lissyking21]

Hi Dustin....You made the video that I needed. When are you posting more videos? You created the reports but you didn't pin any of the report to the dashboards on POwerBi website. Would be cool if you do that. Can you do a video on connecting to the SQL server and create a report from there? Thanks Dustin. I will be visiting your blog now.

[@prauflnpatel]

Dustin, can you add custom filter like last year, last month

[@platanomc]

Thank you Dustin! Great intro video. I was just curious if there's a way to see the code generating the reports.

[@DustinRyan]

+carlos Not to my knowledge. You can, however, view the Power Query code being generated: sqldusty.com/2015/08/10/cleaning-your-powerbi-power-query-code/

[@epastorejr]

Thanks, very nice straightforward intro !

[@ajinair]

Thnx Dustin that was good. Is the data getting externalised when you publish. If yes how to create a URL that is only internal to an org

[@atulvishal2240]

It's really very good video for beginners. Thank you

[@prasadnambiar75]

That was really helpful Dustin. Great job!

[@dakotafog7903]

great video for a Power BI beginner, thank you

[@DustinRyan]

You're welcome! Glad you found it useful!

[@franciscoumegido2865]

Hi Dustin, just have a doubt, can i share/publish a Power BI report tru a corporate MS SharePoint?

[@micheldubois6985]

Great work Dustin. Thnak you very much for sharing you knowledge.

[@samarthtandon3392]

Hi Ryan, I want to connect Power BI desktop to SAP BI system and get data into power BI. Can you please help me in this.

[@bebeto212]

And how can you show a detailed report from clicking in a component of the dashboard?

[@DustinRyan]

+Iñigo Mazo There's not an easy way to drill down to the details. At this point Power BI isn't optimized for displaying the detail data. The latest version of Power BI does provide drill down functionality but not to the most granular level of data. When you deploy a Power BI model to your Power BI site, however, the data source is deployed so that users can create their own reports. This may give your users the ability to view the data as they wish which may answer some of their business questions.

[@mbanford1]

Can I get data on ball speeds and ball spin info?

[@MB-pt8hi]

Hello, what software are you using for the presentation which automatically draws arrows and switchs to drawing pen?

[@hrishikeshkherdekar3858]

Hi Dustin!! Thanks for such an informative session.

[@DustinRyan]

You're welcome! Glad you found it helpful!

[@Cypherdude1]

Hello, I just learned about PowerBI today. I have *Office 2010 32 bit installed on Windows 7 Pro 64 bit. I just downloaded 64 bit Power BI* (the Microsoft website chose it for me). I have not installed PowerPivot but I do have the 32 bit 91.0MB MSI installer. *Can I use PowerBI with my Office 2010 32 bit?* Thanks in Advance.

[@ritzavieux4320]

You made it look so easy. It was indeed very clear. Thank you!!!! Just love building #dashboard.

[@moalam1111]

Awesome video. Thanks Dustin!

[@samtran74]

Nice job Dustin. Is there a demo using date pulled from wikepedia? This tool just blew my mind. It will be so helpful for so many researchers in many areas. Thank-you again Dustin.

[@RaviKumar-yw5ed]

Hey Dustin, wonderful video. Thank you for your excellent intro. I have a query, say if i publish the report to P.B service , how is the data secure on cloud? How reliable is it then ?

[@toyojack]

I want to thank you for a very good tutorial.

[@oscarayang9825]

Thanks for this tutorial. It was very useful

[@lesleyeddie]

Can we use PDF data for this software?

[@Justinanalyst]

Superb.. Good walk thru!!!! Thank you!

[@MrSARAZZ]

Neat little video Dusty, good introduction. Thanks :-)

[@ralphlivermore758]

Great video! Very informative first introduction to PowerBI!

[@krismaly6300]

Deployment / Publishing Do we have to do only at PowerBI website or my company can have it;s own Power BI server or Can we publish on to MS SQL Reports Server? Appreciate your reply and guidance. Wish you good luck!

[@Ryfibi]

Hi Dustin, can I use Power BI Desktop on my company only for intern dashboards with the free download?

[@SqldustyHome]

+JonnyTeronni You can use the free Power BI desktop download to get started but if you want to deploy your Power BI reports and share them you'll need the Power BI site which requires the appropriate Office 365 subscription.

[@lanairgreer588]

Dustin. How do you get noticed in the world of Power BI? I am an new graduate looking to transition from a Pricing Analyst to a Business Intelligence Analyst. Any suggestions?

[@DustinRyan]

Start a blog and start writing about the things you learn. Be active on social media, especially on twitter. Post about new things you learn and answer other people's questions when you can. Start attending PASS events (www.pass.org/Learning.aspx) and join the virtual groups whenever you can.

[@nikethj7764]

really good exposure on Microsoft power Bi..! Thanks for sharing this .

[@venubachu7804]

It's Very helpful and Nice Presentation

[@AACMario]

I want to learn i need moviedata.csv and datetable.csv please. thank Gretings from Peru

[@mcj1234]

Great video! Very informative and easy to understand!

[@MarkChinsky]

Thanks, great video. Once you published it, how does it update the data if the source is a local spreadsheet or SQL Database? Is it automatic?

[@DustinRyan]

+Mark Chinsky The Power BI Enterprise Gateway is used to administrate connections between the Power BI Service and the on-prem data sources. You can read more about the Power BI gateways here: powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/

[@marttraya1922]

it is possible to update the datasource on a published Dashboard? Let us say, I need the data to be updated on a daily basis, does it be reflected to the dashboard as well? or is this possible?

[@DustinRyan]

Yes, the refresh can be scheduled daily or hourly. Depending on the data source, you can also created a live connection that does not require a scheduled refresh.

[@annacorr2263]

Thank you, an amazing walk through PBI

[@sgpleasure]

Why would one need PowerBI if they use Excel 2010, with powerpivot and powerquery addin?

[@DustinRyan]

+ufoubo So there's a few things regarding #PowerBI that I've left out of this video. The crux of Power BI is being able to publish the dashboards to your PowerBI site hosted in the cloud. Once your Power BI report is published, other users can create their own dashboards using your report visualizations or design their own reports using your published data source. With your reports published to the Power BI site, you can also schedule a periodic refresh of the data. And users can access the reports via mobile devices using the Android and iPhone apps.

[@sgpleasure]

+Dustin Ryan Thanks for the reply. It seems this link has a good summary: stackoverflow.com/questions/29696131/difference-between-powerpivot-powerquery-and-powerbi It leads me to conclude that PowerBI is mainly for collaboration. And in the corporate world, we are not allowed to upload data to the cloud for confidentiality reasons. I have been tasked to create a dynamic sales dashboard and I think I have settled down on Excel 2010.

[@DustinRyan]

+ufoubo I believe that would be an incorrect conclusion. Power BI is far more than a collaboration tool. Excel is a powerful and flexible tool, but I believe that with a clearer understanding of the capabilities of the tool you'll find that Power BI to be a superior solution for creating and sharing dashboards, integrating disparate data source and accessing your data from anywhere at anytime (including mobile devices). While I understand the concerns of using the cloud, many corporations are taking advantage of the power of the cloud based toolset considering that Azure has met a variety of industry and international security & compliance standards (azure.microsoft.com/en-us/support/trust-center/compliance/). Still, on-prem Power BI is coming according to the MSBI reporting road map (which you can see here: blogs.technet.com/b/dataplatforminsider/archive/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap.aspx).

[@AbhishekSharma-bd5xu]

Great video!! One quick question, Power BI vs Power BI desktop, what's the difference?

[@DustinRyan]

Power BI Desktop is the desktop authoring tool used to create content. Power BI refers to the service that runs in Azure used to distribute the content, allow collaboration and creation. Power BI Desktop publishes to the Power BI service where the published content is viewed and shared. Hope this helps. :)

[@AbhishekSharma-bd5xu]

+Dustin Ryan Got it. Thanks for prompt reply :)

[@agagroup9952]

how to load from MYsql database server?

[@loveyou1175]

I thank you. But I can not follow you. Since none of your data files. Please send me files.

[@phani9885120096]

@dustin I'm watching my first demo video on power BI n this is very interesting , do we have any concept of dynamic visibility in POBI

[@vivekprabhakar3331]

Thanks a lot for this insightful video.

[@etimessang4980]

How can you embed it on a web page?

[@DustinRyan]

demsy essang Take a look at this: docs.microsoft.com/en-us/power-bi/service-publish-to-web

[@robinsinghyadav]

Liked and useful Dustin. Thanks for this.

[@Myhealthygourmetcoffee11]

Thanks Dustin Very informative

[@jgonzalez1984mx]

Hi Ryan ,hope youre doing well, how can i share a report to my boss? I created a dashboard but i cant see any information on it :(

[@DustinRyan]

+JavierII Gonzalez There's a couple different ways to share content in the Power BI service (app.powerbi.com). You can share a dashboard by right-clicking the ellipses next to the dashboard and clicking share. You can also share content through Content Packs, which you can read about here: powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-packs-introduction/ I hope this helps. :)

[@saber13822003]

Thank you so much I'm living in Iran and you did help me !

[@vinaykumargupta8294]

Really this is awesome power BI tutorial thanks and appreciable.

[@nelsoncastillozapata]

GREAT VIDEO DUSTIN THANKS

[@SqldustyHome]

+Nelson Castillo You're most welcome! Thanks for watching. :)

[@prasannag8600]

Good job!!Thank you for clear explanation.

[@etl7367]

Obviously this is a great visualisation tool despite it is free of charge for desktop version.

[@DustinRyan]

There is also a free version for the online Power BI service. :)

[@chappelle5766]

Dustin, what program are you using to write to your screen?

[@DustinRyan]

It's called ZoomIt. It's a free download. Just do a search for ZoomIt.exe and you'll find it.

[@chappelle5766]

Dustin Ryan Thanks Dustin.

[@shakerahmed3545]

very helpful demo thanks....

[@ksathish11]

Awesome Ryan, thank you so much for nice and understandable explanation. It is really very informative. Thanks again ! Satish

[@DustinRyan]

You're welcome! :)