Business Problem Solving, Tableau and story telling

Introduction to Data and Business Intelligence

Why we visualize data, how to ask questions of data, communication and S.M.A.R.T., known your stakeholders, Listening to stakeholders during elicitation, Business Intelligence(BI) – Introduction, Significance & Tools, Analysis and type of analysis: descriptive, diagnostic, predictive and prescriptive. Structure pyramid analysis plan (SPAP), what makes a good, rich dataset for analysis and visualization, how to find datasets on Open Data portals.

Tableau and Basic Data Analysis in Tableau

Introduction to Tableau, Evaluation of Tableau, Tableau Architecture and Installation of Tableau. Data analysis and data communication with Tableau. Tableau public and desktop. Knowing Your Data, importing data, the “Data Visualization Process”, table view, Dashboard, Tableau Basics: Dimensions, Measures, Tableau Workspace, cards and shelves, marks card, formatting how to analyze structured data using Tableau, exporting data.

Creating Static Charts in Tableau

How to create simple static charts in Tableau , selecting appropriate chart, bar charts, line charts, bubble charts, scatter charts ,tree maps, stacked bar charts, bulleted charts and histogram Visualizing locations and time ,How to save and publish your data in Tableau ,How to export charts from Tableau for use in PowerPoint and Word, reshape data using Tableau. Preparing elevator pitch.

Creating Dynamic Charts in Tableau:

“Measure Names” and “Measure Values” in Tableau, Measures: sum, average, median, minimum, maximum, standard deviation and variance, removing outliers, Filters and groups, data hierarchies, trend lines, box plot and regression. Calculations in Tableau, blending and aggregation level calculations, enabling flexibility in KPI. Creating Maps: point maps, shape maps and customize boundary maps.

Story Telling using Tableau: Exploratory vs. explanatory, who, what and how, big idea and storyboarding, storyboarding hourglass, cluttering, gestalt principles of visual perception, and lack of visual order, Magic of story, constructing the story, narrative structure, tactics to ensure the clarity in story, story creation using tableau, story points and tools for data story, stress-testing the story.

*Case studies related to entire topics are to be taught.