TTFA Academy · A fellowship for people at work
For excel reporting, some pivot tablesPower BI Developer
Dashboards, DAX, Power Query and Report Server, built on the datasets your mentors use at work.
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 Power BI Developer.
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
12 to 16 weeks, depending on your pace. Each module ends with an assignment a mentor reviews.
3 modules · 23 topics · pick a module to see what it covers
Module 1 of 31 new
Understand data analytics fundamentals and Power BI architecture to transform raw data into meaningful business insights.
Introduction to Power BI
Overview of Power BI and its ecosystem. · Components: Power BI Desktop, Service, Mobile App, and Gateway. · Installation and setup of Power BI Desktop. · Interface walkthrough and navigation.
Connecting to Data
Supported data sources in Power BI. · Connecting to Excel, CSV, and databases. · Import, DirectQuery and Direct Lake modes. · Managing and transforming data in Power Query.
Data Preparation and Modeling
Cleaning and transforming data using Power Query. · Creating relationships between tables. · Understanding star and snowflake schemas. · Data types and formatting.
Creating Visualizations
Building bar charts, line charts, and pie charts. · Using slicers, filters, and drill-throughs. · Formatting visualizations for clarity. · Building basic dashboards.
Introduction to DAX (Data Analysis Expressions)
Basics of DAX and calculated columns. · Simple measures: SUM, AVERAGE, COUNT. · Using logical functions like IF and SWITCH. · Introduction to time intelligence.
Publishing and Sharing
Publishing reports to Power BI Service. · Sharing dashboards and reports with users. · Exporting reports to PDF and PowerPoint. · Embedding reports in apps or websites.
Power BI Mobile App
Setting up the Power BI Mobile app. · Accessing reports and dashboards on mobile. · Creating mobile-optimized layouts.
Power BI inside Microsoft FabricNew
OneLake, lakehouse and Dataflows Gen2 in brief · Where a Power BI report sits in a Fabric workspace
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
Power BI Expert
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
Power BI Expert
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
Power BI Expert
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
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.
A counsellor looks at what you do today and tells you, straight, whether Power BI Expert is the right next step.
Seamless Learning across every Device
