SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Course Index
Close
X
Hadoop Basics
Course Overview
1. Big Data
2. Introduction to Hadoop
3. Hortonworks SandBox Installation
4. Run Your First "Hello World Example"
5. Hadoop Core Components
6. Hadoop Programming Language (HIVE, PIG)
7. Installation of ODBC Hive Driver in Windows 7
8. A Real World Business Example of Hadoop
9. What is Next?
<< Previous
Next >>
8.8 Access and Analyse The Data with Excel

You can use Business Intelligence (BI) applications such as Microsoft Excel to access and analyze the data.
In our case we are using Microsoft Excel Professional 2013 for analysis of the data. Now that we are done with loading data in Excel. Lets use Excel Power view feature.

Visualize the Website Click Stream Data Using Excel Power View

Data visualization can help you optimize your website and convert more visits into sales and revenue. In this section we will: Identify a few web pages with the highest bounce rates Click on Insert->PowerView to open report The Power View Fields area appears on the right side of the window, with the data table displayed on the left.

Hadoop Basics

Now a page would be considered to have a high bounce rate if it is the last page a user visited before leaving the website. In the Power View Fields area, select url. All of the other fields should be unselected. In the Power View Fields area, move the pointer over url, click the down-arrow, and then select Add to Table as Count.

Hadoop Basics

The chart shows that we should focus on optimizing four of our website pages for the market segment of men between the ages of 22 and 30. Now we can redesign these four pages and test the new designs based on our target demographic, thereby reducing the bounce rate and increasing customer retention and sales.
<< Previous
Next >>

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy