TTFA Academy · A fellowship for people at work
For analyst doing manual reportingBI & Automation Consultant
Reporting that runs itself: pipelines, scheduled refresh and the consulting habits that make clients trust the number. From analyst doing manual reporting to BI & Automation Consultant, taught by people who do the job.
Designed for AI-native consulting roles: Ask Alteryx and the AI tools palette in Designer, and assistants for documenting workflows and drafting the client note.
Curriculum updated
BI & Automation Consultant is a live online program for the analyst doing manual reporting: the next step is being seen as a BI & Automation Consultant. Reporting that runs itself: pipelines, scheduled refresh and the consulting habits that make clients trust the number. 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 SQL, Tableau, Power BI and Alteryx 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
Pipelines in Alteryx, dashboards in Power BI and Tableau, and the scheduling that removes the manual step. You build the end-to-end flow a consultant would ship.
Career-focused
A consultant scopes, builds and hands over. The programme adds the automation and the client conversation to the analysis you already do.
Pain-point focused
The blend you redo every cycle becomes one workflow with the join rules in one place, documented and scheduled.
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 BI & Automation Consultant.
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.
6 modules · 59 topics · pick a module to see what it covers
Module 1 of 6
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.
Prepares you for
The exams are the vendors' own, taken separately; TTFA is not affiliated with them.
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
BI & Automation Consultant
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.
Sarvdeep Singh
BI & Automation Consultant
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.
Arvind Tiwary
BI & Automation Consultant
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.
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
Excel reporting, some pivot tables
Power BI Developer
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. BI & Automation Consultant 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 consulting roles: Ask Alteryx and the AI tools palette in Designer, and assistants for documenting workflows and drafting the client note.
SQL, Tableau, Power BI and Alteryx, 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 BI & Automation Consultant is the right next step.
Seamless Learning across every Device
