TABLEAU 2018 ADVANCED: Master Tableau in Data Science

Master groups and sets in Tableau to boost efficiency. Learn to create static and dynamic sets, use parameters, and combine them with a live business example.

Explore the Udemy review system, learn how to rate the course accurately, share concerns, and help improve course quality by reflecting on sections, topics, and data sets.

download the 1000 startups data, join the overview and financials in tableau, and use folders to organize 2015 financials for evaluating revenue, expenses, and growth.

Learn how to create and edit groups in Tableau to combine years and industries, manage dimensions and measures, and preserve accurate averages when aggregating.

Explore how static sets in Tableau differ from groups, create a static set of industries, and use it to filter, color, and highlight top performers without changing data.

Learn to create dynamic sets in Tableau, using the top tab and calculations to select top startups by growth and filter by revenue thresholds, enabling flexible visuals.

Explore combining sets in Tableau to create a dynamic target quadrant by intersecting a high revenue set with a low expenses set, and visualize with axis reversal.

Learn to control Tableau sets with parameters to drive dynamic visualizations. Create parameters for growth, revenue, and expenses, connect them to sets, and update treemaps and scatterplots in real time.

Build a startup quadrant dashboard in Tableau with an intuitive scatterplot and aesthetics-driven color, using sets and parameters to reveal top performers for the board.

Apply advanced Tableau dashboard techniques to craft a polished board-ready view by standardizing colors, adjusting axes, adding reference lines and drop lines, and customizing tooltips for executive insight.

Master advanced Tableau by using groups to shape metadata and aggregation, compare groups and sets, leverage static and dynamic sets with parameters, and build powerful visuals.

Explore how to optimize heavy machinery utilization at a coal terminal using data science in Tableau, and master table calculations from basics to stacking calculations.

Analyze coal terminal reclaimers using idle capacity metrics to forecast maintenance needs. Learn to identify eight-hour windows where average idle capacity exceeds 10% and generate executive reports.

Connect to excel data, create a dummy timeline, and perform multiple left joins to unify machine data, pivot metadata, and finalize a unified data connection in Tableau.

Refresh your knowledge of table calculations in Tableau, compare them with calculated fields, and understand how running totals and differences relate to previous or first values after aggregation.

Master advanced table calculations in Tableau, including quick table calculations and difference, then compute idle capacity by subtracting actual tonnes from nominal capacity using table down.

Learn how to save a table calculation in Tableau, convert idle capacity to percent difference, and flip the chart to show positive values with a 10% reference line.

Master Tableau in data science by learning how to specify the direction of computation for table calculations, including implicit vs explicit approaches and how to use compute using options.

Learn to write your own table calculations in Tableau, creating calculated fields and leveraging first, index, lookup, running sum and window moving averages to analyze visuals and data gaps.

Apply an eight-hour moving average to idle capacity data in Tableau to identify machines that require maintenance, and understand how window average table calculations reveal threshold crossings and irregularities.

Apply quality assurance to table calculations by validating moving averages, handling data gaps, and restricting calculations to complete windows, ensuring accurate maintenance insights in Tableau.

Derive actionable insights from Tableau by applying moving averages and trendlines to monitor idle capacity against the 10% threshold, identify planned capacity sacrifices, and forecast maintenance needs.

Create a Tableau storytelling sequence by building a dashboard-based storyline from analysis charts, format axes, customize tooltips, manage trend lines, and present machine-by-machine insights to executives.

Explore how to compile and present an executive report in Tableau, analyze machine performance against a 10% idle capacity threshold using moving averages, and communicate maintenance needs.

Master advanced data preparation and analytics in Tableau by exploring box plots, trend lines, forecasting, and tips for large datasets, plus new data source level filters and blending.

Explore advanced data preparation and analytics in Tableau using ABS retail and demographic datasets to evaluate business environments in Queensland, Victoria, and Western Australia for a hypothetical Australian clothing retailer.

Master advanced Tableau techniques by building box plots to compare net profit margins across states, using data pivoting, disaggregation, and analytics pane insights.

Explore how to construct and interpret box plots in Tableau, including quartiles, medians, interquartile range, outliers, and distribution shapes, to compare state performance and net profit margins.

Learn to prepare and optimize large data sources in Tableau by cleaning the Australian Bureau of Statistics dataset, hiding unwanted columns, and using data source filters to speed pivots.

Pivot the columns after applying a data source filter, then split to separate state and industry, preparing the dataset for analysis.

Master Tableau to build an industry analysis of retail turnover by state and industry from 1982–2015, revealing seasonal patterns, December spikes, February dips, and disruption in real-world Australian data.

Use data source filters to remove irrelevant rows at the data source level, speeding dashboards by excluding nonessential industries and older dates, such as clothing retailing from 2000 onward.

Explore creating and customizing trend lines in Tableau to compare state-level clothing industry trends, apply filters, and assess per capita consumption by normalizing with population growth data.

