Microsoft

Microsoft BI Review
Most complete business intelligence suite for the least money


As seen in
Logosasseeninsmall ab3c74d8852a39fa9ed0fb2833dd7db9c0f026cd637b6c09026ced45c4aaf8bd

Valuable Features:

Microsoft SSRS is a fantastic means for end users to access, run, and schedule delivery of reports. - Core functionality is simple to use for business users of all skill levels - Report models even allow end users to adjust their own reports using a model of your data - Report builder provides an even easier method for users to build their own reports - Report data can even be scheduled for periodic delivery with the report data as an attachmentMicrosoft SSAS is one of the best BI suites on the market. It is also one of the least expensive, and the features bundled rival competitors with prices many more times as expensive. - This feature is one of the most exciting areas of database technologies today - Very powerful and relatively easy to use when compared to other Bi suites

Room for Improvement:

- Active Directory authentication requires an additional login for users without Internet Explorer - Learning curve behind any business intelligence package is quite steep - Price of the SQL Server bundle is potentially cost prohibitive for smaller businesses

Other Advice:

I am quite passionate about the SQL Server suite of tools, and am a fervent user of SSRS. I use SSAS less, only because I am focused more on administration and have not moved into the SSAS space - yet. I am looking to head into the BI arena later on this year, and SSAS is my BI suite of choice!
Disclosure: I am a real user, and this review is based on my own experience and opinions.


1 Comment

Picture 1338 1362337850
HashamNiazConsultantTOP 10LEADERBOARD

Hi Kleegeek !

Nice to read your review, while I was reading it I noticed some of the points which you might still not be aware of. Let’s analyze those;

SSRS: SSRS is a good reporting tool, but mostly it is used for static reporting, detail level reports, it doesn't provide the ability to dynamic dashboard with drill up / drill down options unless you define Action Item for each text box.

Microsoft provides Dynamic Dashboard with PPS or Power View where End-User can change the layout of the dashboard or grid on the fly, add different measures at rum time.

SSAS: The biggest selling point of Microsoft BI is its powerful Multidimensional Model, some of us known it as "Cube". With a craftily designed OLAP Model you can leverage the End-User to perform deep data analysis.

I would like to disagree with you on the point, that cost is the only selling factor or Microsoft BI, because QlikView and Tableau are both very cheap if you compared them with Microsoft BI, and they both provide nice dashboard and charts.

The selling point of Microsoft BI is its architecture and ability to handle the needs of enterprise requirements. In smaller industries QlikView and Tableau gives really tough time on pricing.

Regards,
Hasham Niaz

Like(0)28 July 13
Why do you like it?