Accord info Matrix – DataAnalyst Stack - Syllabus

Python
Python Introduction
Overview of Python
History and Features of Python - Python 2 vs Python 3 - Use Cases and Applications of
Python - Setting Up the Environment - Installing Python - Basic Command-Line Usage -
Writing Your First Program - Understanding the Python Interpreter - Writing a simple "Hello,
World!" program - Running Python scripts -

Python Variables and Data Types

Variables in Python - Variable Naming Convention - Dynamic Typing vs Static Typing - Data
Types - Basic Data Types: Integers, Floats, Strings, Booleans - Composite Data Types:
Lists, Tuples, Sets, Dictionaries - Type Conversion and Type Checking - Data Type
Operations - Arithmetic Operations on Numbers - String Manipulation Techniques -
Common List and Tuple Methods

Python Control Flow Statements

`if`, `elif`, and `else` Statements - Nested Conditions - Ternary Operator - `for` Loops:
Iterating through lists, tuples, strings, and dictionaries -`while` Loops: Usage and
examples - Loop Control Statements: `break`, `continue`, and `pass`

Comprehensions
List Comprehensions - Dictionary Comprehensions - Set Comprehensions

Python Predefined Functions for List, Set, Tuple

List Functions - Common List Methods: `append()`, `extend()`, `insert()`, `remove()`,
`pop()`, `sort()`, `reverse()`- List Slicing and Indexing - Set Functions - Set Operations:
Union, Intersection, Difference - Common Set Methods: `add()`, `remove()`, `discard()`,
`clear()`, `copy()` - Tuple Functions - Tuple Characteristics: Immutable Nature-
Common Tuple Methods: `count()`, `index()`- Tuple Packing and Unpacking - Dictionary
and String Manipulation - Creating and Accessing Dictionaries - Common Dictionary
Methods: `get()`, `keys()`, `values()`, `items()`, `update()`- Dictionary
Comprehensions - String Methods - `len()`, `strip()`, `split()`, `join()`, `replace()`,
`find()`, `format()`- String Formatting: f-strings, `.format()`, and `%` formatting

User-Defined Functions
Defining Functions - Syntax of Function Definition - Parameters and Arguments - Return
Statement - Function Scope and Lifetime - Local vs Global Variables - The `global`
keyword - Lambda Functions - Syntax and Usage of Lambda Functions - When to Use
Lambda Functions – Recursion – Why Recursion? – Where to use recursion?
Accord info Matrix – DataAnalyst Stack - Syllabus

Docstrings and Annotations

Writing Docstrings for Documentation- Function Annotations for Type Hints

Higher-Order Functions
Functions as First-Class Citizens - Using `map()`, `filter()`, and `reduce()`

Python Modules and Packages

Modules - What are modules in Python? - Importing modules (`import`, `from ... import`)
- Standard library modules (e.g., `math`, `random`, `os`, etc.) - Creating and using your
own modules - Aliasing modules (`import module as alias`) - Module search path and
`sys.path`- Packages - Introduction to packages - Directory structure for packages -
`__init__.py` and its role in packages - Importing from a package - Using sub packages

Python File Handling

