Tableau Certification Exam Prep | Relational Database Design

2 courses in 1 - Prepare for the Tableau Data Analyst or Data Specialist Exam and Understand Relational Databases

What you'll learn

Download Tableau and learn each topic required for the Data Analyst and Specialist Certifications with hands on and real guided examples

Visualize data on different types of charts such as line, stacked bar, maps and dual axies charts.

Use the analytics pane to do statistical analysis and summarize and model data effectively.

Master the creation of interactive dashboards and stories for effective data communication.

Requirements

You need a computer or laptop with internet access and the ability to download software.

An understanding of data and basic math such as average and median is helpful but not essential.

Description

If you're interested in taking the Tableau Data Analyst or Data Specialist exam then you're in the right place! This comprehensive Udemy course is designed to cover all the topics you need to ace the Tableau Data Analyst and Data Specialist certification exams, while also offering hands-on projects to enhance your practical skills.Key Highlights:From the basics of Tableau to advanced data visualization techniques, you'll master everything required for certification.The learning journey continues with an exciting guided project. You'll design and build your own Tableau dashboard, gaining hands-on experience in creating visualizations and interactive dashboards. This practical project allows you to apply what you've learned and build a portfolio-ready piece of work.What You'll Learn:Introduction to Tableau and data visualizationData preparation and cleaningAdvanced data visualization and dashboard designRelational database concepts and normalization techniquesCreating ER diagrams for database designBuilding your own Tableau dashboardWho Should Enroll:Aspiring Tableau Data Analysts and Data SpecialistsData professionals looking to enhance their Tableau skillsAnyone interested in creating impactful data visualizationsWhy Choose This Course:This course offers a balanced blend of theoretical knowledge and hands-on practice. You'll gain the confidence to tackle certification exams, while also acquiring the skills to work with real-world data scenarios. There is also a Relational Database Project where you'll delve into the practical world of relational databases. This course will guide you through applying normalization techniques to transform a dataset into a relational structure. You'll then learn how to create an Entity-Relationship (ER) diagram, a fundamental skill for database design.Enroll now, and embark on your path to Tableau certification and data visualization excellence!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Important introduction to Udemy and where to ask a question

Section 2: Introduction to Tableau

Lecture 3 Download Tableau

Lecture 4 Connect to Data Source

Lecture 5 Dimensions and Measures

Lecture 6 Introduction to Data Granularity and the Marks Card

Lecture 7 Aggregate Functions

Lecture 8 Organize Fields

Section 3: Create Charts, Format & Filter Data

Lecture 9 Line Chart

Lecture 10 Bar Chart

Lecture 11 Highlight Table

Lecture 12 Filtering Data

Lecture 13 Context Filters

Lecture 14 Date Filters

Lecture 15 Area and Pie Chart

Lecture 16 Scatter Plot - Part 1

Lecture 17 Scatter Plot - Part 2

Lecture 18 Add Custom Shapes & Color Palettes

Lecture 19 Bubble & Packed Bubble Charts

Lecture 20 Animations

Lecture 21 Annotations

Lecture 22 Titles & Captions

Section 4: Creating Maps

Lecture 23 Create first Map

Lecture 24 Map Selection Type and Grouping Map Data

Lecture 25 Dealing with Unknown Locations

Lecture 26 Heat Maps and Map Layers

Section 5: Create Dashboard

Lecture 27 Creating First Dashboard

Lecture 28 Dashboard Objects

Lecture 29 Dashboard Layout Options

Lecture 30 Dashboard Filters

Lecture 31 Dashboard Actions

Lecture 32 Design for Specific Devices

Lecture 33 Create Story

Section 6: Organizing Data

Lecture 34 Connect to New Data Source

Lecture 35 Hierarchies

Lecture 36 Grouping Data

Lecture 37 Create Bins

Lecture 38 Create Sets

Lecture 39 Sorting Data

Section 7: Additional Charts and Formatting Visualizations

Lecture 40 Histogram

Lecture 41 Tree Maps

Lecture 42 Dual Axies Chart

Lecture 43 Formatting Options

Lecture 44 Add a Visualization to a Tooltip

Section 8: Calculated Fields

Lecture 45 Aggregates

Lecture 46 If and Case Statement

Lecture 47 Date Functions

Lecture 48 Type Conversion

Lecture 49 String Functions

Lecture 50 Mathematical Functions

Section 9: The Analytics Pane

Lecture 51 Add Totals and Sub Totals

Lecture 52 Constant and Average Lines

Lecture 53 Median and Average Lines with 95 CI

Lecture 54 Reference Lines

Lecture 55 Reference and Distribution Bands

Lecture 56 Clusters and Box Plots

Lecture 57 Trend Lines

Lecture 58 Forecast

Section 10: Table Calculations & Parameters

Lecture 59 Quick Table Calculations

Lecture 60 Custom Table Calculations

Lecture 61 Create Predictive Model

Lecture 62 Create a Parameter

Lecture 63 Parameters with Reference Lines

Lecture 64 Swap Sheets in a Dashboard using Parameters

Section 11: Fixed Level of Detail Calculations

Lecture 65 Fixed Level of Detail

Lecture 66 Fixed Level of Detail - Continued

Section 12: Connect to Multiple Data Sources

Lecture 67 Gantt Bar Chart

Lecture 68 Relationships

Lecture 69 Join Data from One Source

Lecture 70 Data Source with Multiple Connections and Data Blending

Lecture 71 Create Join Calculations

Lecture 72 Union

Lecture 73 Data Interpreter and Pivot

Lecture 74 Split Data

Section 13: Tableau Desktop

Lecture 75 Download Tableau Desktop, connect to database and custom SQL queries

Lecture 76 Create Extract and Filter, and connect to .hyper file

Lecture 77 Connect to Server and Publish Dashboard & Data Source

Lecture 78 Create Subscriptions & Alerts. Update Data Source

Lecture 79 Run and Manage Data Flow

Section 14: Understand Relational Data and Normalization - Netflix Project

Lecture 80 What is a Relational Database

Lecture 81 Normalization and First Normal Form

Lecture 82 Second Normal Form - Part One

Lecture 83 Second Normal Form - Part Two

Lecture 84 Third Normal Form

Lecture 85 Entity Relationship Diagram - Part One

Lecture 86 Entity Relationship Diagram - Part Two

Section 15: Create Tableau Bike Sales Dashboard - Guided Project

Lecture 87 Connect to Data

Lecture 88 Top 10 Products

Lecture 89 Stacked Bar Chart

Lecture 90 Bubble Chart

Lecture 91 Map

Lecture 92 Profit and Year on Year % Cards and Create Parameter

Lecture 93 Revenue Card & Line Chart

Lecture 94 Product Category Cost

Lecture 95 Put Dashboard Together - Part 1

Lecture 96 Put Dashboard Together - Part 2

Anyone with little to no experience with Tableau.,Anyone preparing to take the Tableau Certified Data Analyst exam