Data Analyst Program
Real Skills. Real Tools. Real Opportunities. A 45-day job-ready program for IT and Non-IT professionals. Query data with SQL, build interactive dashboards in Power BI with Copilot, create business apps with Power Apps, and automate analysis with Python and AI.
- Live Online Interactive Classes
- Free LMS Access
- Lifetime Recordings
- Placement Support
Who Should Join the Data Analyst Program?
Designed for both IT and Non-IT backgrounds. No coding experience needed — we start from the basics of data and build up step by step.
Students & Freshers
Graduates from any stream (B.Com, BBA, B.Sc, B.Tech and more) starting a career in data analytics.
Non-IT Professionals
Finance, sales, HR, operations and marketing professionals moving into high-demand analytics roles.
IT Professionals
Developers, testers and support engineers adding SQL, BI and AI-driven analytics to their skill set.
Business Analysts
Automate reporting, build interactive dashboards and deliver actionable insights faster with Copilot.
Excel Power Users
Go beyond spreadsheets with SQL databases, Power BI data models, and Python automation.
Managers & Owners
Track KPIs, monitor business performance and make data-driven decisions with your own dashboards and apps.
4 In-Demand Technologies. One Complete Analyst Skill Set.
Each tool covers one stage of real analytics work — from pulling data to presenting insights and automating the job.
SQL for Power BI
Extract, filter, join and shape business data from databases — and connect it directly to Power BI.
Power BI with Copilot
Power Query, data modeling, DAX, interactive dashboards, Power BI Service — plus AI-assisted reporting with Copilot.
Power Apps
Build low-code business apps for data entry and workflows, and connect them to your Power BI dashboards.
Python with AI
Analyse data with Pandas, visualise it, use Generative AI as your analysis assistant and build simple ML models.
What We Train & How We Train It
A structured, hands-on approach that takes you from data basics to job-ready analyst in 45 days.
Live Instructor-Led Classes
90-minute interactive sessions every weekday. Every concept — from SQL joins to DAX to Python — is built live on screen with Q&A.
Hands-On Labs on Our LMS
Practise every topic on kacademy.kalkitec.com right after class, so concepts become muscle memory before the next session.
Real Industry Datasets
Work on realistic business data such as our Indian E-Commerce Sales dataset, mirroring what you will see on the job.
Copilot & Generative AI
Learn to use Copilot in Power BI and AI assistants for SQL, DAX and Python — the way modern analysts actually work.
1-on-1 Doubt Resolution
Stuck on a query, a formula or a visual? Book a 1-on-1 session with a trainer instead of waiting for the next class.
Capstone, Resume & Mock Interviews
Finish with an end-to-end capstone project, an interview-ready resume, mock interviews and placement guidance.
KAcademy — Powered by KALKI TEC
Every student gets free access to kacademy.kalkitec.com, our in-house learning & practice portal, for the full duration of the program.
- Concept-wise theory notes for every topic
- Guided practice labs on real datasets
- DAX Generator to build and understand formulas
- Topic-wise quizzes to track your progress
- Interview question bank and fresher job opportunities
Our 45-Day Training Plan
9 weeks · 5 modules · 90 minutes every weekday. A day-by-day roadmap from absolute beginner to job-ready Data Analyst. Tap any day to see the topics.
SQL for Power BI
Query, combine and shape business data — then feed it into Power BI
Day 01Data Analytics & Database Fundamentals
- What is data analytics?
- Data analyst roles & career paths
- DBMS vs RDBMS
- Tables, rows, columns & keys
- Installing SQL Server & SSMS
- Your first database
Day 02Retrieving Data with SELECT
- SELECT & FROM
- Column aliases
- DISTINCT
- WHERE & comparison operators
- AND / OR / NOT
- ORDER BY
- TOP / OFFSET-FETCH
Day 03Filtering, Functions & CASE
- IN, BETWEEN, LIKE
- Handling NULLs
- String functions
- Date functions
- Numeric functions
- CAST & CONVERT
- CASE WHEN logic
Day 04Aggregations & Grouping
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY
- HAVING
- Grouping by multiple columns
- Sales summary reports
Day 05Joins & Combining Tables
- INNER JOIN
- LEFT & RIGHT JOIN
- FULL OUTER JOIN
- SELF JOIN
- CROSS JOIN
- Multi-table joins
- UNION, INTERSECT, EXCEPT
Day 06Subqueries & CTEs
- Single & multi-row subqueries
- Correlated subqueries
- EXISTS
- Common Table Expressions (CTEs)
- Breaking complex queries into steps
Day 07Window Functions for Analysis
- OVER & PARTITION BY
- ROW_NUMBER, RANK, DENSE_RANK
- LAG & LEAD
- Running totals & moving averages
- Top-N per category analysis
Day 08DDL, DML & Data Modeling
- CREATE, ALTER, DROP
- INSERT, UPDATE, DELETE
- Constraints & keys
- Normalization basics
- Fact & dimension tables
- Star schema for Power BI
Day 09Views, Procedures & Connecting SQL to Power BI
- Views
- Stored procedures
- Indexes basics
- Connecting Power BI to SQL Server
- Import vs DirectQuery
- Native SQL queries in Power BI
- Query folding
Day 10SQL Mini Project & AssessmentMini Project
- E-Commerce Sales Analysis in SQL
- Business questions to queries
- SQL interview questions
- Module assessment
Power BI with Copilot
Foundations, DAX, cloud service and AI-assisted reporting
Day 11Intro to BI & Power BI Ecosystem
- What is Business Intelligence?
- Power BI Desktop, Service & Mobile
- Power BI interface tour
- Connecting to Excel, CSV & SQL
- Where Copilot fits in Power BI
Day 12Power Query & Data Transformations
- Power Query Editor
- Cleaning & shaping data
- Merge & append queries
- Pivot / unpivot
- Conditional & custom columns
- Data types & errors
Day 13Data Modeling & Relationships
- Star schema
- Fact & dimension tables
- Relationships & cardinality
- Cross-filter direction
- Date table
Day 14Basic Visualizations & Reports
- Bar, line, pie & card visuals
- Tables & matrix
- Maps
- Formatting visuals
- Filters pane
Day 15Mini Project & AssessmentMini Project
- Sales report from SQL data
- Modeling & visual review
- Assessment
Day 16Intro to DAX & Calculated Columns
- DAX syntax
- Calculated columns
- Row context
- Logical & text functions
- RELATED
Day 17Measures, CALCULATE & FILTER
- Measures vs calculated columns
- Filter context
- CALCULATE
- FILTER, ALL, ALLEXCEPT
- Iterators (SUMX, AVERAGEX)
Day 18Time Intelligence (YTD, QTD, MTD)
- TOTALYTD, TOTALQTD, TOTALMTD
- SAMEPERIODLASTYEAR
- Year-over-year growth
- Running totals
Day 19Advanced Visuals, Tooltips & Slicers
- Slicers & sync slicers
- Drill-down & drill-through
- Custom tooltips
- Bookmarks & buttons
- Conditional formatting
Day 20Mini Project & DAX DrillsMini Project
- KPI dashboard project
- DAX practice drills
- Assessment
Day 21Power BI Service & Workspaces
- Publishing reports
- Workspaces & apps
- Dashboards & pinning
- Sharing & collaboration
- Scheduled refresh
Day 22Row-Level Security (RLS) & Gateway
- Static & dynamic RLS
- Roles & testing
- On-premises data gateway
- Refreshing SQL data
Day 23Dashboard UI/UX & Design Standards
- Layout & visual hierarchy
- Colour themes
- Data storytelling
- Corporate design standards
- Performance best practices
Day 24Copilot in Power BIAI
- What Copilot can do in Power BI
- Creating report pages with Copilot
- Summaries & narrative visuals
- Writing & explaining DAX with Copilot
- Asking questions of your data
- Prompting tips for analysts
- Licensing & requirements
- Reviewing AI output responsibly
Day 25Capstone Industry Database ProjectProject
- End-to-end Power BI project on an industry database
- SQL → Power Query → Model → DAX → Dashboard
- Publishing to Power BI Service
Power Apps
Low-code business apps that capture data and connect to Power BI
Day 26Power Platform & Power Apps Basics
- Microsoft Power Platform overview
- Canvas vs model-driven apps
- Environments
- Power Apps Studio tour
- Data sources overview
- Creating apps with Copilot
Day 27Building Canvas Apps
- Screens & navigation
- Galleries
- Forms
- Controls & inputs
- Power Fx formulas
- Variables & collections
Day 28Data Connections & CRUD
- Excel, SharePoint & SQL data
- Dataverse basics
- Create, read, update, delete
- Patch function
- Search, filter & sort
- Delegation basics
- Validation
Day 29Power Automate & Power BI Integration
- Power Automate flows
- Email alerts & approvals
- Power Apps visual in Power BI
- Write-back from reports
- Embedding Power BI in an app
Day 30Power Apps ProjectMini Project
- Inventory / Expense Tracker App
- Connected Power BI dashboard
- Sharing & publishing apps
- Assessment
Python with AI
Data analysis with Python, Generative AI as your assistant, and ML basics
Day 31Python Fundamentals for Analysts
- Why Python for data & AI
- Installing Python, Jupyter & VS Code
- Variables & data types
- Operators
- Input & output
Day 32Control Flow & Data Structures
- if / elif / else
- for & while loops
- Strings
- Lists & tuples
- Dictionaries & sets
Day 33Functions, Files & Error Handling
- Functions & parameters
- Lambda functions
- Modules & packages
- Reading CSV & Excel files
- Exception handling
Day 34NumPy for Data Analysis
- Arrays
- Indexing & slicing
- Reshaping
- Broadcasting
- Statistical functions
Day 35Pandas: Data Loading & Cleaning
- Series & DataFrame
- Reading CSV, Excel & SQL
- Missing values
- Duplicates & data types
- Filtering & sorting
Day 36Pandas: Analysis & EDA
- groupby & aggregation
- Pivot tables
- Merge & join
- Date & time handling
- Exploratory Data Analysis (EDA)
Day 37Data Visualization with Python
- Matplotlib
- Seaborn
- Choosing the right chart
- Python visuals in Power BI
- Python scripts as a Power BI data source
Day 38Generative AI for Data AnalystsAI
- What is Generative AI?
- LLMs explained simply
- Prompt engineering for analysts
- AI assistants to write & debug SQL, DAX and Python
- AI-generated insights & summaries
- Responsible AI & data privacy
Day 39Machine Learning Basics for AnalystsAI
- AI vs ML vs Deep Learning
- Supervised vs unsupervised
- Scikit-learn workflow
- Linear regression for forecasting
- Classification basics
- K-Means clustering
- Accuracy & error metrics
Day 40Python + AI Mini ProjectMini Project
- Sales Forecasting
- Customer Segmentation
- AI-written insight summary
- Results shown in Power BI
Capstone Project & Placement Preparation
One end-to-end project using all four tools, then interview readiness
Day 41Capstone: Business Problem & DataCapstone
- Understanding business requirements
- Defining KPIs
- SQL data extraction
- Data model design
Day 42Capstone: Build the SolutionCapstone
- Power Query & DAX
- Interactive dashboard
- Copilot narratives
- Power App for data entry
- Python analysis & forecasting
Day 43Capstone: Publish & PresentCapstone
- Publish to Power BI Service
- RLS & sharing
- Data storytelling presentation
- Portfolio & project write-up
Day 44Resume, LinkedIn & Interview Preparation
- Resume building & audit
- LinkedIn profile audit
- SQL interview questions
- Power BI & DAX interview questions
- Python & AI interview questions
- Explaining your projects
Day 45Mock Interviews & Career GuidancePlacement
- Technical mock interview
- Project explanation round
- HR round
- Where freshers are hiring
- Placement support next steps
Projects You Will Build
Every module ends with a real project you can show in interviews.
E-Commerce Sales Analysis
Answer real business questions with joins, CTEs and window functions.
Module 1KPI & Sales Dashboards
Interactive dashboards with DAX, time intelligence and Copilot.
Module 2Inventory / Expense Tracker
A data-entry app connected live to a Power BI dashboard.
Module 3Forecasting & Segmentation
Pandas EDA, ML models and AI-generated insight summaries.
Module 4End-to-End Business Analytics Solution
Bring all four tools together on an industry dataset: extract data with SQL, model and visualise it in Power BI with Copilot, capture new data through a Power App, and add forecasting with Python — then present it like a real analyst.
Tools Used
- SQL
- Power BI
- Copilot
- Power Apps
- Power Automate
- Python
Deliverables
- Published dashboard
- Business app
- Forecast model
- Project presentation
- Portfolio write-up
What You Will Get In This Program
Free LMS Access
Full access to kacademy.kalkitec.com — theory, hands-on labs, DAX generator, quizzes and interview prep.
Free Recorded Sessions
Lifetime access to recorded classes. Learn at your own pace and revisit topics whenever needed.
Free Interview Prep & Resume Building
Resume building and audits, LinkedIn review, interview question banks and mock interviews.
Course Completion Certificate
A KALKI TEC certificate of completion to show on your LinkedIn profile and resume.
1-on-1 Doubt Sessions
Individual help and troubleshooting from trainers, even after you finish the program.
Placement Support
Career guidance, interview strategies and curated fresher job leads.
Course Fee & Program Highlights
45 Days · 90 Minutes Daily · Weekdays (Mon – Fri)
- 45 days of live interactive online classes (90 min daily)
- SQL for Power BI, Power BI with Copilot, Power Apps & Python with AI
- Free LMS access: labs, DAX generator, quizzes & interview prep
- End-to-end capstone project using all four tools
- Lifetime access to recorded sessions
- Course completion certificate
- Resume building, mock interviews & placement support
Frequently Asked Questions
Can Non-IT students and professionals join?
How are classes conducted?
When does the next batch start?
What if I miss a class?
What software do I need?
Will I get a certificate and placement support?
Become a Job-Ready Data Analyst in 45 Days
Seats are limited to keep sessions interactive. Talk to our team to know the next batch date.