Mastery Tableau: Visualization & Azure Integration(Nov 2024)

Name: Mastery Tableau: Visualization & Azure Integration(Nov 2024)
Rating: 4.8 (2 reviews)

Transforming Insights with Visual Analytics and Cloud Connectivity

Created byProton Expert Systems & Solutions

Last updated 11/2024

English

English [Auto],

What you'll learn

Gain a comprehensive understanding of Tableau's core concepts and fundamentals
Learn essential data manipulation techniques to ensure accurate and efficient visual analysis.
Learn Calculations and Advanced Analytical Techniques
Explore various visualization types (charts, graphs, maps, tables) and learn how to customize them
Explore how to publish and share Dashboards using Tableau Public
Understand how to Integrate Tableau with Cloud Platforms for Data Analysis.

Course content

6 sections • 27 lectures • 2h 17m total length

Lesson 1:Introduction to Tableau5:51
Explore how Tableau connects to spreadsheets, databases, and cloud data to create interactive visualizations and dashboards with a drag-and-drop workflow, live data, and secure sharing.
Practice 1-1: Installing Tableau Desktop2:58
Install Tableau Desktop by downloading and registering with a corporate email, then explore start page and connect to data sources such as Excel, CSV, SQL Server, and Google Sheets to create visualizations.
Practice 1-2: Connect Tableau to various data sources and import data5:26
Connect Tableau to diverse data sources, including Excel, CSV, and MySQL, and seamlessly link your data for powerful visualizations.
Lesson 1 Quiz

Lesson 2: Data Preparation and Transformation5:45
Clean and shape data for analysis with Tableau Prep, mastering data cleaning, data shaping, and transformations using string, number, and date functions for seamless Tableau Desktop integration.
Practice 2-1: Clean and transform Text Functions using Tableau Prep8:30
Master text transformations in Tableau Prep, including concatenate, split, trim spaces, and case changes, by creating calculated fields and clean steps.
Practice 2-2-1: Clean and transform Number Functions using Tableau Prep6:45
Master clean and transform numbers in Tableau Prep by creating calculated fields and applying abs, ceiling, floor, round, sqrt, power, exp, and log to the Sample Superstore data.
Practice 2-2-2: Clean and transform Date Functions using Tableau Prep5:56
Explore date functions in Tableau Prep, converting strings to dates with date pass, truncating to month, and using date add, date diff, and year, month, day extractions.
Practice 2-3-1: Advanced Data Preparation and Cleaning Techniques - Pivoting4:14
Master advanced data preparation in Tableau Prep by pivoting and unpivoting to reshape data; connect to Microsoft Excel sample files, convert columns to rows for analysis and visualization.
Practice 2-3-2: Advanced Data Preparation and Cleaning Techniques -Joins & Union4:52
Explore how to use joins and unions in Tableau Prep to merge and reshape data, compare inner, left, right, and full outer joins, and stack tables with unions.
Practice 2-3-3: Advanced Data Preparation and Cleaning Techniques - Aggregation2:38
Perform aggregations in Tableau Prep by creating an aggregation step, grouping by category, and applying sum, average, and count to key fields like profit, sales, and customers.
Practice 2-3-4: Advanced Data Preparation and Cleaning Techniques - Filtering4:06
Master filtering in Tableau Prep by applying category, numeric range, and date filters using the clean step, region fields, sales sliders, and relative date ranges.
Practice 2-3-5: Advanced Data Preparation and Cleaning Techniques - Output2:13
save your prepared data by adding an output step in tableau prep, choosing excel as the file format, and running the flow to generate and review the output.
Lesson 2 Quiz

Lesson 3: Calculations in Tableau4:33
Master calculations in Tableau by differentiating measures and dimensions, creating calculated fields, using table calculations, and applying lod expressions to control granularity for deeper insights.
Practice 3-1-1: Working with Calculated Fields in Tableau4:18
Explore calculated fields and table calculations in Tableau Desktop to create discounted sales, average sales per order, profit status, and order age with date functions.
Practice 3-1-2: Working with Table Calculations in Tableau6:37
Explore table calculations in Tableau Desktop to build dynamic insights, including running total, percent of total, difference from, moving average, rank, and percentile on sales, category, and region.
Practice 3-2-1: LOD Expressions in Tableau4:07
Master level of detail expressions in Tableau to control data granularity, using fixed, include, and exclude calculations to compute region sales, average sales per customer, and segment totals.
Practice 3-2-2: Combining LODs and Table Calculation in Tableau4:02
Combine lod expressions with table calculations in Tableau to build visuals, such as percentage of total sales by region and rank by customer within a category, using the Superstore data.
Lesson 3 Quiz

