QlikView Customer Snapshot – Albany Times Union
Customer Company Size
Mid-size Company
Region
- America
Country
- United States
Product
- QlikView
- Mactive Analytix
- AdBase
Tech Stack
- Data Analytics
- Business Intelligence
Implementation Scale
- Departmental Deployment
Impact Metrics
- Revenue Growth
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Sales & Marketing
Use Cases
- Predictive Replenishment
Services
- Data Science Services
About The Customer
Albany Times Union is a leading daily newspaper that covers New York's Capital Region. The company offers a range of products and services, including Capital Region TU, SourceLine (a telephone information service), timesunion.com and knick.net Internet services, DirectTU direct marketing services, and hosts several major trade shows and events. Albany Times Union is a subsidiary of the Hearst Corporation and has a daily circulation of more than 100,000. The company is headquartered in Albany, New York and operates in the media industry.
The Challenge
Albany Times Union, a leading daily newspaper in New York's Capital Region, was facing challenges in gaining visibility into the performance of its advertising sales teams. The company was struggling to identify opportunities for revenue growth in advertising among a mix of customers, ad types, products, placements, etc. The lack of detailed insights into these areas was hindering the company's ability to effectively manage its business and make informed and timely decisions.
The Solution
To address its challenges, Albany Times Union deployed QlikView to 35 users across sales and advertising, from the publisher down to sales in the US. The solution enabled the company to assess sales rep performance for all charges on an ad and any credits/debits directed down to the insertion level through Sales Rep Performance Analysis. It also allowed the company to analyze order details in revenue and inches per insertion grouped by ad number, position, placement, product, customer type, and by rep through Ad Order Details Analysis. Additionally, the company could monitor average ad rate grouped by placement, ad type, product, sales team, and sales rep through Ad Rate Analysis. Albany Times Union leveraged Mactive Analytix (QlikView Server) to aggregate modest data volumes from Mactive solutions, namely AdBase.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Blue Bottle Coffee Enhances Ordering Accuracy and Reduces Waste with ML-Driven Demand Forecasting
Blue Bottle Coffee (BBC), a global coffee roaster and retailer, faced a significant challenge in managing the supply of pastries across its international network of cafes. The company was using a manual ordering system, where cafe leaders estimated the required quantity of pastries based on historical sales data, current inventory, and growth projections. This system was effective when BBC had a few cafes, but with over 70 cafes worldwide, it became inefficient and inaccurate. The inaccuracies led to either under-ordering, causing sell-outs and customer dissatisfaction, or over-ordering, resulting in food waste and profit loss. The suboptimal utilization of pastries was also affecting BBC's bottom line. Therefore, BBC needed a scalable, precise, and predictive ordering solution to improve pastry ordering accuracy, reduce food waste, and meet its sustainability goals.
Case Study
Designing an intuitive UI for effective product demand forecasting in retail
The client, a leading luxury store chain operating in over 100 countries, was facing challenges with their product demand forecasting process. The process involved a significant amount of manual work, with all sales-related data being kept in Excel tables and calculated manually. The client's merchandising and planning experts used a demand forecasting web application to make estimations of customer demand over a specific period of time. The solution calculated historical data and other analytical information to produce the most accurate predictions. However, the client wanted to improve the efficiency and effectiveness of this process, making it faster, more accurate, and less complicated for their employees. They sought to unify all processes under an intuitive UI.
Case Study
YAZAKI Europe Limited: Ensuring rapid, cost-efficient order fulfillment and quicker insights into business performance
YAZAKI Europe, a leading automotive supplier specializing in the production of customized wiring harnesses for car manufacturers, was facing challenges in meeting the automotive industry’s demand for same-day delivery. The company's continuous growth was impacting its ability to analyze performance and complete its end-of-month consolidation and reporting processes for its headquarters in Japan. The company needed to eliminate delays and manual processing in its logistics to ensure extremely efficient operations. The company also needed to boost its data analytics capabilities for its finance and controlling departments to accelerate the delivery of complex financial reports.
Case Study
How the Philadelphia 76ers Win Off the Court Using Machine Learning from DataRobot
The Philadelphia 76ers, a professional basketball team in the NBA, is part of a new wave of sports franchises that are leveraging data analytics to optimize both their on-court performance and business operations. The organization has a strong focus on using data to inform decision-making processes across all levels. One of the key challenges faced by the 76ers' Analytics Team was improving the efficiency of their season ticket renewal process. The team had been using data science and simple modeling techniques, but lacked a dynamic machine learning tool that could adapt and learn as more data was collected. This meant that the team had to do a lot of work in the offseason to produce a static model. The goal was to transform the renewal process from a once-a-year event into a year-round retention process.
Case Study
Getin Noble Bank S.A. Personalizing offers to meet customers’ specific banking needs raises savings deposits by 20 percent
Getin Noble Bank S.A. experienced several years of rapid growth, at twice the pace of the rest of the Polish banking sector. As the market became saturated, customers demanded a higher level of service. To create tailored product offers to meet their needs, the bank needed a more efficient and automated method of customer segmentation. It also wanted to develop effective campaigns with repeatable and predictable results.
Case Study
Milgard: Predicting sales with precision to drive swift, efficient production
Milgard Manufacturing, Inc., a leading producer of windows and patio doors, operates on a demand-driven manufacturing model to avoid overstocking issues. This approach requires the company to predict sales extremely accurately to ensure it has the resources needed to fill incoming customer orders quickly. Sales of windows are influenced by various factors, including housing market fluctuations and regional preferences. Therefore, Milgard needs to ensure that its annual budgets and forecasts accurately reflect the impact of these factors. The company's inflexible approach to planning threatened to hamper business agility, prompting it to seek a better solution.
