Back to Catalog
DC
doomsday.courses
Live Program Pathway

Data Analyst with Gen AI

Analyze faster with AI-powered analytics. Master Excel, SQL, Python, Statistics, and Power BI while learning to implement real-world AI-assisted analytics workflows.

Duration

24 Weeks

Curriculum Modules

8 Modules

Certification

Yes, DC Issued

What You Will Learn

Develop business-critical analytical spreadsheets using Excel
Write highly optimized relational database SQL queries
Build interactive dashboards and tell visual business stories using Power BI
Employ GenAI tools to automate data cleaning, write SQL/Python, and outline findings

Program Prerequisites

Basic computer literacy
High school mathematics and logic concepts

Program Syllabus

Click on any module to review detailed lesson schedules and topics.

01

Excel fundamentals & sorting

Master key concepts and practical exercises in Excel fundamentals & sorting

02

Formulas: XLOOKUP & INDEX/MATCH

Master key concepts and practical exercises in Formulas: XLOOKUP & INDEX/MATCH

03

Pivot tables & visualization

Master key concepts and practical exercises in Pivot tables & visualization

04

Power Query & AI tools

Master key concepts and practical exercises in Power Query & AI tools

Real-World Capstone Projects

Build enterprise grade platforms to display on your developer resume.

EASY Project

Sales Analytics Dashboard

Problem Statement:Analyze raw transactional data to identify high-value customer groups and underperforming sales regions.

Outcome:Interactive dashboard showing key performance indicators and revenue trends.

Tech: Excel, Power Query

Skills: Data Modeling, Pivot Tables, KPIs

MEDIUM Project

Customer Retention & Cohort Analysis

Problem Statement:Analyze subscriber log files to build cohort retention matrices and define churn triggers.

Outcome:Visual heatmap outlining monthly customer retention cohorts.

Tech: SQL, Python, Pandas

Skills: CTEs, Cohort Calculations, Seaborn

HARD Project

AI-Powered Business Intelligence

Problem Statement:Deploy an automated pipeline that extracts insights from sales records and generates natural-language executive briefs.

Outcome:Power BI report with embedded GPT summary models.

Tech: Power BI, OpenAI API, Python

Skills: API Integration, Context Management, Dashboards

Frequently Asked Questions

Is there direct placement assistance?

We offer extensive portfolio builders, resume tailoring, and direct mock reviews with mentors to help you crack analytical interviews.

What tools will I learn?

Excel, PostgreSQL, Python, Pandas, NumPy, Power BI, and OpenAI API frameworks.

Secure Your Program Cohort Seat

Start learning immediately, attend interactive sessions, get mock resume reviews, and query GCP BigQuery/AI sandboxes.

Standard Tuition Fee₹15,999₹29,999
Enroll in Cohort