Connect to an Australian population dataset in Tableau, perform pivots, splits, and data source filters to isolate the persons series by state and gender for quarterly analysis.

Master advanced time-series blending in Tableau by joining industry and demographics datasets with custom year and quarter relationships, duplicating quarterly values for monthly insights.

Create a calculated field to compute sales per capita by dividing turnover by population across a two-dataset blend in Tableau, revealing state-level trends and Victoria as a promising expansion target.

Apply forecasts in Tableau by dragging forecast onto charts, then adjust options for trend, seasonality, and prediction intervals to project monthly sales per capita.

Learn to craft a Tableau storyline that blends box plots, industry and competitor analysis, and per-capita sales forecasts into a polished dashboard-driven presentation for executives, highlighting Victoria as expansion target.

Master advanced Tableau techniques by learning to create animated dashboards that combine five dimensions, enhance user engagement, and extract valuable insights through practical animations and expert tips.

Deliver an animated Tableau dashboard showing world population trends over 50 years, with fertility, life expectancy, and population, drillable by country, using the World Bank data.

Edit relationships to blend population, fertility rate, and life expectancy with country metadata using year and country code, then prepare pivots for animation and remove unnecessary fields.

Blend the population dataset as the primary source, size bubbles by population, and plot fertility rate on the x-axis with life expectancy on the y-axis.

Add animation in Tableau by placing year on the pages shelf to create a visualization of country data, revealing five dimensions: fertility rate, life expectancy, population, region color, and year.

Master an advanced technique for blending data in Tableau to sort by a column from a secondary data source, using default properties to set a manual sort.

Master Tableau animations with show history and trails to explore fertility, life expectancy, and population trends. Drill down to individual countries and compare patterns using marks, highlights, and manual history.

Finalize the tableau animation by integrating it into a world demographics dashboard, adjust formatting and legends, remove tooltip controls, apply a workbook theme, and prepare a polished presentation for executives.

Explore a regional profit analysis in Tableau by recreating a state-level visualization using level of detail calculations, with state colors for average city profits and circles for city contributions.

Prepare the workbook in Tableau by joining the list of orders with order breakdown using an inner join, and build a geography hierarchy of state, city, country, and postal code.

Explore aggregation and granularity in Tableau by adjusting dimensions to control the level of detail from city to state to US, and learn how measures aggregate across items and orders.

Master Tableau's level of detail calculations by using include, exclude, and fixed to perform city-level aggregations while keeping visualizations at state or higher levels, enabling calculations without changing the view.

Explore level of detail calculations in Tableau by including city profit while keeping the visualization at the state level, revealing city contributions to state averages.

Explore the atr function in Tableau, which returns a single value when all rows share one value. If values differ, atr yields an asterisk and can appear in tooltips.

Learn to use exclude type 2 level of detail in Tableau to bring state profit to city-level visuals in part one, with a practical step-by-step example.

Apply exclude LOD calculations in Tableau to measure each city's share of state profit, using ratio values with color and size to reveal contributions.

Master the Tableau level of detail calculations with include and exclude logic for multiple dimensions to correctly aggregate profit across state, city, and postal code levels.

Master fixed level of detail calculations to fix aggregation at an absolute level, replacing include and exclude methods and applying city, state, and country dimensions.

Duplicate and merge charts in Tableau to create a combined visualization with dual axis. Adjust colors, borders, and tooltips to highlight state and city profit insights.

Learn to create custom polygons, custom map backgrounds, and custom images on maps in Tableau while calculating distances between points and tackling two business challenges.

Master drawing polygons in Tableau by using x and y coordinates, path order, and a unique shape id to connect points into closed shapes and create custom polygon visuals.

Use background maps in Tableau to overlay meeting room polygons on floor plans and blend data to compare booked versus actual utilization across two floors.

Learn to build a Tableau visualization that toggles between ground and first floors with a select floor parameter and linked background images, and compare booked versus actual utilisation.

Explore the drawing tool for Tableau to generate coordinates from images or maps for background images, polygons, paths, and points, and export results as CSV or table.

Learn to use custom images as marks on maps in Tableau to visualize coffee store locations in Manhattan, showing turnover, months open, and distances to identify gaps.

Calculate distances between stores in Tableau by joining the dataset to itself on store id and using latitude and longitude with the great circle distance to find the minimum distance.

Explore how Tableau integrates with Mapbox to customize map backgrounds, create map styles in Mapbox Studio, and use your Mapbox access token to access background maps.

Recap polygons in Tableau with points and paths, using background images to create map visuals. Explore shapes, distance calculations, and Mapbox integration for blending dynamic maps.

Celebrate completing this Tableau 2018 advanced course with a Tasmanian farewell, featuring Cradle Mountain and Crater Lake, and rate the course if you enjoyed it to help others.