Updated: July 16, 2020 (January 9, 2017)

  Analyst Report

Data Analysis and Access

My Atlas / Analyst Reports

1,540 wordsTime to read: 8 min
Andrew Snodgrass by
Andrew Snodgrass

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

The main purposes of capturing Big Data are to look for insights to help drive business decisions with analytic tools and to automate decision making through advanced offerings, such as machine learning. Choosing the right offerings will depend on the types of analysis and actions required, such as real-time streaming analytics or methodical data mining of historical data, and on how the data and resulting information will be integrated into new or existing applications.

On-Premises and Hybrid

On-premises, a variety of tools can access data and perform analysis, including SQL Server 2016, Excel, and Power BI Desktop.

SQL Server 2016 can use PolyBase to expose Hadoop data sources to Analysis Services for use in analytic data models and other SQL Server—based applications, such as data mining and reports. An advantage of connecting through SQL Server 2016 is that queries can be programmatically set to refresh on a scheduled basis or in real time, which removes a common time-delay barrier of moving Big Data results into other applications.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now