Excel is the most popular data analysis tool used by business analysts and now HDInsight makes it easy to integrate Excel with Hadoop using Hive. In this section, we will see how to use Excel against the data that is in our Data Lake using Hive.
The prerequisites required are listed as follows:
The following are the steps to get your data into Excel and analyze it.
The first step is to download the Hive ODBC driver and set ...