Scratch the image to get a discount on your course. You'll be able to apply the coupon at checkout.

5.0 /5
(23)

147
Bienvenido al Curso que te prepara para el examen DA-100
Un apunte sobre la estructura del curso
Instalar Power BI Desktop
Configurar Power BI Services
Cómo Sacarle el Máximo Partido al Curso
Aprende con Amigos a través de Discord
Descarga los materiales del curso desde aquí
Excel vs Power BI
El mundo del Business Intelligence
Estableciendo las expectativas del curso
¿Cuál es el valor de la certificación en Power BI?
Toma notas de tu curso en tiempo real en Frogames Formación
Cómo cargar fechas en formato inglés
Introducción a la sección
Pasos para afrontar un problema empresarial
Preparar los datos
Modelar los datos
Visualización de los datos
Análisis de los datos
Implementar y mantener los entregables
Introducción a la Sección
Consigue los datos desde diferentes fuentes
Elección del tipo correcto de consulta
¿Qué pasa si un fichero cambia o recibo una nueva versión
Ajustes de las fuentes de datos
Seleccionar un dataset compartido o crear un dataset local
Seleccionar un modo de almacenamiento
¿En qué se diferencian los modos de almacenamiento de los datos?
Identificar problemas de rendimiento de la consulta
Uso de Parámetros
Perfilar los datos
Identificar anomalías en los datos
Examinar estructuras de datos
Consultar propiedades y estadísticas de columnas
Limpiar, transformar y cargar los datos (ETL)
Resolver valores inconsistentes, inesperados o nulos, y problemas de calidad
Reemplazo de valores de forma sencilla
Identificar y crear claves apropiadas para uniones
Evaluar y Transformar tipos de columnas de datos
Aplicar transformaciones de forma de datos a estructuras de tablas
Combinar consultas mediante Merge
Combinar consultas mediante Append
Aplicar convenciones usuales a la nomenclatura de columnas y de consultas
Aprovechar el editor avanzado para modificar el código de Power Query
Configurar la carga de datos
Resolver problemas de importación de datos
Contenido adicional: la preparación de los datos
El Power Query Editor
Cambiar el locale (idioma) en Power BI
Transformaciones básicas
Transformaciones de Texto
Transformaciones de Fecha
Creando una columna calculada
Creando una columna condicional
Entendiendo el Pivotaje y la Desvinculación
Conectarse a una Carpeta
Vista de Dependencia de Consultas
Introducción al caso de estudio
Caso de Estudio - Parte 1.1
Caso de Estudio - Parte 1.2
Introducción a la Sección
¿Qué es un modelo de datos?
Diseñando un modelo de datos
Definir las tablas
Configurar las propiedades de tabla y de columna
Definir medidas rápidas
Aplanar una jerarquía Padre-Hijo
Diseñar un modelo de datos para cumplir con los requisitos de rendimiento
Resolver Relaciones Muchas a Muchas
Crear Tablas de Fechas Comunes
Definir el nivel apropiado de granularidad de los datos
Crear Tablas Calculadas
Crear Jerarquías
Implementar roles de seguridad a nivel de filas
Configurar la función de preguntas y respuestas
Crear medidas usando DAX
Usar DAX para crear medidas complejas
Usar CALCULATE para manipular filtros
Implementar Inteligencia de Tiempo usando DAX
Reemplazar columnas numéricas con medidas
Eliminar filas y columnas innecesarias
Contenido Adicional: modelar los datos
Entendiendo la cardinalidad
Tipos de Tablas
Dirección de Filtro
Dirección de Filtro Bidireccional
Administrar Grupos y Nombres para las Consultas
Caso de Estudio Parte 2
Introducción a la Sección
Crear informes
Añadir elementos de visualización a los informes
Elegir el tipo de visualización adecuado
Formatear y configurar visualizaciones
Importar un elemento de visualización personalizado
Aplicando Filtros
Configurando la página del informe
Establecer la vista móvil
Usar la característica de Q&A
Crear tooltips personalizados
Editar y configurar interacciones entre visualizaciones
Configurar los sync slicers
Usar el panel de selección
Desglose de los datos mediante visualizaciones interactivas
Exportar datos del informe
Contenido adicional: visualizar los datos
Usar la funcionalidad de Drilldown
Incluir y Excluir Datos
Crear Gráficos de Barras
Crear Gráficos de Líneas y de Áreas
Crear Gráficos de Sectores, Donuts y Diagramas de Mosaico
Modo Focus, Ver y Exportar los datos
Añadir formas, imágenes y cajas de texto
Crear Mapas
Crear Tablas y Matrices
Caso de Estudio Parte 3.1
Caso de Estudio Parte 3.2
Caso de Estudio Parte 3.3
Introducción a la sección
Mejorar los informes para revelar información
Color y formato condicional
Aplicar Slicers
Realizar el análisis de los Top N
Crear líneas de referencia usando el panel Analytics
Usar la característica Play Axis en una Visualización
Realizar Análisis Avanzado
Realizar Análisis de Series de Tiempo
Usar Grouping y Binning
Usar los influencers clave para explorar variaciones dimensionales y outliers
Usar el árbol de descomposición visual para descomponer medidas
Aplicar conocimientos de IA
Caso de Estudio - Parte 4.1
Caso de Estudio - Parte 4.2
Caso de Estudio - Parte 4.3
Introducción a la Sección
Administrar el conjunto de datos
Configurar actualizaciones programadas de conjuntos de datos
Configurar el rol de seguridad de acceso a los datos
Dando acceso a un dataset
Avalar un conjunto de datos
Crear y administrar workspaces
Crear y configurar un espacio de trabajo
Asignar roles a un workspace
Administra tus conjuntos de datos
Bonus 1: Metodología de trabajo con datos: Conjuntos Externos vs Internos
Bonus 2: Los datos procedentes de Google Analytics
Bonus 3: Trucos de analista profesional con Power BI
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(23)

  • Avatar
    Gustavo
    (5)
    Data Analyst with Power BI: Your passport to professional analysis certified by Microsoft

    The "Data Analyst with Power BI – Microsoft Certified" course is a direct gateway to the world of modern Business Intelligence. Designed for those seeking to validate their skills with an official certification, this program combines rigorous technical training with a practical approach, preparing you to tackle real-world data analysis challenges.

  • Avatar
    Marc
    (5)
    So happy!

  • Avatar
    Paola
    (5)
    Detailed and interesting

    This course is really useful for organizing the prior knowledge you pick up, it sets a clear path and puts you to the test.

  • Avatar
    Jorge
    (5)
    An incredible quality leap

    I was already using the tool on my own, but the certification gave me the backing I was missing and I learned advanced data modeling techniques that save me hours of work when presenting reports to my bosses.

  • Avatar
    Guillermo
    (5)
    More than I expected

    Excellent course, with excellent teachers, great explanations and good practices that make everything easy to understand in a fun and simple way. Especially Juan Gabriel—I've taken some other courses on other platforms and his way of explaining makes knowledge stick in an easy way. He always encourages you to want to learn more.

  • Avatar
    Angel
    (5)
    Data Analyst with Power BI – Microsoft Certified

    This course prepares you to work as a data analyst using Power BI, following the official PL-300 exam standards. You'll learn to connect data sources, transform them with Power Query, model relationships, apply measures with DAX, and build interactive dashboards.

  • Avatar
    Nieves
    (5)
    Data Analyst with Power BI – Microsoft Certified: master the complete business analytics cycle and earn your official credential

    This course prepares you for the PL-300 exam, covering everything from connecting to data sources to publishing interactive dashboards. You'll learn to use Power Query, model relationships, apply DAX, create effective visualizations, and share reports in Power BI Service.

  • Avatar
    Carlos
    (5)
    Prepare for the DA-100 exam with ease

    For those of us looking to get Microsoft certification, this course is essential. It covers all the necessary aspects to pass the DA-100 exam and includes practical exercises to reinforce what you've learned. I feel much more prepared to take the exam!

  • Avatar
    Javi
    (5)
    I feel like a real pro!

    What I loved most was the confidence you get from knowing you're learning exactly what's in demand today. Seeing data transformed into beautiful, useful charts is really satisfying, and knowing you're on the right track to showcase your skills keeps me super motivated. It's perfect for giving your work a real boost and standing out.

  • Avatar
    Santiago
    (5)
    It's good for seeing different aspects of Power BI

  • Avatar
    Giovanni
    (5)
    Professionalism and real analysis

    I learned how to transform messy data into amazing visual reports that actually tell a story and help with decision-making. I loved the depth of the topics and how professional it feels to handle a tool of this caliber with such ease

  • Avatar
    Rocío
    (5)
    It was really helpful for me

  • Avatar
    María
    (5)
    Certified and with a real-world focus

    I loved this Power BI course. It's geared toward real data analysis. Perfect if you're looking to grow professionally with solid tools.

  • Avatar
    Jackeline
    (5)
    She prepared me for the official exam in just 30 days.

  • Avatar
    Gabriela
    (5)
    A course every data analyst should have in their toolkit

    With this course, I learned how to use Power BI to create impactful visualizations and make data-driven decisions. The Microsoft certification gives it added value.

  • Avatar
    Samuel
    (5)
    I'd recommend it 10/10

    Learning to visualize data like a pro changed how I work. Now my reports look like they were made by an expert

  • Avatar
    danison
    (5)
    Power BI and Microsoft Certification: a Clear Path to Success

    This course was essential for me to prepare and pass the Microsoft DA-100 exam. The lessons are very hands-on and focused on what you really need for certification.

  • Avatar
    Yvonne
    (5)
    Great course

    The course provides solid skills in data analysis and visualization, preparing students for successful careers in the field.

  • Avatar
    Joiser
    (5)
    I love this course

    It was really helpful. I picked up the skills I needed to analyze data effectively and get valuable insights.

  • Avatar
    Maria del Mar
    (5)
    I've done my first data analysis work thanks to the course

  • Avatar
    Eulogio
    (5)
    A really complete course

    I'm seeing more and more Power BI job openings, and this course is giving me the solid grounding I need to make the jump into Data Analysis with this tool.

  • Avatar
    Yeison
    (5)
    Course needed for Certification

    This practical course has given me the knowledge I need to get my Data Analyst certification. The explanation of the different topics is excellent and really straightforward. Thank you so much, professor

  • Avatar
    BORJA
    (5)
    Excellent

    It's perfect for preparing for the DA-100 certificate

