Database Reference
In-Depth Information
Click on
Apply and Close,
and the data will be imported to Excel. You can see the total number of rows
downloaded from your blob storage and even load the data into a data model as shown in Figure
9-27
.
Figure 9-27.
Importing data using Power Query
■
power Query can directly fetch hDfs data and place it in your excel worksheet in a formatted way. there is no
need to access the data through hive, and there is no dependency on the microsoft hive oDBC Driver as with powerpivot
or power view.
Note
You can repeat the preceding steps to connect to different types of data sources and integrate them in your Excel
sheet. The integrated data can then be filtered and shaped to create curated data models targeting specific business
requirements.
Summary
In this chapter, you learned how to integrate Microsoft self-service BI tools with HDInsight to consume data and
generate powerful visualizations of the data. With the paradigm shifts in technology, the industry is trending toward
an era in which Information Technology will be a consumer product. An individual person will be able to visualize the
insights he needs to an extent from a client-side add-in like Power View. You also had a peep into the Power BI tools
that are available from Microsoft to provide data mash-ups and 3-D visualizations of your data. These self-service BI
tools provide the capability of connecting and talking to a wide variety of data sources seamlessly and creating
in-memory data models that combine the data from these diverse sources for powerful reporting.
