What is the duration of the data visualization and analytics online training?

The course will take 120 hours to complete the training.

How many classes and projects are included in the data visualization and analytics course curriculum?

The online course consists of 12 classes with six assignments and projects

Can I pay the data visualization and analytics program fee in installments?

Yes, you can pay the course fee in three installments.

Do the data visualization and analytics course providers offer a loan facility for the students?

Yes, the students who can’t afford the one-time payment can apply for the student loan.

What is the dual certification in the data visualization and analytics program?

After the completion of courses and projects in six months with the MCQ tests, the candidates will receive the dual certification provided by Analytixlab with IBM.

Data Visualization and Analytics by Analytixlabs: Fee, Duration, How to Apply

Data Visualization and Analytics

Analytixlabs

Improve your knowledge on the frameworks of visualization and analytics with Advanced Excel, VBA, SQL, and Tableau in the data visualization & analytics course.

Online

60 Hours

₹ 18000

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based	Frequency of Classes Weekdays, Weekends	Learning efforts 8-10 Hours Per Week

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study, Virtual Classroom

                                    Mode of Delivery
                                    Video and Text Based

                                    Frequency of Classes
                                    Weekdays, Weekends

                                    Learning efforts
                                    8-10 Hours Per Week
                                

Building blocks and data analytics with Excel

Basic Excel

Excel Environment
Key Terminologies
Short Cuts
Key Functionalities
Copy-paste-paste special
Formatting & conditional Formatting
Basic Excel Functions - Types of Functions
Relational operators
Data Sorting, Filtering and Data Validation
Understanding of Name Ranges
Pivot tables - Charts
Basics of charts

Basic programming elements

Overview of programming languages
Basics of programming elements
variables, data types, data structures, loops, conditional statements, inputs, outputs, functions etc
Understanding key terms
Client/server
Database
Hosting/deployment

Introduction to basic statistics

Introduction to Statistics
Measures of central tendencies
Measures of variance
Measures of frequency
Measures of Rank
Basics of Probability, distributions
Conditional Probability (Bayes Theorem)

Overview of dashboards

What is dashboard & Excel dashboard
Adding icons and images to dashboards
Making dashboards dynamic

Business dashboards creation

Management Dashboard for Sales & Services
Best practices - Tips and Tricks to enhance dashboard designing

RDBMS and SQL(Basics)

Basic RDBMS Concepts
- Introduction to Relational Database management system. Why SQL?
- A glance at the tool and its advantages and disadvantages
- Understanding Schema, ERDs and Metadata
- Introduction to MS SQL Server
- What is SQL – A Quick Introduction
- Installing MS SQL Server for windows
Introduction to SQL Server Management Studio
- Understanding basic database concepts
- Getting started

Data analysis and reporting

Data Analysis using Pivot Tables - use of row and column shelf, values and filters
Difference between data layering and cross tabulation, summary reports, advantages and limitations
Change aggregation types and summarization
Creating groups and bins in pivot data
Concept of calculated fields, usage and limitations
Changing report layouts - Outline, compact and tabular forms
Show and hide grand totals and subtotals
Creating summary reports using pivot tables

Data manipulation using functions

Descriptive functions
Logical functions: IF, and, or, not
Date and Time functions
Text functions
Array functions
Use and application of lookup functions
Limitations of lookup functions
Using Index, Match, Offset, reverse vlookup

Data visualization in Excel

Overview of chart types – column/bar charts, line/area , pie, doughnut charts, scatter plots
How to select right chart for your data
Creating and customizing advance charts - thermometer charts, waterfall charts, population pyramids

Introduction to analytics and data science

What is analytics & Data Science?
Business Analytics vs. Data Analytics vs. Data Science
Common Terms in Analytics
Analytics vs. Data warehousing, OLAP, MIS Reporting
Types of data (Structured vs. Unstructured vs. Semi Structured)
Relevance of Analytics in industry and need of the hour
Critical success drivers
Overview of analytics tools & their popularity
Analytics Methodology & problem solving framework
Stages of Analytics

Create dashboards in Excel - using Pivot controls

Concept of pivot cache and its use in creating interactive dashboards in excel
Pivot table design elements - concept of slicers and timelines
Designing sample dashboard using Pivot Controls
Design principles for including charts in dashboards - do's and dont's

