Qlik
概述
|
总部
美国
|
成立年份
1993
|
公司类型
上市公司
|
收入
$100m-1b
|
|
员工人数
1,001 - 10,000
|
网站
|
股票行情
NASDAQ:QLIK
|
公司介绍
Qlik Technologies Inc (Qlik Technologies) 是一家软件开发商，为企业提供自助数据可视化、引导分析应用程序、嵌入式分析和报告解决方案。该公司提供用户驱动的商业智能 (BI) 解决方案，使客户能够通过处理来自多个来源的数据来分析和提取有用的信息，并做出更好的决策。 Qlik Technologies 还提供咨询、培训和支持服务。它通过利用组织中个人的集体智慧来帮助优化商业智能。公司服务于各种规模的行业，如消费品、金融服务、零售、公共部门；能源和公用事业；通讯；制造、技术和医疗保健。
物联网应用简介
技术栈
Qlik的技术栈描绘了Qlik在平台即服务 (paas), 应用基础设施与中间件, 和 分析与建模等物联网技术方面的实践。
-
设备层
-
边缘层
-
云层
-
应用层
-
配套技术
技术能力:
无
弱
中等
强
Supplier missing?
Start adding your own!
Register with your work email and create a new supplier profile for your business.
实例探究.
Case Study
J.B. Hunt's Real-Time Data Delivery Transformation with Qlik
J.B. Hunt, a Fortune 500 company and one of the largest transportation logistics companies in North America, was in the midst of a company-wide digital transformation journey. A key part of this journey was the implementation of a Microsoft Azure Databricks data lake to modernize the data warehouse for increased efficiencies and data access across the organization. However, as the engineering and technology team started its rollout, they noticed increasing pressure on the operational data stores that served as the backbone for J.B. Hunt 360, their cutting-edge digital freight matching platform. After evaluating the data pipelines, the team pinpointed the need to accelerate the flow of data into the lake to ensure that J.B. Hunt 360 users maintained a quality experience with no performance lag.
Case Study
Better physician & patient profiling allows AsteRx & QlikView to break new ground in identifying health trends
Pharmaceutical companies are under increasing pressure to stand out from the crowd in an industry facing pricing pressures, promotional saturation, regulatory scrutiny, reduced product differentiation and increased customer and channel complexity. The healthcare market faces the dual paradox of being awash in data but often lacking in insight. Some of these companies are finding the means to pull ahead of the pack through leveraging analytics in broader and dramatically more effective ways. They are creating the organisational capability to develop and execute against differentiated insights. AsteRx was dealing with large data volumes, comprising millions of scripts from a national sample of hundreds of physicians to be analysed in a myriad of ways that would take weeks to manipulate for a single result. Customers were provided with raw research data, usually in Access or CSV format, making it difficult from which to draw insight. Furthermore, data contained lots of hierarchies, continually changing data frequency with varying levels of data aggregation. Multiple data sources also needed to be integrated with different formats, languages and data structures.
Case Study
Gwent Police Improve Intelligence-LED Policing with Qlikview
Gwent Police, a force in South Wales, United Kingdom, was facing several challenges. The existing performance management system was incapable of providing information for internal stakeholders. The force needed a system that could provide crime mapping and support intelligence-led policing. The previous system was paper-based and took a whole day to compile monthly staff performance reports. Information was dispersed under different applications in the force’s Command and Control system. The force was also keen to identify the availability of appropriately trained staff and highlight where there were shortages.
Case Study
American University of Beirut's Transformation with QlikView Dashboards
The American University of Beirut (AUB), a leading academic institution in Lebanon, faced significant challenges in managing 'big data' and extracting valuable insights. The university was using Oracle's business intelligence solution, which they found difficult to deploy and was only being used for reports rather than for dashboards and business discovery analysis. The university was also seeking to create a roadmap for the use of QlikView throughout the campus. The university and its medical center, AUBMC, were working with a variety of applications and database systems, including IBM DB2, Microsoft SQL Server, FoxPro, Oracle Financials, and specialist systems for hospital clinical needs. They also used three enterprise resource planning (ERP) systems—Oracle ERP, Banner ERP, and IBM—as well as Oracle Business Intelligence Enterprise Edition (OBIEE) for AUBMC.
Case Study
Leveraging IoT and Data Analytics for Equitable Education: A Case Study of Loudoun County Public Schools
Loudoun County Public Schools (LCPS) faced a significant challenge during the COVID-19 pandemic. With the closure of schools, the district had to ensure that all students had access to online learning resources. However, a small percentage of families and staff did not have internet access at home. LCPS had procured 1,500 hotspots from various vendors, but the challenge was to distribute these devices equitably. The district needed to identify not just the students, but also the households that required internet access. A triage approach was established to prioritize the distribution based on the disadvantaged status of households, households with multiple students, and households with students in higher grade levels.
Case Study
Qlikview Gives Allina Health the Tools to Deliver High Quality, Affordable Care and Operate As A Pioneer ACO
Allina Health, a not-for-profit healthcare system, is dedicated to the prevention and treatment of illness and enhancing the health of individuals, families, and communities throughout Minnesota and western Wisconsin. The organization has a comprehensive electronic medical record (EMR) system, Epic, which plays a key role in its success. However, Allina Health is also part of the Center for Medicare & Medicaid (CMS) Innovation’s Pioneer Accountable Care Organization (ACO) model, which requires a strong information infrastructure to manage and visualize the enormous amount of data that will eventually be reported to the government. The goal of this infrastructure is to bring all medical and patient information together, enabling Allina to evaluate its performance, identify areas for improvement, and discover ways for clinicians and care teams to deliver better care to patients.
Case Study
Qlikview Puts Data at the Fingertips of Design Within Reach
Design Within Reach (DWR), a multichannel modern furnishings retailer, was struggling with its data management. The company’s sales and inventory data was often analyzed using Excel, and occasionally with custom built reports using SAP’s Crystal Reports. This led to inconsistencies in data analysis as different people used different processes to create reports. The IT team was also burdened with doing one-off pulls from the company’s databases. DWR needed a solution that was flexible enough to be used by all Area Managers, regardless of location, and easy enough that they could find answers on their own, despite their levels of technical ability.
Case Study
Phoenix PMP gives 360 ̊ data insight
PHOENIX, a premier residential mortgage industry advisor, faced the challenge of collecting and analyzing extensive quantities of data for its over 250 customers. The information required for efficient, effective, and compliant mortgage production and servicing came from multiple sources due to the variety of systems employed by these firms. For instance, a Mortgage Servicing Rights (MSR) owner might use multiple third-party subservicers to manage its MSR portfolio, complicating the process of viewing performance data. It was increasingly difficult to sift through and focus on salient information on a consistent and timely basis to enable informed, smart decisions and to monitor outcomes. A lot of specialized effort was spent gathering the data, understanding what happened with a particular loan, realizing what it means, and then planning a course of action.
Case Study
MAPCO Express, Inc. Utilizes Qlikview to Understand Customer Behavior and Improve Business Processes
MAPCO Express, Inc., a leading convenience store operator in the Southeast United States, was struggling with inaccurate reporting due to the use of Excel as its only reporting tool. The company had significant amounts of valuable data but lacked the ability to extract meaningful information from it. For instance, it was unable to track customer loyalty trends per store. The timeliness of the data was another issue, with reports taking weeks to aggregate, which hindered efficient business decision-making. MAPCO needed a single source of truth and the ability to see the underlying trends and patterns that led to discrepancies.
Case Study
King.com Enhances Gaming Experience and Business Insights with IoT
King.com, a leading global online gaming company, was faced with the challenge of managing and making sense of the massive volumes of gaming data generated by their platform. The company needed a way to make this data accessible to the business for informed decision making. They also aimed to deliver rapid business insights and empower their business users with self-service capabilities. The challenge was not only to handle the data but also to derive meaningful insights that could inform various aspects of the business, from executive decisions to marketing strategies and product development.
Case Study
Nemours is changing the way it sees data with new analytics tech
Nemours Children’s Health System had a big challenge around electronic information: It needed to change its culture, to move to a model where staff started pursuing data versus just receiving data. The organization wanted to shift from repeatedly building dashboards and reports to really enabling the organization. They wanted to bring all their relevant data from any system, across finance, patient care and the overall business, into one place for analysis.
Case Study
How Qlik Helps Us Better Capture Your Science Fiction Imagination
ForbiddenPlanet.com, a leading science fiction retailer in Europe, was struggling with data analysis. The company had a vast amount of data but lacked a system for effective analysis. This was particularly problematic in their fast-paced comics business, where new editions are released weekly and accurate estimations of product demand are crucial. The company's management account meetings were inefficient, with an 80-page management pack of quarterly account data that was already out of date by the time of the meeting. The lack of real-time data analysis led to meetings ending with more questions than answers.
Case Study
IndianOil drills into data
IndianOil, the largest public sector oil and gas company in India, first turned to data analytics with QlikView in 2012. Dashboards were created, mainly for the company’s chairman and directors. During a review of its IT infrastructure, IndianOil identified an opportunity to make more use of the increasing amount of data being held throughout the organization. The company saw the potential of leveraging this data to drive business value across the organization.
Case Study
Canada’s Iconic Food Chain Uses Big Data to Boost Sales and Feed Hungry Customers
Pizza Pizza, a Canadian food chain, was struggling with managing and making sense of the vast amount of data generated from its operations. The company operates over 750 locations and fulfills over 20 million orders annually, generating a database with billions of fields. The company used to rely on static reports and spreadsheets to analyze its operations, which lacked flexibility and interactivity. The reports were generated daily and if a different perspective was needed, it would take days or weeks for IT to generate a new report. The company was unable to access real-time data and lacked the ability to drill down into the details of its operations.
Case Study
New emphasis on e-commerce: Qlik supports a change of direction caused by COVID
Sketch Books, Inc., a bookstore and stationery merchandise company with 30 branches across the Philippines, was forced to shift its focus to e-commerce due to the COVID-19 pandemic. The company needed to ensure a high level of customer service despite the shift to remote working. The challenge was to maintain the same level of service and customer satisfaction while transitioning to a new business model.
Case Study
Using Business Intelligence to Be a Beacon of Change in the Government
The Hillsborough County Tax Collector Office (HCTC) is responsible for collecting and distributing local and state taxes and fees to various partner organizations. They serve as an agent for their partner agencies and all of their community members to ensure that the money that flows into their office goes where it needs to go. However, they were facing challenges in managing the vast amount of data they collected and in using it to improve their efficiency and the quality of their work. They initially used Excel to handle performance metrics and insights, but it was time-consuming and prone to errors. They then tried another solution, but it did not allow them to actively manage their data or understand why certain trends were occurring.
Case Study
Great Ormond Street Hospital Children's Charity improves fundraising campaign performance with analytic insights powered by Qlik
Great Ormond Street Hospital Children's Charity was facing a decrease in the performance of warm cash appeals and needed to understand the reasons why and to explore more insight driven approaches to combat this. Previously, fundraising campaign reporting was done after each campaign by pulling data into Excel to create tables and charts, then moving these into Powerpoint for delivery and presentation. This often occurred after the next campaign was already live. The process was costly in terms of the time and resource required to prepare reports and did not allow the team to be as flexible and reactive as they would like.
Case Study
Strong Leaders, Strong Results: Our Path to Data Analysis, Literacy, and Governance
Gazprom Neft, one of the top three oil-producing companies in Russia, was facing challenges in making data-based decisions due to the lack of a robust Business Intelligence (BI) unit. The company was already a year into their journey with Qlik, a data analytics platform, when the BI Department Head joined in 2013. The task was to further develop the internal Qlik-based processes. However, the allocation of resources was a major challenge, especially server resources. The company was also not always on schedule in the purchasing of new equipment. Change management was another challenge, particularly overcoming internal resistance without clear signaling from company leadership.
Case Study
Empower Financial Services Employees Through BI with Best-Quality Apps
Nationwide Building Society, the world’s largest mutual financial institution, was facing a challenge with data management and analytics. The company's strategic vision is driven by its 15 million members, not the market or shareholders, and data underpins every one of their strategic goals. However, the company found that employees often worked within their silos or divisions and designed things for themselves, unaware that others in the organisation were trying to do something similar—often with the same data. This led to a lack of efficiency and a duplication of efforts. Furthermore, the company was using QlikView, but had licenses for only 500 people, limiting the access to data and insights for many employees.
Case Study
AGI tackles data science skills gap
Anurag Group of Institutions (AGI) is a large educational institution in India with a vision to maintain high academic standards and promote analytical thinking and independent judgement. The Department of Computer Science Engineering at AGI identified a serious skills gap for good data analysts in industry and business. With a forecast of 97,000 jobs that need to be filled in the area of data science, there is a huge need for skilled people. The department has been teaching 'Big Data' subjects to students and recognizes that the future for the next 30 years will be data analytics. However, they were seeking the best way to instruct students in data visualization and provide them with practical experience.
Case Study
Beyond Reporting: Creating Operational Excellence with Qlik
PSCU, a credit union-owned cooperative, was in the midst of a multiyear initiative to evolve and broaden its call center services when it realized the need for better data organization and visibility. The company was dealing with disparate data sources and flat reporting that lacked analysis, color-coding, and cross-functionality. The reports served specific needs but did not show all the inputs or outputs due to lack of integration. PSCU recognized the need to better organize its data to more effectively align with its business model and to provide the full suite of products and member experience required by its credit union relationships. The view needed to be cross-functional for the company to optimize and innovate where necessary.
Case Study
Embrace Data & Bring New Vision to Your Company
Hendry, an asset protection firm, was facing a challenge of limited value in their services due to a narrow vision of their work. The industry was lagging behind in the adoption of technology and clients were demanding more than what was being delivered. The company realized that they needed to change and adapt to the fast-paced, technologically driven world. They wanted to provide more value to their clients than just services required within statutory law. They saw the potential of data and technology to transform their services and become a full-service advisory business.
Case Study
When You Empower Your Team, Innovation Is No Longer a Question of 'If,' but 'When'
Odyssey, a logistics and supply chain management company, was in need of a business intelligence solution that could help them keep up with competitors and add value for their customers. The solution had to be a non-cloud, on-premise solution to allow the company to maintain complete control over the operation. It also needed to be flexible enough to extend into a true 'visibility' platform on the front-end. The company spent almost all of 2016 trying different solutions during the discovery phase of the project, but none of them were the right fit.
Case Study
Data Heats Business Up - Smarter analytics for sustainable growth
Quooker, the creators of a tap that produces boiling water almost instantly, has been experiencing rapid growth, with a 100 percent increase every three years. To sustain this growth and expand operations across a complex global market, the company needed more precise forecasting and analytics tools.
Case Study
Balanced Risk/Reward
BorgWarner, a global automotive components and parts supplier, was previously using a manual, spreadsheet-based approach to produce reports on total spend, supplier performance, and supply chain risk. This process was time-consuming, taking days to prepare for each supplier. The company faced a significant challenge in 2011 when Japanese suppliers were affected by a tsunami. BorgWarner struggled to determine the impact on their supply chain, products, and customer orders.
Case Study
Rounding the Bases: How Qlik Helped Us Bring Data Literacy Home
The article discusses the challenges faced by organizations in their journey towards data maturity. The first challenge is related to data quality. Organizations often have data quality issues, which become more apparent as they try to utilize the data. Issues can range from misspellings, inconsistent data entry methods, to software compatibility issues. Before any progress towards data-based decisions can be made, the data itself must be trustworthy. This requires creating mechanisms to ensure data quality. The second challenge is related to data literacy. Having great data is just part of the equation. Organizations must also have a genuine curiosity and the ability to ask the right questions. Most organizations are very familiar with asking, “what happened?” but the real power in analyzing data comes from more advanced questions. The final stage of intuitive growth involves reaching a level where insights about data trends lead to an ability to influence outcomes.
Case Study
Montrans harnesses the power of analytics
Transport fleets are crucial for modern commerce, and their efficiency is paramount. However, as fleets grow in size, their management becomes increasingly complex. To keep track, organizations have equipped their fleet vehicles with sensors. However, the sheer volume of telemetry data they receive is difficult to consolidate and convert into meaningful reports that point to effective business decisions. Montrans, Russia’s leading transport monitoring company, faced this challenge. It started as a fuel consumption tracker but its systems have since grown in sophistication and it wanted to move away from static reports to provide interactive fleet control and data-driven management.
Case Study
Chinese Academy of Agricultural Sciences builds big data applications for smart agriculture with Qlik
The Chinese Academy of Agricultural Sciences (CAAS) is a national innovation center for agricultural IT. It monitors agricultural information, risk analysis, food safety, and data acquisition. CAAS is in the process of refining big data for smart agriculture through its own application. The application handles heterogeneous data resources from a variety of data sources including local governments, commercial databases, and Internet of Things (IoT). However, the business intelligence (BI) products previously deployed by CAAS were seen as inadequate. They were generally limited to static data analysis and visualized representation, making it difficult to fulfill in-depth data interaction and analysis. CAAS wanted more specialized and powerful functionality. With such a huge volume of data, CAAS was concerned about performance load.
Case Study
Volvo Group’s Journey to Data Adoption and Collaboration with Qlik
Volvo Group, a global manufacturer of trucks, buses, construction equipment, and marine applications, faced a significant challenge in managing its complex material flow. The company had to connect with the right suppliers for the right spare parts and find the most efficient way of getting the right parts to the right trucks at the right time. The company's existing tools, such as MS Excel, were inefficient and left a lot of room for error. The team spent an excessive amount of time gathering data and making it understandable and presentable. This inefficiency led to a culture where teams and individuals quickly became siloed, missing out on opportunities to improve workflows or identify suppliers whose products weren't up to standards.
Case Study
Simplify Complicated Data Management Schemes at HSBC
HSBC, a global bank serving over 40 million organisations and individuals, was grappling with the complexity and scale of its data. The bank recognised the need for a strong commitment to analytics to thrive in the future. However, the challenge was not just about collecting data but making it usable and accessible across the organisation. The bank needed to ensure data quality, make data-driven decisions easier, and enable every staff member to contribute to business intelligence. The sheer size of HSBC and its commitment to data collection and analysis necessitated a simplified approach to data management.
Case Study
Shining a light on accounting and ERP data
Dataspark, a company specializing in data visualization, dashboards, and reporting specifically for Exact Online, Exact Globe, and Exact Synergy, wanted to empower Exact Software users to get even more insights from their data. To achieve this, they needed to build bespoke products and become the go-to services organization for their customers. The challenge was to find a flexible, easily accessible, and fast solution that their customers demand.
Case Study
AECOM relies on Qlik’s advanced SaaS analytics to cut through coal ash market complexities and realize extraordinary efficiency.
AECOM, a premier infrastructure firm, was facing challenges in managing the complex and dynamic market of coal combustion residuals (CCRs), also known as coal ash. The regulatory status of each coal ash unit was not centrally recorded, with each owner/operator maintaining its own website with all required regulatory reports. Manually gathering, analyzing, and summarizing this discrete data was complicated and arduous. Prior to 2019, AECOM was managing U.S. coal ash market data for customers in a series of spreadsheets, which had limited dimensionality and were challenging to quickly get results. The total amount of CCR material exceeds 2 billion cubic yards, making the management of this data a significant task.
Case Study
Analytics en Vogue: How Condé Nast uses data to evolve from a prolific print content creator to a digital media empire
Condé Nast, a dominant player in the international magazine market, embraced the digital revolution to engage with its audience in new ways. However, with its new digital applications, Condé Nast soon encountered more data than ever before. Hidden inside that data were key customer trends that could help Condé Nast create content more precisely aligned to customer appetites and seize advertising opportunities with sharper accuracy. Realizing this, Condé Nast began developing business intelligence infrastructure to make smarter use of its data, and it knew choosing the right partners in the digital transformation journey would be key.
Case Study
Sophistication and Simplicity: Striking the Right Balance in Data Analytics at HPE
HPE, after splitting from HP in 2015, aimed to apply end-to-end analytics to its marketing ecosystem. The company wanted to optimize demand flow through its funnel, take its digital transformation to the next level, connect the dots on marketing spend and outcomes, and transform its existing analytics system. However, the company faced challenges due to the numerous handoffs to other teams in the organization, the presence of multiple 'versions of the truth' due to different BI systems, and the complexity of connecting different connection points housed in different systems with different structures.
Case Study
Qlik enables better executive decisions
Benjamin Moore, a renowned paint company, was looking to transition from being a product-centric enterprise to a customer-centric one. The company wanted to improve its customer experience and needed a solution that would enable it to do so effectively.
Case Study
Data becomes a strategic asset: Active Intelligence drives customer experience
Rackspace Technology was dealing with a chaotic data environment, which was more of a liability than an asset. The business intelligence team was spending more time fact-checking than delivering actionable insights. The company needed to transform its data into a strategic asset that could help it compete better in terms of customer experience. To achieve this, Rackspace Technology established its Global Data Office.
Case Study
Performance Transparency and Value for Business
As a leading global brand in Quick Service Restaurants (QSR), the end-to-end supply chain is pivotal to the ongoing success of the brand. The European supply chain team are responsible for the product journey and field-to-fork performance (ethics, sustainability, quality and cost). With 6 markets, 10 distribution centres and 300 suppliers, the collection of data from multiple internal and external sources is critical and was complex. Once collected this information needs to be presented in a way that is Specific, Measureable, Achievable, Relevant and Time-bound (SMART) in order to transparently drive performance.
Case Study
Corporater leverages the Qlik® Analytics Platform to deliver Business Outcomes
Corporater, a Norway-based company, was looking for a business intelligence (BI) solution to help their customers visualize and make sense of their vast and varied data. The company needed a tool that would empower end-users to see insights and take action. While Corporater typically developed software internally, they carefully weighed the option of partnering, instead of building, a visual analytics tool. They evaluated several options, considering factors such as integration simplicity, ease of doing business, reputation, and visualization capabilities.
Case Study
From Siloed Data to Actionable Insights: Mastering the Digital Supply Chain
SDI, a digital supply chain company, was facing challenges in managing and utilizing its data effectively. The company had siloed areas of expertise, with knowledge spread out across the organization. This resulted in a reliance on tribal knowledge and information sharing, which was not efficient or effective. The company was unable to leverage data effectively between accounts, which could have led to shorter lead times and quicker turnaround for customers. Furthermore, the company was using outdated tools like Excel for data management and had not been exposed to enterprise-level BI solutions.
Case Study
Generali: Real-time data streaming using Qlik solutions
Generali, one of the world’s largest insurance companies, was facing a challenge with their application landscape. They had two-speed IT in place. The core legacy business application landscape had become more and more complex over time, and as a result had lost agility. On the other hand, newer customer facing and channel applications like portals were fast and serving different expectations. The task was two-fold. Firstly, to remove the complexity that had become visible to customers and enable them to independently access accurate information in real time, in a channel of their choice. The second strand was establishing new IT processes and improving development efficiency. They needed a solution that would connect two worlds to make them work more efficiently and cohesively for the business.
Case Study
Asthma Control Test: Improving ACT Scoring Documentation
The Asthma Control Test Qlik Sense application was built to assist in trending scores documented by the Medical Assistants within the clinic flowsheet. The challenge prior to the application was referencing a prior week lookback of data via an excel report. There simply could not be a meaningful conversation involving the ACT documentation without being able to easily show what was occurring.
Case Study
Ensuring strong ROI in education: Gray Associates teams with Qlik to deliver powerful insights
The traditional undergraduate education in the US is facing a decline, and the competition is increasing, especially with the advent of Covid-19 which has forced many institutions to move online. Budgets are tight, particularly for on-the-ground organizations that face the additional cost of maintaining buildings. It is vital that colleges and universities maximize returns when they are making large investments like opening a new campus or satellite. They must be sure that the site is right and must know the demographics of the students they aim to recruit. They must also pinpoint the best focus for their marketing spend. Obtaining this information requires the analysis of millions of lines of data, billions of highly complex calculations and input from the latest machine learning technologies.
Case Study
Driving Higher Revenues and Accelerating a Digital Transformation with Qlik Cloud
CSC ServiceWorks (CSCSW) services laundry locations and air services at gas stations across the United States. These services are often overlooked because when they’re working well, no one thinks twice about them. But these are historically coin-based industries. As currency has increasingly moved into the digital sphere, these services are less convenient for the general public. About a decade ago, the payment technology for laundromats and air machines started to shift so that people could pay with a swipe of a card. It was a nice leap forward. As the years rolled on, the rise of the Internet of Things (IoT) made smart payments with mobile devices possible, connecting information on these payments to a main network. Now, we can monitor all of our machines from a central location, provide convenient app based payment, and offer a higher level of service. Just as CSCSW served a traditional coin industry, we had a traditional on-premise data warehouse platform when I joined the company as Chief Digital Officer in 2019. We have developers for these warehouses, who would run and share reports with others when necessary. It was functional in the past, but as we gained more data this wasn’t a viable solution. With connected machines, our thirst for data and analytics within the company grew exponentially. We needed to have easier access to the data within the organization so people could get the information they needed on their own, and developers could focus on more important work besides pulling queries and running reports. We needed a more efficient way of dealing with data and driving value for our consumers, clients and employees.
Case Study
Supporting growth aspirations with Qlik
Tenaga Nasional Berhad (TNB), the largest electricity utility in Malaysia, is aiming to become a leading provider of sustainable energy solutions by 2025. To support this goal, TNB's Group Finance Division initiated the creation of a centralized Business Performance Management (BPM) dashboard. The dashboard was designed to increase the focus on growth and profitability, transforming finance from process manager to value creator. However, the challenge was to ensure that the dashboard displayed accurate and timely information, provided the correct picture through data visualizations, and was delivered to the right stakeholders.
Case Study
Bootcamp aims to plug skills gap
China’s rapid technological development has created a need for trained data analysts but there is a skills gap in the recruitment market for students with strong data literacy capabilities. One organization working to plug that gap is Xi’an Jiaotong-Liverpool University (XJTLU), an international joint university based in Suzhou, Jiangsu, China. The university recognized the need to provide hands-on data analytics experience to its students to prepare them for the job market.
Case Study
Driving transportation forward: Qlik Data Integration accelerates access to real-time data
J.B. Hunt, one of the largest transportation and logistics companies in North America, was seeking to increase efficiency and customer responsiveness by gaining real-time insights into its operations and assets. However, the company faced the challenge of not impacting production systems while doing so. They had implemented a Microsoft Azure Databricks data lake but needed to accelerate the flow of analytics-ready data into the lake.
Case Study
Empowering Students Using Qlik AutoML at Weber State University
Weber State University (WSU) began using Qlik AutoML in late Q1 2020, right as the pandemic took hold in the US. As Covid-19 wreaked havoc, the university had difficult decisions to make about where to allot resources in the midst of self-described “survival mode.” A combination of the right power at the right price made Qlik AutoML a viable choice even in uncertain times as a method to empower, support, and retain their students in a quickly-changing world. After a trial month with Qlik AutoML, decision-makers saw value thanks to Qlik AutoML’s ability to translate something complicated to something understandable, making it easier to share with stakeholders with and without technology backgrounds. With limited funding, Qlik AutoML was a more attractive option because of its affordability compared to competitors and consultants that can incur “astronomical expenses,” according to WSU’s Heather Chapman, Director, Academic Analytics.
Case Study
Setting a benchmark for security industry
CSC Financial Co., Ltd (China Securities) needed to better understand asset movements in real-time to maximize investment strategies. It also wanted to provide its clients with a real-time display that would clearly show the status of their portfolio from the China Securities application and other investment channels. The company had to deal with large data volumes and many databases which required up to 18 replication tasks. Frequent system upgrades also meant that replication environments had to be constantly rebuilt and replicating from heterogeneous databases was a cumbersome operation.
Case Study
Qlik helps boost store operational performance
Urban Outfitters, a lifestyle retailer with 650 stores across the USA, Europe, and the UK, was struggling with siloed data across different systems and technologies. This made it difficult to gain daily visibility of actionable data, a problem further complicated by different time zones and the varying operating styles of the three business brands. The Covid-19 pandemic added another layer of complexity as the company had to manage store closures and differing pandemic strategies. The company's biggest roadblock was the inability to easily explore information to gain the necessary insights, resulting in reports that had to be manually compiled, consuming a significant amount of administrative time.
Case Study
Increasing marketing efficiency and optimizing lead scoring with Qlik AutoML
Naylor Association Solutions was facing a challenge in their marketing-sales processes, particularly in lead scoring and qualification. The company was using a CMS that required account executives to fill out nearly 30 different data fields, which were then used by the marketing automation platform for scoring and qualification. This process was time-consuming and frustrating for the salespeople, who viewed many of the fields as unnecessary. On the other hand, the marketing team couldn't provide a better justification for the data other than they needed it for their processes.
Case Study
Beyond 12: Helping low-income and first-generation students move to higher education with Qlik AutoML
Beyond 12, a technology-based services organization, aims to increase the number of low-income and first-generation students who graduate from U.S. colleges and universities. However, they lacked a data scientist on staff who could build a predictive analytics model. They needed a robust in-house tool managed by their existing engineering staff for a viable and scalable solution. The objective was to refine Beyond 12’s approach to addressing their analytics needs and to provide coaches with a bird’s-eye view of their students. This would enable them to provide the right assistance to the right students at the right time.
Case Study
Chef Works Meets Qlik AutoML
Chef Works, a supplier for hospitality businesses, was impacted by the economic climate driven by the global Covid-19 pandemic. The company experienced a reduction in bandwidth and a growing need to effectively practice data science with a lower time commitment. The pandemic left many businesses in the hospitality industry on uncertain ground, and Chef Works needed to make the best use of their time and resources to not only sustain themselves through these changes, but to continue to innovate in ways their customers have come to expect at a price point that would be agreeable to once-lucrative businesses now strained for cash. Chef Works understood the grim reality that, while many of their customers would see the other side of the pandemic with business in-tact, many would not. To better support those that would survive, and to understand which businesses those were most likely to be, Chef Works turned to the power of data science.
Case Study
Accurate data underpins services delivery
The Department of Education, Skills and Employment (DESE) in Australia is tasked with a broad undertaking that impacts the lives of every Australian citizen. It accumulates huge amounts of data from multiple sources, including early childhood care providers, schools, universities, registered training organizations and employment services providers. Understanding this data is essential for delivering a world-class education, skills and training and employment support infrastructure. However, DESE faced challenges with its data analytics approach. It needed to future-proof its approach with a scalable SaaS platform. The department also needed to eliminate data time lags to understand the current reality and provide data in an accessible, digestible and engaging format to end users.
Case Study
Seeing Is Believing: How YBR Picked the Right Platform and Added Value to Their Business
Yellow Brick Road (YBR) was struggling with their existing business intelligence (BI) tool. The company was initially using Excel for data analysis and reporting, which led to significant delays in data delivery. The sales teams needed timely information to make decisions regarding sales targets and strategies, but the company didn’t have insights into loans until they received the commission statements from the banks—a delay of around eight weeks from the time of the actual sale. The delayed insights were always a challenge in making informed decisions to improve the sales KPIs, and the stacks of Excel sheets received from the lenders in different formats didn’t help with a timely and meaningful presentation. The company then implemented an emerging reporting software, which was a step up from Excel and a step in the right direction. However, not having local technical support and the tool's exorbitant pricing made them lean towards a more established tool with a local presence.
Case Study
De Swinhove Groep Transforms Itself into a High-Grade Information Organisation with QlikView
De Swinhove Groep, a healthcare provider for senior citizens in the Netherlands, was facing major challenges due to the rising costs in the care sector. The Dutch government was promoting homecare and shifting the responsibility for the use of budgets towards care institutions. This meant that care providers like De Swinhove Groep had to minimize building operation costs and optimize Total Cost of Ownership. The group wanted to develop a high-grade information organization and quickly integrate changes in management control information. They needed a business partner that was familiar with complex healthcare processes as well as business intelligence.
Case Study
QlikView enables the straight way to a coordinated business for Systemair
Systemair, a leading ventilation company with operations mainly in Europe and North America, faced several challenges. The company needed to share valuable business data locked in its Movex ERP system with more than 25 subsidiaries throughout Europe. The goal was to simplify and speed up data analysis enterprise-wide for improved decision-making. Additionally, Systemair wanted tighter control over business processes and operations to ensure 24x7 product availability for customers. As the business complexity grew, the existing system of analyzing data with simple SQL queries and Excel became unworkable.
Case Study
QlikView heightens award-winning customer service focus at Target Express
Target Express, the largest independent express delivery company in the UK, was looking to enhance its industry-leading image as an open, proactive business partner. The company wanted to quickly unlock data stored in various systems to provide superior service and share detailed logistical information with customers beyond standard industry KPIs. A key account recognized that a huge repository of information residing in Target Express’ systems would be valuable for conducting their business more effectively. The customer requested access to the data which would disclose what it cost them to operate in a specific area, move specific products, during a specific time of year, and numerous other operational insights.
Case Study
QlikView Customer Snapshot – TEAM Computers
TEAM Computers, a leading IT Infrastructure Solution provider in India, was looking to leverage its vast pool of data to support its ambitious growth plans. The company wanted to proactively manage its day-to-day business operations to maximize revenue. The challenge was to find a solution that could provide a unified view of data pulled from multiple sources, improve performance, and offer better control over productivity.
Case Study
ThedaCare improves patient outcomes and healthcare value with QlikView
ThedaCare, the largest healthcare provider and employer in Northeast Wisconsin, was facing challenges with its existing reporting systems. The systems were becoming cumbersome and not user-friendly. Ad hoc requests required end users to have IT develop the report. The process could take days to answer business and clinical questions—a situation worsening with increasing data volume. With 43 customer sites, 5400 employees and a commitment to improve healthcare value for its employer plan purchasers and 225,000 patients annually, ThedaCare needed to upgrade its reporting tools—but not at the high capital investment in server hardware and software licenses that its existing dependence on SAP Crystal Reports would require.
Case Study
QlikView provides ThiemeMeulenhoff with up-to-the-minute business information
ThiemeMeulenhoff, one of the three largest educational publishers in the Netherlands, was facing several challenges. The company needed to allow management access to the latest information to gauge performance and allow staff to select and interpret data without the requirement for IT. They also needed to upgrade their reporting to comply with International Financial Reporting Standards (IFRS) and transition from a paper-based to a digital information flow. The company was also implementing a timesheet system that still needed a report module. They had the option of choosing between a traditional system, which produced reams of paper lists on a daily, weekly and monthly basis – heavily supported by their IT department – or a more modern Business Intelligence (BI) solution.
Case Study
Tommy Hilfiger Simplifies Data Analysis and Cuts Reporting Time with QlikView
Tommy Hilfiger's head office databases are periodically updated with data that’s necessary for the work of all group companies and partners. The Russian representative office receives these updates in the form of Excel files from the head office. Head office uses the Oracle and SAP software, and the Russian partners use several different configurations of 1С:Enteprise business management software and other vendor systems. Another challenge was the timely receipt of sales reports from the Russian partners. The supervision system requires partners to provide weekly sales reports to the Moscow office and each of the 12 partner companies keeps daily accounting of sales in spreadsheets or in various accounting systems. At the end of each week, the data is emailed to Moscow, where it is manually consolidated into a report. As the data gathering and consolidation process was lengthy, the Moscow office would often experience delays in receiving information. Moreover, all reports consisted of ‘raw’ figures, which had to be processed and analyzed for a long time before any decision could be made.
Case Study
QlikView Business Discovery Platform Improves Decision-Making for Toshiba Europe
Toshiba Europe, a subsidiary of Toshiba Corporation, was seeking to improve its service quality, measure the performance of its outsourcing partners, and optimize its spare parts procedures. The company's customer service is supported in eight European countries by external customer contact centres that handle around 60,000 calls a month. The company wanted an analysis solution that could check whether the agreed service levels were being met by monitoring various key performance indicators (KPIs). In the repairs department, the aim was to analyse turn-round times on individual orders, so as to manage more efficiently the repairs and necessary logistics processes. The company was looking for an analysis solution that could be installed simply and quickly and then flexibly operated by the European specialist operations department itself. The system should avoid taking a toll on internal IT resources or incurring cost-intensive days spent on site by external consultants, as well as being capable of collating and analysing data without needing a special data warehouse.
Case Study
Manufacturer increases sales conversion rates with BI solution
Tulikivi Corporation, the world’s largest manufacturer of heat-retaining fireplaces, adopted a new, product group-based strategy. In line with the new strategy, the company wanted to analyse business information more efficiently. Previously, meetings dragged on while waiting for information, and in many cases the information received was not the information that was agreed on. Further challenges included slow reporting and software, which resulted in waiting for analyses. In the old days, it was a challenge to compile reports manually quickly enough. The software was too slow and they had to wait for analyses. Meetings dragged on and the reports that were produced did not always meet the actual need. Distribution of reports was another problem.
Case Study
Faster, smarter decision-making at TVH, thanks to QlikView
TVH experienced rapid growth due to several successful takeovers, leading to a significant increase in data volume. Their existing reporting system, which relied heavily on Excel, was unable to handle the increased data load, resulting in slow processing times and a lack of clear overview. The company was using multiple data sources, including AS400, Oracle, and Progress, which further complicated the situation. The old system lacked flexibility and was unable to make necessary links, leading to insufficient collection of sales, customer, and item-related information. There was an urgent need for a new reporting system.
Case Study
UWV’s QlikView Competence Center builds more than 50 applications in just 2 years and provides 1,650 people with reporting & analysis capabilities
UWV, a governmental organization in the Netherlands, was facing the challenge of replacing all paper and static reporting with dynamic models for reporting and analysis, directly tuned to the information requirements of the users. The volume of paper reports within the HRM department was growing continuously, with each report being created manually with data from the personnel information management system. The departmental management team wanted to replace these reports, which were already dated the day they were distributed, with automated, 24/7, dynamic reports presented in an easy to use dashboard environment with slice and dice and drill down functionality.
Case Study
Quick, Relevant and Convenient Information Analysis: QlikView Allows Van Oirschot to Gain Consistent Insight into Its Data
Van Oirschot, a supplier of heating and installation materials for professional installers in Flanders, was facing the challenge of implementing a reporting and analysis tool that ensures consistent information provision and provides easier insight into Microsoft Navision data. The company operates five branches and a central distribution centre in Flanders. It creates added value by handling additional aspects for its customers, such as transport, stocking, provision of credit, collection and splitting, packaging and repackaging, services, guarantees, returns, information provision and training. However, it was crucial for the company to remain competitive and innovative in the face of increasing competition, chain integration and cost pressure. Moreover, their customers were expecting greater flexibility, longer opening hours and automated ordering processes.
Case Study
Vellinge increases cost awareness and achieves greater freedom with QlikView
Vellinge Municipality was facing a challenge of analyzing information residing in disparate source systems. They needed stronger controls in order to reduce overall operating costs. The solution required was one that could be used by employees lacking formal finance training and background. The municipality had a policy of keeping the income tax rates low, which meant that everyone in the organization needed to review all costs associated with every departmental decision. This involved approximately 10 controllers and 60 managers with budget responsibility sitting in different locations. Before implementing QlikView, they had to compare printouts from different systems manually to compile the information. In many cases, they even had to manage without the necessary information.
Case Study
QlikView Customer Snapshot – VIP Auto
VIP Parts, Tires & Service, the largest privately owned US automotive aftermarket retail chain, was facing several challenges. The company wanted to replace its one-dimensional merchandising hierarchy reporting with multilevel merchandising and business unit views. They were also struggling with integrating disparate data from multiple systems. The company was seeking to increase the visibility of operational KPIs throughout the organization. The company's sophisticated business footprint spans retail, wholesale, fleet, and commercial divisions, making it crucial to have a comprehensive and integrated view of all operations.
Case Study
VSE Corporation effectively manages large scale government projects using Deltek with QlikView®
VSE Corporation, a diversified government contractor, was facing challenges in managing the business side of its large-scale projects. The company was struggling with real-time data gathering for current project analysis, which hindered its understanding of the financial status of ongoing projects. This delay in data gathering and analysis led to incorrect invoicing and backlog tracking, causing payment delays from customers. If a project stalled and did not complete on time and on budget, it could have significant consequences for VSE and other government contractors. The company also needed to effectively handle labor utilization and risk assessment to ensure employees were as chargeable as possible and there was financial support for unplanned projects. VSE's previous Business Intelligence capabilities were complex, inflexible, and failed to provide a standardized view of data.
Case Study
Wanbury Gives Managers Access to Analysis on Mobile Devices
Wanbury, a rapidly expanding pharmaceutical company in India, was facing challenges in accessing and analyzing its 'big data'. The company's business was growing and it needed to improve its business discovery capacity to cater to an increasingly mobile executive team and enable complex analysis of large data sets. The company was previously using a system of exporting data from various standalone applications into Microsoft Excel spreadsheets to generate largely static BI reports. This system had several drawbacks, including reduced accountability for, and visibility of, organizational and individual performance. This often delayed decision making by senior management and heads of departments. The reporting solution was also unable to provide analysis trending capabilities to executives who were on the move or away from the office.
Case Study
WD-40 keeps business running smoothly with QlikView
WD-40, a global consumer products organization, was facing challenges in analyzing reported data and gaining insights into customer behavior. The company was relying on hard copy weekly reports to provide crucial business detail, which was putting increasing pressure on the IT department to produce more meaningful sales information in a user-friendly, real-time application. The traditional reports created by the company’s previous ERP system were both costly to produce and lacked important detail. A data analysis tool was needed to support WD-40’s growing business and to ease the pressure on IT resources. The company also needed applications that would support, speed up and simplify financial reporting to its parent in the US, a logistics application for better order-to-delivery efficiency and pan-European sales analysis for proactive management.
Case Study
QlikView Provides a Pyrotechnic Analysis Display for WECO
WECO Pyrotechnische Fabrik, a leading fireworks producer in Europe, faced challenges in managing its multi-stage in-house production system and purchasing merchandise from abroad. The company required accurate logistics planning to ensure all branch outlets received their stocks in time for New Year’s Eve sales. The same level of accuracy was needed for planning production and import schedules. For a long time, data analysis was done using Microsoft Dynamics NAV business management software coupled with individually programmed reports. However, this procedure proved to be time-consuming and error-prone. The data was first exported from the inventory management system into various different Excel worksheets and then collated. This process led to errors and could only assess and optimise processes in retrospect.
Case Study
Wegter generates dozens of reports every day using QlikView
Wegter, a non-food wholesaler, was facing several challenges. They needed a faster business analysis for their customers and a reduction in the time it took to generate reports on licensing and royalty agreements. Their customers were also demanding more detailed reports on available inventory, delivery schedules, and royalties. The company was using different packages to retrieve data, organize it, and present it, which was inefficient and time-consuming. They were also struggling to meet their customers' demand for a delivery reliability rate of more than 92 percent.
Case Study
QlikView for ERP improves management information and business efficiencies for Weir Services
Weir Services, a part of The Weir Group, a global engineering services company, needed an ERP reporting tool capable of delivering quick, executive-level, dashboard views of division operations and finances to ensure optimal performance levels. The company had been sharing an ERP system with the Group’s Weir Pumps manufacturing business and recognized the need to implement its own ERP solution for its various facilities in the U.K, Middle East, and potentially other facilities around the world. The company wanted to leverage the invaluable data locked in its systems from Movex and SAP to its Environmental, Health and Safety system.
Case Study
Yamaha Music Sales Divisions Harmonise Sales Data with QlikView®
Yamaha Music Europe, a subsidiary of Yamaha Corporation of Japan, is responsible for selling Yamaha musical instruments and audio-visual equipment across Europe. The company faced the challenge of harmonizing sales logistics and other data from six European sales divisions. They needed to unify all information into a single BI tool to facilitate cross-selling and upselling across Europe. The company also wanted to offer managers tools for immediate ad hoc query and analysis of data. Prior to the consolidation, the six subsidiaries held business critical information in disparate databases. From a business perspective, Yamaha was keen to improve the potential for cross selling and upselling across the region to take advantage of the growing integration of European markets and the growth of sales via internet.
Case Study
QlikView BI solution achieves heavenly results for York Minster
York Minster, a world-renowned cathedral, is a large organization with around 150 employees and 500 volunteer workers. The operational costs of the Minster are incredibly high, amounting to £9 per minute, 24 hours a day. As a registered charity, it depends on donations and visitors fees to survive. This means that the Minster has had to become increasingly aware of its income streams in order to improve margins and keep reinvesting in its many community and regeneration projects. The IT department is relatively small, with two employees including IT Manager David Wilkinson. Wilkinson also acts as Assistant to the Chief Accountant, and it is this dual role that brought him to QlikView. “When we started charging for entry into the Minster, we needed to be able to analyse visitor trends and tills data. We also wanted to identify where we were improving, especially how much income was coming through from GiftAid and the sale of guide books,” says Wilkinson.
Case Study
QlikView Facilitates Operational Use of Data at Réunion Regional Hospital
The Réunion Southern Regional Hospital was facing challenges in accessing data from numerous sources and systems. They were using simple single-database query tools which were insufficient to allow users to efficiently access all data. The hospital needed a solution that could integrate data from various different sources and systems, and provide instant access to greater amounts of information in the form of visually rich interactive dashboards, and reports. They also needed a solution that could deliver greater independence and self-sufficiency for users.
Case Study
QlikView hyperspeed at Globus hypermarket chain
Globus, a retail chain of supermarkets, was facing challenges in reducing time to value, consolidating data from multiple unstructured sources, and gaining better insight into ongoing campaigns and promotions to increase the efficiency and profitability of operations. The management information system used by Globus was provided by an external company and was based on static Excel reports published in a web environment. The online reporting system could only use a limited number of dimensions and as a result many decisive processes were based on not completely identical outputs, while some reports were not available at all and many were created by manually copying from various systems into Excel tables.
Case Study
Health Market Science taking healthcare provider data a QlikView-leap forward
Health Market Science (HMS) is a leading manufacturer of healthcare provider data in the United States. The company's flagship product, the HMS Provider Master File, includes detailed reference information for over 4.5 million individual practitioners and 1.0 million healthcare organizations. However, the company faced challenges in continuously tracking, integrating, analyzing, cleansing, and packaging millions of records of data from thousands of sources. The company's business analysts depended on as many as three programmers to write SQL code for a new, complex analysis. This process was time-consuming and sometimes led to different answers to a query depending on who was writing the code. HMS needed a solution that would enable business analysts to analyze data without support from programmers and meet requirements without the cost, complexity, and time required by traditional OLAP cube solutions.
Case Study
As a news company, IDG has its own compelling story with QlikView
IDG Denmark, a business unit of IDG, world’s leading technology media, research, and event company, was facing challenges with data analysis. Their business processes were supported by a Siebel® CRM system and a MBS (Microsoft® Business Solutions) Navision ERP system, which churned out static paper reports. Analysis of data across systems was only possible by manual creation of spreadsheets – a tedious and risky process which provided outdated information. With millions of lines of data to analyze, Excel® exceeded the ability to provide IDG Denmark with the needed detail. The company had limited resources to do this – both on staff and financially. They needed a powerful, yet easy-to-use Business Intelligence tool for interactive data analysis, enabling IDG Denmark to effectively and proactively monitor, manage, and optimize the business.
Case Study
Laureate Education Asia Uses QlikView to Cut Analysis Time from Seven Hours to 20 Minutes
Laureate Education Asia, a part of the Laureate International Universities network, was facing challenges in financial forecasting and reporting. The process of preparing monthly analysis and reporting at their regional office was time-consuming, taking up to seven hours to run a comparison of financial performance of their different institutions from Oracle Hyperion. They wanted to reduce this time and improve the quality of their reporting. They also wanted to enable their staff to archive their own data and extract forecasts on a self-service basis for quicker decision-making.
Case Study
QlikView Impacts Purity Life’s Profits
Purity Life Health Products LP, a leading distributor of natural health products in Canada, was facing challenges with its legacy system for business data analysis. The system was cumbersome and only a few employees had access to useful and timely data. This lack of data accessibility and transparency was hindering work efficiency and visibility into the business. The company needed a solution that would liberate its data and make it accessible to more people within the organization.
Case Study
Direct Relief Case Study
Direct Relief, a global humanitarian aid organization, faced a significant challenge in managing its supply chain. The unpredictable nature of world events and the receipt of products from donors made it difficult to plan and execute logistics efficiently. Furthermore, the organization had to deal with medical products with expiration dates stored in warehouses worldwide. The complexities of shipping times and customs protocols posed a risk of these products being wasted unless Direct Relief could move quickly and maintain full visibility of their supply chain. The data essential for this agility and visibility was trapped in their SAP system, making it inaccessible for effective decision-making.
Case Study
Medair and Qlik Partnership for Data Analytics
Medair, a humanitarian organization, was facing a challenge in gathering and analyzing data from the field. They were using Open Data Toolkit (ODK) to collect health and nutrition metrics in the field, which would drive their programming and the work of other NGOs in the region. However, they needed specific analytic visualization to better understand the survey data and respond most effectively with their program work. The potential for impact was enormous, as the data would be used by hundreds of personnel working in the region daily to make better-informed decisions and save more lives.
Case Study
IHS Markit Enhances SAP User Experience with Qlik Gold Client
IHS Markit, a world leader in critical information, analytics, and expertise, was facing challenges in providing effective SAP user support due to the tightly controlled and audited nature of its SAP production system. The system required multiple layers of authorization to access any data, which often resulted in delays before access to production was granted. Prior to implementing Qlik Gold Client, Markit was manually creating, matching, and reviewing a massive amount of information to mimic production data in QA, which was proving to be an inefficient process. The company was looking for a solution that could reduce the excessive use of Firefighter access while still addressing compliance issues.
Case Study
BITMARCK Uses Qlik Replicate™ (formerly Attunity Replicate) and Microsoft SQL Server to Streamline Data Integration and Enable Self-Service, Real-time Business Intelligence for Customers
BITMARCK, the largest full-service provider in the German IT market for statutory health insurance, needed to streamline data integration and enable self-service, real-time business intelligence for its customers. The public health insurance companies use information to measure customer retention and turnover, generate financial reports, manage cash flow, and estimate risk. To support customers’ business intelligence and analytics initiatives, the BITMARCK team routinely had to gather data from several different technical sources and move it into a central target. These data sources ranged from IBM DB2 to MySQL, Microsoft SQL Server, and Informix. BITMARCK had been using IBM Q Replication, but this solution only supported replication between DB2 sources and targets. To replicate data to other sources, the BITMARCK team had to do lots of SQL scripting or use proprietary programs.
Case Study
DomainPower Enables Big Data Analytics in the Cloud with Attunity and Amazon Redshift
DomainPower, a leading real-time bidding exchange connecting online advertisers to rich native advertising inventory, was dealing with a high volume of transactional data from its online auctions. The company recognized the need for a data warehouse to analyze market trends related to its supply inventory and the value of advertising. They decided to explore Amazon Web Services, but the daily source data changes proved to be a challenge. Daily batch data updates between DomainPower’s on-premises Microsoft SQL Server system and an Amazon Redshift data warehouse would not meet the business needs. This represented an obstacle to using Amazon Redshift, since keeping the environments in sync might require significant development effort and ongoing maintenance.
Case Study
Glidewell Laboratories Gains Deeper Data Insights Faster with Amazon Redshift and Attunity
Glidewell Laboratories, the largest dental lab in the United States, faced a significant challenge when they adopted the CAD/CAM Digital Manufacturing standard. The adoption led to a tenfold increase in the amount of data the company had to store and analyze, reaching over 150 million records. To manage this change, Glidewell aimed to create a more responsive, cloud-based infrastructure to support business intelligence and analytics. However, cloud migrations can be tricky, often requiring custom coding that slows down the process, reducing the time-based value of analytics for quick business decision-making. Glidewell's on-premises data storage solution included over 80 separate databases, adding to the complexity of the migration.
Case Study
Gold Client drives Colmobil’s critical enterprise data initiative to ROI success
Colmobil, Israel's largest importer and distributor of vehicles, was executing several SAP projects in parallel across the company’s SAP landscape. This included migrating two subsidiaries’ legacy systems to SAP, which required updating testing environments to develop new business logic and properly connect all the data. However, creating a new system or refreshing an existing one with updated data for a new project was extremely time-consuming. It could take up to a week of intensive work to complete these tasks. As a result, teams always questioned whether it was worth creating a fresh system or whether they could risk working on an outdated one. Dependence on the Basis team created bottlenecks. The Application team had to rely on the Basis team to refresh a QA or Dev environment. Bottlenecks inevitably led to long lead times to create new environments. It was difficult to recreate erroneous events or research bugs. Discrepancies between the production environment and Dev or QA limited the company’s ability to address issues when they arose. Issues usually appeared in the newest customizations or development work, where the gap between production and Dev or QA existed.
Case Study
Mercedes-Benz saves 25 man-days annually on QA refreshes
Mercedes-Benz USA implemented SAP Finance and Controlling in 2000, followed by Parts Logistics, Materials Management, Sales and Distribution, and Production Planning in recent years. With five business units running on two instances of SAP, the environment has become progressively more complex. The total SAP system now houses two terabytes of data, with pricing tables alone adding up to 400 million records. The primary issue caused by the refreshes was that they took the non-production systems offline for several workdays in the middle of the week, which would negatively affect ongoing projects. Mercedes-Benz wanted to be able to provide developers with the data they needed for testing on an as-needed basis while reducing the number of full refreshes required per year. The company also wanted to be able to protect version information.
Case Study
Tangerine gains insights from customer data thanks to Qlik (fomerly Attunity) and Microsoft
Tangerine, a direct bank in Canada, was looking to become a more full-service digital bank. They wanted to listen closely to their customers and create services that their customers were looking for. This required Tangerine to have access to customer data in real time so they could respond quickly to their needs. As they began this journey, they reached out to their customers to find out what they wanted from a bank. The first step was to develop a responsive website with a user interface that easily adapts to the device customers are using to access it. The next step was to leverage customer data differently. They needed to keep track of customer feedback and complaints, which included every face-to-face and phone interaction with a customer, in addition to social media sentiment. This requirement had Tangerine’s IT team looking at the data in their current data warehouse as well as the expected growth for their data over the next several years. It also had the team looking at the time it took to move their data so that their bank managers could analyze it while the data was fresh.
Case Study
University of Maryland College Uses Attunity Software to Replicate Data to the AWS Cloud
University of Maryland University College (UMUC) was facing the challenge of organizing and deriving insights from four core datasets, totaling 10 terabytes. These datasets included data related to online student activities, student enrollments, financials, and customer relationship management. The data was stored in a mix of on-premises Oracle and SQL Server databases, Salesforce, and other cloud-based service applications. UMUC’s challenge was to aggregate these disparate data sources, normalize the data, and then load it into a data warehouse for analysis. This was a classic ‘data integration challenge’ that included extracting data from source systems, staging the data in a relational database and applying transformations, loading data into a data warehouse, and running analytics and providing a visualization layer.
Case Study
QlikView Customer Snapshot – PRIMAGAS
PRIMAGAS, a utility company with regional headquarters in Krefeld, Dresden, and Würzburg, was facing challenges in analyzing Oracle data for its subsidiary. The data was analyzed by manual reports in Excel, which was a time-consuming process. The company was under high pressure due to its business operations. The parent company was using another tool which was not suitable for PRIMAGAS's business. The company was dealing with large quantities of data.
Case Study
QlikView Customer Snapshot – Prince William Health
Prince William Health System faced several challenges. They lacked real-time visibility into their Accounts Receivable (AR) process due to the outsourcing of management and tracking, coupled with limited reporting. This lack of visibility was a significant issue as it hindered their ability to effectively manage their revenue cycle. Additionally, they were struggling with high write-offs for insurance claims, which was negatively impacting their financial performance. Another challenge was the assessment of physician performance for the contract renewal process. The hospital needed a way to track and analyze physician performance to make informed decisions about contract renewals.
Case Study
Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView
Procurement Lincolnshire, a shared service partnership between eight local authorities in the East Midlands, wanted to respond to the need for efficiency savings by analysing its expenditure in more detail than ever before. They decided to improve its visibility over procurement activity with a new software platform to help meet the budget reduction targets posed by the government Comprehensive Spending Review in 2010. The procurement activities under scrutiny already cover around 30 categories. They range from reviews of high spending services, such as adult social care and children services, to outlays on photocopiers, pest control, and even dog kennelling. The challenge was finding a user friendly dashboard solution to access customised data mining reports for a more holistic view of the organisation spend.
Case Study
Province of Bolzano creates statistics with QlikView
The Office for Computing, Geography and Statistics of the Autonomous Province of Bolzano manages the entire information system and serves 6,000 workstations. Its main client is the Provincial Statistics Institute, which runs provincial statistics analyses. The Office needed to find a user-friendly tool that presents detailed findings and a system that does not require complex technological infrastructures. They also needed to analyze highly complex data combinations efficiently. The Office conducted a study to find the tool that best suits the Provincial Administration’s environment – an agile, customizable tool that would not require complex technological infrastructure and that guarantees good performance.
Case Study
QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data
PT. Kapal Api Global, a manufacturer and distributor of Fast Moving Consumer Goods (FMCG), was facing performance issues when analyzing huge amounts of data (1.5 billion records, 200 million rows). There was a 2-3 week gap needed to prepare analysis, which was affecting decision making. The conventional reporting tools they were using were unable to cope with the huge data sets and frequent user changes to analytical requirements. The company has a distribution footprint that includes more than 500,000 stores nationwide, mostly consisting of small family-owned shops.
Case Study
Qualcomm speeds time to answers, optimizes core business operations, and puts users in control with QlikView
Qualcomm, a leading developer and innovator of advanced wireless technologies, products, and services, faced challenges in analyzing the usage of its major enterprise applications. The existing Business Intelligence (BI) tools required up to six months to build each new application, which was time-consuming and inefficient. The team needed a solution that was more rapid and analytically driven to analyze enterprise application usage throughout the company. The search for a solution led Qualcomm Senior Programmer Analyst Steve Rimar to discover QlikView online. He was intrigued by the appealing visual analysis and the ability to rapidly develop new applications.
Case Study
Radiometer relies on QlikView for data analysis
Radiometer, a pioneer and international market leader for blood gas analyzers, was facing increasing cost pressures and needed to optimize its corporate efficiency. The company was using a complex Excel solution with numerous macros for data evaluation. This procedure was not only error-prone and complex, but it was also difficult to use. In addition, the data volume became too large for such a solution to reliably and quickly handle the evaluations. The company considered adopting an OLAP-based business intelligence solution that was already in use at the parent company in Denmark. However, it quickly became clear that this system also could not satisfy the requirements of Radiometer in Germany.
Case Study
QlikView provides individually adapted analysis for Region Skåne across habilitation and assistive technology services
Region Skåne Habilitation and Assistive Technology Services, a group within healthcare organization Region Skåne, was facing several challenges. They needed to coordinate six different operational systems, improve the presentation of analysis in a visually engaging format, and reduce manual data collection and analysis. The services they provide are based on the principle that all people are equal regardless of age, gender, disability, and ethnic or religious background. They help treat people with permanent disabilities with exercise and assistive technology to enable participation in everyday life. The services are based on each patient’s expressed needs, which change in nature and extent throughout a person’s lifetime.
同类供应商.
Supplier
Microsoft Azure (Microsoft)
Microsoft Azure is a Cloud Computing platform and infrastructure created by Microsoft for building, deploying, and managing applications and services through a global network of Microsoft-managed data centers. It provides both PaaS and IaaS services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Azure was announced in October 2008 and released on 1 February 2010 as Windows Azure, before being renamed to Microsoft Azure on 25 March 2014.
Supplier
C3 IoT
C3 IoT provides a full-stack IoT development platform (PaaS) that enables the rapid design, development, and deployment of even the largest-scale big data / IoT applications that leverage telemetry, elastic Cloud Computing, analytics, and Machine Learning to apply the power of predictive analytics to any business value chain. C3 IoT also provides a family of turn-key SaaS IoT applications including Predictive Maintenance, fraud detection, sensor network health, supply chain optimization, investment planning, and customer engagement. Customers can use pre-built C3 IoT applications, adapt those applications using the platform’s toolset, or build custom applications using C3 IoT’s Platform as a Service.Year founded: 2009
Supplier
Tableau
Tableau is an excellent data visualization and business intelligence tool used for reporting and analyzing vast volumes of data. It is an American company that started in 2003—in June 2019, Salesforce acquired Tableau. It helps users create different charts, graphs, maps, dashboards, and stories for visualizing and analyzing data, to help in making business decisions.
_18.jpg)
Supplier
IBM Watson (IBM)
Watson is a question answering computer system capable of answering questions posed in natural language, developed in IBM's DeepQA project by a research team led by principal investigator David Ferrucci. Watson was named after IBM's first CEO and industrialist Thomas J. Watson. The computer system was specifically developed to answer questions on the quiz show Jeopardy!. In 2011, Watson competed on Jeopardy! against former winners Brad Rutter and Ken Jennings. Watson received the first place prize of $1 million. Watson had access to 200 million pages of structured and unstructured content consuming four terabytes of disk storage including the full text of Wikipedia, but was not connected to the Internet during the game. For each clue, Watson's three most probable responses were displayed on the television screen. Watson consistently outperformed its human opponents on the game's signaling device, but had trouble in a few categories, notably those having short clues containing only a few words. In February 2013, IBM announced that Watson software system's first commercial application would be for utilization management decisions in lung cancer treatment at Memorial Sloan Kettering Cancer Center in conjunction with health insurance company WellPoint. IBM Watson's former business chief Manoj Saxena says that 90% of nurses in the field who use Watson now follow its guidance.
Supplier
Alteryx
Alteryx, Inc. was formed in 2011 and is a leader in self-service Data Science and analytics. Alteryx provides analysts with the unique ability to easily prep, blend and analyze all of their data using a repeatable workflow, then deploy and share analytics at scale for deeper insights in hours, not weeks.Analysts love the Alteryx Analytics platform because they can connect to and cleanse data from data warehouses, cloud applications, spreadsheets and other sources, easily join this data together, then perform analytics – predictive, statistical and spatial – using the same intuitive user interface, without writing any code.
