
Learn to ace the Salesforce Tableau data analyst exam with topics on connecting to data sources, preparation, Tableau prep, exploring data, calculations, dashboards, and publishing to Tableau server.
Install the Tableau Desktop Public Edition by downloading the setup and binaries, then create and sign into a Tableau Public profile to publish dashboards and charts.
Explore Tableau Desktop Public Edition by connecting to a Microsoft Excel file, creating relationships, joins, and unions, and building worksheets, dashboards, and stories.
Explore how Tableau distinguishes dimensions from measures using a retailer dataset, covering data types, discrete vs continuous, and basic aggregation like count distinct.
Explore the difference between discrete and continuous fields in Tableau public, where continuous fields create axes and discrete fields create labels, with blue for discrete and green for continuous.
Compare discrete date parts and continuous date values in Tableau using a date field. See how month and quarter data consolidate versus show individual dates, with optional custom date formats.
Learn how Tableau-generated fields such as orders count, major name, major value, and measure value help summarize data, and how latitude and longitude fields enable geographic mapping.
Learn to set and apply default properties for dimensions and measures in Tableau, including currency formatting, number formats, and sort order, so new sheets inherit consistent settings.
Rename a field in the data source to update a sheet, and create aliases to display alternative labels. Changes apply in Tableau only, not to the original data source.
Learn how to choose a data source in Tableau Desktop Professional Edition by using file and server connectors, including csv, pdf, excel, json, and sql server.
Explore live vs extract connections in Tableau Desktop Professional edition and how a hyper file enables offline data, with refresh and extract filters shaping performance.
Compare live connections and extracts to see how Tableau queries the data source versus using the local Tableau data engine. Assess real-time needs, refresh, offline access, and performance with credentials.
Connect to a data source published on Tableau Server or Tableau Online from Tableau Desktop, then create a chart and publish the workbook.
Learn how to connect Tableau to a SQL server relational database and pull data with a custom SQL query, filtering by division to return IT records.
Learn how to replace a connected data source with another in Tableau, mapping fields and updating a chart on a sheet, then compare results with a new data source.
Apply filters to dimensions and measures in Tableau using select from list, show filter, top five, range, and date filters to refine sales data.
Apply context filters in Tableau to show the top five California cities by profit, by converting the state filter into a context filter.
Explore creating and combining sets in Tableau to highlight top ten cities by sales, their profits, and shared members for filtering.
Create and manage hierarchies in Tableau to organize dimensions such as country, state, city, and postal code, and drill down to view sales by state, city, and postal code.
Create groups to combine members of a single dimension into a new field. Use the data pane or visual view to form Avery and Belkin groups, using the paperclip icon.
Create parameters in Tableau to let users choose top N values and switch between sales and profit, with filters and calculated fields driven by a switch.
Learn to create and customize a line chart in Tableau, using date and measure to visualize sales over time, with options for colors, marks, path styles, and independent axis ranges.
Learn how to design pie charts in Tableau, when to use them for a few categories, and how to annotate and format profits, orders, and quantities for high level analysis.
Learn how to build cross tabs in Tableau, then upgrade to a highlight table with color by measure, using sales, profit, discount, and quantity across subcategories and quarters.
Learn how to create and interpret a scatter plot that reveals the relationship between sales and profit ratio, using calculated fields, level of detail, and reference lines to uncover insights.
Learn how to create histograms in Tableau to reveal frequency distributions, bin a measure into one-unit intervals, and count quantities for data analysis.
Create tree maps, word clouds, and packed bubbles in Tableau by visualizing sales by subcategory using color and size, with order date and region options for deeper insights.
Explore how box plots reveal distribution and outliers in Tableau, using one dimension and one measure (subcategory and sales), with median, hinges, IQR, and 1.5x IQR whiskers.
Learn how an area chart combines stacked bar and line charts to show sales over time by region, built from scratch in Tableau using continuous month and region coloring.
Learn to create heat maps in Tableau, extension of cross tabs, using region and subcategory as dimensions, encoding sales with size and profit with color, and comparing to highlight tables.
Learn to create a bar in bar chart in Tableau using a combined axis chart, with subcategory on rows, profit and target profit on columns, and color to combine bars.
Learn to build a Tableau Gantt chart by mapping project phases to bars, using start dates and durations, sorting by start, and coloring each phase.
Learn how to sort data in Tableau public with computed and manual sorts, including ascending, descending, and alphabetical options, plus nested and non-nested sorting across panes.
Explore row bending and column bending in Tableau to apply alternate shading using band size and levels, improving readability across dimensions.
Learn to create calculated fields in Tableau using string and date functions, including lower, upper, starts with, and date diff, to analyze product attributes and order durations.
Learn to use Tableau's logical expressions, including if statements and case statements, to test conditions in calculated fields, assign categories, and handle default null results.
Learn how to write number functions in Tableau by creating calculated fields and applying arithmetic functions (sin, cos, tan, ceiling, floor, exp, abs, pi, power, round, sqrt) to analyze profit.
Explore Tableau's type conversion functions to convert fields to int, string, or date, create calculated fields, and build a date field from year and month for use in views.
Apply quick table calculations in Tableau Public to analyze sales across years and quarters. Learn techniques like running total, percent of total, percent difference, rank, moving average, and year-over-year growth.
Apply quick table calculations in Tableau by selecting compute using across, down, or per pane. See how pane scope changes grand totals and percent totals across quarters and categories.
Explore custom table calculations in Tableau, using first, last, index, and rank to rank subcategories by sales and extract top and bottom five values in a single view.
Learn to compute year-to-date and month-to-date sales in Tableau by using date truncate with today, start of year, and order date, filtering out future data for certification-ready calculations.
Learn to create calculated fields for profit to sales ratio, use sum of profit by sum of sales, and display percentages with subtotals for order IDs and subclasses.
Explore how to use aggregate functions in Tableau, create calculated fields, and compare max, sum, average, and count distinct to analyze sales, profit, and orders.
Explore level of detail expressions in Tableau to compute independent values. Use fixed, include, and exclude to control scope and determine percent of total and order of operations.
Learn how to use a fixed level of detail expression to fix the category dimension and calculate total sales per category, then compute each subcategory's percent contribution within that category.
Learn how to build cohort analysis in Tableau using fixed lod to derive each customer's first order date, analyze retention across years and regions, and visualize 2016 onward trends.
Learn how include LOD expressions in Tableau compute average sales by region while including the category dimension, using the syntax { include category : average }.
Learn how exclude level of detail expressions in Tableau remove the state dimension from a view and compute total sales across categories while applying region filters.
Learn to implement nested lod calculations in Tableau to find minimum subcategory sales within each category and minimum monthly sales per year using fixed and date truncate function.
Create a Tableau dashboard with retailer superstore data: a line chart of profit over time, a region profit map by state, and a top ten profitable products bar chart.
Builds three Tableau charts—profit over time, profit by state, and top ten profitable products—while applying formatting, trend lines, filters, and alignment to reveal insights.
Create sales analytics visuals by duplicating the profit charts: a line chart of sales over time with region-specific sales, a map by state, and the top ten sold products.
Learn tableau sales analysis by duplicating and renaming sheets, swapping profit for sales over time, by state, and top selling products, then prepare a dashboard.
Learn to create dashboards in Tableau, from a new dashboard with device previews and sizes to adding sheets and objects like containers, text, images, and navigation.
Build a profit analysis dashboard in Tableau by consolidating multiple views and maps. Configure region and year filters across data sources, show top products, and format currency for clarity.
learn to add interactivity to a profit analysis dashboard by implementing filter and url actions, set context filters, and highlight the top five profitable products.
Create a sales analysis dashboard in Tableau using horizontal and vertical containers to arrange top five products, sales over time, and sales by state with year and region filters.
Finish sales analysis dashboard by configuring multi-select year filters, updating the map background, and adding actions that navigate states and top products to a new sheet, mirroring profit analysis dashboard.
Build a sales analysis dashboard in tableau with year and region filters, map layers, and an all-products sheet; set actions to open top five products and detailed views.
Explore using dashboard objects, including navigation and download, to switch between sales and profit analysis dashboards and export the active sheet as a pdf.
Create stories in Tableau by turning dashboards and worksheets into story points. Build a profit and sales analysis story with fixed sizes, header updates, and region-focused views.
Learn how to format a profit analysis story in Tableau by duplicating dashboards, customizing story points, and using shading, text boxes, and navigation to present region and overall profit clearly.
Discover how to swap charts in Tableau using a parameter, create the parameter and calculated field, and build a dashboard that shows map, line, or bar charts.
Explore how Tableau dynamic zone visibility controls dashboard charts—map, line, and bar—through calculated fields and layout visibility using value. Learn to implement and optimize chart swapping for faster performance.
Use the show hide button in Tableau dashboard objects to control visibility of containers and filters, managing dashboard space with text or image styles.
Use set actions to modify a category set by user interactions with the visualization, enabling dynamic subcategory display and consolidated sales totals.
Explore parameter actions in Tableau to update a string parameter from subcategories on hover, drive bar colors, and display sales labels.
Create a responsive design for Tableau dashboards by tailoring phone, tablet, and desktop layouts with device previews, adjusting charts, images, and maps, and managing layout locks.
Explore how to create symbol maps in Tableau to visualize U.S. state sales and profit using geocoded fields, size and color, and customizable map layers.
Compare symbol maps to field maps in Tableau by using a single measure to color states and display profits as labels on a filled US map, with currency in dollars.
Density maps in Tableau help you identify where data points concentrate by showing overlap, using density marks type and geographic fields for maps or scatter plots.
Learn to use map features in Tableau to pan and zoom, apply layers and filters, and create custom territories to analyze profit by Western, Eastern, and other regions.
Explore lasso and radial selection on maps to analyze city profits near Los Angeles, compare surrounding cities, and use geographic search with map layers and metric units.
Learn how to use custom geocoding in Tableau to plot exact locations by importing latitude and longitude via a CSV, and understand why this requires Tableau Desktop Professional edition.
Explore how to use a custom background image as a map in Tableau by mapping x and y coordinates to location IDs, labeling room types, and sizing markers.
Connect to a spatial file in Tableau Public using the London wards data and visualize districts as polygons; compute percent of total hectares per district.
Learn to build totals and subtotals in a Tableau view using categories, subcategories, and regions, then add grand totals and row or column subtotals with sum, average, max, and min.
Learn to add and customize reference lines in Tableau, with per pane or per cell scope for regions, profit, and sales, and adjust sums, averages, labels, and formatting.
Learn to use reference bands and lines in Tableau Public, set band from and band to with min, max, or sum, and customize colors and tooltips across panes.
Learn to create and customize reference distributions in Tableau, using bands to shade data with percentile, quantile, percentage, or standard deviation ranges.
Learn to use parameters with a reference line in Tableau to dynamically highlight data by threshold, build calculated fields, and color states based on sales and shipping days.
Explore how trend lines in Tableau reveal the relationship between profit and sales, apply linear, logarithmic, exponential, power, and polynomial models, and adjust intercepts and degrees as data points update.
Explore trend models and identify the best fit line by comparing r-squared and p values across linear, logarithmic, exponential, and power options for profit versus sales.
Learn to create time-series forecasts in Tableau with continuous dates and measures, using exponential smoothing, prediction intervals, and automatic model selection to forecast sales and profit for future periods.
Explore Tableau's data model in 20.2 and 20.3, with a logical layer of related tables and a physical layer from data sources, connected by relationships rather than joins.
Explore Tableau joins by creating inner, left, right, and full outer joins on common columns, including single and multiple column keys, using sales and finance tables.
Learn to use relationships instead of joins in Tableau to combine sales and finance data without data loss, handle nulls, and build unified visuals.
Learn how data blending in Tableau aggregates data before blending to handle different granularity, using separate data connections and a left join on region and country.
Learn how to use relationships in Tableau to join tables without data blending, handle different levels of detail, exclude nulls, and compare relationship versus blend at the data source level.
Master building unions in Tableau by appending year-wise sheets, merging region and country, and understanding that unions add rows while joins add columns.
Learn to clean and pivot data in Tableau using the data interpreter, turning year columns into rows for census population data from 2010 to 2019.
Master Tableau's automatic split to create first and last names from customer name, and use custom split with a hyphen to isolate the last six digits of an order ID.
The name of the certificate has been update from "Tableau Data Analyst" to "Salesforce Certified Tableau Data Analyst". However, the exam guide is same as before.
Everything in a single course - Detailed Video tutorials, Quizzes, Full Practice Test along with solutions.
Do you want to learn Tableau and crack the Salesforce Certified Tableau Data Analyst Exam, then this course is for you.
This course is designed by considering the fact that you are an absolute beginner, and I will teach you even the most basic concepts in Tableau from scratch so that after completing this course you would be able to create rich visualizations easily and confidently.
It will help you to prepare and clear your Salesforce Certified Tableau Data Analyst Exam. In this course, you will find practice tests that will help you to validate your Tableau understanding. We will also show you how to solve the questions in a faster way and all the detailed solutions are provided for the hands-on questions.
Detailed tutorials covering the Data Analyst topic areas:
Data Connections
Organizing & Simplifying Data
Field & Chart Types
Calculations
Mapping
Analytics
Dashboards
All the best!!!
Features:
Everything in a single course - Detailed Video tutorials, Exam Notes PDF, Tips and Tricks, Practice Test.
Tableau Version - All the tutorials are shown in Tableau Desktop public edition which is a free version so that you can follow along. Few of the concepts are demonstrated on Tableau Desktop professional edition like Live Connection and Extracts, publishing and sharing options, custom geocoding, connect to Tableau Server, and connection options as these are not available in Tableau Desktop public edition.
Instructor Support - Quick Instructor Support for any queries.
Lifetime Access