KPI Partners Blog

KPI Partners News Team

Recent Posts

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

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.

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

Security and Collaboration in Power BI

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
  3. What is PowerShell and Connect to Power BI Service
  4. Dataset refresh and other dataset operations from PowerShell

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

Dynamic Selection of Measures in Power BI

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
  2. Security and Collaboration in Power BI
  3. What is PowerShell and Connect to Power BI Service
  4. Dataset refresh and other dataset operations from PowerShell

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

Visual Interactivity in a Power BI Report

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. You can read the other posts in the series here:

  1. Dynamic Selection of Measures in Power BI
  2. Security and Collaboration in Power BI
  3. What is PowerShell and Connect to Power BI Service
  4. Dataset refresh and other dataset operations from PowerShell

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