KPI Partners Blog

Google Data Studio - Initial Impressions

Posted by KPI Partners News Team on Fri, Oct 06, 2017 @ 11:54 AM

by Rushendra Prasad

This blog post offers an insight into the features and functionalities of Google Data Studio and compares it with popular data analysis tools like Tableau, QlikView and new entrants like Power BI.

Disclaimer: This article and all features assessed are as on Sep, 2017 and subject to modifications / enhancements by Google.

Read More

Tags: OBIEE, Rushendra Prasad, Tableau, Blog, Power BI, Google Data Studio

Oracle BI Server Connectivity with Tableau (Part 2)

Posted by KPI Partners News Team on Thu, Jan 26, 2017 @ 11:27 AM

by Rushendra Prasad

To read part 1 of this blog post, please click here.

This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

This is applicable for 8.2, 8.3, 9.0 and later versions.

Read More

Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server

Oracle BI Server Connectivity with Tableau (Part 1)

Posted by KPI Partners News Team on Thu, Jan 19, 2017 @ 12:31 PM

by Rushendra Prasad

This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

This is applicable for 8.2, 8.3, 9.0 and later versions.

Read More

Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server

Informatica SAP Connector Explained

Posted by KPI Partners News Team on Thu, Oct 20, 2016 @ 12:10 PM

by Balaswamy Kaladi

This blog describes how to configure Informatica’s SAP NetWeaver R/3 to connect with SAP BW, extracting data directly from SAP transparent tables. It details setup steps on Informatica and BW servers, as well as what’s required from a developer’s perspective.

It’s also important to note that there are two ways to connect SAP BW from Informatica, i.e.

  1. Using Informatica’s SAP BW Connector – this extraction is driven by an Infospoke and extracts data via the Open Hub Services (OHS)
  2. Using Informatica’s SAP NetWeaver R/3 Connector – this allows data extraction directly from a SAP transparent table

This blog details the second method i.e. using Informatica's SAP NetWeaver R/3 Connector.

Read More

Tags: Informatica SAP Connector

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

Cassandra Installation, Configuration and Multi-Data Center Clustering

Posted by KPI Partners News Team on Wed, Sep 14, 2016 @ 11:39 AM

by Santoshkumar Lakkanagaon

What are the different types of Cassandra distributions available?

Read More

Tags: Blog, Cassandra, Cassandra Installation, Multi-Data Center, Cassandra Configuration

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

An Introduction to Apache Cassandra

Posted by KPI Partners News Team on Tue, Aug 23, 2016 @ 05:35 PM

by Santoshkumar Lakkanagaon

Modern Big Data requirements include:

  • Multi-region availability
  • Fast and reliable response
  • No single point of failure
  • Scalability

Traditional relational databases (RDBMS) are not enough to meet these requirements because the relational model provides normalized schema, table joins and ACID compliance which causes a massive overhead for big data. In order to support these features, we need high-end systems which are not cost effective. Additionally, such systems often require substantial downtime.

Read More

Tags: Blog, Cassandra

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

The Grammar of Business Intelligence

Posted by KPI Partners News Team on Wed, Jul 29, 2015 @ 03:30 PM

by Ron Cruz

Business Intelligence has changed. There are new disruptive technologies, the cloud, and a paradigm shift that is putting more power into the hands of users instead of IT. More competition has allowed companies that have never had a chance to get into business intelligence to enter into the world of BI. Competition has also lead to more functionality to make true the promise of Business Intelligence. 

Read More

Tags: KPI Cloud Analytics, Ron Cruz, Retail, Business Intelligence, Blog, data information, visualization, Data Architecture