DATA ANALYTICS & VISUALIZATION USING EXCEL – TABLEAU

This course focuses on a case study approach for learning and is a completely industry relevant training.

DATA ANALYTICS & VISUALIZATION
USING EXCEL – TABLEAU

COURSE ID – DBAL-101     DURATION – 32 Hours

 
Program Objective
This course focuses on a case study approach for learning and is a completely industry relevant training. At end of the program candidates are awarded Data Analytics & Visualization Certification on successful completion of projects that are provided as part of the training.
In particular, after the completion of this course, you will be able to:

  • Use Excel/Tableau for data analysis, data summarization and exploratory Analysis.
  • Use basic & advanced features of excel/Tableau for data visualization
  • Work on dynamic reports/dashboards and insightful visuals
  • Work on end to end data analytics/visualization projects
Who Should do this course?
This course is a foundation to anyone who aspires to get into analytics and present it in a more sensible manner.
The students(Grad & Post Grad) and Professionals like Analytics consultants, Business Analysts, Data Analysts, Data Scientist, IT/Software Professionals, Project managers, BI & Data House professionals, statisticians.
Pre-requisites
There are no prerequisites for this course. Knowledge of basic excel would be an advantage.
Modules & Topics

Excel

  • Introduction to Excel
  • Working with Formulas and Functions
  • Creating Charts and Graphics
  • Analyzing Data with Excel
  • Essentials, preparing data for the dashboard
  • Data Prep & Reduction techniques
  • Data Analytics Using Excel

EXCEL-DASHBOARDS

  • Overview of Dash boarding
  • Charting (Pivot Charts & Normal Charts)
  • Advanced Power Charting Techniques
  • Adding ActiveX controls
  • Trends & Scenarios
  • Creating your Excel Dashboards
  • Macros
  • User Defined Functions
  • Bullet-proofing your Dashboards
  • Practical Dashboard Creation

TABLEAU

  • Getting Started
  • Working with Data
  • Building Basic Reports(Basic Views)
  • Additional Functionalities
  • Table calculations
  • Calculated Fields
  • Parameters
  • Advanced Charts
  • Geo Coding/ Maps
  • Building Interactive Dashboards
  • Working with Tableau Server – Accessing reports through Web

Need help choosing what course you should enroll to?

Talk to us today to help us understand your requirements in detail and help you achieve your analytics training goals!