KPI Partners Blog

Migrating To AWS Aurora? Things to Consider!

Posted by KPI Partners News Team on Wed, Apr 17, 2019 @ 12:45 PM

by Mohit Mathur

Not 100% convinced of migrating to AWS Aurora? – READ ME 

According to latest reports released in February 2019 by leading market research companies, 94% of respondents now leverage cloud technologies. Public cloud adoption is at 91 percent and private cloud adoption is at 72 percent, according to Right scale – A Cloud Management Company.

According to the survey done by Gartner in last quarter of 2018:

  • Organizations of all sizes are moving to cloud solutions, such as core financial applications, for transactional systems of record.
  • Cloud momentum is consistently higher across financial business applications year over year.
  • Business analytics and enterprise business applications continue as top investment initiatives for senior financial executives.
Read More

Tags: Migrations, Blog, AWS, Amazon Aurora, Mohit Mathur, Migrating To AWS Aurora

Advantages of using Redshift Spectrum

Posted by KPI Partners News Team on Mon, Apr 08, 2019 @ 09:42 AM

by Sristi Raj

With the advent of cloud data warehouse and analytics tools, concepts like data lake, in-place querying, schema on read and data mashup have become a critical and integral part of an organization’s analytics capabilities. Consequently, new tools and features like AWS Redshift spectrum, Athena, Presto, Hive etc. are now playing a game changing role for data analysts to explore and mine data and get value out of existing data assets lying unused within the organization. Although, with so many options to choose from, it becomes utterly necessary to understand the subtle differences between each of them and advantages of each, to select the right tool of choice for a particular use case. With this blog, we will explore some capabilities of Redshift spectrum and advantages of using it in some of the use cases, while keeping the comparison and differences between different tool of choice to a separate blog post.

What is AWS Redshift Spectrum?

As per Amazon “AWS Redshift spectrum is a capability or a service which can be enabled with AWS Redshift that enables you to run SQL queries directly against all your data, out to exabytes, in Amazon S3 and for which you simply pay for the number of bytes scanned.

With Amazon Redshift Spectrum, you now have a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. You can further improve query performance by reducing the data scanned. You do this by partitioning and compressing data and by using a columnar format for storage.”

Pretty clear from the above that Redshift spectrum is a service that can be enabled with AWS Redshift database to query on the data stored in AWS S3 buckets as files. This would sound similar to external tables in Oracle or SQL server database, but with a lot more flexibility and features which I would discuss later in the post.

 

Read More

Tags: Blog, Sristi Raj, Advantages of using Redshift Spectrum, AWS Redshift

Security and Collaboration in Power BI

Posted by KPI Partners News Team on Wed, Aug 29, 2018 @ 02:11 PM

by Ranjeet Mandal

This is the third post in KPI's Power BI blog series. In this blog, we will cover security and collaboration in Power BI. You can read the other posts in the series here:

  1. Visual Interactivity in a Power BI Report
  2. Dynamic Selection of Measures in Power BI

Data Security

Row level data security in Power BI can be implemented by creating multiple roles and rules within Power BI desktop. Users need to be assigned to different roles in Power BI Service.

Read More

Tags: Blog, Power BI, Power BI Blog Series, Ranjeet Mandal, Security and Collaboration

Dynamic Selection of Measures in Power BI

Posted by KPI Partners News Team on Fri, Aug 24, 2018 @ 02:48 PM

by Ranjeet Mandal

This is the second post in KPI's Power BI blog series. In this blog, we will discuss the dynamic selection of measures in Power BIYou can read the other posts in the series here:

  1. Visual Interactivity in a Power BI Report

Have you ever needed to use slicers in Power BI to choose a measure to be displayed in your charts? We know that the default functionality of Power BI slicers is to allow us to choose from the available dimension or measure values. But what about the ability to choose which measure to be displayed?

Read More

Tags: Blog, Power BI, Power BI Blog Series, Ranjeet Mandal, Dynamic Selection

Visual Interactivity in a Power BI Report

Posted by KPI Partners News Team on Fri, Aug 17, 2018 @ 01:24 PM

by Ranjeet Mandal

This is the first post in KPI's Power BI blog series. In this blog, we provide a high-level overview on visual interactivity in a Power BI report.

Power BI visuals in a report page are interactive among each other, by default. An item selection in a visual impacts the rest of the visuals by highlighting the related items. However, do we get the required clarity in visualization? What if we need to display Totals, which should not be impacted by selection in any other visual?

Read More

Tags: Blog, Data Visualization, Power BI, Power BI Blog Series, Ranjeet Mandal

Traditional vs. Agile Software Development Methodologies

Posted by KPI Partners News Team on Fri, Jun 22, 2018 @ 06:13 PM

by Indusree Mavuru

Most companies today focus on delivering quality and gaining customer satisfaction and in order to accomplish this, the challenge lies in choosing between traditional development methodologies and agile development methodologies.

Read More

Tags: Blog, agile software development methodology, traditional vs agile, traditional software development methodology

Integration of OBIEE with an External Web Application - SAML SSO

Posted by KPI Partners News Team on Wed, Jun 13, 2018 @ 11:25 AM

by Siva Kumar Mopuri

Security Implementation Benefits

This solution is beneficial in OLTP applications like Oracle EBS that are integrated with OBIEE. In such scenarios, all the responsibilities/groups from OLTP source would be forwarded to OBIEE. Instead of having all the responsibilities in OBIEE, the user has the privilege to select the required responsibilities at runtime and those would be passed to OBIEE.

Note: This blog post considers Oracle EBS as an OLTP source which is integrated with OBIEE.

Read More

Tags: OBIEE, Blog, SSO

How to Setup Dependencies between Load Plans in Oracle Data Integrator

Posted by KPI Partners News Team on Mon, Jun 11, 2018 @ 11:53 AM

by Chaithanya Kumar Taduvai

ODI developers usually deal with load plans and mismanaged dependencies between multiple-load plans are typically a cause of data corruption in the system. An ideal Informatica warehouse implementation has multiple execution processes dependent on other execution processes which run automatically without any manual intervention. Here is how we can overcome this issue using the load plan dependency feature of ODI.

Read More

Tags: ODI, Oracle Data Integrator (ODI), Blog, ODI Load Plans

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