Survey Data Analysis using Power BI

Sekinat Oyero — Sat, 29 Jul 2023 12:40:26 +0000

Introduction
Recently, I analysed survey data from the research conducted to study the impact of fitness wearables on consumer behaviour, which can be found on Kaggle. The dataset was collected for beginners to perform exploratory data analysis. However, I used this data to practice data modelling, exploratory data analysis, and report/dashboard generation in Power BI.

The Dataset
The dataset consists of 30 responses from 30 respondents and 21 questions that were asked along with the timestamp. This data is tidy, i.e., it is complete with no missing values, every row corresponds to an observation, each column corresponds to a feature in each response, and each cell contains only a value.

Business Task
The three key business questions I identified from this data are

Who are those using the fitness wearables, i.e. consumer demographic?
What is the trend in the use of fitness wearables?
What is the behavioural impact of fitness wearables on consumers?

Due to the nature of the datasets, because it has too many columns with the same answer choice, it is crucial to organise and structure data in a way that makes it easier to understand and analyse.

Data Analysis
The analysis procedures meted on this dataset are data cleaning, modelling and data visualisation. The data cleaning process involved removing the timestamp column, adding a responseID column and renaming some columns.

Data Modelling.
After carefully observing the dataset to model the data so that its analysis will answer those business questions listed better, I realised that some survey questions relate to the impact of fitness wearables on consumers. These impacts are listed below;

Helped them connect to the fitness community
Helped achieve their fitness goal
Impacted their overall health
Improved overall well-being
Improved sleep patterns
Made exercising more enjoyable
Stay motivated to exercise

I grouped all questions related to these and the responseID column (to link the table to other tables in the data model) in a table called impact and unpivoted them, with their answers ranging from strongly disagree to strongly agree

The other group of questions relates to the influence that fitness wearables have had on consumer behaviour, and they are;

To change diet
To exercise more
To join a gym or fitness class
To purchase other fitness-related products

Questions related to these and the ResponseID column were grouped and unpivoted in another table called influence.
Other questions related to the consumers' demographics and the trend of fitness wearables use were left in the survey table. Custom sort tables for impact and influence tables were created to sort the tables from Strongly Disagree being the least to Strongly agree being the highest ranking.
The final data model is shown below.

Data Visualisation

The overview of the visualisations is shown in the Power BI dashboard below. All of the features are categorical columns; as such, donut chart, column and stacked bar chart were used.

In the visual, we could see that the gender of respondents is almost evenly distributed and about 75% are age 34 and below. Only about 10% of the respondents rarely use fitness wearables. 80% of the respondents reported that fitness wearable has positively impacted their fitness routine.

All respondents agree that fitness wearable has influenced them to change their diet, exercise more and join a gym or fitness class. At the same time, only about 2% disagree that it has influenced them to purchase other fitness-related products.

A more significant percentage of the respondents agreed that it has strongly helped them connect to the fitness community, helped them achieve their fitness goal, impacted their overall health, improved overall well-being, improved sleep patterns, made exercising more enjoyable and stayed motivated to exercise.

Conclusion
Despite the small nature of the dataset, significant insights can be made. My data modelling approach gave me a better understanding of how insights can be made from a dataset. However, for a more robust analysis, more data is required.

Link to full Power Bi report (pdf version) here

Thanks for reading. Please share your thoughts in the comment section below.

WeRateDogs Data Viz

Sekinat Oyero — Tue, 11 Jul 2023 17:32:38 +0000

WeRateDog is a Twitter account that rates people's dogs with a humorous comment about the dog. These ratings are carried out in a unique way- The denominator is 10 while the numerator is greater than 10 e.g. 17/10. WeRateDogs started in 2015 and became popular after then. Currently, It has over 4 million followers and has received international media coverage. The data for this account has been gathered, assessed and cleaned. This post aims to draw out some insight from the cleaned datasets. We want to answer the following questions:

Which is the most popular dog breed?
Which Breeds have the highest ratings
Which Dog Stage is more liked?
Does the rating of breeds and dog stages correlate well with the popularity of breeds?
Does the rating of breeds and dog stages correlate well with favorite and retweet count?

I have analysed and visualised the WeRateDogs Twitter data using Python to answer these questions.

Dog Breeds Popularity

From the counts of all breeds arranged in decreasing order, the twenty most popular dogs are shown in the image below.

Golden Retriever is the most popular dog here

Most Enamoured Dog Breed

The average number of likes that each dog breed has accrued over the three years is also displayed below. This bar plot shows that Bedlington_terrier is the most liked dog breed; even though golden retriever is the most popular. It barely made the 20th position on the list.

Most Rated dog Breed by WeRateDog

Rating average of each dog breed over the three years shows that the most rated breed is Bouvier_des_Flandres with a rating of 13/10. However, mean is not a good representation of this. The population that receives this rating is also a determinant. The ratio of mean rating over population shows the distribution and the one with the highest rating distributed across the population is golden_retriever with a rating of 11.56/10. This is followed by Labrador_retriever and Chihuahua as shown below.

Most Rated Dog Stage For Being a Good Dog

Between the two popular dog stage, Pupper and doggo, doggo has the highest mean rating in 2016 and in 2017 they have almost equal mean rating.

In the course of the three years, Doggo is the only dog stage consistently rated high in 2016 and 2017. Data for 2015 is not available probably because the idea of the WeRate Dog just started evolving.

As shown in the image below, In 2016, Doggo has the highest mean likes while in 2017, Pupper had the highest mean likes. Overall, Doggo is well-favourited.