Human Intelligence Labs — HomeHomePrograms
Explore programsprograms⌄
AboutEventsJournalContact
HUMAN INTELLIGENCE LABS / Offline training | Lucknow

Data Analytics & Gen AI Program in Lucknow

Learn Excel, SQL, Python, statistics, Power BI and Generative AI in this 3-month, in-person program in Lucknow. Turn real datasets into business insights, complete a capstone project and prepare for data analyst interviews.

Explore curriculum ↓

Founded by alumni of IISc Bangalore and IE Business School, Spain

ISO 9001:2015
HI / LEARNING IN PRACTICE↗
Illustrative data analytics dashboardCOURSE PROJECT MOCKUP
HUMAN INTELLIGENCE LABSData Analytics & Gen AI Program
Complete Career Track Curriculum & Real-World Case Study Blueprint↗
3 monthsProgram duration
Offline training | Lucknow
Human Intelligence Labs Private Limited

About Human Intelligence Labs

Human Intelligence Labs is an AI-focused software engineering company built to make students job-ready. We focus on practical coding, AI tools, real-world projects, and corporate work culture – pairing personalized mentorship with international exposure and complete placement support including resume building, LinkedIn optimization, mock interviews, and interview preparation.

The Human Intelligence Labs approach

Learning that goes
beyond the classroom.

01

Curriculum by Global Alumni

Curriculum designed by graduates of IISc Bangalore and IE Business School, Spain

02

Elite Mentorship

Guidance from experienced mentors with backgrounds at IITs, NVIDIA, Accenture, and leading companies

03

Global Exposure

Direct access to product teams and companies across India, Spain, and Saudi Arabia

04

Project-Based Learning

Learn by working on live projects, with weekly reviews, feedback, and deadlines. This builds accountability, a key requirement in the industry

05

End-to-End Placement Support

Our Industry Readiness Classes cover resume building, LinkedIn optimization, mock interviews, job prep, and hiring assistance, so you can face interviews with confidence

06

Extra-Curricular Activities

Hackathons, LeetCode Problem-Solving Batches, and other practical coding activities

What you will learn

Data Analytics & Generative AI

Complete Career Track Curriculum & Real-World Case Study Blueprint

08

curriculum modules

01
Foundations, Excel & SQL

Data Analytics Foundations & Advanced Excel

+

Start here, no coding needed

  • Analytics lifecycle: ask, clean, analyse, present
  • Types of data, data sources and data quality
  • Formulas: logical, text and lookup functions
  • VLOOKUP, XLOOKUP and INDEX-MATCH
  • PivotTables, slicers and PivotCharts
  • Data cleaning, validation, Power Query basics
  • Interactive Excel dashboards
  • Business reporting and storytelling
Case studies / projects
  • Retail Sales Report
  • E-Com Orders
02
Foundations, Excel & SQL

Analytics with SQL

+

MySQL Workbench

  • Databases, RDBMS and ER modelling
  • SELECT, WHERE, ORDER BY, GROUP BY, HAVING
  • Joins: inner, left, right, self, cross
  • Aggregates, CASE, date and string functions
  • Subqueries and CTEs
  • Window functions: RANK, LAG/LEAD
  • Views, indexes, constraints, optimisation
  • Data retrieval for dashboards and KPIs
Case studies / projects
  • E-Com Business
  • Retail Store
03
Python, Statistics & EDA

Python for Data Analytics

+

Jupyter, Google Colab

  • Python basics: variables, data types, operators
  • Conditionals, loops, functions, error handling
  • Lists, tuples, dictionaries and sets
  • NumPy: arrays, indexing, vectorisation
  • Pandas: Series, DataFrames, filtering, sorting
  • Cleaning: missing values, duplicates, outliers
  • GroupBy, merge, join, pivot and reshape
  • Reading CSV, Excel, JSON and SQL data
Case studies / projects
  • UPI Transactions
  • Covid-19 Trends
04
Python, Statistics & EDA

Statistics & Exploratory Data Analysis

+

Python, SciPy, Statsmodels

  • Descriptive statistics and dispersion
  • Probability, distributions, Central Limit Theorem
  • Sampling techniques and confidence intervals
  • Hypothesis testing: t-test, chi-square, ANOVA
  • Correlation, covariance, bivariate analysis
  • Univariate and multivariate EDA workflow
  • Outlier detection and feature selection basics
Case studies / projects
  • Loan Default
  • Air Quality
