Data Analysis Using Tableau with Project Based Learning

• Lesson 01: Course Introduction

  • 1.01 Course Introduction

  • 1.02 What you will Learn

• Lesson 02: Data Visualization

  • 2.01 Introduction

  • 2.02 Data Visualization

  • 2.03 Examples of Effective Visualizations

  • 2.04 Storytelling with Data

  • 2.05 Data Visualization Best Practices

• Lesson 03 : Importing Data from a File

• • Previewing and Modifying Data

  • Creating Data Union Aggregate Data

  • Introduction to Workspace

  • Green vs. Blue Pills in Data Pane

  • Working with Sheets in Tableau

  • Introduction

  • Basic Charts: Column Chart

  • Basic Charts: Line Chart

  • Basic Charts: Treemap

  • Basic Charts: Bubble Chart

  • Basic Charts: Stack Column Chart

  • Basic Charts: Maps

  • Basic Charts: Heatmap

  • Basic Charts: Pie Chart

  • Basic Charts: Hightlight Tables

We have developed an interactive dashboard Leveraging Tableau to analyse and compare the sales data of an retail giant. The goal is to support senior management in making informed decisions, enhancing strategic planning, and implementing sales improvement strategies, by visualizing the data on a dashboard and highlighting trends and areas for improvement..

A) Using the following Tableau Features

a) Creating Maps

b) Creating bar charts

c) Creating filters

d) Creating Tables

e) Utilizing Sets

f) Utilizing Parameters

g) Utilizing Dual Axis

h) Utilizing Level of Detail

i) Creating KPIs

j) Creating Interactive Dashboard

B) Creating the following analysis

This dashboard, provides a comprehensive overview of product performance at Walmart.

It includes several key sections:

• Customer, Product & Order Distribution:

• Product Ranking (2013 & 2015):

• Top Products by Sales & Company's Optimum:

• Product Classification by Sales Performance:

• Sales, Profit, Order Quantity & Shipping Cost Summary:

• Visualizing the data on a dashboard and highlighting trends and areas for improvement.

• Introduction to Analytics

• Different Types of Analytics Options in Tableau

• Clustering

• Trend Analysis

• Forecasting

Bookshop data analysis involves examining various aspects of a bookstore's operations and customer behaviour to identify trends, optimize performance, and improve decision-making. This can include analyzing sales data, customer demographics, inventory management, and marketing campaign effectiveness. Key areas of focus include understanding sales patterns, identifying popular genres and authors, optimizing pricing strategies, and improving customer experience.

As you all probably know doing analyses using mapping in Tableau is relatively simple. Lately, Tableau added some new functionalities called 'Spatial Functions' by which you can really improve your mapping analyses. And most importantly, they’re still easy to use!

A Zomato data dashboard provides restaurant owners, managers, and enthusiasts with valuable insights into various aspects of the restaurant industry,

A) Using the following Tableau Features

a) Creating Relationships

b) Creating Maps

c) Creating bar charts

d) Creating filters

e) Creating Tables

f) Creating KPIs

B) Creating the following analysis

g) including online delivery analysis,

h) table booking trends,

i) location-based performance,

j) restaurant type analysis, and more.

k) It helps users understand key performance indicators (KPIs) like average ratings, total reviews, popular cuisines, delivery times, and restaurant distributions.

l) The dashboard allows for data-driven decision-making through interactive visualizations and advanced filters.

We have developed an interactive dashboard to analyze the factors influencing movie success. Conducted descriptive statistical analysis of genres, language, duration, director, and budget, revealing the impact on scores. Provided valuable insights to producers, directors, and investors for decision-making in the film industry.

A) Using the following Tableau Features

a) Creating Maps

b) Creating bar charts

c) Creating filters

d) Creating Tables

e) Creating KPIs

f) Creating Interactive Dashboard

B) Creating the following analysis

The IMDB Top 1000 Movies dashboard report from 1920 to 2020 provides valuable insights into movie ratings, gross revenue, and audience engagement. By leveraging Tableau for data visualization, we will transform raw data into actionable insights that support strategic decision-making in the film industry. This analysis highlights the importance of genre popularity, director influence, and optimal movie runtimes in driving box office success. This portfolio review demonstrates our ability to clean, analyze, and visualize complex datasets, turning them into meaningful insights that support business strategies and decision-making processes in the entertainment industry.