Excelling at Dashbaords

SQL Server MVP Deep Dives 2, Chapter 58

Excel as a BI frontend tool – by Pedro Perfeito (Blog|Twitter)

No matter how good and sophisticated a BI tool is, business users will invariably export data to Excel. – Chapter 58, SQL Server MVP Deep Dives V2

Continue reading

Advertisements

My Lack of Insight

SQL Server MVP Deep Dives 2, Chapter 59

Real-time BI with StreamInsight – by Allan Mitchell (Blog|Twitter)

This was a hard one. I had to remind myself a couple of times while reading this chapter that I am writing these reviews so that I can understand these topics better.

Before I read this chapter I had never heard of StreamInsight and it took me a while to wrap my head around what exactly this tool is. Finally after doing some Binging around on the topic and reading the chapter for the sixth time these lines jumped out at me:

StreamInsight is a complex event-processing engine

Once the events leave the input adapter, they enter the engine.

The engine is where all the query logic is introduced and from where the intelligence is derived.

Continue reading

Business Intelligence 201

SQL Server MVP Deep Dives 2, Chapter 60

BI Solution Development Design Considerations– by Siddharth Mehta (B|T)

This is the first chapter in Deep Dives V2 that I read which felt like I was reading a textbook. I really wanted this chapter to be something I could hand to a manager, DBA, or developer who hadn’t worked on a Business Intelligence project and they would come away with a good understanding of what it was and all of the pieces needed to build it. Essentially I wanted something the me from 3 years ago could have read and not have to learn everything on the job.

Figure 1 Typical BI design for an OLTP-to-dashboard solution from Chapter 60 of SQL Server MVP Deep Dives V2

Continue reading