Big Data Visualization Toolkit (Tableau, Alteryx, QlikSense)

Select chart types in Tableau by the questions you ask and your data properties to convey insights clearly; use line charts for trends, bar for ranking, and maps for geography.

Explore visualizing change over time in Tableau with discrete and continuous line charts, area charts, and stacked bars, including date drill-downs, blended axes, and mark labels.

Learn to create bar charts in Tableau, using vertical and horizontal bars, sorting, stacking, and grouping by course and flavor profiles; explore bullet and Gantt charts for time and quotas.

Build and analyze part-to-whole visualizations with pie and doughnut charts, using count distinct to show gender distribution among enrollees and discover relative and absolute contributions.

Design and format tables and callout numbers in Tableau to display exact figures, using text tables, highlight tables, and crosstabs or pivot tables, with best practices for readability.

Explore how to visualize distributions with histograms and box plots in Tableau, using age and monthly salary data to compare gender groups via bins, counts, and whiskers.

Use scatter plots and correlation matrices to visualize relationships between numerical variables, apply the Pearson correlation coefficient, and interpret trend lines, r-squared, and p-values in the abalone dataset.

Explore spatial charts in Tableau by creating symbol and filled maps from geographic fields, visualizing sales and customers with color, size, and labels across regions and counties.

Create an interactive dashboard by combining multiple views and charts, such as a line chart, a tree map, and a bar chart, using containers, filters, legends, and highlights.

Create and present a data narrative in Tableau using stories, story points, and dashboards. Learn to format captions, apply filters, and guide audiences through a logical, engaging data journey.

Publish a Tableau workbook to widen your audience, enabling viewing, interacting, downloading, and subscribing via web or mobile, centralizing data sources with Tableau Public, Tableau Online, or Tableau Server; security.

Load the video game sales Excel into Tableau, create a stacked area chart of regional sales by year, then build a tree map of global sales by genre.

Load a customer Excel file into Tableau to build a fixed-size desktop dashboard with a symbol map, a total purchase histogram, and a count of customers by gender pie chart.

Explore how Tableau handles aggregations and defaults, switching between text and numeric fields to select counts, minimums, and maximums, and create calculated fields with basic and level-of-detail calculations.

Explore numeric expressions and automatic calculations in Tableau, including absolute value, sign, Zen, ceiling, floor, round, min, and max, via calculated fields.

Explore string expressions to format and manipulate text in tables, using capitalize, upper, lower, trim, left, right, mid, index, substring count, replace, and len to transform book titles.

Explore Tableau's logical functions—IMF, if else, and case when—to create calculated fields like alert and category ID, comparing stocks to orders to signal restock needs.

Explore Tableau's analytics tools from basic totals, subtotals, and grand totals to forecasting with exponential smoothing, trend and seasonality, plus clustering with k-means to reveal data patterns.

Load the mock visitors IP spreadsheet into tableau, clean fields with string functions, and build calculated fields to normalize names, extract email, standardize gender, and identify queens blocks or lots.

Load the woman shopping review CSV into Tableau and recreate a fixed-size dashboard with call-outs, a bar chart, and a table showing average ratings, counts, and recommendations.

Join the Tableau journey and explore this impressive big data integration and analytics tool for data visualization. Reach out with any questions as you continue to learn and apply Tableau.

Explore self-service analytics with Alteryx, enabling citizen data scientists to perform data preparation, cleansing, and extract, transform, and load, with automation via drag-and-drop workflows, plus spatial and predictive analytics.

Learn the essentials for a successful training experience in big data visualization with Tableau, Alteryx, and QlikSense; download and unzip instructor files, and adjust video settings.

The lecture introduces Alteryx essentials, showcasing end-to-end data analytics with drag-and-drop workflows, extensive data connectors and APIs, and workflow execution to automate data cleansing beyond Excel.

Identify the main data types Alteryx supports—strings, numerics, date/time, bullion, spatial, and underscore string variants. Use the select tool to check data types and note numeric subtypes and double precision.

Discover the core components of an Alteryx workflow, including tools, anchors, and data flow, and learn to add tools and connect inputs and outputs.

Format data with the select tool to adjust field name, data type, and size, remove unused columns, and prepare data for analysis; sort and cleanse to fix nulls and whitespace.

Build a basic data workflow by importing a movie data set with an input tool, clean and type fields, rename and replace nulls, then export as a Tableau data extract.

Master data filtering with basic and custom conditions, view true/false outputs, and remove duplicates with the unique tool; then use sampling to select top results by group.

Learn to blend data from multiple sources using join and union tools, matching by specific fields or by record position, and manage outputs for unmatched and matched records.

Master Alteryx's summarize tool to total income, compute averages, and concatenate fields, then group by and pivot data with cross tab and transpose for clearer, flexible layouts.

Explore basic functions in an analytical workflow to handle incomplete data using the formula tool to create and update columns, apply string and numeric operations, and derive new fields.

Explore basic functions and conditional formulas in Alteryx, including if/then, inline if, and multi conditional logic, to flag paid versus free apps and categorize ratings.

Master switch-based conditional logic to create a content code column, handle nulls and empties, and convert data types with string and numeric functions for reliable data preparation.

Learn how to parse, format, and convert date time data in Alteryx using the date time tool, handling string to date time conversions, languages, and custom formats for accurate analysis.

Use the text to columns tool to split concatenated data by a delimiter into columns or rows, then rename fields with the dynamic rename tool using a second input's metadata.

Learn how to use a find and replace tool in a join toolkit to mimic vlookup by replacing and appending fields, including case-insensitive matching and partial field searches.

Apply the same expression to multiple fields with Alteryx's multi field formula tool. Compute days between logins using the multi row formula and date time diff, filling nulls by year.

Learn to build an end-to-end Alteryx workflow that joins movie, rating, director, and actor data, cleans nulls, replaces ids with names, formats dates, and splits actors into columns.

Explore essential tips for organizing and optimizing your designer workflow in big data visualization tools, including canvas prep, layout, grid, favorites, annotations, tool containers, wiring, alignment, and shortcuts.

Visualize data with the table tool to produce read-only, month and product line grouped tables showing gross income and use bar graphs and styling to enhance reports.

Demonstrate how to enhance reports with text tools and charts in Alteryx, including creating and positioning text, attaching to fields, and building interactive bar and pie charts from summarized data.

Master layout and rendering workflows in Alteryx by joining multiple report objects, arranging horizontal and vertical layouts for bar chart and pie chart, and exporting a pdf or html report.

Learn to convert standard workflows into analytic apps or macros in Alteryx, build interfaces with file browse and list box tools, and publish to server or gallery.

Explore macros in analytics workflows, including standard, batch, innovative, and local optimizer macros, plus how to create, configure inputs and outputs, map fields, and insert into workflows.

Explore spatial data concepts and the Alteryx spatial toolset. Convert coordinates to spatial points, build lines and polygons, and visualize routes and boundaries on maps.

Learn to measure areas and distances with the trade area and distance tools, creating radius and concentric rings around stores, and finding nearest customers using the find nearest tool.

Analyze relationships between spatial objects using the spatial process tool to combine, cut, and intersect trade areas, then apply the spatial matched tool to relate customers to stores.