PROGRAM OBJECTIVES & DESCRIPTION

  • To acquaint the participants with the knowledge of streamlining the analysis and highlight their implications efficiently using smart visualizations (without any coding)
  • To apprise the participants of the usage of GUI based data analytics techniques and helping those becoming experts in communicating business-relevant implications of data analysis.
  • To familiarize the participants with the knowledge as to how without incorporating any coding techniques, they can structure the data and align it with the expectations of various stakeholders.
  • To acquaint the participants with the knowledge of connecting & creating interactions among disparate data sets, designing summaries & visuals to further use them for business decision making.
  • To accustom the participants to the knowledge of creating persuasive business stories from data points and presenting them in the form of storyboards and dashboards for easy comprehension.

WEEK 1

  • Introduction to Data Summariza- tion & visualization
  • Need of visualization and visualiza- tion types
  • Understanding visualization context and accordingly select the visual types
  • Cognitive vs Perceptual Design Principles

WEEK 2

  • Visualization Design Principles & Standards (Best Practices)
  • Visualization Challenges
  • Ineffective vs Effective Visuals
  • Visualization Data Models & varia- bles, Visualization Tools
  • Introduction to the data visualiza- tion software Tableau
  • The Tableau Interface
  • Distributing and Publishing on Tableau
  • Getting Started with Tableau

WEEK 3

  • Managing Metadata
  • Establishing data connections in Tableau
  • Importing data in Tableau
  • Tableau data types
  • Data Preparation with Text and Excel Files
  • Preparing tables for analysis in Tableau
  • Types of Joins in Tableau
  • Joins, Cross Joins
  • Data Blending

WEEK4

  • Tableau connecting to PDFs, Cubes
  • Introduction to Visual Analytics
  • Drill down the Hierarchies
  • Sorting, Grouping & Creating Sets in Tableau
  • Filters & Parameters

WEEK 5

  • Table calculations (Quick & Custom)
  • Data Visualization case studies from Marketing, HR, Operations, Finance and e-commerce & telecom domain
  • Expert Interaction

WEEK 6

  • Advanced Calculations
  • Aggregation, Granularity, and Ratio Calculations
  • Date & Time, Logic, String, Time, Number calculations
  • Fixing incorrect sorts
  • Integrate R & Tableau
  • Charts & Graphs – Bollinger, Bump, Control, Funnel, Pareto Charts

WEEK 7

  • Forecasting, Clustering and Time series analysis
  • Mapping and geo-mapping
  • Editing Unrecognized locations
  • Spatial Files
  • Custom Geocoding
  • Web Authoring

WEEK 8

  • Dashboards & Storyboards
  • Formatting Tooltips, Trend lines, Reference Lines
  • Creating first Dashboard in Tableau
  • Creating Interactive dashboards
  • Designing and Publishing Dash- boards
  • Introduction to business story- board
  • Principles of designing business storyboard
  • Why stories are important in business
  • Creating a Storyboard
  • Assessment & Feedback