How to set up Microsoft Business Intelligence environment on bare metal

SQL Server 2012 SP1, SharePoint 2013 and Office 2013 are next generation business intelligence platform from Microsoft that will enable organizations democratize the concept of business intelligence. This new BI solution provides end-to-end capabilities –


  • ·        Stage data and build new data marts using SQL Server Integration Services
  • ·        Perform data enrichment and modelling through Data Quality Services and Master Data Services
  • ·        Create rich BI modelling layer through BI Semantic Model (BISM)
  • ·        Best in class OLAP engine with in-memory analytics capabilities through SQL Server Analysis Services
  • ·        Perform data mining using one of these out-of-the-box algorithms – Time series forecasting, Regression, Naïvebayer, Decision Tree, Neural Networks, Association and Clustering, or create your own data mining algorithms using Data Mining Expressions (DMX)
  • ·        Best in class reporting and analytics tools for users  across your organization – Strategic, Tactical and Operational – that are familiar and provides rich data visualization and exploration capabilities
    • o   SQL Server Reporting Services
    • o   SharePoint 2013 PerformancePoint Services
    • o   SQL Server Power View
    • o   Microsoft Excel PowerPivot Reports
  • ·        One of the most widely deployed collaboration platform for users to share their insights and take more informed decisions
  • ·        Extend or move your BI to cloud through Windows Azure Platform-as-a-Service or Infrastructure-as-a-Service solution offerings


Refer the attached step-by-step installation and configuration guide, with visual screenshots,  for setting up this comprehensive BI platform.


SQL Server BI Setup Guide.pdf

Comments (0)

Skip to main content