Telco, Cable and Utilities Application Areas

Sales Analysis and Billing	Fraud Management and Call Center
Network Optimization	Marketing Analysis
Customer Care and Analytical CRM	Financial Analysis

Sales Analysis and Billing
MicroStrategy delivers the scalability and functionality required to gain effective insight from the terabytes of data associated with selling and billing for residential, business, bundled and unbundled services. MicroStrategy leverages data analysis into competitive advantage by revealing more profitable sales opportunities and the path to more efficient back office operations.
MicroStrategy Reports Product Sales and Trends Customer Trends Sales Force Performance Commission Reporting Quota Attainment Product Affinity Account Balances Utilization Fraud Telemarketing EBPP / Intelligent Billing	Customer Snapshots: Comcast and Cox Business Services Comcast Cable Communications Inc., the country's leading cable and broadband communications provider, uses MicroStrategy to increase internal operational efficiency and employee productivity. Comcast has more than 55,000 employees in six divisions, and serves more than 21 million customers. Comcast tracks and assesses business data across functional areas to provide managers with greater insight into the company's operations. "With MicroStrategy's software, our employees will have the ability to create their own reports, and that helps support our goal of generating and internally disseminating timely, in-depth reports on key aspects of our operations. MicroStrategy offers ease-of-deployment, ease-of-use, ease-of-administration, exceptional scalability and powerful analytics that can drill down to the most minute detail." - Eric DeSimone, Director of Business Intelligence Systems, Comcast Cox Business Services, an operating division of Atlanta-based Cox Communications Inc., uses MicroStrategy to more efficiently identify sales prospects for Cox's Internet and telecommunications services. Cox sales managers conduct sales assessments by geographical areas using a combination of Cox's databases and Dun & Bradstreet data. Cox's network data engineers also tap MicroStrategy to evaluate Cox's networks to ascertain potential areas of expansion. "MicroStrategy's user-friendly reporting capabilities coupled with its powerful analytics are tailor-made for our needs." - Mark Snow, Director of Marketing Analytics, Cox
Report example

top

Network Optimization
Growing and maintaining profit margins requires optimum network efficiency. MicroStrategy's ROLAP architecture and powerful analytics allow carriers to compare a wide-range of metrics across network operations, and create real-time reports that identify problems for immediate attention. Alerts can also be created for instant notification of emergency situations requiring rapid response.
MicroStrategy Reports Traffic Analysis Network Planning Quality of Service Network Utilization Switch Operations Call Routing Capacity Switch Utilization Volume Management Failure Notification Capacity Analysis	Customer Snapshots: Telephia and Keyspan Telephia uses MicroStrategy to provide marketing and service quality performance products designed to help mobile companies track their position in the mobile marketplace, optimize investment decisions, and drive adoption and usage of their services and products. Telephia utilizes the MicroStrategy platform to anchor its Extranet, which provides marketing and service quality data to wireless carriers. "The timely, flexible and secure delivery of information through our MicroStrategy-powered client portal will permit our customers to more easily integrate Telephia syndicated marketing and service quality metrics into their business decision-making processes," said Greg Shaw, vice president of systems engineering at Telephia. Keyspan uses MicroStrategy Narrowcast Server to send alerts via email and pager when the actual flow of gas is less or more than the projected amount. KeySpan's customers, the "marketers"' that sell gas to end-users, can log into the KeySpan extranet, view gas usage projections and make informed decisions as to how much gas should be brought through the pipelines on any given day. KeySpan uses MicroStrategy technology to analyze such factors as historical data and weather conditions to project how much gas should be distributed. Four times a day, MicroStrategy Narrowcast Server compares the actual flow of gas to the projection made earlier in the day and then sends an exception report via email or pager to the marketer and the gas operations department controlling the valves. The alerts notify marketers when they have under- or over- nominated gas usage so that they can make appropriate adjustments. "KeySpan depends on the intelligent alerting capabilities of MicroStrategy Narrowcast Server to ensure homeowners and businesses throughout New York have enough energy to heat their homes and offices and run their hot water heaters." - Joan Hughes, Section Manager, IT sales, marketing and corporate data warehouse at KeySpan >> Read the Keyspan success story
Report example

top

Customer Care and Analytical CRM
Fierce competition for customers across the telecommunications landscape demands advanced customer care efforts. MicroStrategy enables telcos to segment customers by demographic, service plans, billing, and other criteria, delivering insight where it is needed, enabling managers to develop effective strategies that win and retain profitable customers while weeding out unprofitable ones.
MicroStrategy Reports Customer Scorecards Churn Analysis Customer Profitability Customer Plan Migration Service Level Agreement Trouble Ticket Service Complaints Customer Inquiry Dispatch Request Service Call Monitoring Preferences and Permissions	Customer Snapshot: O2 O2, the leading German mobile telecommunications provider, uses MicroStrategy for enterprise-wide reporting and analysis. O2 has more than 400 employees in sales, finance, marketing and management harnessing MicroStrategy to analyze and report on data collected from over 5.7 million customers. Via MicroStrategy's user-friendly Web interface, O2 performs applications such as sales force performance. "The MicroStrategy-anchored business intelligence system plays a fundamental role in securing and maintaining our company's success by gathering up-to-the-minute customer information across our entire business. Our management team is able to drill down to find specific information about new customers, successful sales channels, or popular products and have the information presented in easy-to-read one-page reports. We can now better assess performance and enhance operational efficiencies." - Dr. Clemens Schäffner, Head of CRM and Analytics for O2
Report example

top

