Home>Courses>Marketing>Data Analyst Course: Excel, SQL, and Power BI from Scratch

Course Data Analyst: Excel, SQL, and Power BI from Scratch

Learn Excel, SQL, and Power BI from scratch and take your first steps as a junior data analyst. Five modules and 16 lessons using a real-world company dataset, plus a capstone project for your portfolio.

S/ 304.64

21% off

Buy now

4.8 (44) Calificación

63 Estudiantes

16 lessons Lecciones

What You'll Learn

About course

Hard Skills

Soft Skills

This data analyst course is designed for people who are starting from scratch and want to pursue a career in data analysis within a company. Over the course of five modules, you’ll master the entire data workflow: collecting, cleaning, analyzing, and visualizing data. You’ll start with Excel, move on to querying databases with SQL, and finish by building dashboards in Power BI. The course combines brief theory, real-world case studies, and hands-on exercises, and culminates in a capstone project using a real-world company dataset that you’ll add to your portfolio when applying for your first job as a junior analyst.

Data analysis and interpretation to answer business questions.
Data cleaning, preparation, and standardization.
Advanced Excel skills: formulas, functions, pivot tables, and dashboards.
Writing SQL queries for relational databases.
Creating interactive reports and dashboards in Power BI.
Using Power Query to automate data processing.
Calculations and metrics with DAX.
Building clear business reports based on data visualization.
Fundamentals of Business Intelligence.
Working with relational databases in SQLite.
Automating routine analysis processes.
Preparing data for decision-making.
The complete analysis cycle: collect, clean, analyze, and visualize.

Analytical and critical thinking.
A structured approach to solving business problems.
Data-driven decision-making.
Ability to identify patterns and draw conclusions.
Presenting results in clear, business-friendly language.
Data storytelling: turning numbers into an understandable story.
Communication with business teams and clients.
Attention to detail and data integrity.
Independently completing analytical tasks.
Work on real-world cases and business projects.

What tools will we cover in the course?

Microsoft Excel

SQL

SQLite

DB Browser for SQLite

Microsoft Power BI

Power Query

Facebook Business Manager

Power BI Service

Curriculum

4 modules

16 lessons

16 practical assignments

Module1

4 lessons

4 practical assignments

1 test

Introduction to Data Analysis and Business Intelligence

Essential Excel: Navigation, Formulas, and Basic Functions

Data Cleaning and Preparation in Excel

Pivot Tables and Exploratory Analysis

Module2

3 lessons

3 practical assignments

1 test

Advanced Functions: VLOOKUP, HLOOKUP, INDEX/MATCH

Charts and Data Visualization in Excel

Interactive Dashboards in Excel

Module3

4 lessons

4 practical assignments

1 test

Introduction to SQL and Relational Databases

Filters, Sorting, and Aggregation Functions

JOINs: Combining Data from Multiple Tables

Subqueries, Views, and Exporting Data for Power BI

Module4

4 lessons

4 practical assignments

1 test

Introduction to Power BI: Interface and First Connection

Power Query: Transform and Clean Data

Data Model and Basic DAX

Professional Dashboard in Power BI: Design and Publishing

Module5

1 class

1 practical assignment

Final Project: End-to-End Business Analysis

Certificate

Upon completing the course, you’ll receive your data analyst certification issued by Progresivo Academy, along with a validation code that you can verify online. Add it to your resume and LinkedIn profile to showcase your new skills to recruiters.

LEARN FROM THE EXPERTS

Data Analyst Course: Excel, SQL, and Power BI from Scratch

8 years of experience

Marketing

Diego Mateo Díaz León

Industrial Engineer from UTEC, specializing in analytics and automation.
Data Translator at Yape, connecting data and business for strategic decision-making.
Specialist in Excel, SQL, and Power BI.
Led a data team at Marble on an AI project, processing over 4 million records.

About the instructor

Google Reviews

Trusted by 100+ business leaders

4.8 out of 5

Based on 6 reviews

Muy buen curso. Todo está explicado de forma simple y directa. Se nota que hay experiencia real detrás de las clases y no solo teoría sacada de internet.

Siempre quise entender el marketing de afiliados, pero en todas partes encontraba información poco útil. Aquí todo es claro y directo: cómo encontrar ofertas, lanzar campañas y monetizar el tráfico. Ahora tengo ingresos estables y sigo desarrollando mis proyectos de afiliación.

Pensé que los cursos online no servían, pero Progresivo Academy me sorprendió. Tomé el curso de Marketing Digital y desde la primera semana ya aplicaba estrategias en mi negocio. Los profes explican claro y resuelven dudas rápido. Ahora manejo mis campañas y aumenté mis ventas. ¡Valió totalmente la pena!

Siempre quise trabajar en redes sociales y el curso de SMM en Progresivo Academy fue clave. Aprendí a crear contenido, analizar métricas y conseguí prácticas reales. Poco después de terminar, ya estaba en una agencia de marketing. ¡Una experiencia top!

Al principio dudaba sobre tomar un curso online. Pero decidí probar con Progresivo Academy, y desde el primer día me di cuenta de que esta plataforma es diferente. El material es claro, práctico y actualizado. Además, siempre puedes contar con el soporte y los mentores para cualquier duda. ¡Vale totalmente la pena!

Start free with Progresivo

We will contact you within 3h

Frequently Asked Questions

Do I need prior experience to take the course?

No. The program is designed to help you start as a data analyst from scratch: we begin with basic Excel and move step by step to SQL and Power BI.

Is the course offered online?

Yes. It’s a 100% online course: you can train to become a data analyst online at your own pace, with recorded classes and access to course materials and hands-on exercises.

What tools will I be using?

You’ll train to become a data analyst using Excel, and you’ll also learn SQL, SQLite, Power BI, Power Query, and DAX. You’ll practice everything from data cleaning to building interactive dashboards.

Will I learn how to work with databases?

Yes. There’s a complete module on SQL for data analysts: you’ll learn about SELECT statements, filters, aggregate functions, and JOINs for combining data from multiple tables.

Will I be creating reports and dashboards?

Yes. In the final section, you’ll build reports as a data analyst using Power BI: a data model, DAX measures, and a dashboard published to the Power BI Service.

What project will I complete at the end of the course?

You wrap things up with an integrative project: you take a real-world company dataset, clean it, query it using SQL, and present a dashboard with findings and recommendations. That project goes into your portfolio.

Will I receive a certificate upon completion?

Yes. Upon passing the course, you’ll receive a certificate with a validation code that can be verified online, which you can add to your resume and LinkedIn profile.

What kind of job does this prepare me for?

For entry-level roles in data analysis: Land your first job with the skills required for junior-level positions.

Course Data Analyst: Excel, SQL, and Power BI from Scratch

What You'll Learn

About course

Hard Skills

Soft Skills

What tools will we cover in the course?

Curriculum

Module1

Module2

Module3

Module4

Module5

Certificate

LEARN FROM THE EXPERTS

Diego Mateo Díaz León

Trusted by 100+ business leaders

Can't decide?

Start free with Progresivo

Frequently Asked Questions

Free consultation