Data Analysis For Market Research With Excel & Tableau

Conduct market segmentation analysis, market trend analysis, and competitor pricing analysis with Excel and Tableau

What you'll learn

Learn basic fundamentals of market research, such as getting to know its use cases and the difference between quantitative and qualitative market research

Learn how to conduct market research for cosmetic product in Excel

Learn how to visualize data using bar chart, pie chart, scatter plot in Excel

Learn how to conduct market research for restaurant using Tableau

Learn how to segment customer data by demographics, such as gender and skin type

Learn how to conduct price range analysis

Learn how to analyze market share

Learn how to find correlation between price and product rating

Learn how to segment market by product ingredients

Learn how to analyze customer preferences regarding product size and packaging type

Learn how to analyze competitors pricing strategies based on restaurant type

Learn how to conduct price positioning analysis based on cuisine type

Learn how to conduct location based pricing analysis

Learn how to analyze the relationship between restaurant facility and pricing

Learn how to analyze the relationship between food prices and ratings

Learn how to clean dataset by removing missing values and duplicates

Learn how to analyze and visualize market research data using Julius AI

Requirements

No previous experience in market research is required

Basic knowledge in statistics

Description

Welcome to Data Analysis for Market Research with Excel & Tableau course. This is a comprehensive project based course where you will learn how to analyze market trends, segment customer data, evaluate competitor strategies, and visualize data using Microsoft Excel and Tableau. This course is a perfect combination between statistics and business intelligence, making it an ideal opportunity to practice your analytical skills while improving your technical knowledge in market research methodologies. In the introduction session, you will learn the basic fundamentals of market research, such as getting to know its use cases, step by step process, and also learn the difference between quantitative and qualitative market research. Then, in the next section, we will find and download market research dataset from Kaggle, it is a platform that provides a wide range of datasets from various industries. Afterward, we will set up browser based Microsoft Excel, enabling us to have the necessary tools to perform data analysis and visualization effectively. We will go through the basic functionalities like sorting, filtering, conditional formatting, and pivot tables to organize and summarize data efficiently. Following that, we will clean the market research data, specifically we will remove missing values and duplicates, making sure the dataset is accurate and ready for analysis. Then, after that, we will conduct exploratory data analysis to identify patterns, trends, and key insights within the dataset. This will help us better understand the structure of the data and gain a clear overview of its composition and relationships between variables. Then, in the next section, we will conduct extensive market research for cosmetic products using Microsoft Excel. In the first section, we will segment customer data by skin type. This will enable us to identify which skin concerns are most addressed by brands and optimize product offerings based on demand. Next, we will analyze the price range by category. This will allow us to assess pricing strategies, identify affordability trends, and find gaps in premium or budget-friendly markets. Following that, we will analyze market share. This will enable us to determine industry leaders, track emerging competitors, and uncover opportunities for new product launches. Then, in the next section, we will find the correlation between price and customer reviews. This will enable us to assess whether higher-priced products receive better ratings and guide pricing and marketing decisions. Next, we will analyze ingredient-based segmentation. This will assist us to identify trending ingredients, consumer preferences, and how brands differentiate their formulations. In the next section, we will then segment products by gender. This will enable us to understand market demand for male and females. After that, we will conduct a product size preference analysis. This helps determine which product sizes are most favored by consumers, allowing brands to optimize packaging and distribution strategies. In the last section, we will also segment products by packaging type. This will enable us to identify packaging trends, sustainability preferences, and functional design choices that influence purchases. Then, in the next section, we will conduct market research for restaurants using Tableau. In the first section, we will analyze restaurant type pricing strategies to understand how different restaurant types position their prices. Next, we will examine cuisine type and price positioning to identify which cuisines are premium or budget-friendly. Following that, we will conduct a location-based competitor pricing analysis to compare restaurant prices across different areas. Then, we will assess the impact of online ordering on ratings and pricing to determine if it influences customer perception and pricing strategies. In addition, we will find correlation between price and rating to see if higher-rated restaurants tend to have higher prices. Lastly, at the end of the course, we will also learn to analyze data using AI, where you can input any data and let AI automatically extract valuable insights from the data.First of all, before getting into the course, we need to ask ourselves these questions: why should we learn about market research? Well, here is my answer, market research helps businesses understand customer preferences, optimize pricing strategies, and stay ahead of competitors. By analyzing trends and consumer behavior, companies can make data driven decisions, reduce risks, and maximize profitability.Below are things that you can expect to learn from this course:Learn basic fundamentals of market research, such as getting to know its use cases, the difference between quantitative and qualitative research, and understand market research step by step processLearn how to clean dataset by removing missing values and duplicatesLearn how to conduct market research for cosmetic product in ExcelLearn how to visualize data using bar chart, pie chart, scatter plot in ExcelLearn how to segment customer data by demographics, such as gender and skin typeLearn how to conduct price range analysisLearn how to analyze market shareLearn how to find correlation between price and product ratingLearn how to segment market by product ingredientsLearn how to analyze customer preferences regarding product size and packaging typeLearn how to conduct market research for restaurant using TableauLearn how to analyze competitors pricing strategies based on restaurant typeLearn how to conduct price positioning analysis based on cuisines typeLearn how to conduct location based pricing analysisLearn how to analyze the relationship between restaurant facility and pricingLearn how to analyze the relationship between food prices and ratingsLearn how to analyze and visualize market research data using Julius AI

