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.

Advertisements

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.