KPI Partners Blog

Manual performance optimization in Denodo – Most relevant and most used techniques

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:46 AM

by Manju Das

Manual performance optimization in Denodo – Most relevant and most used techniques

We are going to discuss how to optimize the Denodo query to make the most of the optimization in the Denodo platform. Below are the most powerful query optimization techniques that we can apply in Denodo platform manually which will increase the performance significantly.

Read More

Tags: Blog, Manju Das, Denodo, Most relevant and most used techniques, Manual performance optimization in Denodo

BigQuery Best Practices to Optimize Cost and Performance

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:46 AM

by Pushkar Reddipalli

BigQuery Best Practices to Optimize Cost and Performance

BigQuery is Google's fully managed, petabyte scale, low cost analytics data warehouse. It allows you to execute terabyte-scale queries, get results in seconds, and gives you the benefits of being a fully managed solution. BigQuery and other Google Cloud Platform (GCP) services offer "pay per use" pricing. If you know how to write SQL Queries, you already know how to query it. In fact, there are plenty of interesting public data sets shared in BigQuery, ready to be queried by you.

In this blog post, I will guide you through best practices to implement Google BigQuery to control costs and optimize performance regardless of the level of development experience you have. To start working with BigQuery, you must first upload your data, which means that you will also use it as storage, then verify this data in some way to create your models or create reports. In the next section, we will analyze best practices for these main actions of loading, querying and storing.

Read More

Tags: Blog, Data Warehouse, BigQuery, BigQuery to optimize cost and performance, Pushkar Reddipalli, BigQuery Best Practices

Solving Data Lake Challenges with Databricks Delta Lake

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:46 AM

by Shiva Molabanti

Solving Data Lake Challenges with Databricks Delta Lake

What is Data Lake:

Data lake drive is what is available instead of what is required. The typical data lake is a storage repository that can store a large amount of structured, semi-structured, and unstructured data. It is a place to store every type of data in its native format with no fixed limits on account size or file. It offers high data quantity to increase analytical performance and native integration to implement Machine Learning and AI models to make profitable predictions. This enables the 360 degrees view of customers and makes the analysis more robust to offer a competitive advantage to the organization.

Read More

Tags: Shiva Molabanti, Blog, Databricks, Delta Lake, What is Databricks Delta Lake, Data lake challenges, Databricks Delta Lake, Data Lake Challenges with Databricks Delta Lake

Snowflake Secure Views vs. Views in Oracle

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:45 AM

by Balachandra Sridhara

Snowflake Secure Views vs. Views in Oracle

What is a view in a Database?

A view is the result set of a SQL query built on top of one or more tables. Views do not store the data; however, during run time view definition (SQL) will be executed, and the result will be shown to the user. Please find the Wikipedia link for more information View (SQL).

Read More

Tags: Blog, Balachandra Sridhara, Snowflake secure views vs views in Oracle, Snowflake secure views

Salesforce and Tableau: Integrating Tableau Dashboards

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:44 AM

by Ksheetij Dongre

Salesforce and Tableau: Integrating Tableau Dashboards within Salesforce.com framework

This article talks about the technical aspects that should be considered to integrate/embed Tableau Dashboards into the Salesforce portal.

Read More

Tags: Salesforce.com Analytics, Tableau, Blog, Salesforce, Integrating Tableau with Salesforce

Azure Analysis Services with Power BI - Best Practices

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:43 AM

by Chandra Matam

Azure Analysis Services with Power BI - Best Practices

Power BI Overview

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. Connect to a wide variety of data sources and bring your data to life with live dashboards and reports.

Read More

Tags: Blog, Power BI, Power BI Blog Series, Microsoft Azure, Azure Analysis Services

How does Synapse Analytics improve over Azure SQL DW Gen 2 and Gen 1

Posted by KPI Partners News Team on Mon, Aug 24, 2020 @ 07:42 AM

by Gaurav Gupta

How does Synapse Analytics improve over Azure SQL DW Gen 2 and Gen 1

Introduction

If you are not familiar with Synapse Analytics (formerly Microsoft Azure SQL Data Warehouse), it is known as a massively parallel processing system (MPP). MPP systems have been around for a long time, but traditionally they have been very expensive and large hardware investments. Some providers in this space include Teradata, Netezza, and Microsoft, with their analysis platform system offer. In this model, the data in the tables is distributed between the nodes and the results are joined in the main or control node. It is a model that is fully optimized for large-scale data loading, as well as for reports.

Read More

Tags: Blog, Data Warehouse, Gaurav Gupta, Azure SQL Data Warehouse Gen2, Gen2 Over Gen1, Azure SQL DW,  Analytics Platform System, Microsoft Azure partner, Synapse Analytics, Azure Synapse Analytics

Azure Power BI Automation - DataSets

Posted by KPI Partners News Team on Wed, Aug 12, 2020 @ 03:41 PM

by Madan Thota

Azure Power BI Automation - DataSets

This is the fifth post in KPI's Power BI blog series. In this blog, we provide a high-level overview of dataset refresh and other dataset operations from PowerShell. 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
  3. Security and Collaboration in Power BI
  4. What is PowerShell and Connect to Power BI Service

Read More

Tags: Madan Thota, Blog, Power BI, Power BI Blog Series, Azure Power BI Automation, 2 DataSets

Azure Power BI Automation - 1 Basics and Connect

Posted by KPI Partners News Team on Wed, Aug 12, 2020 @ 03:41 PM

by Madan Thota

Azure Power BI Automation - Basics and Connect

This is the forth post in KPI's Power BI blog series. In this blog, we provide a high-level overview of PowerShell and how to connect it to the Power BI service. You can read the other posts in the series here:

Read More

Tags: Madan Thota, Blog, Power BI, Power BI Blog Series, Azure Power BI Automation, Basics and Connect