Overview

Section 1: Introduction to the Course

Lecture 1 Introduction

Lecture 2 Table of Contents

Lecture 3 Whom This Course is Intended for?

Section 2: Tools & Resources

Lecture 4 Tools & Resources

Section 3: Introduction to Market Research

Lecture 5 Introduction to Market Research

Section 4: Finding & Downloading Market Research Datasets From Kaggle

Lecture 6 Finding & Downloading Market Research Datasets From Kaggle

Section 5: Cleaning Dataset by Removing Missing Values & Duplicates

Lecture 7 Cleaning Dataset by Removing Missing Values & Duplicates

Section 6: Segmenting Customer Data by Gender & Skin Type

Lecture 8 Segmenting Customer Data by Gender & Skin Type

Section 7: Conducting Price Range Analysis

Lecture 9 Conducting Price Range Analysis

Section 8: Calculating Market Share for Each Brand

Lecture 10 Calculating Market Share for Each Brand

Section 9: Finding Correlation Between Product Price & Rating

Lecture 11 Finding Correlation Between Product Price & Rating

Section 10: Segmenting Market by Product Ingredients

Lecture 12 Segmenting Market by Product Ingredients

Section 11: Analyzing Customer Preferences Regarding Product Size

Lecture 13 Analyzing Customer Preferences Regarding Product Size

Section 12: Analyzing Customer Preferences Regarding Packaging Type

Lecture 14 Analyzing Customer Preferences Regarding Packaging Type

Section 13: Analyzing Competitor Pricing Strategies Based on Restaurant Type

Lecture 15 Analyzing Competitor Pricing Strategies Based on Restaurant Type

Section 14: Conducting Price Positioning Analysis Based on Cuisines Type

Lecture 16 Conducting Price Positioning Analysis Based on Cuisines Type

Section 15: Conducting Location Based Pricing Analysis

Lecture 17 Conducting Location Based Pricing Analysis

Section 16: Analyzing Relationship Between Restaurant Facility & Pricing

Lecture 18 Analyzing Relationship Between Restaurant Facility & Pricing

Section 17: Analyzing Relationship Between Food Price & Rating

Lecture 19 Analyzing Relationship Between Food Price & Rating

Section 18: Analyzing & Visualizing Market Research Data with Julius AI

Lecture 20 Analyzing & Visualizing Market Research Data with Julius AI

Section 19: Conclusion & Summary

Lecture 21 Conclusion & Summary

Data analysts who are interested in analyzing and visualizing market research data using Microsoft Excel and Tableau,Business consultants who are interested in transforming market research data into valuable business insights