Going Hardcore on your Business Intelligence with Power BI - Adam Cogan

Microsoft has recently announced Power BI is now becoming generally available (GA). It’s a great time to start exploring some of the advanced functionality Power BI offers. In this session Adam Cogan will quickly bring you up-to-speed with Power BI, then get straight into the cool stuff. You’ll feel the fire of the Power BI Desktop App, connecting to data sources, building a data model and publishing the end result to PowerBI.com.

Adam will also talk about what your organization should be doing now… how to create custom content packs, the developer options and how to extend Power BI beyond what ships in the box.

With the recent acquisition of Datazen by Microsoft a new product comes into the mix, Adam will take you through the features and how it fits into the BI roadmap.

00:00:00 - Introduction
00:02:32 - History
00:11:42 - Power BI - Editions
00:15:45 - Power BI - Up and Running (Browser) + Sharing
00:33:32 - Power BI - Desktop (windows) + Advanced
01:07:38 - Power BI - Custom Content Pack (publishing)
01:15:16 - Power BI - Integrating Your App With PowerBI.com
01:28:41 - Roadmap - Datazen, Where Does It Fit?
01:40:36 - Resources and Conclusion

Links:

- Power BI developer center

- Power BI blog

- Power BI REST API

[g]

At 1:03:12 you are incorrect. You can refresh the data on demand. You click the refresh button whilst in the desktop application and then click publish. It does take a few minutes but it can be done.

[masterlaw]

Thank you for your presentation. Wonderful and amazing insights!

[rupeshsharma]

Thanks Adam your presentation is such that I skipped other work and finished this video first.

[culpritdesign]

Great presentation! Some of your suggestions have been put in place: Embed code in websites, reporting services tiles. I think you are right about your predictions. Seems like they are piling in huge updates to Power BI and merging SSRS in as well. I think you comments on version control is on point. We really need to be able to sync our files from web to desktop and have dev vs production control.

[adam]

That was a great presentation and a good intro to Power BI. It does highlight something to me that a *lot* of BI tools miss though: presenting a nice layer to the end user where they don't have to know anything about the underlying data and its relationships to query, especially ad-hoc stuff. This is where Business Objects has always had it all over the competition, IMHO. That universe layer is the single best thing about that product and the fact that you can go from question to data to analysis very quickly. I wish that Tableau, PowerBI and other products allowed a developer or DBA to build something like this for the end users. If I were putting Power BI for database querying out there for my end users now, I would be building a set of denormalised or Kimball style star-schema views that they could hit and not have to worry about all that detail underneath.

[ruwan]

Really good video for those new to Power BI. Top class. Thanks Adam.

[eespiedrop]

Really great video for those new to Power BI. Top class.

[brijendraydv]

how to pin slicer to dashboard?I'm working on same but cannot do so, please help me out.

[stevenwang]

is there anyway to embed the dashboard to a web portal just like Tableau Public?

[Slarti]

Interesting talk - thanks must also go to youtube for adding the ability to speed up videos.
The duck typing needs to be fixed, I am guessing that the system has been designed in the manner to provide speed over accuracy.

[jameslovering]

wish the links were posted up here at the end !

[davidstanford]

Adam, this was a fabulous presentation - Thank you.

[SUNRAYS]

.Hey, Great show I guess this is how to have fun, learn and spend some quality time too...
PS: Is it possible to share the slides

[DinukaWanasinghe]

How you add the Google Analytic logo (25.02) on top ?

[dpw]

I still think Power BI is well behind when compared to Qlikview I'm afraid, I just think the big issue is around security and version control release still very vague

[OOpSjm]

release cadence can be as low as 1 week.

[lwheatcraft]

Adam can keep his idiotic comments about the Australia freedom ban to himself.