Professional Certification Course in Advanced Data Visualization and Analysis - Nashik

Course Curriculum

Introduction to Data analysis & Data Visualizations

Data Analytics Overview
Data Visualization for Decision making
Data Analytics in Different Sectors
understanding of the importance of data visualization

MIS with Advance Excel 2019

Excel Essentials
Working with Multiple Worksheet
Cell Referencing
Working with Data Lists
Conditional Formatting

Data Validation
What-If Analysis
Formula Auditing
Protection

Formulas & Functions

Conditional Function
Text & Statistical Function
Financial Function
Date and Time Function

Advanced Filter Methods
Creating HLOOKUP and VLOOKUP Functions
Advanced Conditional Formatting
Advanced Lookup and Reference Functions

Dashboard Designing (MIS)

Charts & Sparkline’s
Use of Power Pivots for Data Analysis
Use of Power Queries & Power Map
Pivot table Dashboard with Slicers
Creating Dashboard with Slicers and Timeline

Automation

Working with External Data
Exporting & Importing Data to
Excel, Access, PPT, TXT, CSV

Updating Charts, Table in PowerPoint
Converting Reports into PDF
Exporting Charts, Tables to PowerPoint

Chat GPT

Introduction ChatGPT with Excel
Enhancing Excel Formulas with ChatGPT
Advanced Formula Assistance with ChatGPT
Data Cleaning and Transformation
Basic Data Analysis Techniques

Macros with VBA

Macro recording
Visual Basic Editor
Understanding Objects, Methods, Properties and Variables
Conditional Statement

Control Structures-Decision
Looping Structures
User Forms and GUI
Worksheet / Workbook Operations
Error Handling

MS-Access

Getting Started with Access
Working with Table Data
Querying a Database
Using Forms
Generating Reports
Designing a Relational Database
Sharing Data Across Applications

Power BI

Introduction to Power BI

What is Power BI
Installing Power BI Desktop
Exploring the Power BI Workflow

Transforming Data with Power BI Desktop

Connecting to different sources
Different connecting Options
Shaping and transforming data with Power Query
Editing, Merging, Appending queries etc.

Modeling with Power BI

Introduction to Modeling
Building Relational Models
Creating table relationships
Understanding the filter flow
Cardinality and Cross filtering

Visualizing Data with Reports

Creating Visualisations
Color & Conditional Formatting
Sort Order
Scatter & Bubble Charts & Play Axis
Tooltips, Slicers
Timeline Slicers & Sync Slicers
Cross Filtering and Highlighting
Visual, Page and Report Level Filters

Drill Down/Up, Hierarchies
Group, Bins and Parameters
Constant Lines
Tables, Matrices Table Conditional Formatting
Map Visualisations

Introduction to DAX

Understanding DAX Syntax
DAX calculation types
DAX functions
Using variables in DAX expressions
Table relationships and DAX
DAX tables and filtering

M Language

IF...ELSE Conditions, Transform Column () Types
Remove Column (), Spilt Columns (), Replace value ()
Table. Distinct option and Group BY option Table.
Group (), Table. Sort () With Type Conversions PIVOT
Operation and Table. Pivot (). List Functions Using
Parameters with M language

Creating Dashboards

Pin Visuals and Pin Live Report Pages to Dashboard
Advantages of Dashboards
Interacting with Dashboards
Formatting Dashboard
Sharing Dashboard

Tableau

Introduction to Tableau

Understanding Working
Architecture & Data Model
Data Connection & Joins
Working with multiple data sources
Data joining and blending

Tableau Interface

Measures and dimension
Shelves
Show me
Data Types
Default Properties
Marks Card
Page Shelf
Difference between. twb and. twbx

Chart Types

Bar Charts & Stacked Bars
Pie Chart
Line Graph with Date
Line Graph without Date
Area charts
Tree Map

Word Cloud
Packed Bubble
Box & Whiskers Plot
Scatter Plots
Highlight tables
Heat maps

Advanced Charts

Waterfall
Funnel
Geographical fields
Map options

Data Formatting

Legends
Highlights
Labelling
Number Formats
Alignment

Advanced Function

Sorting
Groups
Sets
Hierarchy
Reference and Trend Lines
Edit Axis
Bins

Filters

Dimension Filter
Measure Filter
Filter - Display Option
Context Filters
Relevant Filters
Sets in filters
Conditional Filters

Run Time Columns

Calculated Fields
String Calculation
Data Calculation
Logical Calculation
Numeric Calculation
Parameters

Table Calculations
Discrete vs Continuous
Date Aggregations and Date parts
Cross tab
Totals & Subtotals

Dashboards

Dashboard Objects
Dashboard Actions
URL
Highlight
Filter
Publish to Web

Storyline in Tableau

Publish Reports

Data Analysis with Python & R Basics

Visualising Data with Reports

Introduction to Python and its Ecosystem
Setting Up Python Environment (Anaconda, Jupyter)

Python Basics for Data Analysis

Python Libraries installation using PIP
Python Variables, Data Types, and Operators
Control Structures (if statements, loops)
Functions and Libraries in Python
Python Basics -Data & time modules

Python Libraries

Pandas (Series, Data frames)
NumPy (Arrays, Memory, Matrices, Broadcasting, Masked Arrays)
SciPy
Matplotlib

Seaborn
Sklearn (Scikit Learn)
Stats models

Jupyter Notebooks & Data Collection

Jupiter Notebooks
Data Collection (using CSV, JSON, XML, HTML & Scrapping)

Data Wrangling & Summarization

Understanding
Filtering
Typecasting
Transformations & Normalization
Imputation
Handling Duplicates & Categorical Data
Data Summarization

Data Visualisations using Python Packages

Line Chart
Bar Chart
Pie Charts
Box Plots
Scatter Plots
Figures & Subplots
Additional Visualization Packages – bokeh, ggplot, plotly
Python XML and JSON parsers
Basic Images Processing using python OpenCV

Basic of R

Data Types
Data Structures
Data Manipulation
Decision Making Statements
Conditional Loops
Flow Control Statements (If Nested)

Working with Packages
Built Functions in R: (Base, Datasets, Dplyrand, Ggplot)
Reading & Writing Data
String & Date Manipulation
Exploratory, Statistical & Regression Analysis

SQL

Database Management system
SQL Syntax
Data Manipulation Language
Data Query Language
Built in functions in SQL
Sub-Query & Joins

MongoDB

Introduction to NoSQL
Introduction to MongoDB
Data modelling & basic operations
Collections and basic operations on collections
Inserting data into tables
Query document
RDBMS where clause equivalents in MongoDB

Update document
Delete document
Limit records
Shading
Backup and restore
Deployment
Advanced features of MongoDB

GJx: - Our Advanced Certificate Course in Data Visualization and Analysis stands out with its unique selling points (USPs). With a comprehensive curriculum, you'll gain expertise in manipulating, analyzing, and visualizing data. Practical exercises and real-world projects ensure hands-on skill application. Expert instructors with industry experience provide valuable guidance. This career-focused training opens doors to diverse sectors and job roles, empowering you for success in data analysis and visualization.

JAIN: Our Professional Certification Course in Advanced Data Visualization and Analysis provides a comprehensive curriculum that prepares you with the necessary skills to succeed in the field. Through hands-on learning and real-world projects, you'll gain practical experience. With expert instructors who bring industry expertise, you'll receive valuable guidance throughout the course. This career-focused training covers a diverse range of tools and techniques, equipping you for various roles in data visualization and analysis. Upon completion, you'll receive an industry-recognized certification, elevating your professional opportunities.

Enquire Now

Key Highlights