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

Microsoft Excel

SQL

SQLite

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

8 years of experience

Marketing

Ayrton Joao Luna Zapata

Digital marketing & social media senior expert
Focus: lead gen & data-driven optimization
Teaches digital marketing to teams & founders
Tools: GA, Looker, Google, Meta & TikTok Ads

About the instructor

Más de 100 destacados líderes empresariales han colaborado con nosotros.

Every lesson in Progresivo follows a clear and simple plan. It’s a comfortable and easy-to-follow path to learning. First, you watch a short video, then you work through examples, theory, and hands-on materials.

Carlos Mendoza

After the course, I landed my first job as a Junior Affiliate Manager at an iGaming company. Within 6 months, I was promoted to a Mid-level position making $2,800/month. The final project was a key factor in my interview.

Course

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

Instructor

María González

This digital marketing course was a true game-changer for me. The lessons are bite-sized, easy to follow, and motivate you to put everything into practice right away. What I value most is the live feedback from the mentors—you can tell they genuinely want to help you grow.

Course

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

Instructor

Lucía Huamán

The AI marketing course opened doors to a completely new approach to my work. I finally understand how to apply AI to real-world tasks. Thanks to the results from this course, I even landed a promotion. Thank you, Progresivo!

Course

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

Instructor

Can't decide?

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

Más de 100 destacados líderes empresariales han colaborado con nosotros.

Can't decide?

Start free with Progresivo

Frequently Asked Questions

Free consultation