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

5.0 /5
(20)

54
Bienvenidos a nuestro curso de MySQL, RStudio y Power BI con casos reales
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
Introducción
DataScient - DataScientist
Acerca de la herramientas a usar en el curso
Contexto del caso
Importancia de los pronósticos para el negocio
Consulta SQL para data de Serie de Tiempo
Conexión RScript con MySQL para Data de Tserie
Pruebas formales tseries en Script R
Series de tiempo y forecast Script R
RMardown Pronóstico de ventas Retail
Contexto del caso 2
Importancia de la minería de datos en el negocio
Consulta SQL para data de Asociación de ventas de productos
Conexión R MySQL data Asociación de ventas de productos
RScript Reglas de asociación
Knitr RMardown Reglas de Asociación Retail
Informe HTML Reglas de Asociación productos Retail
Contexto caso 3
Importancia de la minería de opinión para el negocio
¿Cómo hacemos minería de Opinión?
Tablas MySQL para formulario NPS
Formulario web NPS y Opinión
Formulario NPS parte 2
Publicación del formulario NPS y Opinión
RScript Minería de Opinión data MySQL NPS
RScript Minería de Opinión para Windows
RScript Minería de Opinión en Power Query
Modelado Power Query Minería de Opinión
Cálculos DAX para informe NPS y Minería de Opinión
Cálculos DAX parte 2
Informe NPS y Minería de Opinión parte 1
Informe NPS y Minería de Opinión parte 2
Informe NPS y Minería de Opinión parte 3
Prueba de funcionalidad del informe y Formulario web
Publicación del informe a Power BI web
Informe Power BI NPS y Minería de Opinión en la Web
Contexto del caso 4
Importancia del clustering para el negocio
Dataflows
Consulta SQL para datos Retail clustering
RScript Kmeans data MySQL parte 1
Inserción Resultado Kmeans hacia MySQL
API Rest data Clustering Retail
Publicación web de las API Rest Clustering Retail
DataFlow Power BI con API Rest Clustering Retail
Informe Power BI dataflow Clustering Retail parte 1
Informe Power BI dataflow Clustering Retail parte 2
Informe Power BI dataflow Clustering Retail parte 3
Publicación e inserción HTML del informe web de Power BI Clustering
Despedida del curso

instructor

5.0 /5
(20)

  • Avatar
    Angel
    (5)
    Data Science with MySQL, RStudio and Power BI: Real Cases

    This course teaches you how to solve real business problems by applying data science with three key tools: MySQL for structured queries, RStudio for statistical analysis and text mining, and Power BI for dynamic visualization. You'll learn to connect databases, process information with RMarkdown, create predictive models and build interactive dashboards that communicate strategic insights. Each module starts with a practical case, simulating real challenges in areas like sales, marketing and customer experience.

  • Avatar
    Gabriela
    (5)
    Applied Data Science for Real-World Cases

    I loved how this course combines tools to solve real-world problems. The exercises are super practical and easy to follow.

  • Avatar
    Marc
    (5)
    Really interesting

    The fact that the course focuses on real-world use cases was really helpful for me

  • Avatar
    danison
    (5)
    Keep it up.

    You can tell the care you put into your courses. Keep it up, a hug.

  • Avatar
    Jackeline
    (5)
    I loved that it includes everything from SQL queries to interactive dashboards

  • Avatar
    Jorge
    (5)
    Everything in one package

    It was super helpful to see how data connects from the server to the final report; now I'm able to extract valuable information from any database and present it in a way anyone can understand.

  • Avatar
    BORJA
    (5)
    Excellent

    Highly recommended if you want to advance in Data Science.

  • Avatar
    Javi
    (5)
    Everything connected and working

    I loved seeing how information flows from one tool to another until it becomes a report that anyone can understand. Using real-life examples made everything much easier to grasp. It's great to feel like you have the power to transform raw data into smart decisions for any business.

  • Avatar
    Santiago
    (5)
    Very practical, it helped me improve my analyses in RStudio

  • Avatar
    Giovanni
    (5)
    A complete and professional workflow

    Learning to extract data with SQL, process it with R, and finally visualize it in an impactful way in Power BI has given me a global view of the entire analysis cycle. The hands-on projects are very dynamic and leave you with a portfolio ready to show that you know how to handle large volumes of information from start to finish

  • Avatar
    Rocío
    (5)
    I enjoyed seeing applications in real cases

  • Avatar
    Nicolás
    (5)
    What I enjoyed most were the real-world cases

    excellent course

  • Avatar
    Nieves
    (5)
    Data Science with MySQL, RStudio and Power BI: Real Cases – connect, analyze and visualize data with a business approach

    This course teaches you how to integrate MySQL, RStudio and Power BI to solve real business problems through data analysis. You'll learn to run SQL queries, connect R with databases, apply text mining and time series analysis, and build interactive dashboards in Power BI.

  • Avatar
    Rosa
    (5)
    Amazing how the creation of interactive dashboards that show results and KPIs for decision-making works.

  • Avatar
    Gustavo
    (5)
    Data Science applied: From MySQL to Power BI with RStudio as analytical engine

    The "Data science with MySQL, RStudio and Power BI: Real Cases" course offers a complete learning experience for those who want to master the full cycle of data analysis, from extraction to visualization, passing through statistical modeling. What sets it apart is its focus on real cases, which allows participants to apply what they've learned in concrete and relevant contexts.

  • Avatar
    María
    (5)
    Real-world cases that prepare you for the workplace

    I loved this course because it doesn't just stick to theory. Working with MySQL, RStudio, and Power BI in real situations helped me understand the complete flow of professional data analysis. Very comprehensive and well explained.

  • Avatar
    Samuel
    (5)
    A complete shift in mindset

    The practical applications helped me see how to use data science in the real world. Now my work makes more sense and my analyses are much more accurate.

  • Avatar
    Carlos
    (5)
    Applied Data Science with Powerful Tools

    What I enjoyed most was the variety of tools and how each one is used in real-world scenarios. Now I have a much clearer picture of how data scientists work in real life. An incredibly useful and well-structured course!

  • Avatar
    Joiser
    (5)
    Very practical

    I loved that it was a hands-on course, and that they covered lots of common cases, I really enjoyed it

  • Avatar
    Yvonne
    (5)
    KEEP GOING

    The Data Science course with MySQL, RStudio and Power BI gives you real cases to apply your skills in data analysis, visualization and manipulation using these powerful tools.

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

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

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