OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

Generando un Data Lake House con Azure Synapse Analytics

Leire Ahedo

En este proyecto aprenderemos a generar un Data Lake House con Azure Synapse Analytics. Un Data Lake House es una arquitectura novedosa que engloba las ventajas de los Data Warehouse convencionales junto con las capacidades de Big Data y Data Lakes.

Durante este curso aprenderemos todo lo relacionado con Synapse Analytics, desde la generación y configuración del entorno, hasta el desarrollo de ETL con Data Factory y la visualización de datos con Power BI. Además incorpora ejercicios y proyectos prácticos para aprender haciendo.

Read more

En este proyecto aprenderemos a generar un Data Lake House con Azure Synapse Analytics. Un Data Lake House es una arquitectura novedosa que engloba las ventajas de los Data Warehouse convencionales junto con las capacidades de Big Data y Data Lakes.

Durante este curso aprenderemos todo lo relacionado con Synapse Analytics, desde la generación y configuración del entorno, hasta el desarrollo de ETL con Data Factory y la visualización de datos con Power BI. Además incorpora ejercicios y proyectos prácticos para aprender haciendo.

Por todo ello, aprenderás a generar y aplicar una de las arquitecturas mas novedosas y mas potentes en el mundo del dato y del Big Data junto con Azure Synapse Analytics

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until March 12, 2027
Save 40% Off 3 Months
Access thousands of top-rated learning programs with a Coursera Plus monthly subscription and take 40% off 3 months for a limited time.
Take
40%
off
Get offer

What's inside

Syllabus

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Explica parte de un proceso de Big Data y Data Lakes
Tiene proyectos prácticos para aprender haciendo
Requiere conocimientos de ETL con Data Factory
Aprende sobre visualización de datos con Power BI
Enseña sobre la configuración del entorno de Azure Synapse Analytics

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Guía práctica data lake house azure synapse

Según los estudiantes, este curso es un altamente recomendado punto de partida para entender e implementar una Data Lake House con Azure Synapse Analytics. Los estudiantes resaltan la excelente capacidad del instructor para explicar conceptos complejos de forma clara y concisa. El curso destaca por su fuerte enfoque práctico, ofreciendo numerosos ejercicios y proyectos que facilitan el aprendizaje y la aplicación real de conocimientos. Aunque generalmente muy positivo, algunos estudiantes señalaron inconvenientes con el entorno de laboratorio, si bien la mayoría logró resolverlos. Este curso es ideal para profesionales que buscan aprender una arquitectura de datos moderna y relevante.
Aborda una arquitectura de datos moderna y esencial para el futuro.
"Se aprende un concepto nuevo, y que es el futuro de los Data Warehouse y Big Data."
"El curso es muy útil para empezar en el mundo de Azure Synapse Analytics y data lakehouse."
"Se cubren conceptos importantes y se aplica una arquitectura de datos moderna y relevante."
El instructor explica conceptos complejos de forma excelente.
"Las explicaciones del profesor son excelentes, lo que facilita el aprendizaje."
"El instructor explica de manera clara y concisa, ideal para entender conceptos complejos."
"Muy buena la explicación del profesor, con gran capacidad para hacer los temas accesibles y comprensibles."
Curso con ejercicios y proyectos prácticos muy útiles.
"Excelente proyecto práctico, muy bien explicado y muy útil."
"La parte práctica del curso me parece la más importante y fue muy bien lograda, aprendí haciendo."
"Es un excelente curso, donde se aprende mucho, con ejercicios prácticos y bien explicados."
Algunos alumnos tuvieron dificultades con el entorno de laboratorio.
"No funciona el link de powerbi, no carga la base de datos... tuve que buscar en los foros."
"Tuve un problema al cargar los datos en el Data Lake, aunque logré solucionarlo buscando en el foro."
"La herramienta de laboratorio tuvo algún error, pero lo consideré más del ambiente que del curso."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Generando un Data Lake House con Azure Synapse Analytics with these activities:
Compilar Recursos de Azure Synapse Analytics
Compilar recursos te permitirá acceder fácilmente a información y herramientas relevantes para el curso.
Browse courses on Azure Synapse Analytics
Show steps
  • Recopilar enlaces a documentación, tutoriales y artículos
  • Organizar los recursos en categorías o carpetas
Revisar Conceptos de Data Warehousing
Refrescar tus conocimientos sobre data warehousing te proporcionará una base sólida para comprender el concepto de Data Lake House implementado en Azure Synapse Analytics.
Browse courses on Data Warehousing
Show steps
  • Revisar notas de cursos anteriores o leer artículos sobre data warehousing
  • Practicar el diseño dimensional y comprender los conceptos de grano y dimensionalidad
Participar en un Grupo de Estudio de Azure Synapse Analytics
Participar en un grupo de estudio te permitirá conectarte con otros estudiantes, compartir conocimientos y aprender de diversas perspectivas.
Browse courses on Azure Synapse Analytics
Show steps
  • Unirse o crear un grupo de estudio con compañeros de clase o estudiantes de la comunidad
  • Discutir conceptos, resolver problemas y compartir recursos
  • Revisar el material del curso y prepararse para los exámenes
Five other activities
Expand to see all activities and additional details
Show all eight activities
Build a Data Lake House with Azure Synapse Analytics
Seguir tutoriales guiados te permitirá explorar las capacidades de Azure Synapse Analytics y comprender cómo construir un Data Lake House de forma práctica.
Browse courses on Azure Synapse Analytics
Show steps
  • Explorar la documentación oficial de Azure Synapse Analytics
  • Seguir tutoriales paso a paso en plataformas como Microsoft Learn o Coursera
Hands-on ETL Development with Mapping Data Flows
La práctica repetitiva con Mapping Data Flows te ayudará a desarrollar fluidez en el desarrollo de ETL y mejorar tus habilidades de transformación de datos.
Browse courses on Mapping Data Flows
Show steps
  • Crear flujos de datos de mapeo para escenarios de transformación de datos comunes
  • Experimentar con diferentes transformaciones y funciones
  • Resolver problemas y optimizar el rendimiento de los flujos de datos
Visualize Data with Power BI Dashboard
Crear un panel de Power BI te permitirá visualizar los datos procesados en Synapse Analytics y obtener información valiosa.
Browse courses on Power BI
Show steps
  • Conectarse a Azure Synapse Analytics desde Power BI
  • Crear visualizaciones interactivas utilizando gráficos y tablas
  • Agregar filtros, segmentaciones y otros elementos de interacción
  • Compartir el panel con las partes interesadas
Realizar Ejercicios Hands-on de Desarrollo ETL
Practicar ejercicios prácticos de desarrollo ETL te preparará para los desafíos del curso y mejorará tus habilidades de transformación de datos.
Browse courses on Data Integration
Show steps
  • Completar ejercicios de muestra o crear tus propios escenarios de ETL
  • Utilizar herramientas como Azure Data Factory o SSIS para implementar soluciones ETL
  • Optimizar los procesos ETL para mejorar el rendimiento y la eficiencia
Participar en Hackatones Relacionados con Azure Synapse Analytics
Participar en hackatones te permitirá aplicar tus habilidades, colaborar con otros y ampliar tus conocimientos en un entorno práctico y competitivo.
Browse courses on Azure Synapse Analytics
Show steps
  • Buscar y registrarse en hackatones relevantes
  • Formar un equipo o trabajar individualmente
  • Desarrollar soluciones innovadoras utilizando Azure Synapse Analytics

Career center

Learners who complete Generando un Data Lake House con Azure Synapse Analytics will develop knowledge and skills that may be useful to these careers:
Data Lake Analyst
A Data Lake Analyst is responsible for designing, developing, and managing data lakes within an organization. They work closely with data engineers to ensure that data is properly ingested, stored, and processed within the data lake. This course can help you become a Data Lake Analyst by providing you with the skills and knowledge you need to design, develop, and manage data lakes using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to ingest, store, and process data from a variety of sources, and how to use Power BI to visualize and analyze data stored in the data lake.
See salaries and explore the career path for Data Lake Analyst
Data Engineer
Data Engineers are responsible for designing, developing, and managing data pipelines within an organization. They work closely with data scientists and data analysts to ensure that data is properly ingested, stored, and processed for use in data science and analytics applications. This course can help you become a Data Engineer by providing you with the skills and knowledge you need to design, develop, and manage data pipelines using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to ingest, store, and process data from a variety of sources, and how to use Power BI to visualize and analyze data stored in the data lake.
See salaries and explore the career path for Data Engineer
Data Architect
Data Architects are responsible for designing and managing the overall data architecture within an organization. They work closely with data engineers and data scientists to ensure that data is properly managed and used to support the organization's business objectives. This course can help you become a Data Architect by providing you with the skills and knowledge you need to design and manage data architectures using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to design and implement data architectures that support the organization's business objectives.
See salaries and explore the career path for Data Architect
Data Scientist
Data Scientists are responsible for using data to solve business problems. They work closely with data engineers and data analysts to develop and implement data science models that can be used to predict outcomes, identify trends, and make recommendations. This course can help you become a Data Scientist by providing you with the skills and knowledge you need to use Azure Synapse Analytics to develop and implement data science models. You will learn how to use Azure Synapse Analytics to access and analyze data, and how to use Power BI to visualize and communicate your findings.
See salaries and explore the career path for Data Scientist
Business Analyst
Business Analysts are responsible for identifying and solving business problems using data. They work closely with stakeholders to understand their business needs and develop solutions that meet those needs. This course can help you become a Business Analyst by providing you with the skills and knowledge you need to use Azure Synapse Analytics to identify and solve business problems. You will learn how to use Azure Synapse Analytics to access and analyze data, and how to use Power BI to visualize and communicate your findings.
See salaries and explore the career path for Business Analyst
Data Management Consultant
Data Management Consultants help organizations to improve their data management practices. They work with organizations to assess their current data management practices, and develop and implement solutions to improve data quality, data security, and data governance. This course can help you become a Data Management Consultant by providing you with the skills and knowledge you need to assess and improve data management practices. You will learn how to use Azure Synapse Analytics to assess data quality, data security, and data governance, and how to develop and implement solutions to improve these areas.
See salaries and explore the career path for Data Management Consultant
Database Administrator
Database Administrators are responsible for managing and maintaining databases. They work closely with database developers to ensure that databases are properly designed, implemented, and maintained. This course can help you become a Database Administrator by providing you with the skills and knowledge you need to manage and maintain databases using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to create, manage, and maintain databases, and how to monitor and optimize database performance.
See salaries and explore the career path for Database Administrator
Software Engineer
Software Engineers are responsible for designing, developing, and maintaining software applications. They work closely with stakeholders to understand their software needs and develop solutions that meet those needs. This course can help you become a Software Engineer by providing you with the skills and knowledge you need to design, develop, and maintain software applications using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to develop and implement software applications that can access and analyze data.
See salaries and explore the career path for Software Engineer
Systems Analyst
Systems Analysts are responsible for analyzing and designing systems. They work closely with stakeholders to understand their system needs and develop solutions that meet those needs. This course can help you become a Systems Analyst by providing you with the skills and knowledge you need to analyze and design systems using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to develop and implement systems that can access and analyze data.
See salaries and explore the career path for Systems Analyst
Data Warehouse Developer
Data Warehouse Developers are responsible for designing and developing data warehouses. They work closely with data analysts and data scientists to ensure that data warehouses are properly designed and implemented to support the organization's business objectives. This course can help you become a Data Warehouse Developer by providing you with the skills and knowledge you need to design and develop data warehouses using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to design and implement data warehouses that support the organization's business objectives.
See salaries and explore the career path for Data Warehouse Developer
Data Analyst
Data Analysts are responsible for analyzing data to identify trends and patterns. They work closely with stakeholders to understand their data needs and develop solutions that meet those needs. This course can help you become a Data Analyst by providing you with the skills and knowledge you need to analyze data using Azure Synapse Analytics. You will learn how to use Azure Synapse Analytics to access and analyze data, and how to use Power BI to visualize and communicate your findings.
See salaries and explore the career path for Data Analyst
Project Manager
Project Managers are responsible for planning, executing, and controlling projects. They work closely with stakeholders to understand their project needs and develop solutions that meet those needs. This course may be useful to Project Managers by providing them with the skills and knowledge they need to manage projects that involve Azure Synapse Analytics. They will learn how to use Azure Synapse Analytics to develop and implement project plans, and how to monitor and control project progress.
See salaries and explore the career path for Project Manager
Systems Administrator
Systems Administrators are responsible for managing and maintaining computer systems. They work closely with users to ensure that computer systems are properly configured and maintained. This course may be useful to Systems Administrators by providing them with the skills and knowledge they need to manage and maintain systems that use Azure Synapse Analytics. They will learn how to use Azure Synapse Analytics to configure and maintain systems, and how to monitor and troubleshoot system performance.
See salaries and explore the career path for Systems Administrator
IT Manager
IT Managers are responsible for managing and directing the IT department within an organization. They work closely with senior management to ensure that IT resources are aligned with the organization's business objectives. This course may be useful to IT Managers by providing them with the skills and knowledge they need to manage and direct the IT department in an organization that uses Azure Synapse Analytics. They will learn how to use Azure Synapse Analytics to develop and implement IT strategies, and how to manage and control IT resources.
See salaries and explore the career path for IT Manager
Data Governance Manager
Data Governance Managers are responsible for developing and implementing data governance policies and procedures within an organization. They work closely with stakeholders to ensure that data is properly managed and used to support the organization's business objectives. This course may be useful to Data Governance Managers by providing them with the skills and knowledge they need to develop and implement data governance policies and procedures. They will learn how to use Azure Synapse Analytics to develop and implement data governance policies and procedures, and how to monitor and enforce data governance compliance.
See salaries and explore the career path for Data Governance Manager

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Generando un Data Lake House con Azure Synapse Analytics.
Cover image
The Data Warehouse Lifecycle Toolkit
Save
Este libro proporciona una base sólida en los conceptos fundamentales de almacenamiento de datos. Es una lectura esencial para aquellos que buscan comprender los principios y mejores prácticas detrás de los almacenes de datos, que son esenciales para el funcionamiento de Azure Synapse Analytics.
The Data Warehouse Lifecycle Toolkit
Paperback
Check
The Data Warehouse Lifecycle Toolkit
Kindle Edition
Check
Cover image
DAX Patterns
Save
Este libro proporciona una guía completa sobre visualización de datos con Power BI, que es esencial para comunicar los resultados del análisis de datos.
(English) DAX Patterns: Second Edition
Paperback
$$
(English) DAX Patterns 2015
Paperback
$$
(English) DAX Patterns: Second Edition
Kindle Edition
$$
Cover image
Expert Cube Development with SSAS Multidimensional...
Save
Este libro proporciona una referencia rápida para Power BI, que es esencial para utilizar esta herramienta para visualizar y analizar datos desde un Data Lakehouse.
(English) Expert Cube Development with SSAS Multidimensional...
Kindle Edition
$$
Cover image
The Kimball Group Reader
Save
Provides a comprehensive overview of data warehousing concepts and best practices. It valuable resource for anyone who is new to data warehousing or wants to learn more about its fundamentals.
The Kimball Group Reader
Paperback
Check
The Kimball Group Reader
Kindle Edition
Check
Cover image
Data Science for Business
Save
Provides a comprehensive overview of data science concepts and applications. It valuable resource for anyone who is new to data science or wants to learn more about its applications in business.
(English) Data Science for Business: What You Need to Know...
Paperback
$$
(English) Data Science for Business: What You Need to Know...
Kindle Edition
$$
Cover image
Drawing Codes
Save
Provides a gentle introduction to machine learning concepts and algorithms. It valuable resource for anyone who is new to machine learning or wants to learn more about its applications.
(English) Drawing Codes: Experimental Protocols of...
Hardcover
$$
Cover image
Deep Learning
Save
Provides a comprehensive overview of deep learning concepts and algorithms. It valuable resource for anyone who is new to deep learning or wants to learn more about its applications.
(English) Deep Learning
Paperback
$$$
(English) Deep Learning (Adaptive Computation and Machine...
Hardcover
$$$
(English) Deep Learning (Adaptive Computation and Machine...
Kindle Edition
$$$
Foundations of Statistical Natural Language...
Save
Provides a comprehensive overview of natural language processing concepts and algorithms. It valuable resource for anyone who is new to natural language processing or wants to learn more about its applications.
Foundations of Statistical Natural Language...
Paperback
Check
Foundations of Statistical Natural Language...
Kindle Edition
Check
Cover image
The New Fire
Save
Provides a comprehensive overview of computer vision concepts and algorithms. It valuable resource for anyone who is new to computer vision or wants to learn more about its applications.
(English) The New Fire: War, Peace, and Democracy in the Age...
Paperback
$$
(English) The New Fire: War, Peace, and Democracy in the Age...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Generando un Data Lake House con Azure Synapse Analytics.
Python with Power BI: Analyzing Financial Data
Most relevant
Power BI for Data Science and Analytics
Most relevant
Introduction to Data Analytics
Most relevant
Creative Designing in Power BI
Most relevant
Power BI Masterclass 8 -Python, Finance, and Advanced DAX
Most relevant
Data Visualization with Power BI: Storytelling with Data
Most relevant
Data Visualization in Power BI: Create Your First...
Most relevant
IBM Data Analyst Capstone Project
Most relevant
Power BI Integration with AWS and Snowflake
Most relevant

Coursera Buyer Protection & Guarantee

Verified partner policies & purchase protections

Accredited University Partner
Free Trial & Audit

7-Day Free Trial & Free Audit

7-day free trial on monthly Coursera Plus subscriptions; free audit option available on most individual courses to explore video lectures and readings at no charge.

Return & Refund Policy

14-Day Refund Guarantee

14-day refund window on annual Coursera Plus subscriptions and single-course purchases prior to certificate issuance. Monthly subscriptions do not offer refunds once billed.

Buyer Protections

Verified Academic & Industry Partner

Accredited university and industry certifications (e.g. Stanford, Google, IBM, Yale), secure SSL payment processing, and verifiable digital certificate links.

Key Purchase Protections
14-day refund window on annual Coursera Plus and single courses
7-day free trial on monthly Coursera Plus subscriptions
Free course audit option for lectures and readings
Verified certificates from top universities & companies
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
2 horas
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Leire Ahedo
Language
Español
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Explica parte de un proceso de Big Data y Data Lakes
Tiene proyectos prácticos para aprender haciendo
Requiere conocimientos de ETL con Data Factory
Aprende sobre visualización de datos con Power BI
Enseña sobre la configuración del entorno de Azure Synapse Analytics
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Generando un Data Lake House con Azure Synapse Analytics.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser