We may earn an affiliate commission when you visit our partners.
Course image
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.

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

What's inside

Syllabus

Visión general del proyecto
En este curso se aprenderá a utilizar Azure Synapse Analytics y a generar ETLs con Mapping Data Flows y visualizar los datos con Power BI

Good to know

Know what's good
, what to watch for
, 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

Save Generando un Data Lake House con Azure Synapse Analytics to your list so you can find it easily later:
Save

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

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

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Generando un Data Lake House con Azure Synapse Analytics.
Crea un app de Machine Learning con Spark, Synapse...
Most relevant
Azure Synapse Analytics: desde el DWH, hasta PowerBI y...
Most relevant
Regresión (ML) en la vida real con PyCaret
Most relevant
Agrega estilo a una página HTML usando CSS
Most relevant
Diseño y optimización de un modelo de datos en Power BI
Most relevant
PowerBI: Preparación de datos para el análisis
Most relevant
¡Luces, celular y acción! Crea contenidos audiovisuales...
Most relevant
Ciencia de las Técnicas Culinarias
Most relevant
Innovar
Most relevant
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 - 2024 OpenCourser