05
Data Visualization & BI

Data Visualization & BI with Power BI

+

Power BI Desktop and Service

  • Principles of effective visual storytelling
  • Power Query: connect, transform, model data
  • Star-schema modelling and relationships
  • DAX measures, columns, time intelligence
  • Charts, maps, KPI cards, drill-through
  • Publishing, sharing and scheduled refresh
  • Row-level security and KPI governance
  • Python charts: Matplotlib and Seaborn
Case studies / projects
  • Sales Dashboard
  • People Analytics
06
Generative AI for Analytics

Generative AI for Data Analytics

+

Live lectures

  • How LLMs work: concepts, capabilities, limits
  • Prompt engineering for analysis and code
  • AI in Excel and Power BI (Copilot, DAX help)
  • AI-assisted SQL: write, debug, optimise
  • AI-assisted Python: pandas code, automation
  • AI-driven EDA: insights, anomaly spotting
  • Executive-ready narratives from findings
  • “Chat with your data” assistant via LLM API
  • Responsible AI: privacy, bias, verification
Case studies / projects
  • Customer Feedback Mining
  • Credit Risk Insights
07
Capstone & Career Launch

Capstone & Live Industry Projects

+

Portfolio on GitHub

  • Problem framing with a stakeholder brief
  • End-to-end: SQL → Python → Power BI → GenAI
  • Version control and GitHub portfolio
  • Demo day: present insights, mentor feedback
  • Case-study write-ups for recruiters
Case studies / projects
  • Capstone Project
  • Live Industry Project
08
Capstone & Career Launch

Career Readiness & Placement Prep

+

Runs alongside the program

  • Resume and LinkedIn for analyst roles
  • SQL, Python and case-based interview practice
  • Mock technical and HR interviews
  • Communication and stakeholder skills
  • Salary negotiation and offer basics
Case studies / projects
  • Mock Interviews
  • Job Support
Every module is taught the same way
  1. 01Concept
  2. 02Hands-on lab
  3. 03Real case study
  4. 04AI-assisted practice
  5. 05Mentor review
Your roadmap

Complete the Roadmap. Build the Skills. Become Industry Ready.

After completing this roadmap, you’ll be equipped with the skills and practical experience to confidently pursue data analyst interview opportunities.

Tools & technologies covered

Hands-on from day one

Spreadsheets & BI

ExcelPower QueryPower BI DesktopPower BI Service

Databases & SQL

SQLMySQLMySQL Workbench

Programming, Notebooks & Version Control

PythonNumPypandasJupyterGoogle ColabGitHub

Statistics & Visualization

SciPyStatsmodelsMatplotlibSeaborn

Generative AI & Large Language Models

ChatGPTClaudeGeminiMicrosoft CopilotLLM APIs
One end-to-end workflow

From raw data to AI-powered insight.

  1. 01SQL: extract & prepare
  2. 02Python: clean & analyse
  3. 03Power BI: visualise & share
  4. 04GenAI: summarise & narrate
Practical · Job-ready

Skills you will learn

01

Data Cleaning & Preparation

Turn messy data into analysis-ready data
  • Fix missing values, duplicates, outliers and wrong data types in Excel and pandas
  • Merge, reshape and pivot data from files and SQL
02

Exploratory Data Analysis

Find the story hidden in the numbers
  • Run univariate, bivariate and multivariate EDA
  • Spot outliers, correlations and patterns early
03

SQL & Database Querying, MySQL

Get exactly the data you need, fast
  • Write joins, subqueries, CTEs and window functions
  • Pull KPIs for dashboards and speed up queries with views and indexes
04

Data Visualization & Dashboards

Make insights impossible to miss
  • Build interactive dashboards in Excel and Power BI with DAX measures
  • Create clear charts with Matplotlib and Seaborn; publish with row-level security
05

Statistics & Business Insights

Back every decision with evidence
  • Apply probability, sampling, confidence intervals and hypothesis tests
  • Measure relationships with correlation and turn results into business recommendations
06

Generative AI & Prompt Engineering

Use AI with confidence, and verify it
  • Understand how LLMs work, where they fall short and how to use them responsibly
  • Write prompts that get reliable answers for analysis, reporting and code
07

AI-Assisted Workflows & Apps

Do in minutes what took hours
  • Speed up SQL, Python, Excel and Power BI work with AI and Copilot help
  • Build a “chat with your data” LLM assistant
08

Real-World Projects & Careers

