Client Description

AT&T Inc. is a communications holding company. The Company, through its subsidiaries and affiliates, provides local and long-distance phone service, wireless and data communications, Internet access and messaging, IP-based and satellite television, security services, telecommunications equipment, and directory advertising and publishing.

The company offers services via wireless, wireline, satellite, WiFi, IP network, Virtual Private Network, and fiber optic cable. The company is the biggest wireline voice provider and the second biggest wireless provider (behind Verizon Communications ) in the US with more than 135 million subscribers. It offers digital TV (as well as voice and internet service) through its U-verse brand and satellite Pay TV through DIRECTV. AT&T in October 2016 agreed to buy Time Warner Inc. for $85 billion. The deal would unite AT&T’s distribution capabilities with Time Warner’s content, which includes HBO.

AT&T’s Business Solutions segment is its biggest unit, generating about 45% of revenue. The unit provides services to business, governmental, and wholesale customers, and individual subscribers who purchase wireless services through employers.

The Entertainment Group accounts for about 30% of revenue by providing video, internet, interactive and targeted advertising services, and voice services to US residential customers. The group includes AT&T’s DIRECTV and U-verse operations. The Consumer Mobility business, about 20% of revenue, provides wireless services to consumers and wireless wholesale and resale services in the US. The international unit, which consists mostly of operations in Brazil and Mexico, accounts for the remaining revenue.

Dallas, Texas-based AT&T has spectrum licenses in all 50 US states, Puerto Rico, and Washington, DC. About 95% of AT&T?s revenue is generated in the US. Its wireless services and mobile broadband services are available in about 200 countries, but most of its international revenue comes from Mexico and Brazil.

The deal for Time Warner followed by about a year AT&T’s acquisition of satellite pay-TV provider DIRECTV for $48.5 billion in mid-2015. The combination enables AT&T to offer new packaged services and deliver content on mobile devices, TVs, laptops, cars, and airplanes.

Two other significant acquisitions made AT&T one of the biggest mobile carriers in Mexico. The purchases of Iusacell and Nextel Mexico in 2015 brought AT&T nearly nationwide coverage of Mexico and a potential customer pool of 100 million.

In 2014 it purchased Leap Wireless (which operates under the Cricket brand) for some $1.2 billion in an effort to build its profile in the prepaid market and expand its LTE network.

Challenge

AT&T wanted to convert an existing churnlite process into a Teradata data mart to, analyze subscriber data, and optimize call center performance management.

Solution

iOLAP identified anomalies in the e-commerce data mart, and documented areas of architectural improvement in the existing ETL process.

Benefit

AT&T now has a robust solution, with faster data delivery times and cleaner data, driving a positive ROI.

  • Tools: Informatica | Microsoft SQL Server Integration Services (SSIS) | MicroStrategy | Netezza | SAP BusinessObjects | Teradata | Unix
  • Categories: Analytics, Big Data, MDM, Strategy
  • Tags: Communications