Social Network Statistics using SAP Lumira

[ansonabraham]

I have selected Social Network Statistics to experience SAP Lumira for the first time. Here is my little story about my first experience with Lumira.

Motivation

The richest people in the world look for and build NETWORKS, everyone else look for WORK. -  Robert Kiyosaki

Building networks is important in the competitive world whether it targets to sell a product or expand the brand name. Social Networks are the best place to fulfill this mission in internet. My objective is to find Social Networks with highest no of users and best page rank in web search. The dataset I have used in the analysis can be used to determine which Social Network is suitable for an individual or a firm to expand their brand through internet.

Action Plan

• Set up the system
• Learn the basic functionalities of SAP Lumira (I am an ABAPER and this is my first attempt in SAP’s Analytics space)
• Find the dataset through Google
• Refine the data
• Upload the data to Lumira
• Visualize the data

Setting up the system

First impression: Lumira setup file was comparatively light weight and installation procedure was very easy (just like normal windows programs).

Learning the basic functionality

I have gone through the official product tutorials to get better understanding of SAP Lumira.

Finding the dataset

I have collected the data from Wikipedia and created an excel file.

Source: List of social networking websites - Wikipedia, the free encyclopedia

Wikipedia article

Excel sheet

Refining the data

• Hyperlinks were removed from the excel records.
• Alexa’s page rank and registered users columns were converted into number format.

Uploading the data into Lumira

I have excluded the ‘Date Launched’ column from the excel sheet while uploading it.

Grid view of the dataset in Lumira

Visualizing the data

Objectives

1. Find the Social Networks with highest no of registered users. Bar chart, pie chart and tag cloud are used to visualize the data.
2. Find the Social Networks with highest page rank based on Alexa’s ranking.Table view is used to visualize the data.

Finding the Social Networks with highest no of registered users.

Bar chart

X – Axis: Social Network name

Y – Axis: No of registered users

Pie chart

Dimensions: Social Network name and Alexa’s page rank

Measure: No of registered users

Tag cloud

Dimensions: Social Network name and Alexa’s page rank

Measure: No of registered users

Result

Facebook, Twitter and Google plus are having the highest no of registered users.

Finding the Social Networks with highest page rank based on Alexa’s results

Dimensions: Social Network name

Measure: Alexa’s page rank (Ascending order)

Filter: Alexa’s page rank (Excluded empty ranks)

Filtering out empty ranks from the view

Final table view

Result

Facebook, Twitter and LinkedIn are having the best page ranks.