Fraud Management and Call Center
MicroStrategy incorporates fraud detection and call center solutions that help management stop crime and operate efficiently. Drilling down into customer and employee contact records, MicroStrategy delivers insight that can reveal possible fraudulent activity, as well as identify operational problems that can be fixed.
MicroStrategy Reports Fraud Analysis Corrective Action & Notification Product Affinity / Bundling Pricing Models Discounting Call Volumes Call Times Response Times Complaint Logs Employee Productivity Capacity Forecasting	Customer Snapshots: Comcast, BellSouth and Southern California Edison Comcast Cable Communications, Inc., the country's leading cable and broadband communications provider, has selected the MicroStrategy Business Intelligence Platform™ to increase internal operational efficiency and employee productivity. Comcast has more than 55,000 employees in six divisions, and serves more than 21 million customers. Comcast will utilize the MicroStrategy system to track and assess business data across functional areas to provide managers with greater insight into the company's internal operations. Comcast will run these applications against a 1-terabyte Redbrick database. BellSouth's ISP business is using MSTR to study customer information compiled by its entire customer service operation. Loaded nightly into a data warehouse, customer information is analyzed to identify the cause of common problems. BellSouth responds by training call center representatives on the problem, updating the customer self-serve web site and developing new software for subscribers. Southern California Edison is one of the largest electric utilities in the U.S., and the largest subsidiary of Edison International. On an average day, SCE provides power for 11 million individuals, 800 communities and cities, 5,000 large businesses, and 280,000 small businesses in Central and Southern California. They use MicroStrategy to compare customers on certain plans with non-plan customers to gather information about who uses more energy, who makes more calls to the call center, and the demographics of these customers. Also, all users, regardless of group, use the same products to access the data warehouse. This leads to significantly reduced training efforts, especially when employees change groups. Management and Monitoring of all reporting applications is also significantly easier.
Report example

top

Marketing Analysis
MicroStrategy makes effective category management of telecommunications services possible by providing analytics across a wide range of marketing, planning, pricing, operations, and network variables, helping management determine what promotions and service plans are most effective for specific customer profiles.
MicroStrategy Reports Up-Sell Analysis Loyalty Programs Customer Segmentation Demographic Analysis Cross-Sell Analysis Service History Channel Efficiency Next to Buy Promo Lift Price Points Market Share	Customer Snapshots: Sprint and Telephia MicroStrategy is the enterprise-wide business intelligence standard at Sprint. More than 16,000 employees use MicroStrategy for 27 critical applications for such areas as marketing analysis, financial performance, call traffic and Web-traffic analysis. To provide the highest quality and reliability of service, approximately 3,000 Sprint employees access MicroStrategy software to track financial, sales and customer activity in order to make decisions that improve business performance and strengthen customer relationships. Telephia Inc., the leading provider of marketing and service quality intelligence to the mobile industry, uses MicroStrategy to provide reports to wireless carriers. MicroStrategy anchors Telephia's industry-leading portfolio of marketing and service quality performance products designed to help mobile companies track their position in the mobile marketplace, optimize investment decisions, and drive adoption and usage of their services and products. "The timely, flexible and secure delivery of information through our MicroStrategy-powered client portal will permit our customers to more easily integrate Telephia syndicated marketing and service quality metrics into their business decision-making processes. MicroStrategy's platform will enable us to take maximum advantage of the vast Telephia warehouse of wireless carrier information by consolidating our delivery environment to ensure user interface consistency, scalability, ease-of-use, information security, and reduced time-to-market." - Greg Shaw,VP of Systems Engineering at Telephia
Report example

top

Financial Analysis
MicroStrategy enables telecommunications carriers to take the financial pulse of their business whenever needed. Examination of financial performance metrics from across the enterprise arm financial managers with intelligence to make the most profitable business decisions possible. Financial insight from MicroStrategy ultimately improves gross margins and bottom line performance.
MicroStrategy Reports Revenue Reporting P&L Reporting Cost Analysis Margin Analysis Tariffs Taxes Budget Variance Analysis Access and Line Charges AR / AP Reporting Collections Reporting Contracts Reporting	Customer Snapshots: Telefónica and BT Wholesale Telefónica, the leading telecommunications operator in the Spanish and Portuguese speaking world and the second-largest European operator in terms of stock market capitalization, licensed MicroStrategy to expand the reach of its business intelligence applications. Telefónica has deployed a number of business intelligence applications across the enterprise, including applications for sales analysis, financial analysis, purchase reporting, audit reporting and marketing campaign analysis. "Our MicroStrategy system is a valuable component of our business, as the technology enables our employees to review and analyze information to make better business decisions. By adopting MicroStrategy technology across the enterprise, we have seen the speed by which decisions are made and productivity levels increase. MicroStrategy's intuitive Web interface lets users analyze and share corporate data with ease, and satisfies the business requirements of our widespread end-user community." - Luis Morán Abad, Manager of technology architecture & information systems at Telefónica More than 87 percent of the BT Wholesale workforce receives financial updates by email from MicroStrategy. Finance and key operational people also regularly access MicroStrategy to run their own reports. Tools include high-level financial reporting and in-depth analysis (profit and loss, balance sheet, cash flow), detailed financial transactions (accounts payable, journals, non-financials) and operational management control. "The MicroStrategy Business Intelligence platform is meeting the challenges that BT is demanding of it, and it is BT Group's business intelligence standard for financial reporting. One key factor that lifted the MicroStrategy solution above rival offerings is its strong Web technology foundation. Support for open standards like XML and Java paved the way for the rapid development of new reporting tools and simplified the delivery of tools offered by the legacy system. " - Pete Weeks, Reporting Development Manager at Xansa, BT Wholesale's technology partner
Report example

top