Data Visualization Training

——–Call Us Now 1800-212-2120

Register
Course Agenda

About Data Visualization Certification Training

Data Visualization is an easy way to assist the human memory and enhance decision making. There are various tools which will cater to the needs of viewing humongous data to the tune of Peta bytes (1000^5) & Zeta bytes (1000^7). Number crunching will huge data is extremely challenging and Tableau is one such software which will be your friend in addressing challenging business problems.

As part of this data visualization training you will learn about various pitfalls which even a seasoned analyst must know. You will learn on how to visually represent a social network and perform social network analysis. Tableau, which is considered market leader in visualization, will be taught to carry out the data representation in a meaningful manner. You will learn on how to use minimum graphics to showcase maximum business value.

Tools You Will Learn…

  • Tableau
  • NodeXL – Open source MS Excel plugin

Topics You Will Learn…

PART 1:  Tableau 9.1 Basics

  • Introduction to the various file types
  • How to access help
  • Quick introduction to the user interface in Tableau
  • How to create data visualization using Tableau feature “Show Me”
  • Reorder & remove visualization fields
  • How to sort & filter data
  • How to create a calculated field
  • How to perform operations using cross-tab
  • Working with workbook data & worksheets
  • How to create a packaged workbook
  • Creating various charts such as
    • Heat map
    • Box and Whisker plot
    • Pareto chart, etc.
  • Creating maps & setting map options
  • Creating dashboards & working with dashboard
  • What is data visualization?
    • Why visualization came into picture?
    • Importance of visualizing data
    • Poor visualizations versus perfect visualizations
    • Principles of visualizations
    • Turfte’s graphical integrity rule
    • Turfte’s principles for analytical design
    • Visual rhetoric
    • Goal of data visualization
  • Tableau –Data visualization tool
    • Introduction to tableau
    • What is tableau?
    • New Features of Tableau 9.1
    • Top chart types in tableau
  • Data Interpretation
  • Pivot Tables
  • Split Tables
  • Responsive Tool Tips
  • Radial & Lasso Selection
  • Right Click Filtering
  • Creating calculated fields
    • Logical functions
    • Case-if functions
    • ZN function
    • Else-if function
    • Ad-Hoc Calculations
    • Manipulating text-left and right functions
  • Time series charts
    • Time series hands-on
  • Bullet graphs
    • What are bullet graphs?
    • Bullet graphs hands-on
  • Scatter plot
    • What is scatter diagram?
    • Introduction to correlation analysis
    • Inroduction to regression analysis
    • Scatter diagram hands-on
  • Pre-defined analytics
  • What are histograms?
  • Bin sizes in tableau
  • Histogram hands-on
  • What is box plot?
    • Why to use box plot?
    • Box plot hands-on
  • Pareto Charts
    • What are Pareto Charts?
    • Pareto charts hands-on

PART 2:  Tableau 9.1 Advanced

  • Maps in tableau
    • Types of maps in tableau
    • Maps hands-on
    • Polygon Maps
  • Dashboards Hands-On in Tableau
  • Story hands-on in tableau
  • Animated visualization hands-on
  • Connecting with WMS server
  • Adding Background Image
  • Creating Workbook Data Extract
  • Tools for sharing information
  • Publishing our Workbooks in Tableau Server
  • Connecting Tableau with Tableau Server
  • Connecting Tableau with R
  • What is R?
    • How is tableau integrating with R?
    • How to integrate Tableau with R?
  • Connecting with all major data sources such as Cloudier Hadoop, Amazon Redshift, etc.
  • Connecting to Web Data Connector
  • Case Studies:
    • Visualizing Space Shuttle Dataset
    • Visualizing Olympic Medals Dataset

PART 3:  NodeXL for Network Analysis Visualization

  • 3 important principles of Visualization
  • Lie Factor
  • Using consistent scales
  • Presenting data in the context
  • Data-ink ratio
  • Turfte’s Graphical Integrity Rules
  • Tufte’s Principles for Analytical Design
  • Various chart junks & how to avoid chart junks
  • Dashboards – Good, Bad & Ugly
  • Affordance Theory
    • Network theory – using NodeXL
    • Degree (In-degree, Out-degree)
    • Centrality (Closeness, Betweeness, Eigenvector)
    • Grouping / Clustering
    • Facebook network hands-on
  • Big data visualization problems

Data Visualization Course Introduction Video

  • Introduction to Data visualization
    • Introduction to Data visualization

    • Watch Video

Watch our sample e-learning video recorded by industry’s best trainers with extensive subject knowledge expertise and who are considered to be the best trainers of the industry. All the participants will be provided access to our state-of-the-art Learning management system (LMS) at ExcelR.net, where one can access end to end course videos at your own pace & convenience sitting back at your home. Videos can be accessed from your desktop, mobile, tablet, etc. Switch back and forth as you choose

FAQS

  • Data visualisation is all about telling a story using visual graphics/images which cannot be told by data alone. Data visualisation should not be mistaken for beautiful aesthetic visuals, however it is about solving business problems.
  • Though there are umpteen number of data visualisation tools which follow the data visualisation principles. Tableau holds No.1 position in the leaders quadrant for data visualisation. Hence data visualisation training offered by ExcelR is exclusively on Tableau Desktop.
  • The detailed course outline is provided on the website. The training covers 30 hours of concepts. Participants will also be trained on NodeXL which is majorly used for Network analysis.
  • Yes, data visualisation is mandatory for all data scientists because they are expected to present the products / solutions to the clients. There are also jobs on data visualisation alone & Tableau alone.
  • Our trainers have 15+ years of experience in the field of their expertise from prestigious colleges such as IIT, ISB, IIM, etc. Also the training content which ExcelR provides is incomparable with any other training institute. We provide Tableau Server training along with Tableau Desktop training which makes your profile complete.

Testimonials

” EXCELLENT TRAINER  

Excellent ,Trainer has explained the topic with real time example very well. He made us to be active in the class using his teaching style

Siripurapu Pradeep,Manufacturing Engineer, Textron

linkedin

” TRAINING WAS EXTENT 

Good, able to understand the process areas, techniques to remember

Raveendra Kuma, Tata Consultancy Services

linkedin

Read More

Modes of Training

Why Excelr?

Our Clients