Barter AI AcademyStart for free
School with AI tutor · Academia Barter Rubio

Data Analysis and Power BI Course

Clean and analyze data, build reports in Power BI, query databases with SQL, and present executive dashboards.

🔥 Join the more than 15,600 students who have already trained with the Academia Barter Rubio.

5 levels

from Basic to Crack + 1 specialization

60 lessons

6 final projects

≈ 12 hours

in total, at your own pace

≈ 7 weeks

with 15 min a day

Start the first lesson for free →

No credit card · Free placement test to find out where to start

Full Syllabus

Each lesson takes just a few minutes: you read an idea, practice with challenges that are graded instantly, and Barty, your AI tutor, explains anything you don't understand. Times are estimates and depend on your pace.

💡We recommend going step by step: each lesson builds on the previous one, so you learn better. If you want to reinforce a specific topic, you can start any unit or lesson.

1

Level Basic · 12 lessons · ≈ 2 h

Data Analysis from Scratch

+

Understand what data is, how it is organized, and how to get answers from it.

By the end: You will answer business questions using organized data.

Unit 1

⏱ ≈ 28 min

Thinking with Data

  1. 1.What Is Data AnalysisStart ›
  2. 2.Questions You Can Answer with DataStart ›
  3. 3.Data TypesStart ›
  4. 4.Clean Data vs. Dirty DataStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Organizing

  1. 5.Well-Built TablesStart ›
  2. 6.Filter and SortStart ›
  3. 7.Remove Duplicates and ErrorsStart ›
  4. 8.Summarize with TotalsStart ›
▶ Start this unit

Unit 3

⏱ ≈ 28 min

First Conclusions

  1. 9.Averages and PercentagesStart ›
  2. 10.Compare PeriodsStart ›
  3. 11.Charts That Make SenseStart ›
  4. 12.Communicating a ConclusionStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Análisis simple de las ventas de un negocio con conclusiones🎓 Level certificateTools: Excel, Google Sheets
2

Level Intermediate · 12 lessons · ≈ 2 h

Power BI

+

Connect data, build models, and create your first reports in Power BI.

By the end: You'll build interactive reports in Power BI.

Unit 1

⏱ ≈ 28 min

Getting Started

  1. 1.What Is Power BIStart ›
  2. 2.Load DataStart ›
  3. 3.Power Query for Cleaning DataStart ›
  4. 4.Your First ChartStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Model

  1. 5.Fact and Dimension TablesStart ›
  2. 6.RelationshipsStart ›
  3. 7.Basic Measures with DAXStart ›
  4. 8.Calendar and DatesStart ›
▶ Start this unit

Unit 3

⏱ ≈ 28 min

Reports

  1. 9.Design a Clear ReportStart ›
  2. 10.Filters and slicersStart ›
  3. 11.Cards and IndicatorsStart ›
  4. 12.Publishing and SharingStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Reporte interactivo de ventas en Power BI🎓 Level certificateTools: Power BI Desktop
3

Level Advanced · 12 lessons · ≈ 2 h

SQL and Advanced Analysis

+

Query databases with SQL and deepen your analysis with DAX and statistics.

By the end: You will extract and analyze data directly from databases.

Unit 1

⏱ ≈ 28 min

SQL

  1. 1.What Is a DatabaseStart ›
  2. 2.SELECT, WHERE and ORDER BYStart ›
  3. 3.Group and SummarizeStart ›
  4. 4.Joining Tables with JOINStart ›
▶ Start this unit

Unit 2

⏱ ≈ 29 min

Advanced DAX

  1. 5.CALCULATE and ContextStart ›
  2. 6.Time IntelligenceStart ›
  3. 7.Comparisons and RankingsStart ›
  4. 8.Best Practices for Data ModelsStart ›
▶ Start this unit

Unit 3

⏱ ≈ 29 min

Practical Statistics

  1. 9.Distribution and SpreadStart ›
  2. 10.Trends and SeasonalityStart ›
  3. 11.Correlation Is Not CausationStart ›
  4. 12.Simple ForecastingStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Análisis completo con consultas SQL y tablero🎓 Level certificateTools: SQL, Power BI, Excel
4

Level Expert · 12 lessons · ≈ 2 h

Professional Data Analyst

+

Take analysis to the business level: executive dashboards, automation, AI, and client work.

By the end: You will deliver professional-level data analysis projects.

Unit 1

⏱ ≈ 28 min

Executive Dashboards

  1. 1.KPIs That MatterStart ›
  2. 2.Storytelling with DataStart ›
  3. 3.Design for ExecutivesStart ›
  4. 4.Automatic RefreshStart ›
▶ Start this unit

Unit 2

⏱ ≈ 28 min

Automation

  1. 5.Data flowsStart ›
  2. 6.Python for Analysis: First StepsStart ›
  3. 7.AI for Data AnalysisStart ›
  4. 8.Data Quality and GovernanceStart ›
▶ Start this unit

Unit 3

⏱ ≈ 28 min

Career

  1. 9.Analyst PortfolioStart ›
  2. 10.Client ProjectsStart ›
  3. 11.Interviews and Technical TestsStart ›
  4. 12.Growing as an AnalystStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Tablero ejecutivo con informe y recomendaciones para un negocio🎓 Level certificateTools: Power BI, SQL, Basic Python, AI
5

Level Crack · 4 lessons · ≈ 74 min

Crack of Data Analysis

+

Turn data into decisions: ask the right questions, run solid analysis, and tell a story that persuades.

By the end: You will do analysis that changes decisions in a company.

Unit 1

⏱ ≈ 29 min

Elite Challenges

  1. 1.Asking the Right Questions of Your DataStart ›
  2. 2.Avoiding Statistical TrapsStart ›
  3. 3.Telling a Data Story That ConvincesStart ›
  4. 4.Final boss challenge: the analysis that changes a decisionStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Reto jefe: análisis completo de un caso real con recomendaciones accionables🎓 Level certificateTools: Excel, SQL, Power BI, applied statistics
🛠

Practical specialization · 8 lessons · ≈ 2 h

Power BI Dashboards for Businesses

+

Build sales, inventory, and finance dashboards in Power BI that managers use every day.

By the end: You'll be able to deliver professional dashboards to businesses.

Unit 1

⏱ ≈ 28 min

Practical Power BI

  1. 1.Connect and Clean DataStart ›
  2. 2.Simple Data ModelStart ›
  3. 3.Key Measures with DAXStart ›
  4. 4.Visuals That Make SenseStart ›
▶ Start this unit

Unit 2

⏱ ≈ 29 min

Dashboards for Businesses

  1. 5.Sales DashboardStart ›
  2. 6.Inventory and Finance DashboardStart ›
  3. 7.Publish and ShareStart ›
  4. 8.Offering Dashboards as a ServiceStart ›
▶ Start this unit
🛠 Final project (≈ 45 min): Tablero de ventas en Power BI listo para entregar a un cliente🎓 Level certificateTools: Power BI, Excel, Power Query

Start today, at your own pace.

The first lesson and the placement test are free.

Create my free account →