View More Reviews

PLANS TO MATCH YOUR GOALS AND NEEDS

Buy the individual course, get all the learning path or access to the entire platform

Choose the payment method that works best for your needs and budget with a one-time course payment, monthly or yearly access to the learning Path, or even to the entire platform.

One-Time Payment

Buy the course once and access it for life

59.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Popular

Bronze Frog

Access all Frogames courses, communities and extras

39 /month

  • Single payment of 39€ per month
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

Business Intelligence Path

Access all courses in the Business Intelligence Path

19.99 /month

  • Single payment of €19.99 per month.
  • Instant access to the +10 courses in the Path.
  • Access the Path 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

One-time payment

Buy the course once and access it for life

59.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Valorado

Gold Frog

Access all Frogames courses, communities and extras

349 /year

  • Single payment of €349 per year
  • 3 months of discount
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Resource Library
  • Monthly Q&A livestreams
  • Premium support

Business Intelligence Path

Access all courses in the Business Intelligence Path

199 /year

  • Single annual payment of €199
  • 4 months of discount
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Premium support

* All prices include taxes.

For your security, all orders will be processed on a secure server.

Business Intelligence Path

The ultimate package with all our Business Intelligence courses to master tools like Tableau and Power BI. Includes upcoming courses and updates and improvements to current ones.

