![]() The map displays the product categories by color for each state. To display product categories in the map by color, drag the category field into the COLOR box. Our dataset includes product data, so we can display the product categories viewed by website visitors in each state. Move the pointer over each state to display the IP count for that state. Use the map controls to zoom in on the United States. Remove the country field from the LOCATIONS box by clicking the down-arrow and then Remove Field. First, drag the ip field into the SIZE box.ĭrag country from the Power View Fields area into the Filters area, then select the usa checkbox. ![]() Now let’s take a look at a count of IP address by state. The map view displays a global view of the data. On the Design tab in the top menu, click Map. The data table will update to reflect the selections. In the Power View Fields area, leave the country checkbox selected, and clear all of the other checkboxes. Let’s start by taking a look at the countries of origin of our website visitors. Drag the handles or click the Pop Out icon to maximize the size of the data table. The Power View Fields area appears on the right side of the window, with the data table displayed on the left. In the Excel workbook with the imported webloganalytics data, select Insert > Power View to open a new Power View report. Identify web pages with the highest bounce rates.Graph the website user data by age and gender.Analyze the clickstream data by location.Visualize Data Using Power Viewĭata visualization can help you optimize your website and convert more visits into sales and revenue. Now that we have successfully imported Hortonworks Sandbox data into Microsoft Excel, we can use Excel's Power View feature to analyze and visualize the data. The imported query data appears in the Excel workbook. On the Import Data dialog box, click OK to accept the default settings and import the data as a table. On the Sort Order screen, click Next to continue without setting a sort order.Ĭlick Finish on the Query Wizard Finish screen to retrieve the query data from the sandbox and import it into Excel. On the Filter Data screen, click Next to continue without filtering the data. Select the webloganalytics table in the Available tables and columns box, then click the right arrow button to add the entire webloganalytics table to the query. The Hortonworks ODBC driver enables you to access Hortonworks data with Excel and other Business Intelligence (BI) applications that support ODBC.Īfter the connection to the sandbox is established, the Query Wizard appears. On the Choose Data Source pop-up, select the Hortonworks ODBC data source you installed, then click OK. Open a new Excel workbook, then navigate to Data > From Other Sources > From Microsoft Query. Excel 2013), which is currently only offered for Windows computers. Have a version of Excel with Power View (i.e.Have sample retail data already loaded by completing this tutorial.Have installed the Cloudera ODBC driver for Apache Hive.In this section, we will use Microsoft Excel to access refined clickstream data. Visualize Log Data with Microsoft Excel Introduction
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |