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

5.0 /5
(20)

90
Bienvenido al curso de SAP Business One
Preview del Informe Final
Roadmap del curso
Toma notas de tu curso en tiempo real en Frogames Formación
SQL Server
Power BI
Avance 1 Roadmap
Conociendo los Insights requeridos por el negocio
Avance 2 del Roadmap
Acerca del ERP SAP Business One
Databases (examples) de SAP Business One
Ayuda de la SAP Community para el desarrollo de queries SQL
Avance 3 del Roadmap
Tips & Tricks de SQL para el Analista de Datos
Preparación SQL de tabla de datos de Ventas
Preparación SQL de tabla de datos de Compras
Preparación SQL de tabla de datos de Clientes
Preparación SQL de tabla nombre de la empresa
Avance 4 del Roadmap
Conexión SQL - Power Query Tabla Ventas
Conexión SQL - Power Query Tabla Compras
Conexión SQL - Power Query Tabla Clientes y Empresa
Limpieza y transformación Inicial de datos
Modelo Relacional en Power BI
Avance 5 del Roadmap
Tips and tricks: Storytelling vs Dashboards
Diseño y configuración del Lienzo
Título dinámico del informe
Primer párrafo del Informe
Avance 5 del Roadmap
¿Cuánto se ha comprado?
¿Cuál es la curva de crecimiento de las Compras del Negocio?
¿Cuál es el producto más comprado?
¿Qué se ha comprado?
¿Cuánto se ha comprado?
¿A quién se le ha comprado?
¿Desde dónde se trae lo comprado?
¿Se ha recibido todo lo comprado?
¿Se recibió en el tiempo acordado?
¿Cuál es el leadtime que se ha dado a las compras?
¿Cuál es el tiempo promedio de recepción de lo comprado?
¿Cuál es porcentaje de órdenes de compra válidas?
¿Cuál es el porcentaje de órdenes de compra cerradas?
¿Ha habido variación en los precios unitarios de los productos?
Párrafo de cierre contexto Compras
¿Cuánto se ha vendido?
¿Cuál es la curva de crecimiento de las ventas?
¿Cuántas transacciones se han hecho?
¿Cuál es la curva de crecimiento de transacciones?
¿Cuántas transacciones se registraron por canal?
¿Cuáles son las categorías líderes?
¿Cuál es el producto más vendido?
¿Qué se ha vendido?
¿Cuánto se ha vendido?
¿Quién ha vendido?
¿Cuál es el proveedor de esos productos?
¿A cuántos clientes se les ha vendido?
¿En dónde están los clientes?
¿Cuánto compran en promedio?
¿Cuál es la variedad de productos que se ha tenido y ventas válidas?
¿Cuántos clientes se encuentran registrados?
¿Cuál es la curva de crecimiento del registro de clientes?
¿En dónde se ubican los clientes registrados?
¿Cuántos clientes están registrados por los tipos de entrega que se tienen?
¿Cómo es la relación transacciones y monto promedio de compra de los clientes?
Avance 7 del Roadmap
Reutilización del informe caso SAP B1 Casos: Argentina y España
Avance 8 del Roadmap
Query SQL Server Mayor Contable
Modelo Relacional Tabla Finanzas México
¿A cuánto asciende el capital de trabajo del negocio?
¿Cuál es la curva de crecimiento del Activo Corriente vs Pasivo Corriente?
¿Cuál es el total de Ingresos del Período?
¿A cuánto ascienden los Gastos del período?
¿Cuáles son las fuentes de ingresos?
¿Cómo se distribuyen los Costos y Gastos?
¿Cómo la visión integral contable de la empresa?
Conexión SQL Power Query Finanzas España
¿Cuál es la distribución de la Financiación básica?
¿Cuál es la distribución de los Ingresos?
¿Cuál es la distribución de los Egresos?
¿Cuál es la distribución de las existencias?
¿Cómo es la visión integral contable de la empresa española?
Avance 9 del Roadmap
Publicación del Informe
Actualizar el Informe de forma automática y periódica
Compartir el informe vía web
Resumen Cuantitativo
Despedida del Curso
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(20)

  • Avatar
    Gabriela
    (5)
    Transforming businesses with SAP Business One and Power BI

    The instructor has a practical approach that makes everything easy to apply. Now I can make more informed decisions and optimize processes in my company. An essential course for business professionals.

  • Avatar
    Gustavo
    (5)
    SAP Business One + Power BI: Connected business intelligence with SQL Server

    The "SAP Business One: Business Insights with Power BI and SQL Server" course is designed for those who want to turn operational data into strategic decisions. Through a powerful integration between SAP Business One, SQL Server and Power BI, this program teaches you how to extract, transform and visualize key business information in real time.

  • Avatar
    Joiser
    (5)
    Great day to get started

    This course left me with a great taste, I really enjoyed the content and how you develop the topics, congratulations

  • Avatar
    Samuel
    (5)
    I feel more prepared for the challenges

    Using Power BI and SQL Server together changed how I see data. Before I just looked at it, now I interpret it and extract key insights.

  • Avatar
    Nieves
    (5)
    SAP Business One: Business Insights with Power BI and SQL Server – turn operational data into strategic decisions

    This course teaches you how to extract, transform, and visualize data from the SAP Business One ERP using SQL Server as your source and Power BI as your analysis tool. You'll learn to run SQL queries on SAP B1's structured tables, prepare reusable analytical models, and build dashboards that reveal commercial, administrative, and financial insights. The approach is technical, practical, and focused on business storytelling—perfect if you're looking to automate reports and make decisions backed by evidence.

  • Avatar
    Angel
    (5)
    SAP Business One: Insights de Negocios con Power BI y SQL Server

    This course teaches you how to extract, transform, and visualize data from the SAP Business One ERP using SQL Server and Power BI. You'll learn to run T-SQL queries on the system's structured tables, prepare reusable analytical models, and build dashboards that reveal commercial, administrative, and financial insights.

  • Avatar
    Jorge
    (5)
    Connecting the pieces

    I had the data in one place and the visualization in another, and this course taught me how to close the loop perfectly; seeing how information flows from the management system to the final dashboard was eye-opening for optimizing the sales report in my job.

  • Avatar
    Yvonne
    (5)
    100/10 excellent SAP Business course

    I learned how to get valuable business insights using Power BI and SQL Server, which has significantly improved decision-making in my company. I recommend this course to all SAP Business One users.

  • Avatar
    Carlos
    (5)
    Business Insights with SAP Business One and Power BI

    The instructor nailed it explaining how to extract and transform data from this powerful ERP to generate impactful dashboards. Now I feel more prepared to make data-driven decisions within my company. An extremely valuable course, no doubt about it.

  • Avatar
    Rosa
    (5)
    Excellent for teams!

  • Avatar
    Javi
    (5)
    The perfect combination for staying organized

    It helped me see all the information in my surroundings in a much clearer and more visual way. Now I feel like I have total control and can present reports that really impress with how well-organized they are. It's ideal for stopping work blind and starting to see real results.

  • Avatar
    Giovanni
    (5)
    Pure analytical power for SAP Business One

    The ability to transform raw information into strategic decisions that I've gained here has completely transformed the way I work

  • Avatar
    Santiago
    (5)
    I loved the course

  • Avatar
    Nicolás
    (5)
    Crystal clear explanations

  • Avatar
    Rocío
    (5)
    10 of 10

  • Avatar
    Jackeline
    (5)
    I really enjoyed the course

  • Avatar
    María
    (5)
    From SAP to Power BI Without Losing Your Way

    This course was exactly what I needed to understand how to integrate SAP Business One with Power BI and SQL Server. The explanations are very practical and focused on generating business value. I recommend it to anyone working in corporate environments.

  • Avatar
    Marc
    (5)
    Thrilled with the course

  • Avatar
    Yeison
    (5)
    Excellent data analysis course

    Another excellent course from Professor Pedro. A new tool for my data analysis toolkit, and by combining it with SQL and PowerBI I know my future analyses will be powerful and striking. Thank you very much Professor and Frogames team

  • Avatar
    BORJA
    (5)
    Excellent

    Very interesting course.

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