• Home
  • Services
    • Corporate End Customer Services
      • Our Capabilities
      • Business Analytics
        • Business Intelligence
        • Predictive Analytics
        • Mobile Analytics
      • Performance Management
      • Data Warehousing
      • Big Data Analytics
      • Cloud Computing
    • Channel as a Service Partner
      • Fast Tracking Success
      • VAR Success Story
  • News
  • Company
    • Partnerships
    • Our Mission
    • Value Add
    • Business Model
    • Why Choose Us
    • Careers
  • Contact Us

Cognos Data Warehouse Solutions

KCM SolutionsCase StudyMarch 10, 2014

Data Warehouse and IBM Cognos 8 Implementation – Health Care

Cognos Data Warehouse

Business Challenge

A leading Health Care company engaged KCM Solutions to build a data warehouse that delivered fast and adequate reporting.

  • Previously used MicroStrategy, which did not provide real time updates and required a customer web interface
  • Limitations in the web interface meant only one report could be run at a time for the batch process update
  • Highly inefficient batch process took 6 hours to run
  • Usability was low and maintenance and support costs for this application was high

KCM’s Solution

  • Immediately designed the data warehouse, leveraging Informatica as the ETL tool to extract data from the different transactional sources and separate them into different Subject Area Marts
  • Added extra columns to the data warehouse that were not available previously to provide more insight into the business.
  • Replaced MicroStrategy with IBM Cognos 8 as the Business Intelligence Tool for the client after running a cost-requirement analysis
  • Reduced the number of reports from 300 to 50 while increasing functionality and simplicity of use, by leveraging IBM Cognos 8’s advanced functionality such as conditional blocks, conditional formatting and parameter maps
  • Report run time was reduced from 6 hours in MicroStrategy to 5 minutes using IBM Cognos 8 , which is also connected to real-time data and refreshes each time the report is run

Benefits

  • Enhanced and all inclusive solution that offered more features, reduced support and decreased maintenance costs
  • Overall number of reports was reduced by 80%
  • Performance time enhanced 60-fold
  • Standard and easy to use web interface

 

Learn How To Move To The Cloud Risk Free.

Save on software licenses, infrastructure, operating costs and more. Find out how your business can move to the cloud risk free.

Download "How To Cut The Risk Of Moving To The Cloud" for FREE!
Tags: Cognos Enterprise, Data Warehouse, ETL, OLAP, Self-service reporting

Our Services

  • Corporate End Customer Services
  • Channel as a Service Partner

Our Expertise

  • Sales
  • Marketing
  • Finance – Financial Analytics
  • Operations – Supply Chain Management

Recent Posts

  • The Top 5 Ways Traditional IT Is Slowing You Down
  • SPSS
  • IBM Cognos TM1
  • IBM Cognos 10
  • Cognos Data Warehouse Solutions

Why KCM Solutions?

Our team of expert consultants can help turn Sales, Marketing, and Finance related data into focused insightful and actionable information that can lead to better decisions, performance and outcomes.

By focusing on the Key Performance Indicators (KPI) that matter most, organizations become better aligned, aware, agile and take a proactive approach to decision making. KCM has worked with many leading companies to increase sales, marketing, and financial effectiveness across the organization.

Recent News

  • The Top 5 Ways Traditional IT Is Slowing You Down
  • SPSS
  • IBM Cognos TM1
  • IBM Cognos 10
  • Cognos Data Warehouse Solutions

Get An Advantage

To stay up-to-date on new technologies, ways to save on license agreements, promotions, industry events and more, please fill out the form below.

Contact Us

KCM Solutions Inc.
1 Yonge Street, Suite 1801
Toronto, Ontario M5E 1W7
CANADA: (647) 361-1501
US: (661) 615-2122
info@kcm-solutions.com
Facebook
Twitter
Google+
LinkedIn
YouTube
IBM Cloud Computing Business Partners
HomeChannel as a Service PartnerCorporate CustomerContact UsPrivacy StatementTerms of UseSitemap
© 2019 All rights reserved. KCM Solutions
Website by Collabo