TTFA Academy · A fellowship for people at work
For fresh graduate or non-technical roleJunior Data Analyst
Excel for analysis, SQL for questions, cleaning, dashboards and two industry projects for the portfolio. From fresh graduate or non-technical role to Junior Data Analyst, taught by people who do the job.
Designed for AI-native analyst roles: Copilot in Excel for formulas and summaries and assistants for SQL, with a module on checking AI output before anyone relies on it.
Curriculum updated
Data Analyst with Excel & SQL is a live online program for the fresh graduate or non-technical role: the next step is being seen as a junior Data Analyst. Excel for analysis, SQL for questions, cleaning, dashboards and two industry projects for the portfolio. Classes run over 16–20 weeks on weeknight evenings and weekends in IST and are recorded the same day, so a late shift doesn't cost you the week. You work in Excel and SQL on projects modelled on the mentors' production work, each reviewed 1:1, with doubt-solving on the LMS between classes. A counsellor confirms the batch, the schedule and the fee on one call; nothing is charged on the call.
Why this program
Results, your career, the part of the job you do by hand today, and who teaches it.
Results-focused
Excel for analysis, SQL for questions, cleaning and dashboards, on two projects modelled on real work and reviewed 1:1.
Career-focused
A first analytics role asks for Excel, SQL and the habit of checking your numbers. The programme builds all three on real data.
Pain-point focused
You learn to clean it, question it in SQL and present it so a manager believes the number. Trust in your own work comes first.
Premium and professional
Mentors who build this in production, projects modelled on their own, 1:1 review of every build, recordings the same day. For analysts who want to be taken seriously, not for anyone collecting certificates.
Who this is for
You already do part of this job. The program closes the gap between where you are and being seen as a Junior Data Analyst.
Probably not for you, yet
If you haven't worked in the domain at all, a counsellor will say so on the call and point you to a better starting program. If you want a certificate more than a portfolio, this isn't it.
What you'll build
Each project is modelled on the mentors' production work and reviewed 1:1. Together they are your portfolio.
Project 1
Modelled on the mentor's production work, with the messy parts left in, reviewed 1:1.
Project 2
Brief, build, review: the way a manager would hand it to you, with the checks that stop it breaking next month.
Project 3
Published, documented and defended, with the notes a senior would give you.
Curriculum
16 to 20 weeks, depending on your pace. Each module ends with an assignment a mentor reviews.
5 modules · 46 topics · pick a module to see what it covers
Module 1 of 5
Equip participants with the skills to manage, query, and analyze data efficiently using SQL tools and techniques.
SQL Introduction
Overview of SQL and Its Applications · Importance of SQL in Data Management
Application Installation
Setting Up SQL Tools (PostgreSQL, MySQL, SQL Server) · Configuring Workspaces
Introduction to Application Interface
Understanding the Query Editor · Basic Commands and Syntax
Importing Tables from Sources
Connecting to Excel and Other Data Sources · Data Import Methods
Queries & Types
DDL (Data Definition Language) · DML (Data Manipulation Language) · DCL (Data Control Language) · TCL (Transaction Control Language)
SQL Functions
Aggregate Functions (SUM, AVG, COUNT) · String and Date Functions
Keys & Constraints
Primary and Foreign Keys · Constraints for Data Integrity
Joins & Types
INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN · Cross Joins and Self Joins
Nested Queries
Writing Subqueries · Advanced Query Structures
Tools
You use each one on the kind of data your mentors handle at work, not on a toy example.
TTFA Academy is an independent training provider. It is not affiliated with, endorsed by or a partner of Microsoft, Salesforce or Alteryx. Microsoft, Power BI, Excel and Fabric are trademarks of the Microsoft group of companies. Tableau is a trademark of Salesforce, Inc. Alteryx is a trademark of Alteryx, Inc. Names are used only to identify the tools taught.
LMS EXPERIENCE
Learn at your pace, practice through real-world projects, build your skills, earn certifications, and discover opportunities that match your potential.
Complete industry-relevant courses designed to build practical skills and prepare you for real-world applications.
Put your learning into practice with assignments and hands-on projects designed to build practical skills and help you grow with confidence.
Practise real-world tasks with interactive simulators that help you apply your knowledge, sharpen your skills, and prepare for the workplace.
Upload and enhance your resume, then discover job and freelance opportunities matched to your skills, experience, and career goals.
Complete projects, build your skills, and unlock certifications at each level as you progress through your learning journey.
Your mentors
Names, employers and photos appear only with their written permission.
Jitendra Singh
Data Analyst with Excel & SQL
Jitendra Singh
Lead Instructor
Jitendra leads instruction at TTFA across the analytics stack: Alteryx workflows, Tableau and Power BI dashboards, SQL and Python on real company data, and the GenAI layer on top of them, from agents and MCP to RAG. He teaches the job the way it is done at work: real data, in the order you meet it, with the mistakes left in.
Arvind Tiwary
Data Analyst with Excel & SQL
Arvind Tiwary
Senior analytics consultant
Arvind trains the analyst's working stack: Python and Alteryx for preparing and automating data, SQL for querying it, and Excel for the models and reports that run on it. He teaches the consultant's habits as well: scoping the work with the person who will use it, and handing it over so it survives without you.
Sarvdeep Singh
Data Analyst with Excel & SQL
Sarvdeep Singh
Data & BI mentor
Sarvdeep mentors across the Data & BI programs: Power BI dashboards, SQL for the questions behind them, and Excel for the analysis most teams still start in, with the reporting discipline that makes an analyst's numbers trusted on a Monday morning.
How the weeks run
A counsellor confirms the exact days and times for your batch on the call.
Two evenings a week with the mentor, on the work of the week.
Project time with the mentor in the room: build, get stuck, get unstuck.
Every class recorded the same day; 1:1 doubt-solving whenever you're stuck.
Your projects reviewed like production work, with notes you can act on.
Data & BI
Programs next to this one. A counsellor will tell you which fits what you do today.
MIS, ops or finance reporting in Excel
Data Analyst
Data or MIS analyst
BI Developer
Analyst doing manual reporting
BI & Automation Consultant
Questions
Anything else: ask on the call.
Yes. The program assumes you know your work, not the tool. If you've never worked in the domain, a counsellor will point you to a better start.
Every class is recorded the same day, and 1:1 slots exist for exactly this. Most people who fall behind catch up in a week.
There is career support: mock interviews, profile reviews and referrals where we have them. Nobody honest can promise you a role; your projects make the case for you.
Both. Data Analyst with Excel & SQL is VILT (virtual instructor-led training): live online classes in the evenings and on weekends, in IST, recorded the same day so you can rewatch them. It runs 16–20 weeks, depending on your pace.
Designed for AI-native analyst roles: Copilot in Excel for formulas and summaries and assistants for SQL, with a module on checking AI output before anyone relies on it.
Excel and SQL, the way they are used at work, on projects modelled on the mentors' own. The curriculum section lists every module and topic.
Fees are not published on the site. A counsellor confirms the fee, GST and the instalment options in writing after one call; nothing is charged on the call.
A counsellor looks at what you do today and tells you, straight, whether Data Analyst with Excel & SQL is the right next step.
Seamless Learning across every Device