Introduction to Analytics & Data Science

What is analytics & Data Science?
Business Analytics vs. Data Analytics vs. Data Science
Common Terms in Analytics
Analytics vs. Data warehousing, OLAP, MIS Reporting
Types of data (Structured vs. Unstructured vs. Semi Structured)
Relevance of Analytics in industry and need of the hour
Critical success drivers
Overview of analytics tools & their popularity
Analytics Methodology & problem solving framework
Stages of Analytics

Data manipulation using functions

Descriptive functions
Logical functions: IF, and, or, not
Date and Time functions
Text functions
Array functions
Use and application of lookup functions
Limitations of lookup functions
Using Index, Match, Offset, reverse vlookup

Data analysis and reporting

Data Analysis using Pivot Tables - use of row and column shelf, values and filters
Difference between data layering and cross tabulation, summary reports, advantages and limitations
Change aggregation types and summarization
Creating groups and bins in pivot data
Concept of calculated fields, usage and limitations
Changing report layouts - Outline, compact and tabular forms
Show and hide grand totals and subtotals
Creating summary reports using pivot tables

Data Visualization in Excel

Overview of chart types – column/bar charts, line/area , pie, doughnut charts, scatter plots
How to select right chart for your data
Creating and customizing advance charts - thermometer charts, waterfall charts, population pyramids

Create dashboards in Excel - Using Pivot controls

Concept of pivot cache and its use in creating interactive dashboards in excel
Pivot table design elements - concept of slicers and timelines
Designing sample dashboard using Pivot Controls
Design principles for including charts in dashboards - do's and dont's

Data analytics with SQL

A quick recap of RDBMS and basic SQL

Apply learning’s on business case study

Data based objects creation (DDL commands)

Creating databases and tables. Understanding data types
Inserting values into the table
Altering table properties
Introduction to Keys and constraints
Creating, Modifying & Deleting Tables
Create Table & Create Index statements
Drop & Truncate statements – Uses & Differences
DDL Statements with constraints
Import and Export wizard to get the data in SQL server from excel files or delimited files

Data manipulation (DML commands)

Data Manipulation statements
Insert, Update & Delete statements
Select statement – Sub setting, Filters, Sorting. Removing Duplicates, grouping and aggregations etc
Operators, predicates and built in functions(Top, distinct, Limit)
Where, Group By, Order by & Having clauses
SQL Functions – Number, Text, Date, etc
SQL Keywords – Top, Distinct, Null, etc
SQL Operators - Relational (single valued and multi valued), Logical (and, or, not), Use of wildcard operators and wildcard characters, etc

Accessing data from multiple tables using SELECT

Append and Joins
Union and Union All – Use & constraints
Intersect and Except statements
Table Joins - inner join, left join, right join, full join
Cross joins/cartesian products, self joins, natural joins etc
Inline views and sub-queries & it's types
Optimizing your work
Update operations with and without joins

Advanced SQL

Creating table copy and database copy
Views
Transactions
Stored Procedures in SQL
Crud operations using stored procedures
Window functions in SQL
Miscellaneous Topics: Rollup and cube

Data Analytics & Visualization with Power BI

Introduction

Introduction to Power BI
Installing Power BI Desktop (Signup for PowerBI)
Various Options in Power BI Desktop
Views in Power BI Desktop
Template Apps
Task pipeline when your working on a project

Data Preparation and Modelling

Connect and Retrieve data from different sources (csv, excel etc.)
Query editor in Power BI
Power Query for cleaning the data
Power Query Functions – Text, Date, Numeric
Power Query Conditional Columns
Clean & transform data with Query Editor
Define data granularity
Combining data – Merging & Appending
Fill Down in Power BI, Grouping, Transpose, Unpivot, Data Types, Replace errors and values, Keep and Remove rows, Add Remove and Go To Columns
Work with relationships and cardinality
Types of Relationships (1:1, 1: Many, Many:1)
Optimizing for performance
PBIDS Files

Data handling & summaries

Sets (In/Out Sets/Combined Sets
Grouping/Bins/Histograms
Drilling up/down – drill through
Hierarchies
View data
Actions (across sheets)

Building Advanced Reports/ Maps

Explain latitude and longitude
Default location/Edit locations
Building geographical maps
Using Map layers

Calculated Fields

Aggregate vs. Disaggregate data
Explain - #Number of Rows
Basic Functions (String/Date/Numbers etc)
Usage of Logical conditions

Table Calculations

Explain scope and direction
Percent of Total, Running / Cumulative calculations
Introduction to LOD (Level of Detail) Expressions
User applications of Table calculations

Parameters

Using Parameters in
- Calculated fields
- Bins/Reference Lines
- Filters/Sets
Display Options (Dynamic Dimension/Measure Selection)
Create What-If/ Scenario analysis

Building Interactive Dashboards

Combining multiple visualizations into a dashboard (overview)
Making your worksheet interactive by using actions
Filter/URL/Highlight
Complete Interactive Dashboard for Sales & Services

Building Stories

Story Points
Options in Formatting your Visualization
Working with Labels and Annotations
Effective Use of Titles and Captions

Working with Data

Multiple Table Join
Data Blending
Difference between joining and blending data, and when we should do each
Toggle between to Direct Connection and Extracts

Sharing work with others

Sharing Workbooks
Publish to Reader/PDF
Publish to Tableau Server and sharing on the web

Automation with VBA (eLearning)

Introducing VBA

What is Logic?
What Is VBA?
Introduction to Macro Recordings, IDE

A look at some commonly used code snippets

Programming constructs in VBA

Control Structures
Looping Structures
The With- End with Block

Functions and procedures in VBA - Moedling your programs

Worksheet & workbook functions
Automatic Procedures and Events
Arrays

Objects and memory management in VBA

The NEW and SET Key words
Destroying Objects – The Nothing Keyword

Error handling

Controlling accessibility of your code - Access specifiers

Code reusability - adding references and components to your code

How VBA Works with Excel

Working In the Visual Basic Editor
Introducing the Excel Object Model
Using the Excel Macro Recorder
VBA Sub and Function Procedures

Key components of programming language

Essential VBA Language Elements
Keywords & Syntax
Programming statements
Variables & Data types
Comments
Operators
Working with Range Objects

Communicating with your users

Simple Dialog Boxes
User Form Basics
Using User Form Controls
Add-ins
Accessing Your Macros through the User Interface
Retrieve information through Excel from Access Database using VBA

Popular Courses

Popular Platforms

Heads	Amount in INR (exclusive of taxes)
Classroom & Bootcamp	₹ 30000 + taxes
Fully Interactive Live Online	₹ 25000 + taxes
Blended eLearning	₹ 18000 + taxes

Popular Searches

Data Visualization and Analytics

Online

60 Hours

₹ 18000

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

Eligibility criteria

What you will learn

The syllabus

Building blocks and data analytics with Excel

Basic Excel

Basic programming elements

Introduction to basic statistics

Overview of dashboards

Business dashboards creation

RDBMS and SQL(Basics)

Data analysis and reporting

Data manipulation using functions

Data visualization in Excel

Introduction to analytics and data science

Create dashboards in Excel - using Pivot controls

Introduction to Analytics & Data Science

Data manipulation using functions

Data analysis and reporting

Data Visualization in Excel

Create dashboards in Excel - Using Pivot controls

Data analytics with SQL

A quick recap of RDBMS and basic SQL

Apply learning’s on business case study

Data based objects creation (DDL commands)

Data manipulation (DML commands)

Accessing data from multiple tables using SELECT

Advanced SQL

Data Analytics & Visualization with Power BI

Introduction

Data Preparation and Modelling

Data handling & summaries

Building Advanced Reports/ Maps

Calculated Fields

Table Calculations

Parameters

Building Interactive Dashboards

Building Stories

Working with Data

Sharing work with others

Automation with VBA (eLearning)

Introducing VBA

A look at some commonly used code snippets

Programming constructs in VBA

Functions and procedures in VBA - Moedling your programs

Objects and memory management in VBA

Error handling

Controlling accessibility of your code - Access specifiers

Code reusability - adding references and components to your code

How VBA Works with Excel

Key components of programming language

Communicating with your users

Admission details

Filling the form

How it helps

FAQs

What is the duration of the data visualization and analytics online training?

How many classes and projects are included in the data visualization and analytics course curriculum?

Can I pay the data visualization and analytics program fee in installments?

Do the data visualization and analytics course providers offer a loan facility for the students?

What is the dual certification in the data visualization and analytics program?

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms