Grow Data Skills

Tableau Projects For Data Analyst (Live Batch)

LanguageEnglish
Sessions 14
Duration 1.5 Months
Starts On In Progress
Validity 1 Year
Mode Live

Demo Class Video

INR 2200

Admission Open

Buy Now

This course includes

25+ hours content live lecture
45 minute doubt session after each class
5 Industry level real world projects
Tableau Certification Preparation Session
Learn while solving real life examples in live lectures
Projects will be covered from scratch
Hands on exercises & quizzes for certification preparation
Career & Interview Preparation guidance session
Resume Preparation session
Linkedin Profile Making
Certificate of completion

Tech stack you'll learn

Course Content

Tableau Introduction: Tableau Products, Their Website & Its Versions
Tableau Starter: Installation Guide, Interface walkthrough & Navigation
Tableau Help & Resources

Problem Overview
Connecting to Data Sources (Snowflake & CSVs)
Performing Exploratory Data Analysis (EDA)
- Data Cleaning: Identify and handle missing values, duplicates, and outliers.
- Descriptive Statistics: Summarize data with measures like mean, median, standard deviation, and variance.
- Trend Analysis: Identify and analyze trends over time using line charts and area charts.
Transforming data to create KPIs using Tableau Calculations
Creating dashboard using various charts, such as
- Bar charts
- Line charts
- Map charts
- Heatmaps
- Pie Charts & More
Adding Interactivity
- Filters
- Parameters
Deploying the dashboard
- Deploying to Tableau Public
- Deploying to Tableau Server

Problem Overview
Connecting to Data Sources
- Importing data from Snowflake
- Modeling the star schema
PCreating KPIs
- Average Order Value (AOV)
- Growth Rate
- Conversion Rate
- Customer Lifetime Value (CLV)
Dashboard Development
- Creating E-commerce Dashboard using various charts
  - KPIs
  - Circle Views
  - Side by Side Charts
  - Tables
  - Histograms
  - Scatterplots
- Analyzing dashboard to understand purchase patterns, Customer demographics etc
- Customer segments
Deploying the dashboard

Problem Overview
Data Connections & Modelling
- Importing inventory and supplier data from JSON files, csvs
- Setting up data connections in Tableau
- Performing Joins & Unions
Data Transformations
- Creating KPIs (Order Fulfillment Time, Stock turnover rates, Supplier performance KPIs etc)
- Finding Trends using LODs & Window functions
Wireframing of dashboard
Creating Dashboards
- Creating Supply Chain & Logistics Management
- Creating dynamic Control charts to help planner manage supply & demand
Deploying The Dashboard
- Deploying to Tableau Public
- Deploying to Tableau Server

Problem Overview
Connecting & Joining Data Sources
- Importing the data from MySQL and modeling financial and budget data in Tableau
Performing EDA on Dataset
- Univariate Analysis
- Bivariant Analysis
Data Transformations
- Calculating relevant KPIs
  - Guest Satisfaction Score
  - Net Promoter Score
  - Customer Retention Rate
  - Guest Complaints
  - Average Length of Stay
- Forecasting revenue and expenses
Wireframing of Dashboard
Dashboarding
- Creating Hotel & Hospitality Analysis Dashboard
- Using ML functions in Tableau to predict the business
Complex Interactivity & functionality
- Implementing user actions
- Dynamic chart selection
- Creating advanced charts & stories
  - Interactive Tables
  - Image Maps
  - Applying color theory to the dashboard
  - Guest Complaints
  - Average Length of Stay
- Using custom themes, shapes & extensions
Setting up Incremental Refreshes
Deploying the dashboard
- Deploying to Tableau Public
- Deploying to Tableau Server
- Embedding the dashboard in custom website

Problem Overview
Data Source Connections
- Importing data from PDFs, Google Drive & Snowflake
- Setting up data connections in Tableau
- Joining Multiple Data Sources
Exploratory Data Analysis (EDA)
- Data Cleaning: Handle missing values, duplicates, and outliers.
- Descriptive Statistics: Summarize data with measures like mean, median, standard deviation, and variance, along with Univariant & Multivariant Analysis
Data Transformations
- Creating KPIs
  - Active Users
  - New Users
  - Customer Retention Rate
  - Customer engagement and conversion rates
  - Customer Satisfaction Score & more
Creating Dashboards
- Creating Food Delivery Platform Dashboard
- Adding custom charts & extensions
  - Donut Charts
Adding Interactivity in the dashboard
- URL Actions
- Parameter Actions
Dashboard Deployment
- Deploying to Tableau Public
- Deploying to Tableau Server
- Setting Alerts

Understanding Tableau Certification Exams ( Tableau Desktop Specialist vs Tableau Data Analyst)
Exam structures, Rules and formats
Passing scores and grading criteria
FAQs about Certification Exams
Perks of being Tableau Certified
Scheduling the exam

Practice Real Questions for Tableau Desktop Specialist Certification exam
- Multiple-choice questions
- Multiple Response Questions
- True/False Questions

Practice Real Questions for Tableau Certified Data Analyst exam
- Multiple Choice
- Multiple Response
- True/False Questions
- Hands-On Tasks & Labs

Attention Seeking Resume Preparation and Interview Strategies
Strategies To Crack Tech Interviews
Linkedin Profile Making
How To Expand Your Professional Network On Linkedin
How To Use Various Job Portals
How To Approach For Referrals

Course Schedule

Started On:

Live

24-Aug-2024

Course Duration:

1.5 Months

Class Timings:

Saturday & Sunday [2:00 PM - 4:00 PM Live Teaching, 4:00 PM to 4:45 PM Live Doubt Session] (IST)

Class Duration:

2 Hours Live Teaching, 45 minutes Doubt Solving

Class Recording Provided:

Yes

Course Validity:

1 year

Prerequisite:

Tableau - Check Our Tableau Course

⚠️ Important Notice :

The video may not work on Linux due to DRM restrictions. It is only accessible on Chrome when using Windows or macOS.

Workaround: To access the video on Linux, you can create a Windows virtual machine (VM) and watch the video through the VM. Alternatively, you can use our Android or iOS application to view the video on your mobile device.

Instructor

Sahil Choudhary

Sahil is a Google Certified Data Analyst and a Senior Data Analyst with Tableau expertise at Sigmoid Analytics. He worked with startups and Fortune 500 companies, helping them make data-driven decisions. He mentored over 500+ students in analytics and developed multiple third-party products and web apps for Tableau.