Basics of File Handling - Types of files: Text and Binary - Opening a file (`open()` function,
modes like `r`, `w`, `a`, etc.) - Reading from a file (`read()`, `readline()`, `readlines()`)
- Writing to a file (`write()`, `writelines()`) - File Operations - Closing files (`close()`) - File
handling using `with` statement (context managers) - Handling file exceptions (`try`,
`except` blocks for file operations - Advanced File Handling - Working with binary files -
Moving, renaming, and deleting files using `os` and `shutil` modules - File paths and
directories (`os.path`, `pathlib`) - Working with CSV files (`csv` module) - Working with
JSON files (`json` module) - File compression (`zipfile`, `gzip`)

Python Regular Expressions (Regex)

Introduction to Regex - What is a regular expression? - `re` module in Python - Basic
Patterns - Literal characters - Metacharacters and special sequences - Character classes,
sets, and ranges - Quantifiers (`*`, `+`, `?`, `{}`) - Anchors (`^`, `$`) - Common Regex
Functions in Python - `re.match()`, `re.search()`, `re.findall()`, `re.finditer()` -
`re.sub()` for substitutions - `re.split()` for splitting based on regex patterns - Compiling
regular expressions (`re.compile()`

Python Exception Handling

Introduction - What are exceptions? - Exception vs Syntax Error - Basic Exception
Handling - `try`, `except` block - Handling multiple exceptions - `else` clause in
exception handling - `finally` block (cleanup actions) - Built-in Exceptions - Common
built-in exceptions (`ZeroDivisionError`, `FileNotFoundError`, `IndexError`, `KeyError`,
etc.) - Exception hierarchy (`BaseException`, `Exception`, etc.) - Raising Exceptions -
Raising exceptions using `raise`- Custom error messages - Custom Exceptions - Defining
user-defined exceptions - Creating custom exception classes
Accord info Matrix – DataAnalyst Stack - Syllabus

Python OOPs (Object-Oriented Programming)

Introduction to OOPs Concepts - Class and Objects - Attributes and Methods (Instance
and Class variables) - `self` parameter - Principles of OOP – Encapsulation - Abstraction
- Inheritance (Single, Multiple, Multilevel) - Polymorphism (Method overloading, Method
overriding) - Composition and Aggregation-Advanced OOP Concepts - Special methods
(`__init__()`, `__str__()`, `__repr__()`, etc.) - Static methods and Class methods - Property
and Getter/Setter methods (`@property`, `@setter`) - Operator overloading (`__add__`,
`__lt__`, etc.) - Understanding `super () ` and MRO

Python Collections and Data Structures

Built-in Data Structures – Lists – Tuples – Sets – Dictionaries - Advanced Collections -
`collections` module - `namedtuple()`- `deque()`- `Counter()` - `defaultdict()` -
`OrderedDict()`- `ChainMap()`- Stacks (using lists or `deque`) - Queues (using `deque`
or `queue` module) - Linked lists (singly and doubly linked lists implementation) - Trees
(basic implementation of binary trees, binary search trees)
Accord info Matrix – DataAnalyst Stack - Syllabus

SQL
Introduction and Installation
Introduction to Databases - What is a Database? Importance of databases in applications
- Introduction to Database Management Systems (DBMS) - Types of DBMS: Relational,
NoSQL, Object-Oriented, etc. - Overview of SQL and its role in relational databases
(RDBMS

Introduction and Installation

Introduction to SQL Server - What is SQL Server? Overview of RDBMS concepts - Overview
of different SQL Server Editions (Express, Standard, Enterprise) - SQL Server Management
Studio (SSMS) Introduction and Setup. - Installing and using SQL Server Management
Studio (SSMS) for database management

DDL (Data Definition Language)

Creating and Modifying Databases – Creating and Modifying Tables - Table Constraints -
- Primary Keys (`PRIMARY KEY` constraint) - Foreign Keys (`FOREIGN KEY` constraint) -
Unique Constraints (`UNIQUE` constraint) - Default Values (`DEFAULT` constraint) -
Check Constraints (`CHECK` constraint). - Operators, Data Types, and Type Conversion -
Arithmetic Operators - Comparison Operators - Logical Operators – BETWEEN, IN, LIKE for
pattern matching - IS NULL and IS NOT NULL operators. - SQL Server Data Types - Type
Conversion

DML (Data Manipulation Language

Inserting Data - Updating Data - Deleting Data

DQL (Data Query Language)

Basic Querying with `SELECT - Filtering Data with `WHERE - Sorting Results Using
`ORDER BY` to sort records in ascending (`ASC`) and descending (`DESC`) order. -
Conditional Logic with `CASE`- Using Aggregate Functions - Group By, Having, - Difference
between `WHERE` and `HAVING`- Using `HAVING` with aggregate functions.

Predefined Functions (String, Date/Time Functions

Common string functions: `LEN()`, `SUBSTRING()`, `CHARINDEX()`, `UPPER()`,
`LOWER()`, `REPLACE()`, `LEFT()`, `RIGHT()` - Concatenating strings with `+` or
`CONCAT()`. Date/Time Functions in SQL Server - Getting the current date/time
(`GETDATE()`, `SYSDATETIME()`) - Adding/subtracting dates (`DATEADD()`) - Finding the
difference between dates (`DATEDIFF()`) - Extracting parts of a date (`YEAR()`,
`MONTH()`, `DAY()`)
Accord info Matrix – DataAnalyst Stack - Syllabus

Joins in SQL Server

Introduction to Joins - What are joins? Why do we use them - Types of Joins - INNER JOIN,
LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN

Transaction Control and Permission

Understanding Transactions - `BEGIN TRANSACTION` - `COMMIT TRANSACTION`-
Committing the transaction - `ROLLBACK TRANSACTION` - `SAVEPOINT` - SQL Server
Privileges and Subqueries - Granting Permissions - Revoking permissions - Role-based
permissions in SQL Server.

Subqueries and Index in SQL Server

Using subqueries in `SELECT`, `WHERE`, `FROM`, and `HAVING` clauses - Correlated
Subqueries vs Non-Correlated Subqueries - Subqueries in `JOIN` conditions - Indexes -
Creating indexes - Removing indexes - Clustered vs Non-Clustered Indexes. - Impact of
indexes on performance (index maintenance, over-indexing).

Database Objects
Views – Creating Views - Modifying views – Removing Views - Using views for complex
query simplification - Stored Procedures - Creating stored procedures - Executing stored
procedures (`EXEC`) - Input/output parameters in stored procedures - Error handling in
stored procedures with `TRY...CATCH – Triggers - Creating triggers `INSERT`, `UPDATE`,
`DELETE` operations - BEFORE and AFTER triggers.
Accord info Matrix – DataAnalyst Stack - Syllabus

Tableau
Introduction to Tableau
What is Tableau - Overview of Tableau Products: Tableau Desktop, Tableau Online, Tableau
Server, Tableau Public - Why Tableau - Tableau vs. Traditional Reporting Tools - Tableau
Ecosystem Overview

Installation and Environment Setup

System Requirements and Installing Tableau Desktop - Setting Up Tableau Public (for Free
Use) - Tableau Interface Overview - Data Pane, Shelves, Cards, and Worksheet Navigation

Connecting to Data
Supported Data Sources: Excel, CSV, Databases, and Cloud Platforms - Live vs. Extract
Connections - Managing Data Connections: Updating, Replacing, and Extracting Data -
Connecting to Sample Superstore Dataset

Data Preparation and Cleaning

Data Preparation Tools - Understanding Dimensions and Measures - Renaming Fields,
Assigning Aliases - Splitting Columns, Grouping, and Creating Sets - Data Cleaning -
Handling Null Values and Duplicates - Filtering and Sorting Data - Pivoting and Unpivoting
Data

Tableau Data Modeling

Introduction to Data Modeling Concepts in Tableau - Managing Joins: Inner, Left, Right, and
Full Outer Joins - Blending Data from Multiple Sources - Relationships and Logical Layer
Modeling (Tableau’s New Data Model) - Unioning Tables

Tableau Calculations and Functions

Basic Calculations - Calculated Fields and Aggregations - Arithmetic Calculations (e.g.,
Profit Ratios, Percentages) - Table Calculations - Running Totals, Moving Averages, and
Percent of Total - Advanced Functions: Logical Functions: IF, CASE, ZNULL - String
Functions: CONCAT, LEFT, RIGHT, MID - Date Functions: TODAY, DATEDIFF, DATENAME -
LOD (Level of Detail) Expressions: FIXED, INCLUDE, EXCLUDE

Visual Analytics
Creating Visualizations: Bar Charts, Line Charts, Scatter Plots, and Pie Charts - Heat Maps,
Tree Maps, Bubble Charts - Advanced Visualizations: Dual-Axis Charts, Waterfall Charts,
Bullet Graphs - Geospatial Visualizations: Maps and Custom Territories - Enhancing
Visuals: Formatting Options: Fonts, Colors, and Layout - Adding Labels, Annotations, and
Tooltips
Accord info Matrix – DataAnalyst Stack - Syllabus

Interactivity in Tableau
Filters: Quick Filters, Context Filters, and Top N Filters - Parameters: Creating and Using
Parameters for Interactivity - Dashboard Interactivity: Actions: Filter, Highlight, and URL
Actions

Dashboards and Stories

Building Dashboards: Adding Worksheets to Dashboards - Adjusting Layouts and Sizing for
Responsiveness - Dashboard Best Practices: Designing for User Experience - Using
Containers for Alignment - Creating Stories: Telling a Data Story with Tableau Stories -
Adding Annotations and Descriptions

Tableau Maps and Geospatial Analytics

Working with Geographic Data - Creating Maps with Geographic Dimensions - Advanced
Mapping: Custom Territories, Path Maps, and Heat Maps - Integrating Map Layers

Tableau Server and Tableau Online

Publishing Workbooks to Tableau Online or Tableau Server - Managing Permissions and
Sharing Dashboards - Automating Data Refresh for Extracts - Collaboration and User Roles
in Tableau Server

Performance Optimization
Best Practices for Extracts and Joins - Using the Performance Recorder Tool - Advanced
LOD Calculations: Row-Level, Aggregate-Level, and Nested LOD Expressions -
Integrations: Connecting Tableau with R and Python for Advanced Analytics - Tableau Prep
for Data Preparation - Embedded Analytics: Embedding Tableau Visuals in Applications

End-to-End Project
Connect to a Dataset - Prepare and Clean Data - Create Calculations and Visualizations -
Build an Interactive Dashboard - Publish and Share on Tableau Public or Online