Show proof of work to employers
  • Deliver an end-to-end capstone from SQL to Python to Power BI to a GenAI summary
  • Build a GitHub portfolio, plus resume, LinkedIn and mock-interview skills
Your outcome

From raw data to business decisions. Powered by AI.

Take a raw dataset from messy to meaningful and explain it to the business.

Human Intelligence Labs

Your mentors

Mr. Ansari TK — Co-founder, Human Intelligence Labs10+ yearsexperience
YOUR MENTOR

Mr. Ansari TK

Co-founder, Human Intelligence Labs

Ex-NVIDIA, IISc Bangalore alumnus

Mr. Harshit Dixit — Project Manager, Cars245+ yearsexperience
YOUR MENTOR

Mr. Harshit Dixit

Project Manager, Cars24

Ex-Morgan Stanley

Ms. Dishanshi — Team Lead, Accenture8+ yearsexperience
YOUR MENTOR

Ms. Dishanshi

Team Lead, Accenture

Ex-TCS

Ms. Sangeeta Mishra — Senior Software Developer8+ yearsexperience
YOUR MENTOR

Ms. Sangeeta Mishra

Senior Software Developer

Engineering mentorship

Ms. Nidhi Shukla — Senior Software Developer8+ yearsexperience
YOUR MENTOR

Ms. Nidhi Shukla

Senior Software Developer

Engineering mentorship

Mr. Shivam Rai — Software Engineer4+ yearsexperience
YOUR MENTOR

Mr. Shivam Rai

Software Engineer

Human Intelligence Labs

Mr. Bharat Joshi — Software Trainer3+ yearsexperience
YOUR MENTOR

Mr. Bharat Joshi

Software Trainer

Human Intelligence Labs

Mr. Vimal Tiwari — Front-End Developer4+ yearsexperience
YOUR MENTOR

Mr. Vimal Tiwari

Front-End Developer

Human Intelligence Labs

Your mentor support

Complete one-on-one support throughout your journey to your first job

Every student gets one-on-one support from 5 to 6 mentors.

Mentor 1

Trainer

Fundamentals & Theory

He will work on your fundamentals, strengthen your theoretical knowledge, and teach you how to apply what you learn in practical work.

Mentor 2

Software Engineer

Live Projects & Technical Guidance

He will guide you through the live projects you work on, conduct weekly reviews, provide feedback, and support you throughout your project journey.

Mentor 3

HR

Interview & Career Preparation

She will guide you on interview preparation, mock interviews, resume building and soft skills development.

Mentor 4

Industry Experts

Mock Interviews & Industry Exposure

Industry experts will conduct mock interviews and help you prepare for job interviews, referrals and real-world hiring processes.

Mentor 5

Placement Officer

Job Opportunities & Placement Support

His role will be to provide interview opportunities with companies and bring relevant company vacancies to the placement portal.

Our group companies
FawriT Technologies Pvt LtdAl-Majal Al-Fawrieh (Dubai, Saudi)Eje Technologies SL (Madrid, Spain)The CIO World
Duration3 months
Schedule5 days a week
Classes4 to 5 hours a day
EnrollmentOnly 10 seats available
Program fee

Data Analytics & Gen AI Program

No Cost EMI options available

₹35,000 + GST

Limited 10 seats: book yours by paying ₹5,000 + GST

Book your seat ↗
Common questions

Before you begin.

What will I learn?+

The program moves through Excel and data foundations, SQL, Python, statistics, Power BI and Generative AI, followed by capstone work and placement preparation. The curriculum contains eight modules in five phases.

How long is the program?+

The program lasts three months, with classes five days a week for four to five hours a day.

What are the fees?+

The brochure lists ₹35,000 + GST, with a booking amount of ₹5,000 + GST. No Cost EMI options are available.

Where are classes held?+

This is an offline program in Lucknow. The brochure lists ten available seats.

Your next step

Make your next
move count.

Founded by alumni of IISc Bangalore and IE Business School, Spain

Join Human Intelligence Labs

Start your application

Data Analytics & Gen AI Program

↗
4 programs. One place to grow.

Find your direction.

At a glance

The Data Analytics & Gen AI Program is a 3-month, in-person course in Lucknow covering Excel, SQL, Python, statistics, Power BI and Generative AI, followed by capstone work and placement preparation.

Data Analytics & Gen AI Program

Request a Call

+91 7388899595
contact@thehilabs.com

Chat on WhatsAppTalk to admissions