© 2013, Tagra Management Systems Ltd.
Microsoft has been positioned as a Leader in the Magic Quadrant for Business Intelligence and Analytics Platforms that was published February 5, 2013.
Microsoft delivers on a vision of making Business Intelligence more accessible to
everyone across the organisation, as witnessed by the higher than average deployment
of BI solutions recorded by its customers. By providing Business Intelligence capabilities
in familiar tools such as Excel and SharePoint, Microsoft empowers an entirely new
segment of business users to build and consume rich BI solutions as part of their
everyday work. Delivering the server-
Our reporting solution from Microsoft is SQL Server Reporting Services. Reporting
Services is ‘free’ with SQL Server, meaning you can fully utilise your current investments, at
no additional licence cost, to access and combine data from virtually any data source
to meet the reporting needs of your business. Reporting Services covers the full
range of reporting through highly intuitive ad-
Microsoft SQL Server Analysis Services also ships at no additional cost with SQL Server. Again, you can fully utilise your current investments to pull together analytical models from virtually any data source across your organisation with the industry’s leading OLAP solution. Users can access these analytical capabilities through the familiar Microsoft Excel and SharePoint Server environments, therefore extending the reach to more employees throughout the organisation, or even out to the public and to partners if required.
With Microsoft Data Mining, you move beyond simple data analysis to identify hidden trends,
problems or relationships in the data. After insights are extracted from patterns, clusters
and trends, people can better identify the ‘root cause’ of problems and predict future
outcomes. Microsoft builds these powerful data mining capabilities into SQL Server
Analysis Services, allowing you to surface predictive analytics in your reports,
dashboards and scorecards to provide deeper insights to more employees. Through the
Data Mining Add-
The Business Intelligence Semantic Model has been introduced in Analysis Services for SQL Server 2012. The BI Semantic Model is one model for all end user experiences – reporting, analytics, scorecards, dashboards, and custom applications.
All client tools in the Microsoft BI stack – Excel, PowerPivot, Power View, SharePoint Insights and Reporting Services – operate on this model. BI professionals can create the model in Visual Studio and deploy it to an Analysis Services server. Interestingly, the model can also be created by business users with PowerPivot for Excel and shared via PowerPivot for SharePoint