Chapter 7. Analyze and Report from Data Lake

The real value of big data is when data becomes information that decision makers can take action with. In this chapter, we will review how to access data from Data Lake for analysis and reporting. The topics covered in this chapter are as follows:

  • Data access overview
  • Analysis using Excel and Microsoft Hive ODBC Driver
  • Analysis using Excel Power Query
  • Other business intelligence features in Excel
  • Hive for ad hoc queries
  • Other alternatives for analysis

Data access overview

Once we have data in a normalized and aggregated form, business analysts can run pivot tables and what-if analysis, and data scientists can run statistical analysis to present insights to executive management empowering them to make business ...

Get HDInsight Essentials - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.