Key Influences Visual: Expand By Fields

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

 

In the previous article, I have explained what is the key influencers visual and how it works. Later the count and impact have been explained in the other Post.

Initially, Key Influencers visual just has two data fields:

Analyze and Explained by

the Analyze fields, analyse the data based on row by row, so no aggregation on data. for instance, in the above example, for identifying what factors impact on the house sale price, we analyze it by house years build, overall quality of the house  and lot area of the house.

this visual will answer below question:

Which fields, LotArea, Overall Quality and Year Built, has more influence on House Sales Price?

That nicely shows the LotArea has more influence, now imagine we want to ask below question:

Which of these factors, LotArea, Overall Quality and Year Buil, has more influence on House Sales Price for the average sales price of House?

As you can see in the below picture, the result could not be shown up, because of below error message

” you need to have more fields for the Explain by field”

Solution

The question needs a grouping aggregation field. I change the question as below one:

Which of LotArea, Overall Quality and Year Built which one has more influence on Average of House Sales Price for each Neighbourhood?

to solve the problem and answer the question, I need the average of sales price aggregate by other fields. Hence, I will add the neighbourhood to Expand by data field.

 

if you compare the results in first visual, we analyse the wholesales price for all type of the house ( in house level analysis) and we find that the LotArea has more impact on the sale price

however for each neighbourhood, the story was a bit different, the average house of each neighbourhood has been impacted by Overall quality more

 

 

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube
Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Leave a Reply

Your email address will not be published. Required fields are marked *