Complete Descriptive Statistics Course - RStudio and Python

Start with the foundations of programming in R and Python, from scratch and with no prior experience, applying them to the world of data analysis and descriptive statistics

215 classes

Databases: Learn SQL from scratch

Learn SQL, the language of databases, from scratch with practical exercises to master loading, querying, modifying and managing your data while learning all the key SQL commands.

82 classes

Introducción al mundo del Business Intelligence

Dive into the world of business intelligence to make decisions based on available data

25 classes

Aprende Tableau para Data Science de la A a la Z

Learn the basic fundamentals to apply Tableau in Data Science step by step. Real-World Practical Exercises and Cases to learn by doing!

96 classes

Curso Avanzado de Tableau: domina Tableau para Data Science

Master Tableau 21 applied to Data Science. Solve real-world analysis problems and work with advanced data. Learn data visualization and mining through our practical case studies.

85 classes

15 días de Power BI - El bootcamp completo de Power BI

Learn Power BI from scratch through hands-on projects. Become a data analysis master in no time! Unlock the secrets of data visualization and take your career to the next level

199 classes

Power Platform: Grandes Soluciones Empresariales de low-code

Solutions with Power Platform: Power Automate - Power Apps - Power BI and Microsoft 365: MS Forms - Sharepoint... and more

