Data Analytics
Course Curriculum
- Excel: Basics to Advanced
- MySQL
- Tableau
- Power BI
- Introduction
- MS office Versions
- Interface
- Row and Columns
- Keyboard shortcuts
- Data Entry
- Formatting options
- Functions & Referencing
- Absolute, Relative, Mixed
- SUM, COUNT, AVERAGE
- Logical Functions
- IF, AND, OR, NOT, IFERROR
- Lookup Functions
- VLOOKUP, HLOOKUP, INDEX, MATCH
- Data Handling
- Sorting, Filtering
- Remove duplicates
- Visualization
- Charts
- Conditional formatting
- Pivot & Dashboard
- Pivot tables
- Dashboard creation
- Power Query & VBA
- Data cleaning
- Macros & automation
- Introduction to Databases & RDBMS
- SQL Commands (DDL, DML, DQL, TCL)
- SELECT, WHERE, JOIN, GROUP BY
- Constraints & Keys
- Stored Procedures & Functions
- Triggers & Exception Handling
- Introduction to Tableau
- Charts & Formatting
- Filters & Calculations
- Joins & Data Blending
- Dashboards & Analytics
- Power BI Installation & Interface
- Data Visualization
- Power Query
- Data Modeling
- DAX Expressions
- Dashboard & Publishing
- Business Statistics
- Fundamentals of R
- Fundamentals of Python
- SAS
- ChatGPT
- Introduction to ChatGPT
- Applications & Use Cases
- AI Concepts
- Prompt Engineering
- Best Practices
