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

5.0 /5
(31)

199
Bienvenidos al curso de Power BI en 15 días
Cómo Sacarle el Máximo Partido al Curso
Aprende con Amigos a través de Discord
Toma notas de tu curso en tiempo real en Frogames Formación
Hoja completa de comandos DAX
¿Qué tipo de gráfico elegir según tus datos?
5 Casos Prácticos de uso del Diagrama de Sankey
5 Casos Prácticos de uso de la Escala Likert
Motivación y acerca del curso
Cómo sacarle el máximo partido al curso
Objetivos del Día 1
Comprender las bases de Power BI
Descargar e instalar Power BI
Nota rápida: los ajustes regionales y de idioma
Emocionémonos!
Las 3 vistas de Power BI
La interfaz
Importante: los ajustes iniciales
Nuestro proyecto y la obtención de datos
Query Editor - Limpieza Básica de Datos
Cómo trabajar con los archivos de los proyectos adjuntos en el curso
Query Editor
Cómo editar filas y columnas
Los tipos de datos
Reemplazo de Valores
Tipos de datos, reemplazo y edición de filas
El Resumen de Hoy
Día 1: Proyecto final
Solución de la Tarea
Objetivos del día 2
Extracción de valores
División de Columnas
Operadores de texto
Operadores Numéricos
Creación de relaciones (modelo de datos)
Práctica: limpieza de datos y relaciones
Solución Limpieza de datos y relaciones
Diagramas de columnas apiladas
La pestaña de Formato
Diagrama de sectores - Directrices
Diagrama de sectores
Día 2: Proyecto Final
Solución de la Tarea
Objetivos del día 3
Anexar Consultas (Append Queries)
Anexar Consultas
Merge de Columnas y Agrupación de Consultas
Fechas y Jerarquías
Diagrama de Líneas
Día 3: Proyecto
Solución de la Tarea
Ficheros desde una carpeta
Modelos de Hechos Dimensional
Modelos de Hechos Dimensional
Edición de Relaciones y Cardinalidad
Activar y desactivar relaciones
Manejar y auto detectar relaciones
Cuestionario final del día 3
Objetivos del día 4
Tablas
Cómo personalizar las tablas
El formato condicional
Día 4: Proyecto Parte I
Solución de la Tarea
Añadir columnas con Merge
Unpivot y Pivot
Relaciones Many to Many y Dirección del Cross Filter
Slicer o Visualización del Filtrado
Editar Página
Día 4: Proyecto Parte II
Solución de la Tarea
Objetivos del Día 5
El Panel de Filtros
El Filtro Top N
Sincronizar Slicers
Visualizaciones TreeMap (Diagramas de Mosaico)
Editar Interacciones
Profundizaciones (Drilltrhoughs)
Mantener filtros con profundizaciones
Tooltips
Día 5: Proyecto Parte I
Solución de la Tarea
Columnas Personalizadas
Activar y Desactivar la Carga
Referencias vs Duplicados
Columnas desde Ejemplo
Día 5: Proyecto Parte II
Solución de la Tarea
Objetivos del Día 6
Cabecera de la Visualización y Orden de los Datos
Columnas Condicionales
Mapas
Mapas Rellenos
Predicciones
Profundizaciones a través de botones
Marcadores (Bookmarks)
Reto: Los Productos Top
Tarjetas
Tarjetas de Múltiples Filas
Día 6: Proyecto Final
Solución de la Tarea
Objetivos del Día 7
Página de Tooltips
Trabajar con Plantillas
Visualización a través de Scripts de R
Librerías y obtención de datos utilizando R
Trabajar con R para transformar los datos
Trabajar con Parámetros
Día 7: Proyecto Final
Solución de la Tarea
Objetivos del Día 8
Parámetros con Listas y Consultas
Obtener parámetros desde una página web
Utilizar parámetros en una página web
Reto (Solución)
Invocar una función personalizada
Tabla dinámica de fechas con parámetros y función personalizada
Solución a la Tarea
Objetivos del Día 9
Comprender las Columnas Calculadas
Comprender las Medidas
AVERAGE
COUNT, DISTINCTCOUNT, COUNTROWS
SUMX
AVERAGEX y ROUND
RELATED y el modelo de datos
CALCULATE
Los problemas del Filter
FILTER
Operadores Lógicos
Formateos y Comentarios
Retos de DAX
Las Soluciones del Reto
Objetivos del Día 10
ALL
ALL en Columnas
ALLEXCEPT
ALLSELECTED
DATEADD
Años hasta la Fecha y Meses hasta la Fecha
ROUNDING
FORMAT
Tabla completa de fechas con descripciones
Reto de DAX
Soluciones de la Tarea
Objetivos del Día 11
¿A dónde ir desde aquí?
Power BI Pro vs Free vs Premium
Regístrate de Forma Gratuita
Método alternativo sin email de trabajo
Un tour rápido por la interfaz
Mi Espacio de Trabajo
Publicar Reportes
Editar Reportes
Actualizar Reportes con Power BI Desktop
Crear y Explorar Espacios de Trabajo
Día 11: Proyecto
Solución de la Tarea
Objetivos del Día 12
Instalar y utilizar un Dat Gateway
Refresco Programado
Crear Apps
Crear Dashboards
Obtener Información Rápidamente
Utilizar la App para Móvil
Crear un Layout para Móvil
Día 12: Proyecto
Solución de la Tarea
Objetivos del Día 13
Seguridad básica a nivel de filas
Seguridad a nivel de filas en la nube
Modelo de Datos y Seguridad a Nivel de Filas
Seguridad dinámica a nivel de filas
Seguridad a nivel de filas muchos a muchos
Seguridad a Nivel de Página
Objetivos del Día 14
Plan de Acción
Cómo configurar Python en Power BI
Transformación de datos usando Python
Crear visualizaciones usando Python
Diagramas de violín, emparejados y ridge usando Python
Machine Learning (Analizador de Textos Bayesianos) usando Python
Eficiencia y Errores
Carga dinámica de datos desde web con JSON
Cómo configurar una base de datos MySQL
Carga dinámica de datos desde una base de datos SQL
Cómo configurar una base de datos PostgreSQL
Objetivos del Día 15
¿Qué es el lenguaje M?
Fundamentos del Editor Avanzado
Valores y Listas
Funciones de Table y Transformaciones de Columnas
Reto Rápido 1
Solución al Reto Rápido
Each y Table.AddColumns
Reto Rápido 2
Solución al Reto Rápido
Más funciones y Siguientes pasos
Felicidades por completar el curso de 15 días de Power BI

instructor

5.0 /5
(31)

  • Avatar
    Christian
    (5)
    Recommended

    I recommend the course because it teaches Power BI from scratch. It's helped me get started with implementing reports and dashboards.

  • Avatar
    BORJA
    (5)
    Excellent

    A really complete course, everything well explained.

  • Avatar
    Rocío
    (5)
    Excellent foundation for moving towards more complex data analysis

  • Avatar
    Joiser
    (5)
    One of the best

    It's an intensive and hands-on bootcamp, giving you solid skills to keep growing in Power BI

  • Avatar
    Miguel Ángel
    (5)
    Very practical and fun course

    This course was my first introduction to the world of Power BI. Before taking it, I only knew it by name. And honestly, I loved it. Although it's a "short" course in the sense that it's designed to be completed in 15 days, it's really comprehensive and lets you grasp the concepts. It has a very practical approach in that both during the classes and the assignments you end up practicing a lot of what's taught. Let's say the course goes from beginner to advanced as the days go by. The days covering the basics, where you see data cleaning and all that, seemed the coolest to me, maybe because it's the one that will demand the most work from you. The best part is that it left me wanting to take more courses on this subject.

  • Avatar
    Javi
    (5)
    Record time!

    I was impressed by how much I managed to progress in just a couple of weeks. I went from not understanding anything about reports to creating my own dashboards that look super professional and organized. The best part is that the pace is steady and doesn't let you lose interest, perfect for those of us who are short on time but want to really learn.

  • Avatar
    Santiago
    (5)
    Excellent course

    Excellent Power BI introductory course, you really don't need any prior knowledge and little by little you acquire all the tools necessary to overcome every challenge. I'm currently applying the foundations I've learned at work despite it having nothing to do with the subject (I'm a psychologist in a care home) and it's been a huge help—I'm offering solutions and perspectives that hadn't even been considered before. I encourage everyone to take the course because what you learn will definitely be very useful to you.

  • Avatar
    Gustavo
    (5)
    15 days that transform how you see data: the ultimate Power BI bootcamp

    The 15 Days of Power BI - The complete Power BI bootcamp is an intensive and perfectly structured experience that turns any data enthusiast into a professional capable of creating impactful dashboards, automating reports, and making decisions based on solid insights.

  • Avatar
    Giovanni
    (5)
    A radical shift in how I report

    It's incredible what you can achieve in such a short time when the content is so well structured and focused on practical results

  • Avatar
    Maria del Mar
    (5)
    I love how the course is structured

  • Avatar
    danison
    (5)
    a very complete course

    excellent course, all the content is very useful

  • Avatar
    Angel
    (5)
    15 Days of Power BI: The Complete Bootcamp to Master Analytics and Visualization

    This intensive course guides you step by step to master Power BI in just 15 days. You'll learn to connect multiple data sources, clean and transform information with Power Query, create impactful visualizations, and build interactive dashboards for decision-making. We also cover DAX fundamentals, hierarchies, time series and aggregations, all with a practical approach based on real projects.

  • Avatar
    María
    (5)
    Power BI in 15 days: intense but effective

    I loved this bootcamp format. Each day has a clear focus and objective, and that helped me stay motivated. I learned how to use Power BI professionally in a short time. An excellent experience!

  • Avatar
    Jorge
    (5)
    Intensive and really eye-opening

    It was days of heavy practice, but every minute was worth it; the bootcamp format gets you straight to what works and now I can create dashboards in a heartbeat that used to take me all morning.

  • Avatar
    Santiago
    (5)
    Intensive and practical

  • Avatar
    Nicolás
    (5)
    The learning curve is perfect.

  • Avatar
    Rosa
    (5)
    Intensive and practical

  • Avatar
    Jackeline
    (5)
    Ideal for learning fast and with structure.

  • Avatar
    Samuel
    (5)
    It's amazing what you can learn in such a short time

    This bootcamp is the best. In just 15 days I already feel like a pro at Power BI. The analyses I do now are much more professional

  • Avatar
    Carlos
    (5)
    Power BI from scratch in just 15 days

    The mix of theory and exercises in this course helped me gain confidence in no time, and now I can create professional dashboards without any trouble. Perfect for those looking for quick and effective results!

  • Avatar
    Gabriela
    (5)
    From zero to expert in just 15 days

    It was an intense class but incredibly rewarding. Recommended to master Power BI quickly

  • Avatar
    Guillermo
    (5)
    excellent course

    It's a highly recommendable bootcamp because every day it goes further and the challenges make you put into practice what you've seen and this way understand in an applied way what you learned in each class 100% recommendable

  • Avatar
    Alberto
    (5)
    The discovery of the year

    When I started I didn't think I'd get hooked on this program, now I'm struggling with SQL joins.

  • Avatar
    Isabel
    (5)
    Complete, practical and functional course

    I really enjoyed the course. The syllabus is very comprehensive, covering the most commonly used topics and the most demanded by companies. Thank you so much :)

  • Avatar
    Caty
    (5)
    Good and quite useful

    Very practical and accessible, perfect for BI professionals and beginners

  • Avatar
    Marc
    (5)
    Perfect

    The course went perfectly for me, I really enjoyed doing it

  • Avatar
    Yvonne
    (5)
    I love this course

    It's easy to keep up with them, Very good course. It motivates me to keep learning more every day

  • Avatar
    José Pablo
    (5)
    Excellent

    Very complete, really well explained, and the support material is amazing.

  • Avatar
    Omar
    (5)
    Great

  • Avatar
    Alberto
    (5)
    What a great acquisition!

  • Avatar
    Nicolas
    (5)
    Recommended

    I loved the course! The daily program design motivated me and let me progress systematically with small wins day after day.

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

69.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

69.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