SkillManthan Logo - Best IT Training Institute in Lucknow
Loading your future skills...
+91-6392-361-443,+91-9120-341-047
theskillmanthan@gmail.com
Development Website
Our Placements Download Brochure
Register Now Skill Test
Verify Certificate Register Now
Download Courses - SkillManthan Technologies Pvt Ltd
Data Analyst Course Banner

Data Analyst (Excel + SQL + Power BI)

Learn data analysis from scratch — work with Excel, SQL, and Power BI to analyze data, create dashboards, and generate business insights.

Course Description

This course covers the complete Data Analyst workflow including Excel for data handling, SQL for data extraction, and Power BI for visualization. You will work on real datasets and build professional dashboards.

Detailed Course Syllabus

L.N. Contents Hours
1
  1. Introduction to Data Analysis
  2. Role of Data Analyst
  3. Data Types & Sources
 2
2
  1. Microsoft Excel Basics
    • Formulas & Functions
    • Sorting & Filtering
    • Conditional Formatting
 3
3
  1. Advanced Excel
    • Pivot Tables
    • Charts & Dashboards
    • Data Cleaning
 3
4
  1. SQL for Data Analysis
    • SELECT Queries
    • Joins
    • Aggregate Functions
 3
5
  1. Advanced SQL
    • Subqueries
    • Views
    • Performance Basics
 3
6
  1. Power BI Basics
    • Data Import
    • Data Transformation
    • Basic Visualizations
 3
7
  1. Advanced Power BI
    • DAX Functions
    • Interactive Dashboards
    • Report Publishing
 3
8
  1. Data Visualization
    • Best Practices
    • Storytelling with Data
 2
9
  1. Real Projects
    • Sales Dashboard
    • Business Analytics Case Study
 3
10
  1. Portfolio Building
  2. Resume Preparation
  3. Interview Questions
 2
11
  1. Mock Interviews
  2. Placement Preparation
 2