Diploma In Data Analyst
ADVANCED EXCEL
• MS office version ( similarities and difference )
• Interface
• Mathematics calculation with cell referencing ( absolute , relative
and mixed )
• Keyboard shortcut for easy navigation
• Data Entry ( fill series )
• Forma ng Op on – Font, Alignment, Clipboard
• Arithmetic Function – (Sum, SumIf, SumIfs, Count, CountIf S,
Average, AverageIfs, Max, MaxIfs, Min, MinIfs )
• Logical function – IF, AND, OR, NOT, ERROR, Usage of mathematical
and logical function nested together
• V look up
• H look up
• Index
• Index with match function
• Indirect
• Offset
• Nested v look up
• Data validation
• Charts
• Pivot tables
• Basic introduction to VBA and macros
BASIC PROGRAMMING
• Introduction to programming
• Variable and arithmetic expression
• Function
• Data type
• Condition and conditional statement
• Lists
• Oops
DATABASE WITH SQL
• Introduction to MY SQL
• SQL command and data type
• DQL operators
• Case when then and handling NULL values
• Group operation and aggregate function
• Constraints
• Joins
• DDL
• DML and TCL command
• Indexes and views
• Stored procedure
• Function , constructs
• Union, intersect , sub – query
• Exception handling
PYTHON
• Introduction to python, Data types & Opera on in python
• Anaconda installation
• Data type contd, slicing the data
•Inbuilt function in Python, Sets, Sets theory & Regular expression
•Decision making Statement, Loops, function & Lambda function
• Using PANDAS analysis on universities salary data sets
POWER BI
• Power BI Introduction and Installation
• The Power BI user interface, Including types of data sources and visualizationÂ
• Sample dashboard with animation visual
• Power BI artificial intelligence visual & Power BI visualization
• Power query editor & Modeling with Power BI
• Power query editor filters data & customizes the data in Power BI
• Data expression, Custom visuals & Power BI services
TABLEAU
- Introduction to Tableau (how to install Tableau Desktop)
- Basic charts, formatting, Filters, Calculation
- Data source and workspace page & Data combing techniques
- Changing data roles, Visual cues for field
- Data connection in Tableau, Organizing and simplifying data
- Using latitude and longitude field & Heat map
- Using Gan charts, string date logical and arithmetic calculation
- Working with parameter & Creating multiple dashboard
- Connection between dashboard and story & Special field type
- Practices for creative effective dashboard
- Using dashboard ac on, share the work & Custom charts
- Groups, Bins, Hierarchies sets, Parameter & Analytics and Dashboard
- Dashboard action, Tableau public & Tableau generated fields
- Organizing and Simplifying data
- Formatting and Annotation
R PROGRAMMING
- Introduction to R, Installation of R studio & Data types in R
- Decision making statement, Loops, Function & Built in function in R
- Join, DPLYR, Ggplot2 & Program flow control in R
- Array and string programming in R & Data reshaping and data frames
- Oops and error handling in R & GUI design
GOOGLE SHEET
- Introduction to Google Sheets interface and navigation
- Creating, opening, and saving spreadsheets
- Formatting cells, rows, and columns
- Using formulas and functions (e.g., SUM, AVERAGE, IF, VLOOKUP)
- Managing and sorting data
- Working with multiple sheets within a workbook
- Inserting and manipulating charts and graphs
- Collaboration features such as sharing and commenting
- Data validation and conditional formatting
- Importing and exporting data
- Working with pivot tables
- Automation with Google Apps Script
- Advanced functions and formulas (e.g., INDEX-MATCH, ARRAYFORMULA)
- Protecting sheets and cells
- Tips and tricks for efficient spreadsheet management
- Real-world examples and case studies
- Troubleshooting common issues in Google Sheets
- Integration with other Google Workspace applications (e.g., Google Forms,
Google Docs) - Best practices for organizing and maintaining spreadsheets
BUSINESS STATISTICS
- Descriptive statistics, Probability, Normal distribution
- Inferential distribution & Data cleaning and insights
CHAT GPT AND GENERATIVE AI
- Evaluate production method in statisticsÂ
- Using Chat GPT to generate prompt
- Chat GPT Prompt Engineering
- Types of AI and Chat GPT Architecture
- Introduction to Chat GPT and AI
SAS (STATISTICAL ANALYSIS SYSTEM)
- Basic knowledge of SAS & Software for data analysis and report writing
- Spread sheet and database & Statistical analysis in tables, graph and
PDF documents