51 classes

Power BI: Mi primer proyecto Fitness Life

Learn to use Power Query, Power Pivot, DAX, Power BI Service, and Power BI

13 classes

Analítica avanzada con Power BI

Master advanced data analysis techniques in Power BI Desktop through 12 practical canvases

20 classes

Power BI online: Datamarts e informes desde la web

Develop your Power BI reports from the web, with Power BI Datamarts and a Premium subscription

30 classes

WhatsApp Analytica & Minería de Texto con R & Power BI

In this course you'll learn to process WhatsApp group chat files with R software and apply sentiment and emotion analysis, using text mining techniques to then create professional reports.

35 classes

El Universo analítico Power BI: La expedición desde los datos

This adventure through data isn't just a journey—it's your chance to unleash your creativity and explore the uncharted corners of your own information universe.

61 classes

The Data Analytics Process with SQL Server and Power BI

Run the complete Data Analytics process from complex databases using top tools like SQL Server while creating high-impact reports in Power BI

79 classes

Business Data Science con Python y SQL Server

Data Analysis for Business Decision Making based on Descriptive, Diagnostic, Predictive and Prescriptive Analytics

51 classes

Análisis de Datos Deportivos de Fútbol con Power BI

This course opens the door to a world of data and gives you the chance to create insights from disciplines like Business Intelligence, Business Analytics, Big Data, Big Data Analytics... all applied to sports companies!

78 classes

Experto en HR Analytics: MySQL, Power BI y Python para RRHH

Convert HR data into dynamic, integrated reports with descriptive and predictive analytics

44 classes

Análisis de forecasting con Power BI

Learn how to import time series from CSV files and create interactive dashboards in Power BI to communicate clear and compelling results

7 classes

Inteligencia Artificial y Big Data con Power BI web services

In this course you'll learn how to create data flows in the Power BI web service, add AI analysis using Cognitive Services, and much more.

45 classes

SAP Business One: Insights de Negocios con Power BI y SQL Server

Create the best Data Storytelling with Power BI for business insights with SAP Business One top global ERP data

90 classes

Power BI, SQL y Desarrollo Web integrados para Seguimiento de Tareas

The BI analyst must have the ability to identify data potentially important for the business and that, when processed, can become a solid foundation for decision-making.

38 classes

Ciencia de datos con MySQL, RStudio y Power BI: Casos Reales

Put yourself in the shoes of a data scientist looking at different real-world scenarios

54 classes

Data-Driven Leadership: Strategic Decisions with Data

Become a data-driven leader and make strategic decisions based on solid data

75 classes

Machine Learning práctico e integrado con Python, Sql Server, MySQL y Power BI

Excellent course to learn how to implement Machine Learning solutions integrating Clustering, Forecast, Sentiment Analysis, Association Rules, Decision Tree with Python, SQL Server, MySQL and Power BI

43 classes

Sistema de Recomendación en Power BI con Python y SQL Server

Add a really compelling skill to your profile: building a recommendation system using multiple technologies. It's applicable in any work context and will help you stand out as a highly valuable professional for any business.

28 classes

Data Analyst with Power BI - Microsoft Certified

Data Analysis and Visualization with Microsoft Power BI - Guide for the Microsoft DA-100 Exam. Prepare for your certification in just 30 days

147 classes