Business Intelligence from Panorama Software Helps The Times-News Analyze Circulation and Uncover Hidden Revenue Streams.Business Editors TORONTO--(BUSINESS WIRE)--June 7, 2004 Panorama Software's Business Intelligence Solution Leveraged To Discern Profitable Demographics and Redirect re·di·rect tr.v. re·di·rect·ed, re·di·rect·ing, re·di·rects To change the direction or course of. n. A redirect examination. re Sales Efforts When contending with circulation woes and the negative affects of Do Not Call Lists to its telemarketing telemarketing, the practice of selling goods or services to customers by means of the telephone or of surveying consumer preferences in telephone conversations. efforts, the Erie (PA) Times-News chose to improve its operational efficiency and seek out hidden revenue streams with assistance from business intelligence (BI) software. Working through E.J. Barry, a technology and marketing consulting company Noun 1. consulting company - a firm of experts providing professional advice to an organization for a fee consulting firm business firm, firm, house - the members of a business organization that owns or operates one or more establishments; "he worked for a based in Bethesda, MD, Panorama Software's NovaView(TM) solution was integrated with E.J. Barry's IntelliQube data warehouse, to leverage the power of Microsoft's SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. 2000(R), Analysis Services(R) and Reporting Services(R) and uncover critical information about the newspaper's circulation. 'Do Not Call List' Negatively Impacts Paper's Circulation An award-winning family-owned newspaper with a circulation of 60,000 daily and 88,000 Sunday, management at the Erie Times-News The Erie Times-News is a daily morning newspaper in Erie, Pennsylvania. It has a daily circulation of about 61,000[1] and a Sunday circulation of about 88,000[1]. was unable to properly analyze data regarding daily single copy sales, subscription 'no pays,' information relating to relating to relate prep → concernant relating to relate prep → bezüglich +gen, mit Bezug auf +acc sell-outs and returns, nor could they build reports so that managers and sales staff could respond to ever-changing conditions within the business. The paper also faced challenges caused by new telemarketing restrictions recognized as "Do Not Call Lists." The Erie Times-News needed tighter control of the newspapers' daily business activity to assist in the development of a new go-to-market strategy, which included a focus on a broader geographic readership and improved retention of both new and existing customers. E.J. Barry recognized that Panorama's solution would deliver in depth analysis of circulation, readership and retention through a highly graphical interface See GUI. , complete with easy-to-generate reports of key performance indictors (KPIs). With business intelligence in place, the Erie Times-News has realized tangible results in just a few short months. Non-pay subscriptions have declined nearly 15 percent, single-copy sales are up and the newspaper is on track to achieve its sales goals for the year. "While we've only just scratched the surface of our newly integrated business intelligence solution, we are able to use it every day to do near real-time analysis to track retention rates and single copy sales, and identify repeat non-pay customers for subscription campaigns," said Glenn Caruso, Erie Times-News circulation director. "Our circulation, sales and marketing teams all use the system to monitor daily performance and pull the analysis needed to support the creation of highly targeted and effective direct marketing campaigns." The highly integrated data management system, which resides on a server at the newspaper's offices, uses Microsoft's SQL Server 2000, Analysis Services and Reporting Services. E.J. Barry then combined the strengths of its IntelliQube data warehouse solution with Panorama NovaView, which extends Microsoft's SQL Server and Analysis and Reporting Services, and allows desktop and Web access to the data housed in Intellicube. NovaView includes valuable features such a "bubble-up" exception reporting, which warns of an underlying problem even when a user is analyzing a broader view of data. For example, NovaView can identify a poorly performing delivery route affecting the sales numbers of an entire district. NovaView also enables users to display sales results and identify growth opportunities via a highly visual mapping system. This has enabled the Erie Times-News to physically map the areas where subscriber no-pays exist and where single copy subscriptions are regularly sold out or returned. All Erie Times-News users can easily complete "self-serve" reporting and analysis functions, eliminating additional IT man hours previously needed to complete the reporting process. The implementation of Panorama's NovaView and IntelliQube has resulted in the Erie Times-News' ability to: - Forecast the number of upcoming new subscribers against the number of subscriptions that will end - Quickly identify gaps between beginning and ending subscriptions with enough time to take action and meet circulation goals - Use mapping tools to graphically display where both problems and opportunities lay - Direct retention campaigns to customers whose subscriptions are about to expire - Target potential customers who are most likely to subscribe - Review real-time data Real-time data denotes information that is delivered immediately after collection. There is no delay in the timeliness of the information provided. Some uses of this term confuse it with the term dynamic data. on all levels as information is updated daily - Accurately forecast single-copy sales to cut down costly returns or increase goals where there are consistent sell-outs - Use sophisticated analysis to compare year-to-date and year-over-year results "By combining the strengths of NovaView and IntelliQube through Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. , the Erie Times-News has been able to uncover in minutes what used to take upwards of a month," said Larry Sackett, president and CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. of E.J. Barry. "In our opinion Panorama's NovaView is the best OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. tool as it exposes the full functionality of Analysis Services. After working with a variety of OLAP tools, we've concluded that NovaView is our preferred solution." ABOUT PANORAMA SOFTWARE For software used to create panoramas, see . Panorama Software is an Canadian software and consulting company specializing in business intelligence. The company was founded by Rony Ross in Israel in 1993; it relocated its worldwide headquarters to Toronto, Canada in 2003. Panorama Software, a leading innovator of business intelligence solutions, helps global organizations unlock the hidden value of their information assets to improve business performance and results. By extending the Microsoft Platform through integrated business intelligence and corporate performance management solutions, Panorama ensures that decision makers at all levels and functions can easily analyze data, quickly create and distribute reports, and proactively measure performance. With offices throughout North America North America, third largest continent (1990 est. pop. 365,000,000), c.9,400,000 sq mi (24,346,000 sq km), the northern of the two continents of the Western Hemisphere. and EMEA (Europe, Middle East, Africa) Refers to that region of the world. For example, one might see products packaged differently for the UK, EMEA and Asia Pacific markets. , Panorama supports a global customer base in industries such as financial services The examples and perspective in this article or section may not represent a worldwide view of the subject. Please [ improve this article] or discuss the issue on the talk page. , manufacturing, healthcare, retail, healthcare, telecommunications and life sciences, and maintains more than 100 partners in 30 countries. More information is available at www.panorama.com. All trademarks and company names mentioned are the property of their respective owners. |
|
||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion