KPI Partners Blog

Data Warehousing and Analytics Using Amazon Redshift

Posted by KPI Partners News Team on Fri, Oct 14, 2016 @ 01:33 PM

by Balaswamy Kaladi

In today’s world of big data, analytics, and data warehousing, data volumes continue to grow, seemingly only matched by businesses’ appetite to exploit data for commercial advantage, and do so ever more quickly.

Historically, to deal with the kind of large data volumes that are now becoming commonplace, expensive and heavyweight technologies from vendors such as Teradata, Netezza and Vertica were needed. These typically cost millions of dollars, and required hardware, software, and consulting.

Read More

Tags: Data Warehousing, Blog, AWS, Amazon Redshift

Evaluating the Cloud for Your Data Warehouse

Posted by KPI Partners News Team on Fri, Sep 02, 2016 @ 12:13 PM

by Ron Cruz

Thinking of moving to a cloud based data warehouse platform? Here’s what you need to evaluate and learn how to do it.

Read More

Tags: Data Warehousing, Cloud, Ron Cruz, Blog

What Is A Data Scientist?

Posted by KPI Partners News Team on Fri, Aug 07, 2015 @ 12:44 PM

by Jeremiah Johnson

Data scientists are master communicators.  They speak fluently with people in operations areas and those in information technology departments.  They understand technical jargon, business lingo and are information experts.  Unlike a jack-of-all-trades, who knows a lot but masters nothing, data scientists know plenty and often are experts in many fields.  Most importantly, they find solutions for business problems.

Read More

Tags: Data Warehousing, Database, Data Scientist, Big Data, Data Discovery, Business Intelligence, ETL, Jeremiah Johnson, Data Integration, Blog, Datastax

Code Migration In Cloud World

Posted by KPI Partners News Team on Tue, Feb 10, 2015 @ 09:56 AM

by Ksheetij Dongre

Migrating Code from Development to Production in the Cloud

The cost of cloud migration is not cheap but the promise is that the company will acheive a significant return on investment over the long haul.  The objective of this article is to help us understand how to setup Development and Production environments in the cloud, specifically regarding these components of a data warehouse (DW):

Read More

Tags: Data Warehousing, Cloud Services, SQL Server, Database, Ksheetij Dongre, Oracle, Informatica, Cloud Master Data Management, ETL, Blog

An Informatica Expert's Understanding of Oracle Data Integrator (ODI)

Posted by KPI Partners News Team on Tue, Nov 25, 2014 @ 10:42 AM

by Prashanth Gajjala

I started working with Oracle Data Integrator (ODI) a year ago while participating in a Oracle Business Intelligence Applications 11.1.1.7 implementation.   I have been working with Informatica as the extract-transform-load (ETL) tool of choice for a long time, which included Oracle Business Intelligence Applications and custom warehouse projects.

Read More

Tags: Data Warehousing, ODI, Prashanth Gajjala, ELT, Oracle, Informatica, ETL, Data Integration, Oracle Data Integrator (ODI), Blog

Ongoing Challenge: Data Integration In "The Cloud"

Posted by KPI Partners News Team on Wed, Nov 19, 2014 @ 10:49 AM

by Potnuru Hatakesh

Adoption of "The Cloud" is growing significantly as more a enterprises start to see and experiencing the value in agility, scalability, and cost savings.

Read More

Tags: Data Warehousing, Cloud Services, Potnuru Hatakesh, Informatica, Cloud Master Data Management, ETL, Data Integration, Cloud Application Integration, Blog

TDWI Conference Focuses On Data-Driven Decision Making

Posted by KPI Partners News Team on Fri, Sep 26, 2014 @ 11:44 AM

by Darren Chilton

Read More

Tags: Data Warehousing, TDWI, Big Data, Business Intelligence, Darren Chilton, Blog

Star Schema or No Star Schema? That is the (Tableau) Question.

Posted by KPI Partners News Team on Tue, Sep 23, 2014 @ 01:23 PM

by Avinash Mohan

Exploring the different ways Tableau connects to data and whether dimensional modeling is necessary when using Tableau’s architecture.

 

Architecture

Tableau has two primary ways to connect to data sources and work with them as shown in this simplified architecture diagram shown below .

Read More

Tags: Data Warehousing, Real-Time BI, Cache, Avinash Mohan, Data Discovery, Business Intelligence, Tableau, Data Integration, Book, Blog

Higher Education Analytics: Key Star Schemas for Institutional Research

Posted by KPI Partners News Team on Fri, Sep 12, 2014 @ 01:40 PM

by Parul Singh

The need for robust reporting and a structured enterprise data warehouse for educational institutions is becoming a necessity.  This type of modern architecture empowers academic institutions with best-in-class reporting and analytic capabilities to increase faculty, staff and student productivity; streamline operations and institutional advancement; and ensure student success.

There are a few key star schemas that can aid universities and their stakeholders to make informed decisions and deliver a better student experience:

Read More

Tags: Student Information Analytics, Campus Analytics, Data Warehousing, Higher Education BI, Business Intelligence, Education, Banner

Understanding The Informatica MD5 Function

Posted by KPI Partners News Team on Fri, Apr 25, 2014 @ 03:52 PM

by S. K. Purushotham

This article will help you understand the importance of the MD5 function in Informatica. It will also help you answer questions like:

Read More

Tags: Data Warehousing, Informatica, Tutorial, ETL, SK Purushotham, Data Integration, Blog