List of Attractive BI Technologies from Microsoft

This was my second session today at Tech-Ed 2011 Middle East. Very interesting and demos were extremely useful to understand all the BI Technologies listed.

Now what exactly are we talking about? The session was all about listing the most promising (some are already existing) BI Tools running on top of either OR all of the following: SQL Server 2008 R2, SharePoint 2010, Silverlight.

The following are the list:

  1. SharePoint Excel Services
  2. PowerPivot Galleries
  3. PerformancePoint (Dashboards, Scorecards & KPIs)
  4. PowerPivot for SharePoint
  5. Pivot Tool – based on Silverlight
  6. Bing Data Connector – To show geospatial data
  7. SQL Server 2008 R2 Reporting Services (Report Builder)

Each of them will take it’s own time to allow user to understand the basics. I let my readers to BING or GOOGLE these terminologies and learn it.

But, the above list is what Microsoft concentrates more on currently to let users create the most attractive BI for them.



Top 10 Challenges on Delivering BI to the Masses at Microsoft

This was my first session today at Tech-Ed 2011 Middle East. The session titled “Delivering BI to the masses at Microsoft using Consolidated Business Intelligence (CBI) – Top 10 Challenges“.

The approach taken by Microsoft is fairly unusual.

Leave the BI Design to End-Users (or designated Power End Users) and simultaneously build EDW (Enterprise Data Warehouse). Once the design & EDW is ready, use following tools to achieve this CBI Model:

Microsoft Office, SharePoint 2010, SQL Server 2008 R2, Silverlight Technology.

CBI basically means one Single Enterprise Report Catalog. It’s then delivered as a SharePoint based BI Portal. Microsoft IT hosts BI with Reporting Services, PPS, etc, BUT Power End Users design and publish Reports on to this Portal. There are certain restrictions in terms of how many users being allowed to publish these reports for their own Team/Department/Division.

Top 10 Questions which Microsoft asked themselves before CBI (and of course everyone of us to ask ourselves as well):

1. IT Cost too much to implement this BI Catalog. What to do first? EDW or BI Reporting Catalog?
1.1. Allow End Users to publish all their ideas on a Not-So-Clean EDW Data.
1.2. Clean EDW and keep EDW ready.

2. How do you get the First Sponsorship?
2.1. Push and Pull Approach
2.2. Create a Cool Demo

3. How do you architect with big Holistic Enterprise Vision?

4. How do we implement seamless security across layers?

5. Who should create BI and show we actually give control of the report catalog to business and enable self-serviced BI?

6. Can we implement ZERO footprint deployment for masses using SharePoint?

7. What about regional deployment and scalability?

8. What front end tools to BI publishers use and how do you integrate various tools?

9. How do you evangelize and achieve enterprise adoption?

10. How do you achieve high Customer Satisfaction?
10.1. Customer Empathy
10.2. Maintain Customer Relationship
10.3. Improve, Improve & just Improve

Until next post on Tech-Ed from me.


Office 365 & SharePoint Online – TechEd 2011 Session

Just attended the session, Office 365 & SharePoint Online, in TechEd 2011 Middle East. And it’s very exciting and interesting.

It’s a service offered by Microsoft for anyone who wants a Hassle-Free and Pay-As-You-Use experience. Happened to see a live demo of Office 365 and it’s terrific to say the least.

MSFT may not be the first one to work on this, but they have certainly got an edge since it’s built on their flagship Product, Microsoft Office, which is used by millions of people out there.

Very impressive. More information here: Microsoft Office 365 – Get In The Cloud.


Microsoft Tech-Ed Middle East 2011 – Starts Tomorrow

This is my first Tech-Ed. And I am damn so excited about it, to say the least. So many terrific sessions, diversified topics across all Microsoft’s most happening Platforms and Technologies. And it’s all going to happen from tomorrow (well, it’s already started in fact from today, but that was Preliminary Sessions).

I will be attending these sessions from tomorrow 8th March 2011 to 10th March 2011.

For more information on this event, check this site: Microsoft Tech-Ed 2011 Middle East.