Day 3 Team C (RAHUL RATHEE)

Topics Covered on Day 3:

File used: Cell.sav

a) Non-Hierarchical Clustering- K-means:

K-means requires:

• A number of clusters k

• An initial assignment of data to clusters

• A distance measure between data d(xn, xm)

• Hierarchical clustering only requires a measure of similarity between groups of data points.

b) Concept of Dendrogram:


• Provides an interpretable visualization of the algorithm and data
• Useful summarization tool, part of why hierarchical clustering is
popular

Groups that merge at high values relative to the merger values of their
subgroups are candidates for natural clusters.

c) Analyzing OLAP Cubes:

OLAP Cubes: An OLAP cube is a multidimensional database that is optimized for data warehouse and Online Analytical Processing applications.

An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases.

Study: Airtel & Reliance Male Users (Pre-paid and Post-paid)

Overall Airtel Users

Overall Reliance Users

Airtel Prepaid Users

Reliance Prepaid Users

Airtel Postpaid Users

Reliance Postpaid Users

Analysis: Overall Monthly Expenditure is much higher in case of Reliance Male Users as compared to Airtel (448 vs. 332 Rs).
Overall average for male users: 349 Rs

• SMS bill is almost same for both.
• Reliance exceeds in case of Fixed charges while Airtel is having more of Other Charges and Internet bill.

Prepaid case: Airtel vs. Reliance 334 vs. 410

• Fixed component of bill is much higher in case of Reliance.
• Other Charges, SMS bill, and internet are higher while Voice call bill are lesser in Airtel 

Postpaid case: Airtel vs. Reliance 250 vs. 625

• Voice call bills are higher while Other charges, SMS bill are lesser in Airtel.
• Fixed component of bill is much higher in case of Reliance.

Strategy for Airtel: 

• They should try to increase the fixed charges and give call and SMS at lower rates to increase the revenue on a broad level.
• As seen in the OLAP cubes, Reliance is having more revenue from Vlaue-added services like Special-package and Games.
• Airtel should try to bundle these services with the connection and should try to create dependency between various services provided to increase the perception of value visualized by customers.

Submitted by: Rahul Rathee

Team C

References: 

http://searchdatamanagement.techtarget.com/definition/OLAP-cube

http://home.dei.polimi.it/matteucc/Clustering/tutorial_html/kmeans.html

Note: Blogger is using Rohit Thorat's ID due to access issue