About Course
Welcome To Data Analyst Training
Course Content
EXCEL Module 1: Excel fundamentals
-
Overview of Excel interface
05:09 -
Cells, rows, columns, and sheets
02:36 -
Navigation and basic shortcuts
03:46 -
SUM, AVERAGE, COUNT functions
04:52 -
Basic arithmetic operations
06:49 -
Relative and absolute cell references
05:38 -
Cell formatting (font, color, borders)
08:06 -
Number formatting
07:08 -
Conditional formatting
04:54
Module 2: Data Management and Analysis
Module 3: Advanced Formulas and Functions
Module 4: Advanced Data Analysis
Module 5: Visualizations and Charts
SQL Module 1: Introduction to Databases
Module 2: SQL Basics
Module 3: Advanced SQL Queries
Module 4: Database Design and Normalization
Module 5: Stored Procedures and Functions
Module 6: Triggers and Views
Module 7: Indexing and Query Optimization
Module 8: Advanced Topics in SQL
Module 9: SQL Best Practices and Performance Tuning
Power BI Module 1: Introduction to Power BI
Module 2: Getting Started with Power BI Desktop
Module 3: Data Modeling in Power BI
Module 4: Building Visualizations in Power BI
Module 5: Advanced Power BI Features
Module 6: Power BI Service and Collaboration
Module 7: Power BI Administration and Maintenance
Module 8: Power BI Best Practices and Optimization
Student Ratings & Reviews
No Review Yet