© 2013, Tagra Management Systems Ltd.

Business Intelligence... Your way

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-side capabilities to enable self-service BI via SharePoint and SQL Server provides a common, scalable data platform to handle any data, any size, from anywhere.

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-hoc reporting for business users, as well as providing powerful report authoring environments for IT professionals and developers.


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-ins for Excel we make the power of data mining available through the familiar and intuitive Excel experience, allowing these capabilities to be accessible to a broader range of users.

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

Tagra Complimentary MSBI Consulting Day

Click here to download additional information…

Click here to Contact Us...