KPI Partners Blog

How to Setup Oracle Analytics Cloud Service

Posted by KPI Partners News Team on Thu, Feb 15, 2018 @ 01:39 PM

by Dindima Mahesh Jami

This blog post is intended for those who are familiar with OBIEE or have previously worked on it. It contains step by step instructions on how to setup OACS using a trial account.

What is OACS?

Oracle Analytics Cloud Service (OACS) is a new Platform as a Service (PaaS) offering comprehensive analytics capabilities at any scale, in any environment, and on any device. This was first announced on Sep 30, 2014 at Oracle OpenWorld and was officially launched on Apr 4, 2017.

Read More

Tags: Blog, oacs, Oracle Analytics Cloud Service, Dindima Mahesh Jami

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