Enterprise Business Intelligence Solutions and Power BI

In the context of an Enterprise wide solution Power BI tends to be used more at the beginning and at the end of an Enterprise wide Business Intelligence solution. The rest of the time the Enterprise wide solution architecture needs to be developed.

Power BI tends to be used at the beginning of an Enterprise Business Intelligence project since Power BI is an excellent prototyping tool.

Power BI tends to be used more towards the end of an Business Intelligence project once the data warehouse / cube has passed the initial testing and the self service report delivers have been fully trained.

I hope you find the diagram in the following link helpful ..

http://www.innovativebusinessintelligence.com.dnnmax.com/Enterprise

As always your constructive comments are most welcome.

Why is Power BI a Data Revolution?

Click on the following link to see why I understand Power BI is a data revolution …

http://www.innovativebusinessintelligence.com/WhyPowerBI . This is certainly an ongoing work in progress. However I believe I have done enough to be helpful.

Clicking on the like button is nice. However what is more useful are your comments including constructive criticisms.

As always I offer free demonstrations provided that there is the real possibility of paid work at the end of this demonstration. I can work anywhere in the world. I am only limited by the fact that I only speak English.

DAX Basic Reference

adventureworkssubsetsnowflaked
Power BI is causing a revolution in the world of data analytics mainly because it is feature rich, has a low cost and a high degree of synergy with other products such as Excel online, SSRS and R.

For some people the barrier to pick up Power BI is learning the Power BI language DAX (Data Analysis eXpressions).

To hold down a very intense contract on Power BI (backed up with 3 Linkedin recommendations on http://www.linkedin.com/in/kieranpatrickwood) I created a Word document where I documented the most commonly used DAX commands that I used within this contract. So when I received a new business requirement which I needed to implement in DAX in the first instance I re-read and updated this Word document to gain an idea of which DAX function I should use. I also looked at other resources such as those listed within … http://www.innovativebusinessintelligence.com/Resources.

In the interests of serving the Power BI community and saving people from going through the pain I went through I have converted this Word document to a web page http://www.innovativebusinessintelligence.com/DAXReference .

Of course the above is a work in progress as my knowledge and experience of DAX grows. As always your constructive feedback is appreciated.

Presentation On Power BI and SQL 2016

Many thanks to all you who heard me present at SQL Relay 2016 in Nottingham, UK.

I am updating my slides in the evenings and weekends due to the exciting and every changing world of Power BI

I have updated  the following link with my latest slides; – http://www.slideshare.net/KieranWood/contrasting-querying-data-in-a-tabular-format-within-power-bi-excel-2016-and-ssrs-2016
It’s getting more difficult to present the existing content within the typical 60 minute slot offered. So I intend to split this presentation into several smaller and more detailed presentations with headings similar to the following …

1) Different Methods Of Querying Data In A Tabular Format Within PowerBI

2) Overview of the Microsoft Business Intelligence Architecture and Data Life Cycle

3) Power BI Gateway set up with on premises server data source.

4) Power BI Gateway setup with Azure data source.

5) Creating and Optimising DAX using DAX Studio.

6) Choosing the right chart types in Power BI

A mixture of the content will continue to be freely available. Some of the content will be available via https://www.converselink.com.

So I will continue to strive to create original content which does not overlap with the free resources described within the following link .. Power BI Free Demonstration and Resources

Power BI Free Demonstration and Resources

Free Demonstration

Get on board the Power BI revolution by empowering non technical business stakeholders to make decisions based on their own data or other freely available mature data sets using advanced attractive visualizations.
I am offering a free demonstration of Power BI either remotely via Skype or on site depending on your location.
Add a comment to this post if you want me to contact you.

Resources

Comparing and Contrasting Different Methods of Querying data in a Tabular Format within  the Microsoft Business Intelligence stack including Power BI, Excel 2016 and SSRS 2016

Introducing Power BI Free ebook

Online Course: Analyzing and Visualizing Data with Power BI

Microsoft SQL Server 2016 Free Ebook

Applied Microsoft Power BI: Bring your data to life!

Microsoft Excel 2013: Building Data Models with PowerPivot (Business Skills)

The Definitive Guide to Dax

Sqlbi

PowerPivotPro

DAX Patterns 2015

M Is for (Data) Monkey

Power BI Fantasy

Power Query for Power BI and Excel

OLAP PivotTable Extensions & DAX Studio

Many to Many Relationships in Power BI and Excel 2016

SQL Server 2016 Step-By-Step: Installing a Free Evaluation

Power Pivot Utilities

Import Power BI Desktop Model to SSAS Tabular 2016

I look forward to your comments, enjoy !!!

SQL Server 2016 Step-By-Step: Installing a Free Evaluation

This new version of SQL Server has more of an emphasis on data science. Consequently, there are a few extra steps to take than previous recent versions of SQL Server. SQL 2016 is a very exciting product.

These instructions focus on the virtual traditional box installation as opposed to the Azure / Cloud route. I personally like the box installation since I don’t need to rely on an internet connection to use the product.

This tutorial gives step by step instructions for installing an evaluation license of SQL 2016 within an evaluation copy of Windows Server 2012 where this server operating system is delivered from Hyper V Manager from Windows 10 on my laptop with 8Gb of RAM.

Please find these instructions on the following link; – link