Diploma in Data Analytics

with AI Gen

1.Core And Advanced Excel

Duration: 6 Months

 Mathematical Functions
SUM | SUMIF | SUMIFS | COUNT | COUNTA | COUNTABLANK | COUNTIF |
COUNTIFS | AVERAGE | AVERAGEA | AVERAGEIF | AVERAGEIFS | SUBTOTAL |
AGGREGATE | RAND | RANDBETWEEN | ROUNDUP | ROUNDDOWN | ROUND |
SUMPRODUCT | MOD | SQRT | POWER | FACT | CONVERT | ROMAN
 Text Functions
CHAR | CLEAN | CODE | CONCATENATE | FIND | SEARCH | SUBTITUTE | REPLACE |
LEN | RIGHT | LEFT | MID | LOWER | UPPER | PROPER | TEXT | TRIM | VALUE
 Date & Time Functions
DATE | DAY | MONTH | YEAR | EDATE | EOMONTH | NETWROKDAYS | WORKDAY |
WEEKNUM | WEEKDAY | HOUR | MINUTE | SECOND | NOW | TODAY | TIME
 Logical Functions
AND | OR | IF | IFERROR | NOT | NESTED IF
 Lookup & Reference Functions
VLOOKUP | DOUBLE VLOOKUP | HLOOKUP | INDEX | MATCH | OFFSET | INDIRECT |
ADDRESS | COLUMN | COLUMNS |ROW | ROWS | CHOOSE | ARRAYS | CONCEPT IN
LOOKUP FORMULA’S
 Other Functions
PMT | FV |ISNA | ISBLANK | ISERR | ISEVEN | ISODD | ISLOGICAL | ISTEXT | MAX |
MIN and Other many functions.

 Advanced Excel with AI – Integrating ChatGPT with Excel

What is ChatGPT
How to Integrate ChatGPT in Excel
Practical Applications of ChatGPT in Excel

 Excel Formula’s with AI

*Advanced Excel with AI refers to using artificial intelligence tools and
features within Microsoft Excel to enhance data analysis, automation, and
overall productivity.
*AI can be integrated into Excel through various methods, including built
in features.
*AI tools complex Excel formulas based on natural language prompts or
even explain existing formulas.

 Data Collection Method with Data Quality, Collaboration & Security Like
Share Your Workbook on Share Drive with Quality
 Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables
 Advanced Chat Technique, How to make Dynamic Charts, Bar Charts, Pie
Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart,
Gantt Chart
 Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold
Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
 Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/
Font Color), Conditional Formatting, Data Validation, Group & Ungroup,
Data split.
 Pivot Table and Charts, Import and Export data, Protect/Unprotect
sheets/workbooks. Worksheet formatting and Print Display
 Report Development (Live Project)

2.MYSQL

 Introduction to Basic Database Concepts
 Introduction to SQL Server
 Introduction to SQL
 DDL and DML Statements
 Working with Queries (DQL)
 Aggregate Functions
 Joins and Set Operations
 Working with Constraints
 Implementing Views
 Data Control language (DCL)
 Writing Transact-SQL (T-SQL)
 Working with Stored Procedures
 Backup and Restore

3. Python

 Python- An Introduction
 Python Variables & Data Types
 Operators

 Python Conditional Statements
 Python Looping Concept
 Python Control Statements
 Python Data Type Casting
 Python Number 9. Python String
 Python List
 Python Tuple
 Python Dictionary
 Python Sets
 Python Data & Time
 Python Function
 Module
 File Handling (Input/Output)
 Exception Handling
 OOPs Concepts
 Multithreading
 Python Mail Sending Program
 Regular Expression
 Database Connection
 Interacting with Networks
 GUI (Graphical User Interface)
 Python Web Scrapin

4.MS Power-BI

 Learn to use the easiest Business Intelligence tool to create stunning
reports and dashboards
 Learn how to connect multiple sources of data in Power BI
 Learn M-language user in Power BI
 Learn how to create advanced DAX measures and calculated columns for
complex calculations.
 Learn how to use charts using visuals like column, line, pie, combo,
Funnel, Gauges and KPIs to name a few.
 Learn to create powerful tables and matrix of reporting data.
 Learn how you can visualize that data in a meaningful way to revile insights into your business like never before.
 Learn how to turn data into insight and data into interactive visualizations
to tell a story.
 Learn how to collaborate and share contents on Microsoft’s Powerful
platform.
 This hands-on course will prepare you to start your Data Analytics career