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

5.0 /5
(22)

79
Bienvenidos al curso de Data Analytics con SQL Server y Power BI
Bienvenido a Power BI y SQL Server
El Contexto de Data Analytics
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
SQL Server
Power BI Desktop
Base de datos Adventureworks
Enlaces de descarga de los softwares a usar en el curso
Archivo backup de la bases de datos Adventureworks
Fase 1 del proceso de Data Analytics
Requerimiento de información del negocio
Fase 2 del Proceso de Data Analitics
Recolección y catura de datos en el negocio
Fase 3 en el proceso de Data Analytics
Diagrama Entidad Relación Compras
Diagrama Entidad Relación Produccion
Diagrama Entidad Relación Ventas
Diagrama Entidad Relación de RRHH
Diagrama de Entidad Relación Clientes
Preparación de las consultas a las tablas en SQL Server
Vista SQL de Compras
Vista SQL tablas de Producción
Vista SQL tablas de Almacén
Vista SQL tablas de ventas
Vista SQL tablas RRHH
Vista SQL tablas Clientes
Fase 4 del proceso de Data Analytics
Power Query Compras
Power Query Produccion
Power Query Inventario
Power Query Ventas
Power Query Clientes
Power Query RRHH
Power Query Tabla Calendario
Modelo de datos integrado
Fase 5 del proceso de Data Analytics
Documentación Microsoft funciones DAX
DAX tabla de Compras 1
DAX tabla Compras 2
DAX tabla Compras 3
DAX tabla Producción 1
DAX tabla Producción 2
DAX tabla de Ventas 1
DAX tabla de Ventas 2
DAX tabla RRHH 1
DAX tabla RRHH 2
DAX tabla RRHH 3
DAX tabla Clientes
Fase 6 del proceso de Data Analytics
Logo Adventureworks
Dashboard Compras 1
Dashboard Compras 2
Dashboard Compras 3
Dashboard Compras 4
Dashboard Compras 5
Dashboard Producción 1
Dashboard Producción 2
Dashboard Producción 3
Dashboard Ventas 1
Dashboard Ventas 2
Dashboard Ventas 3
Dashboard Almacén 1
Dashboard Almacén 2
Dashboard RRHH 1
Dashboard RRHH 2
Dashboard RRHH 3
Dashboard RRHH 4
Dashboard Clientes 1
Dashboard Clientes 2
Dashboard Clientes 3
Menu del Informe 1
Menu del informe 2
Publicación del informe al Web Service Power BI
Compartir el informe en la web
Revisión general del Informe Data Analytics
Contenidos vistos en el curso
Despedida

instructor

5.0 /5
(22)

  • Avatar
    Joiser
    (5)
    Excellent course

    If you want to dive into the world of Data Analytics, this course will be a great help, 100% recommended

  • Avatar
    Angel
    (5)
    The Data Analytics Process with SQL Server and Power BI: master the complete cycle of business analysis

    This course guides you step by step through the complete Data Analytics process, combining the power of SQL Server for data management and extraction with Power BI's ability to visualize and analyze it. You'll learn to navigate complex schemas, create efficient T-SQL queries, transform data with Power Query, build relational models, and apply DAX to generate KPIs and temporal analysis. The approach is practical, structured, and designed for real business environments.

  • Avatar
    Javi
    (5)
    Everything is much clearer now

    It really helped me learn how to organize information because sometimes I had a bunch of data piled up and didn't know what to do with it. I liked how they teach you to connect the data with charts that you understand right away.

  • Avatar
    María
    (5)
    From raw data to final insight

    This course helped me understand the entire data analysis process: from the basics with SQL Server to final visualization in Power BI. It explains everything clearly with great examples. Really useful!

  • Avatar
    Santiago
    (5)
    Finally a course that explains the complete cycle

  • Avatar
    Nieves
    (5)
    The Data Analytics Process with SQL Server and Power BI – master the complete cycle of business analysis from database to dashboard

    This course teaches you how to execute the entire data analysis workflow in enterprise environments, combining the power of SQL Server for data management and transformation with Power BI's visual versatility. You'll learn to run SQL queries, prepare relational models, apply ETL processes, build interactive visualizations, and automate reports.

  • Avatar
    Nicolas
    (5)
    Great course.

    It has everything I needed, I'd buy the course again, excellent teacher, you can tell he has a lot of knowledge from how he diagrams and explains things, highly recommended!

  • Avatar
    Giovanni
    (5)
    From Raw Data to Strategic Decisions

    It's a fundamental course for anyone who wants to move beyond simply "looking at data" to generating real, actionable insights

  • Avatar
    Nicolás
    (5)
    Really great course and an excellent instructor

  • Avatar
    Jackeline
    (5)
    Excellent for automating processes without writing code

  • Avatar
    Rosa
    (5)
    a super cool course

  • Avatar
    Gustavo
    (5)
    From Basics to Insight: Master the Analytical Process with SQL Server and Power BI

    The Data Analytics Process with SQL Server and Power BI course is comprehensive training that connects two fundamental pillars of modern analysis: efficient data management with SQL Server and strategic visualization with Power BI. Ideal for those seeking to understand the complete cycle of data analysis, this course offers a clear, practical, and powerful path from extraction to decision-making.

  • Avatar
    Samuel
    (5)
    I'm really happy with the course

    Now I understand data analysis processes at a more logical level.

  • Avatar
    Gabriela
    (5)
    Discovering the Power of Data

    Clear explanations made everything easy to understand.

  • Avatar
    Carlos
    (5)
    Data Analytics with SQL Server and Power BI in One Course

    One of the most complete courses I've taken. It taught me how to manage complex databases with SQL Server and turn that data into high-impact reports with Power BI. I really liked the course structure because it follows the complete data analysis workflow, from extraction to visualization.

  • Avatar
    Belisario
    (5)
    Excellent Course, Huge Thanks to the Instructor

    Huge thanks for the excellent course, an in-depth model applicable to the job market and very educational, where each area of knowledge about this tool is covered, the applicability of the case study was very useful. I'm very happy to have received this knowledge.

  • Avatar
    Ever
    (5)
    Recommended

    One of the best courses to strengthen the connection between SQL Server and Power BI

  • Avatar
    Marc
    (5)
    So happy!

  • Avatar
    Maria del Mar
    (5)
    Great course

  • Avatar
    Yvonne
    (5)
    following my Power BI Path

    I started my course, following the Power BI courses, honestly excellent, really good classes, easy to understand and great audio and video quality.

  • Avatar
    danison
    (5)
    is one of the best out there for online courses

    I'm loyal to their courses, I love them.

  • Avatar
    BORJA
    (5)
    Excellent

    Very interesting course.

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

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

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