.png)
Certified AI-Powered Data Analyst (CAPDA Lite)
CAPDA Lite is a 40-hour foundational to intermediate course designed for professionals, students, and career switchers who want to gain hands-on skills in data analysis—quickly and effectively. This course blends essential tools like Excel, SQL, Power BI, and Python with cutting-edge AI integrations like ChatGPT, Copilot, and AI-powered dashboards, preparing you for the data-driven jobs of today.What You'll Learn
From mastering Excel and SQL to building interactive Power BI dashboards and writing Python scripts for analysis, CAPDA Lite covers it all. You'll also explore prompt engineering and how to use AI tools to automate reports, generate code, and uncover data insights. The course wraps up with a real-world capstone project, helping you build your first portfolio piece for LinkedIn and GitHub.
KEY BENEFITS
- Learn job-ready tools like Excel, SQL, Power BI & Python
- Integrate AI like ChatGPT and Copilot into your workflow
- Build a strong foundation for analytics and business intelligence roles
- Gain confidence through hands-on projects and expert guidance
- Get support with resume building, LinkedIn profile, and career prep.
Module 0: Orientation & Career Scope (1 Hour)
Who is a Data Analyst? Responsibilities & Roles
Career pathways: Analyst, BI Developer, Data Scientist
Overview of Tools: Excel, SQL, Power BI, Python, AI
Job preparation roadmap (LinkedIn, GitHub, Resume)
Module 1: Excel & Advanced Excel (8 Hours)
Key Topics:
Basic Operations: Data types, formatting, filtering
Formulas: IF, IFS, SUMIFS, COUNTIFS, TEXT functions
Lookup Functions: VLOOKUP, INDEX-MATCH, XLOOKUP
Power Query: Importing, cleaning, merging data
Pivot Tables & Charts: Grouping, filtering, dashboards
AI Integration:
“Analyse Data” in Excel
Using ChatGPT to generate formulas
Auto summary writing from Excel tables
Module 2: SQL for Analysts (6 Hours)
Key Topics:
Database basics & relational models
SELECT, WHERE, ORDER BY, GROUP BY
INNER JOIN, LEFT JOIN, UNION, DISTINCT
Filtering, sorting & aggregating
Hands-on exercises with mock HR/Sales databases
AI Integration:
Using ChatGPT or Gemini to write SQL queries from plain English
Auto SQL explanations and optimization tips
Module 3: Power BI & Dashboards (8 Hours)
Key Topics:
Power BI Desktop Interface
Importing data from Excel, Web, and SQL
Visualizations: bar, line, pie, matrix, KPI
Slicers & Filters for interactivity
Introduction to DAX (basic calculated columns/measures)
Creating a simple, interactive dashboard
AI Integration:
Power BI AI visuals: Q&A, Smart Narrative, Key Influencers
Copilot to explain data patterns
Module 4: Python for Data Analysis (6 Hours)
Key Topics:
Python setup and IDE (Jupyter or Google Colab)
Variables, data types, conditions, loops
Intro to Pandas: read_csv, head(), describe(), filtering
Basic data cleaning & summary reports
Simple visualizations with matplotlib
AI Integration:
Use ChatGPT to generate beginner Python code
Code explanation and bug fixing via CoPilot
Module 5: AI Tools & Prompt Engineering (4 Hours)
Key Topics:
What is Prompt Engineering?
Prompt writing for Excel, SQL, Python tasks
ChatGPT for report automation, formula generation
AI assistants for data cleaning and insight generation
Module 6: Capstone Project (4 Hours)
Choose 1 domain (Retail, HR, Sales, Finance)
Use Excel + SQL + Power BI to solve a real-world problem
Create report + dashboard
Document your workflow using AI
Final review + LinkedIn/GitHub upload
CERTIFICATION
Certified By ACMIT (American Council on Management and Information Technology), USA.
DURATION
Total Duration: 40 Hours
Additional Details
Duration: 40 Hours | Level: Foundation to Intermediate
Payment We Accept