Lesson 4: Creating Visualizations6:13
Turn raw data into compelling visuals in Tableau by creating basic and advanced charts, using filters, parameters, and hierarchies, then drill down and customize visuals for clarity and interactivity.
Practice 4-1: Create basic visualizations like charts and maps7:33
Learn to create and customize basic visualizations in Tableau using the Sample Superstore data, including bar, line, pie, map, scatter, heat map, tree map, and area charts.
Practice 4-2-1: Use filters for interaction7:20
Master interactive data exploration in Tableau by applying general, wild card, condition, and top and bottom filters, using show filters, customizing controls, and applying filters across worksheets.
Practice 4-2-2: Use parameters for interaction3:27
Create a sales threshold parameter and a calculated field to filter Tableau visuals, producing a dynamic, color-coded bar chart of categories above or below the threshold.
Practice 4-3-1: Use of Hierarchy in Tableau3:36
Mastery Tableau teaches creating a product hierarchy from category, subcategory, and product name, then using drill down and drill up to explore data in the sample superstore.
Practice 4-3-2: Use of Drill through in Tableau2:45
Explore drillthrough between summary and detailed views in Tableau, creating a two sheet drillthrough action that links category filters to subcategory sales for quick, interactive exploration.
Lesson 4 Quiz

Lesson 5:Tableau Public and Sharing4:04
Publish and share your dashboards with Tableau Public by moving from Tableau Desktop to Tableau Public, then distribute via direct links or embed codes for interactive, cloud-based sharing.
Practice 5-1: Create a dashboard, Publish a dashboard to Tableau Public6:29
Create a live Tableau dashboard from sample superstore data by building bar, map, and line charts, then publish to Tableau Public and share via link or embed.
Lesson 5 Quiz

Lesson 6: Tableau Integration with Cloud Services4:19
Explore how Tableau integrates with Azure SQL Database for real-time data analysis and cloud dashboards. Create and configure Azure SQL Database, connect Tableau, build dashboards, and publish to Tableau Public.
Practice 6-1: Connect Tableau to cloud data source & create a realtime dashboard9:07
Connect Tableau to Azure SQL database, import data, build interactive visuals and a dashboard, then publish the realtime dashboard to Tableau Public.
Lesson 6: Tableau Integration with Cloud Services(Azure)

Requirements

Basic Understanding of Data
Fundamental Excel Skills
Interest in Data Analysis
Curiosity and Enthusiasm

Description

This comprehensive Tableau course covers essential skills for creating impactful data visualizations and analyzing data effectively. You will learn Tableau's core concepts, including data preparation, transforming data with Tableau Prep, and applying advanced calculations such as LOD expressions. Explore various visualization types like charts, maps, and graphs, and master interactivity with filters, parameters, and drill-through actions. Gain hands-on experience in publishing and sharing dashboards on Tableau Public. The course also covers integrating Tableau with cloud platforms, enabling real-time data access and collaboration. By the end, you'll be equipped to create, publish, and share dynamic, interactive dashboards for data-driven insights.
Whether you're a beginner or looking to refine your expertise, this course offers a deep dive into Tableau's core functionalities, ensuring you master the art of transforming raw data into actionable insights.

The journey begins with an introduction to Tableau’s powerful tools, focusing on data preparation and transformation using Tableau Prep. You’ll learn how to clean, structure, and optimize your data to ensure accuracy and efficiency in your analysis. Moving forward, the course delves into creating various visualizations, including bar charts, line charts, scatter plots, heat maps, and geospatial maps. Each type of visualization is explored in detail, emphasizing its use cases and customization options to convey information effectively.

One of the highlights of this course is mastering advanced Tableau features such as calculated fields, table calculations, and Level of Detail (LOD) expressions. These techniques enable users to perform complex data manipulations and derive insights beyond surface-level analysis. Additionally, you'll learn to enhance dashboard interactivity through the use of filters, parameters, hierarchies, and drill-through actions, empowering you to build intuitive and user-friendly dashboards.

The course also focuses on the practical aspects of data sharing and collaboration. You’ll gain hands-on experience publishing your work on Tableau Public, allowing for seamless sharing of dashboards with a wider audience. Furthermore, the curriculum includes a segment on integrating Tableau with cloud platforms such as Azure and AWS. This integration enables real-time data access, ensuring that your visualizations and analyses stay updated with the latest information.

By the end of the course, you’ll be proficient in creating, publishing, and sharing dynamic dashboards tailored to specific business needs. With these skills, you’ll be ready to present data-driven stories that facilitate informed decision-making. Whether you’re looking to enhance your career in business intelligence, analytics, or data visualization, this Tableau course provides a solid foundation to achieve your goals and excel in a data-driven world.

Who this course is for:

Business Analysts
Data Analysts
Data Scientists
IT Professionals

Mastery Tableau: Visualization & Azure Integration(Nov 2024)

What you'll learn

Explore related topics

Course content

Lesson 1:Introduction to Tableau3 lectures • 14min

Lesson 2: Data Preparation and Transformation9 lectures • 45min

Lesson 3: Calculations in Tableau5 lectures • 24min

Lesson 4: Creating Visualizations6 lectures • 31min

Lesson 5:Tableau Public and Sharing2 lectures • 11min

Lesson 6: Tableau Integration with Cloud Services(AZURE)2 lectures • 13min

Requirements

Description

Who this course is for: