EDUCADD’S SYLLABUS FOR

DATA
ANALYTICS
02
EduCADD | THINKWorks

Who We Are
At EduCADD, we’re not just an institution; we’re a pathway
to limitless possibilities. With over 25 years of dedicated
service in the field of education, we have been unwavering
in our commitment to nurturing inquisitive minds and
empowering individuals to unlock their fullest potential.

160+ 25+ 90% 100000+

Centers across India Your of success Placement Record Happy Students
03
EduCADD | THINKWorks

Course Summary
A 360-degree Learning experience designed for geeks
who wish to get hands-on Data Analytics. Mentored by
industry experts; learn to apply Data Analytics methods
and techniques, and acquire analytical skills. So Master
the Art of Data Analytics and Data Visualization Now!

Students will become proficient in the statistical

analysis of data and the use of computation tools for
data analysis.
Students will apply statistical and computational
tools to applied problems, and communicate the
results in both written reports and oral
presentations.
Students will understand the importance of proper
data management, documentation of work to allow
reproducibility of results, and how to assess the
ethical considerations of a data science project.

Prerequisites:
Freshers from any domain with good analytical and
logical skills.
EduCADD | THINKWorks 04

Course Syllabus
Part 1

Advanced Excel
EduCADD | THINKWorks 05

Module 1 - Advanced Excel

• Introduction
MS office Versions(similarities and differences)
Interface(latest available version)
Row and Columns
Keyboard shortcuts for easy navigation
Data Entry(Fill series)
Find and Select
Clear Options
Ctrl+Enter
Formatting options(Font,Alignment,Clipboard(copy,
paste special))
• Referencing, Named ranges, Uses,Arithmetic Functions
Mathematical calculations with Cell
referencing(Absolute,Relative,Mixed)
Functions with Name Range
Arithmetic
functions(SUM,SUMIF,SUMIFS,COUNT,COUNTA,COU
NTIFS,AVERAGE,AVERAGEIFS,MAX,MAXIFS,MIN,MINI
FS)
• Logical functions
Logical functions: IF, AND,OR, NESTED IFS, NOT
Usage of Mathematical and Logical functions nested
together
EduCADD | THINKWorks 06

• Advanced functions
Combination of Arithmetic
Logical
Lookup functions
Data Validation(with Dependent dropdown)
• Date and Text Functions
Date Functions: DATE, DAY, MONTH, YEAR, YEARFRAC,
DATEDIFF, EOMONTH
Text Functions: TEXT, UPPER, LOWER, PROPER, LEFT,
RIGHT, SEARCH, FIND, MID, TTC, Flash Fill
• Referring to data from different tables: Various types of Lookup,
Nested IF
LOOKUP
VLOOKUP
HLOOKUP
INDEX
INDEX WITH MATCH FUNCTION
INDIRECT
OFFSET
EduCADD | THINKWorks 07

Data Handling::Data cleaning, Data type identification, Remove

Duplicates, Formatting and Filtering
Number Formatting(with shortcuts)
CTRL+T(Converting into an Excel Table)
Formatting Table
Remove Duplicate
SORT
Advanced Sort
FILTER
Advanced Filter
Data Visualization: Conditional Formatting, Charts
Conditional formatting(icon sets/Highlighted colour sets/Data
bars/custom formatting)
Charts:Bar,Column,Lines,Scatter,Combo,Gantt,Waterfall,pie
Data Summarization: Pivot Report and Charts
Pivot Reports:Insert,Interface,Crosstable Reports;Filter,Pivot
Charts,
Slicers:Add,Connect to multiple reports and charts
Calculated field, Calculated item
Data Summarization: Dashboard Creation, Tips and Tricks
Dashboard:Types,Getting reports and charts together, Use of
Slicers.
Design and placement: Formatting of
Tables,Charts,Sheets,Proper use of Colours and Shapes
EduCADD | THINKWorks 08

Data Handling::Data cleaning, Data type identification, Remove

Duplicates, Formatting and Filtering
Number Formatting(with shortcuts)
CTRL+T(Converting into an Excel Table)
Formatting Table
Remove Duplicate
SORT
Advanced Sort
FILTER
Advanced Filter
Data Visualization: Conditional Formatting, Charts
Conditional formatting(icon sets/Highlighted colour sets/Data
bars/custom formatting)
Charts:Bar,Column,Lines,Scatter,Combo,Gantt,Waterfall,pie
Data Summarization: Pivot Report and Charts
Pivot Reports:Insert,Interface,Crosstable Reports;Filter,Pivot
Charts,
Slicers:Add,Connect to multiple reports and charts
Calculated field, Calculated item
Data Summarization: Dashboard Creation, Tips and Tricks
Dashboard:Types,Getting reports and charts together, Use of
Slicers.
Design and placement: Formatting of
Tables,Charts,Sheets,Proper use of Colours and Shapes
EduCADD | THINKWorks 09

VBA and Macros

Editing Macros
VBA:Introduction to the basics of working with VBA for
Excel: Subs, Ranges, Sheets
Comparing values and conditions
if statements and select cases
Repeat processes with For loops and Do While or Do
Until Loops
Communicate with the end-user with message boxes and
take user input with input boxes, User Form
EduCADD | THINKWorks 10

Course Syllabus
Part 2

SQL
EduCADD | THINKWorks 11

Module 1: SQL Overview

1. What is SQL?
2. SQL Process
3. SQL Commands
Module 2: SQL - RDBMS Concepts
4. What is RDBMS?
5. SQL Constraints
6. Data Integrity
7. Database Normalization
8. First Normal Form (1NF)
9. Second Normal Form (2NF)
10. Third Normal Form (3NF)
Module 3: SQL - RDBMS Databases
11. MySQL
12. MS SQL Server
13. ORACLE
14. MS ACCESS
Module 4: SQL Syntax
15. Various Syntax in SQL
Module 5: SQL Data Types
16. SQL Data Types
Module 6: SQL Operators
17. What is an Operator in SQL?
18. SQL Arithmetic Operators
19. Arithmetic Operators – Examples
20. SQL Comparison Operators
21. Comparison Operators – Examples
22. SQL Logical Operators
23. Logical Operators – Examples
EduCADD | THINKWorks 12

Module 7: SQL Expressions

24. Boolean Expressions
25. Numeric Expressions
26. Date Expressions
Module 8: SQL Database Management
27. CREATE Database
28. DROP or DELETE Database
29. SELECT Database, USE Statement
Module 9: SQL Table Management
30. CREATE Table
31. Creating a Table from an Existing Table
32. DROP or DELETE Table
Module 10: SQL Queries and Clauses
33. INSERT Query
34. SELECT Query
35. WHERE Clause
36. AND & OR Conjunctive Operators
- The AND Operator
- The OR Operator
37. UPDATE Query
38. DELETE Query
39. LIKE Clause
40. TOP, LIMIT, or ROWNUM Clause
41. ORDER BY Clause
42. Group By
43. DISTINCT Keyword
44. SORTING Results
EduCADD | THINKWorks 13

Module 11: SQL Constraints

45. NOT NULL Constraint
46. DEFAULT Constraint
47. UNIQUE Constraint
48. Primary Key
49. Foreign Key
50. CHECK Constraint
51. INDEX Constraint
52. Dropping Constraints
53. Integrity Constraints
Module 12: SQL Joins
54. INNER JOIN
55. LEFT JOIN
56. RIGHT JOIN
57. FULL JOIN
58. SELF JOIN
59. CARTESIAN or CROSS JOIN
Module 13: SQL Unions and Set Operations
60. UNION ALL Clause
61. INTERSECT Clause
62. EXCEPT Clause
Module 14: SQL Null Values and Aliases
63. NULL Values
64. Alias Syntax
Module 15: SQL Indexing and Table Alterations
65. CREATE INDEX Command
66. DROP INDEX Command
67. INDEX Constraint
68. ALTER TABLE Command
69. TRUNCATE TABLE Command
EduCADD | THINKWorks 14

Module 16: SQL Views

70. Creating Views
71. WITH CHECK OPTION
Module 17: SQL Filtering and Transactions
72. HAVING Clause
73. Properties of Transactions
74. Transactional Control Commands
Module 18: SQL Subqueries
75. Subqueries with SELECT Statement
76. Subqueries with INSERT Statement
77. Subqueries with UPDATE Statement
78. Subqueries with DELETE Statement
Module 19: Practice Sessions and Final Delivery
79. Practice Session 1
80. Practice Session 2
81. Practice Session 3
82. Practice Session 4
83. Final Output and Delivery
EduCADD | THINKWorks 15

Course Syllabus
Part 3

Python
EduCADD | THINKWorks 16

Module 1: Python Basics

1. Variable Types
2. Basic Operators
Module 2: Control Flow
1. Decision Making
2. Loops
Module 3: Data Structures
1. Strings
2. Python Lists
3. Dictionary
Module 4: Functions and Modular Programming
1. Functions
2. Modules
Module 5: Exception Handling
1. Exceptions Handling
Module 6: Advanced Python
1. Object-Oriented Programming (OOP)
2. MySQL Database Access
Module 7: Practice and Final Delivery
1. Practice Sessions
2. Final Output and Delivery
EduCADD | THINKWorks 17

Course Syllabus
Part 4

PowerBI
EduCADD | THINKWorks 18

Module 1 - Power BI Introduction

Introduction to Power BI Desktop
Getting data (Excel and RDBMS, Web, SharePoint)
Naming for Q&A
Direct Query vs Import data
Module 2 - Modelling With Power BI
Introduction to Modelling
Set up and Manager relationships
Cardinality and cross filtering
Creating hierarchy in the model
Default summarization and sort by
Creating calculated columns
Creating measures and quick measures
Module 3 - Power BI Desktop Visualizations
Creating visuals
Colour and conditional formatting
Setting sort order
Scatter and bubble charts and play axis
Tool tips
Slicers, timeline Slicers and sync Slicers
cross filtering and highlighting
Visual, Page and Report level filters
Drill down/up
Hierarchies
Constant Lines
Tables, Matrix and Table conditional formatting
KPI’s, Cards and Gauges
Map Visualizations
Custom visuals
Managing and Arranging
Drill Through
Custom Report themes
Grouping and binning
Bookmark and buttons
EduCADD | THINKWorks 19

Module 4 -DAX Expressions

Introduction to Dax (how to write Dax and basic
functions in Power BI)
Important Dax used in Power BI along with its
applications.
how to create calculated columns and measures in
Power BI and differences in its application
Scenarios with Questions on Dax & explanation
Creating date dimension in Power BI using calendar
functions and its importance
Module 5 - Publishing And Sharing
Sharing options
Publish from Power BI Desktop
Publish reports to Web
Sharing reports and Dashboards
Workspaces
Apps
Printing, PDF and exports
Row level Security
Exporting data from Visualizations Refreshing
Datasets
Understanding data refresh
Gateways
Don't miss this opportunity to acquire in-demand skills
and become a proficient data scientist with Data
Visualization expertise. Enroll now and take the first step
toward a rewarding career in data science.

contact@educadd.net

www.thinkworks.co.in