Introducing Microsoft BI Tools

October 27, 2015

Microsoft Power BI

Microsoft BI Tools and the Key Workloads They Best Support

Microsoft provides a variety of business intelligence (BI) tools that can address key workloads. In addition to providing guidance about the best BI tools to meet your organization’s analytics needs, this article discusses the workloads – Self Service BI, Corporate BI, and Advanced Analytics -- and the tools that best support each.


  • Introducing Microsoft BI Reporting and Analysis Tools
  • Self-Service BI, Tool Options, Typical Infrastructure, Key Considerations
    • Microsoft Excel
    • Power Pivot for Excel
    • Power Query for Excel
    • Power View for Excel
    • Power Map for Excel
    • SharePoint 2013 Sites
    • Power BI for Office 365
    • Power BI Designer Preview
    • Power BI Preview
    • Data Mining Client for Excel
  • Corporate BI and Tool Options, Typical Infrastructure and Key Considerations
  • Tool Options
    • Microsoft SQL Server 2014 Analysis Services
    • Microsoft SQL Server 2014 Reporting Services
    • Power View for SharePoint 2013
    • SharePoint 2013 Dashboards
    • Performance Point Services
  • BI and Microsoft Azure Technologies
    • Azure Machine Learning
    • Azure Stream Analytics
  • Advanced Analytics
    • Tool Options
    • Data Mining Client for Excel (2010, 2013)
    • Data Mining in Analysis Services
  • Conclusion