Tableau Certification Exam Prep – Relational Database Design

Free Download Tableau Certification Exam Prep – Relational Database Design
Published 11/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.93 GB | Duration: 10h 3m
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

Homepage

www.udemy.com/course/tableau-certification-exam-prep-relational-database-design/