SQLSaturday Edinburgh: Power BI- best practices to deliver just-in-time insights

BI – Business Intelligence implementation is a common factor in every business success!

Choice of business intelligence tool plays important part, such a solution require lower cost and speed-up time to gain real-time analytics.

Microsoft provides a variety of tools in BI arena since ’97, remember MS Excel. Having said that in their own words:

Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. There are two experiences now available for Power BI: the current experience, generally referred to as Power BI for Office 365, and a new experience for Power BI, currently offered as a Public Preview. If you’re new to Power BI, you should try the new experience.

There are series of links:


To share from my experience and industry best practices I have been opportunity to present at upcoming SQL Saturday BI Edition 2015 – Edinburgh (thanks to Jen Stirrup aka MVP Girl Geek). You can more details about SQLSat #388 schedule and bunch of industry Professionals will be there to share their wisdom. Not only a free day conference on June 13 2015, a pre-con session from Chris Webb is hosting an Introduction to Power BI and you can get more information and register here.

Coming back to my session I will be presenting about Power BI best practices to deliver just-in-time insights topic.

We will overview multiple options about how to deploy Power BI, how to implement configuration parameters and package BI features as a part of Office 365 roll out in your organisation.

A value from a best practice follow up is enormous, and it is possible to manage the deployments as trouble-free without having major hiccups on implementation. As a DBA/SystemAdmin you have biggest responsibility to deliver best possible components to data stewards and end-user.

Having said that, cloud computing is another aspect of this technology made is possible to get data within few clicks and ticks to the end-user. Let us review how to manage & connect on-premise data to cloud capabilities that can offer full advantage of data catalogue capabilities by keeping data secure as per Information Governance standards.  Not just with nuts and bolts, performance is another aspect that every Admin is keeping up, let us look into few settings on how to maximize performance to optimize access to data as a real-time and how this Power BI features can enable this solution.