Power BI: Key Influencers

The Key Influencers visual in Power BI can help identify important factors in your data by analyzing the relationships between different variables and identifying which variables are most strongly associated with a particular outcome. This visual provides a way to understand the key drivers of a particular metric or outcome and can be used to support decision-making, such as identifying which marketing campaigns are most effective in driving sales.

Once the Key Influencers visual is generated, it will display a list of the most important variables that are influencing the target variable. The visual uses machine learning algorithms to analyze the data and identify the relationships between variables. The Key Influencers visually display the results as a list of cards, each representing an explanatory variable, with a score indicating the strength of the relationship. The visual also displays a chart that shows the relationship between the target variable and each explanatory variable.

By using the Key Influencers visual, you can identify which variables are most strongly associated with a particular outcome and use this information to make data-driven decisions.

Example: Let’s imagine we’re working with a dataset of an online retail company that wants to understand its customers better and identify the key factors influencing customer satisfaction. We’ll use the Key Influencers visual to analyze the data and unveil those factors.  

Here’s a step-by-step guide on how to use the Key Influencers feature in Power BI:

Step 1: Create a new Power BI report

Open Power BI Desktop and create a new report. You can do this by clicking on ‘File’ > ‘New’ or simply starting Power BI Desktop for the first time.

Step 2: Load your data

To load your dataset into Power BI, click on ‘Home’ > ‘Get Data’ > ‘Excel/CSV/Text file’ or select your preferred data source. Locate your dataset file and click ‘Open’. Once your data is loaded, it will appear in the ‘Fields’ pane on the right side of the screen. 

Step 3: Add the Key Influencer’s visual

In the ‘Visualizations’ pane, click on the Key Influencers icon (it looks like a small person next to a bar chart) to add a new Key Influencers visual to your report canvas. You can also use the search bar to find the visual by typing ‘Key Influencers.’

Step 4: Configure the visual

Now, let’s configure the Key Influencers visual to analyze customer satisfaction. First, drag the ‘Customer Satisfaction’ field from your dataset into the ‘Analyze’ section. Let’s say we have a column in our dataset called ‘Customer Satisfaction’ with values ranging from 1 (low satisfaction) to 5 (high satisfaction). 

Next, drag the fields you want to explore as potential influencers into the ‘Explain by’ section. For example, we might want to see how factors like ‘Product Category,’ ‘Delivery Time,’ ‘Discount,’ and ‘Customer Age’ influence satisfaction.

Step 5: Interpret the results

The Key Influencers visual will display the top factors influencing customer satisfaction in your data, along with a ranked list of associated values or categories.

For instance, it might show that customer satisfaction is highly driven by ‘Delivery Time’ and ‘Product Category.’ To dive deeper, it might reveal that faster delivery times (e.g., 1-2 days) lead to higher satisfaction scores.

Further down the visual, you’ll also see the ‘Top Segments’ section, which can help you better understand the characteristics of the dataset. For example, it might show that a significant portion of your customers are aged 25-35 and prefer ‘Electronics’ products.

Step 6: Customize and explore 

You can customize the Key Influencers visual by clicking on the paintbrush icon and adjusting styles, colors, and other formatting options. Feel free to continue exploring the data by adding or removing fields in the ‘Explain by’ section or using filters to refine your analysis.

Related Tags: