Advanced Tableau - Data Model from Coursera

This Advanced Tableau course provides next-level training for structuring and connecting data in Tableau to build elegant and professional models.

In this course, you’ll combine related data using joins, relationships, and blends to bring data into visuals. We’ll work through a scenario with evolving business requirements. These requirements will need more and more data added to our model as we progress. Each time you do this, you’ll be introduced to new options for joining, relating, and blending data, common problems, and methods for optimizing your data model for performance.

By the end, you’ll have learned to think more carefully about the structure of your data, the types of connections you should use, and the performance options that are best for your data.

By the end of this course you will be able to:

• Build a basic data model using Tableau’s relationship feature

• Optimize data model relationships using performance tuning

• Understand the differences between JOINS, Relationships, and Blends

• Adapt a data model based on an expanding set of requirements

• Deal with common issues like NULLs, Many-to-Many, One-to-One relationships and filtering.

• Understand how ETL tools can make life easier to create an optimal Star Schema

This Tableau course is perfect for professionals who have a solid understanding of Tableau and want to solidify their knowledge of data modeling. If you want to know how to make good data modeling decisions in Tableau, this course is for you.

What's inside

Syllabus

Getting Started

In this course, we'll combine related data using joins, relationships, and blends to bring data into visuals. We’ll work through a scenario with evolving business requirements. These requirements will need more and more data added to our model as we progress. Each time you do this, you’ll be introduced to new options for joining, relating, and blending data, common problems, and methods for optimizing your data model for performance.

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Examines relationships and blends in Tableau, which is standard industry knowledge

Develops more advanced Tableau skills, knowledge, and tools

Taught by Tableau experts, Sebastian Taylor and Pavel Nacve

Prerequisites such as foundational Tableau knowledge are greatly encouraged

Reviews summary

Advanced tableau data modeling for professionals

According to learners, this course is a highly valuable resource for professionals aiming to deepen their Tableau data modeling skills. Students consistently highlight the instructor's clear explanations of complex topics like relationships, joins, and blends, along with practical guidance on performance optimization. While the course excels in offering real-world scenarios and tips for handling common data issues such as NULLs and many-to-many relationships, some learners felt the pace could be inconsistent or desired more challenging hands-on exercises. It is explicitly noted that this course assumes prior Tableau knowledge and is not for beginners.

Valuable insights on ETL processes and Star Schema.

"The content on ETL and Star Schema was particularly insightful, connecting Tableau to broader data warehousing principles."

"I particularly liked how they explained the importance of a star schema."

"The section on ETL and Star Schema was particularly helpful, broadening my perspective beyond just Tableau."

Instructor provides clear explanations of data modeling.

"The instructor's explanations of relationships vs. joins vs. blends were incredibly clear, using practical examples that demystify complex concepts."

"The instructor clearly knows their stuff. I particularly liked how they explained how to handle NULLs and the importance of a star schema."

"This course helped fill critical gaps. I appreciate the instructor's pragmatic approach to relationships and performance."

Practical focus on real-world scenarios and optimization.

"I especially appreciated the focus on performance optimization which is crucial in real-world scenarios. It really helped me move beyond basic data connections."

"The real-world scenario approach made it easy to follow and apply what I learned immediately. The optimization tips are gold."

"I've already applied some techniques to my work dashboards, gaining practical advice on optimizing performance."

Pace sometimes inconsistent, may require rewatching.

"While the content is relevant, I felt the pace was inconsistent. Some modules were clear, others a bit hard to follow without rewatching."

"I found some explanations a bit rushed, especially around the nuances of relationships."

Some advanced learners want more challenging exercises.

"My only minor critique is that some parts could have benefited from a bit more hands-on exercises, but the demos were thorough enough."

"I hoped for more on practical application with large datasets, as the examples felt a bit small-scale. More challenging exercises would truly cement the concepts."

"For an 'advanced' course, I expected more in-depth problem-solving techniques and less reiteration of basic concepts."

Assumes solid Tableau knowledge; not for beginners.

"It does assume you're already familiar with Tableau, so it's definitely not for beginners."

"A very solid course that builds well on existing Tableau knowledge."

"As an experienced Tableau user, this course filled critical gaps in my data modeling knowledge."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Advanced Tableau - Data Model with these activities:

Organize Course Resources

Show steps

Create a system to organize and review your course materials, including notes, assignments, and practice exercises.

Show steps

Create a dedicated folder or notebook for course materials.
Categorize and label your materials for easy retrieval.

Review Data Modeling Concepts

Show steps

Refresh your understanding of data modeling concepts, including the different types of relationships and how to optimize data models.

Browse courses on Data Modeling

Show steps

Review your previous notes or course materials on data modeling.
Complete online quizzes or practice exercises on data modeling.

Review Relational Database Concepts

Show steps

Strengthen your foundation in relational database concepts to enhance your understanding of data modeling in Tableau.

Browse courses on Relational Databases

Show steps

Review basic SQL statements (e.g., SELECT, JOIN, WHERE).
Understand data types, primary keys, and foreign keys.
Explore database normalization concepts.

Ten other activities

Expand to see all activities and additional details

Show all 13 activities

Connect with Tableau Experts

Show steps

Seek out experienced Tableau professionals who can provide guidance and support throughout your learning journey.

Show steps

Attend Tableau user group meetings or online forums.
Reach out to Tableau experts on social media platforms like LinkedIn.

Attend a Tableau User Group Meeting

Show steps

Connect with local Tableau users, share knowledge, and learn about best practices by attending a user group meeting.

Show steps

Find a Tableau User Group in your area: https://www.tableau.com/about/user-groups.
Register for an upcoming meeting.
Attend the meeting and participate in discussions.
Network with other Tableau users.

Practice with joins

Show steps

Review the concept of joins in SQL, ensuring you have a solid understanding before starting the course.

Browse courses on Data Structures

Show steps

Review the syntax for INNER JOIN, LEFT JOIN, and RIGHT JOIN in SQL.
Practice writing SQL queries using joins to combine data from multiple tables.

Explore Tableau Community Forums

Show steps

Tap into the collective knowledge and support of the Tableau community to resolve issues and enhance your understanding.

Show steps

Visit the Tableau Community Forums: https://community.tableau.com/s/.
Browse through existing discussions or search for specific topics.
Post questions and engage with other Tableau users.
Contribute to the community by answering questions and sharing your experiences.

Practice Joining Tables

Show steps

Reinforce your understanding of how to join tables by practicing various join types in Tableau.

Show steps

Create a new Tableau workbook and connect to a sample dataset.
Drag and drop two tables onto the canvas.
Select the 'Data' menu and choose 'Join'.
Choose the join type (e.g., inner, left, right, full outer).
Drag and drop the join fields to connect the tables.

Data Blending Exercises

Show steps

Complete practice exercises to enhance your understanding of the different types of data blending in Tableau.

Browse courses on Data Blending

Show steps

Use Tableau's data blending functionality to combine data from multiple sources.
Explore the different types of data blending options available in Tableau, such as inner, outer, and left joins.
Troubleshoot common data blending issues, such as data type mismatches and duplicate records.

Advanced Tableau Relationships

Show steps

Explore advanced concepts of Tableau relationships, such as creating and managing relationships between multiple tables.

Browse courses on Data Modeling

Show steps

Watch video tutorials on advanced Tableau relationship techniques.
Practice creating and managing relationships using the Tableau Desktop application.

Build a Dashboard with Multiple Data Sources

Show steps

Demonstrate your ability to integrate multiple data sources and create a visually compelling dashboard in Tableau.

Browse courses on Data Visualization

Show steps

Gather data from various sources (e.g., CSV files, databases).
Create a new Tableau workbook and connect to the data sources.
Design and build the dashboard layout, including visualizations and filters.
Configure interactions and drill-down capabilities.
Publish the dashboard and share it with stakeholders.

Tableau Data Model Optimization Project

Show steps

Embark on a project where you apply your understanding of data modeling to optimize the performance of a real-world Tableau data model.

Show steps

Identify a dataset that requires data modeling.
Design and implement a data model that optimizes performance and meets business requirements.
Evaluate the performance of your data model and make necessary adjustments.

Interactive Dashboard on Course Data

Show steps

Create an interactive dashboard that visually represents the data and insights you have learned throughout the course.

Browse courses on Dashboard Creation

Show steps

Design the layout and structure of your dashboard.
Incorporate interactive elements such as filters, tooltips, and drill-downs.
Publish your dashboard and share it with others.

Career center

Learners who complete Advanced Tableau - Data Model will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Advanced Tableau - Data Model

Here's a deal for you

What's inside

Syllabus

Traffic lights

Save this course

Reviews summary

Advanced tableau data modeling for professionals

Activities

Career center

Reading list

Share

Similar courses