Transcript Cube Implementation

Nidhi Singh
Nitesh Chilakala
Business Background
• AT&T Inc. is an American multinational
telecommunications corporation.
• AT&T is the second largest provider of mobile
telephone in the united states.
• It is spread across various wireless
communication sectors which includes voice,
data, internet and networking.
Business Needs
• What type of customers to target based on
demographic segmentation
• What bundled/mobile plans sell the most in
each region? We would know what types of
bundles to provide in each region.
• Quarterly and Yearly Sales and Usage
reports based on various demographic
factors.
• Region wise sales data to implement new
stores.
• To study usage patterns of customers and
formulate plans.
• To find new clients.
• Assess Product Demand.
• Revenue/Accounting Reports.
• Formulate Future Plans based on customer
feedback.
Data Model from MSAccess
Importing Database
from MS Access
using
SQL Server
Management
Studio
Creating Multi
Dimensional Data
Model using
MS SQL Server –
SQL Server Data
Tools
Two Star Schema Cube Structure
State wise report for products sold
•
The total number of products sold in Alabama is 20.
•
The total number of 100$ Family bundle product sold is 36.
•
The highest Sales were 43, in Texas.
•
The Total Sales in all states was 326.
State wise report for Revenue
•
The highest revenue was generated by Texas, total revenue $2578.
•
The least revenue was generated by Wisconsin.
•
100$ Family bundle generated the highest revenue of $3600.
•
The Total Revenue generated in all states - $20756.
Month wise Usage report
•
The highest Data usage was in the month of November.
•
The least Data usage was in the month of January.
•
The Total Data Usage for the year is 11733.
Quarter wise Usage Quantity report
•
The highest Usage for all plans was in Fourth Quarter.
•
The least Usage for all plans was in Third Quarter.
•
The Total Quantity of Usage of all plans for the year is 36430.
Sales Report by Stores and Quarter
•
The highest Sales were made by Store 7015 in the Fourth Quarter.
•
The least Sales were made by Store 7016 in the Second Quarter.
•
The Total Sale made by all the Stores is 20756.
Sales Report by Stores and Plans
•
The highest Sales were made by Store 7015 for $160 Bundled Plan.
•
The Total Sale made by all the Stores is 20756.
Usage Report by Age and Plans
•
The highest usage was by
Customers with age 33.
•
The Total Usage Quantity
was 36430.
Usage Report by Profession and Plan Types
• The highest usage was by Students.
• The least usage was by Corporates.