CERTIFIED DATA ANALYST
COURSE OBJECTIVES - To train and upskill workforce in Data Analytics to facilitate digitization at
COURSE OBJECTIVES
- To train and upskill workforce in Data Analytics to facilitate digitization at the workplace.
- To provide fundamentals of business analytics
- Build informative dashboards
- To build and develop workforce ability to interpret data which helps in making better judgements.
- Understand self-service Business Intelligence.
- Participant also will know to connect to the SQL Server database and execute query.
- Participant also will learn query Data Frame structures for cleaning and processing
- Describe common Python functionality and features used for data science.
MODULES
- CLASSIC DATA ANALYSIS with EXCEL
- SPREADSHEET FUNDAMENTALS
- PREDEFINED FUNCTIONS
- APPLICATION OF DATA VALIDATION
- DATA NORMALIZATION
- PIVOT TABLES
- DATA VISUALIZATION in EXCEL
- BUILD INTERACTIVE EXCEL DASHBOARDS
- EXAMINING DISTRIBUTION
- DESCRIPTIVE STATISTICS
- CONSTRUCTING ADVANCED GRAPHS AND CHARTS
- INTRODUCTION TO STATISTICAL DATA ANALYSIS
- REGRESSION ANALYSIS
- FORECAST ANALYSIS
- INTRODUCTION TO BASIC DATABASE CONCEPTS
- E-R MODELING AND DIAGRAM
- NORMALIZATION
- INTRODUCTION TO SQL SERVER
- INTRODUCTION TO SQL
- PYTHON BASICS
- LOOPS & FUNCTIONS
- UNIT TESTS & CLASSES
- STYLE GUIDES, SCRIPTS, IMPORTS
- INTRODUCTION TO NUMPY
- NUMPY IMPLEMENTATION DETAILS
- INTRODUCTION TO PANDAS
LEARNING OUTCOME
- Use PivotTables and functions effectively to summaries and augment Data in Microsoft Excel
- Assess data distributions and statistical relationships with Microsoft Excel.
- Create interactive visuals
- Visualize data & create dashboards for reporting with Microsoft Excel.
- Build a data model in Python
- Expand Datasets in Python
- Build a database using Data Definition Language Statement Perform basic CRUD operations using Data Manipulation Language statements like insert, update, and delete write and call stored procedures and functions stored in database.
CERTIFICATION
CONVERGENCE CERTIFICATION AND SKILL DEVELOPMENT COUNCIL (CCSD)