Data is one of an organization’s most valuable commodities. But how can organizations best use their data? And how does the organization determine which data is the most recent, accurate, and useful for business decision making at the highest level?
Este curso faz parte do Certificado Profissional Engenharia de dados da IBM
oferecido por
Informações sobre o curso
6.318 visualizações recentes
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Curso 12 de 13 no
Nível iniciante
Computer and IT literacy.
Aprox. 12 horas para completar
Inglês
Legendas: Inglês
Habilidades que você terá
Business IntelligenceData Warehousingcognos analytics
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Curso 12 de 13 no
Nível iniciante
Computer and IT literacy.
Aprox. 12 horas para completar
Inglês
Legendas: Inglês
oferecido por
IBM
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
Programa - O que você aprenderá com este curso
2 horas para concluir
Data Warehouses, Data Marts, and Data Lakes
Welcome to your first module! This module provides a gentle but thorough introduction to data warehouse systems, data lakes, and data marts. When you complete this module, you’ll be able to identify and compare data warehouse systems, data mart, and data lake architecture and understand how organizations can benefit from each of these three data storage entities. Optionally, explore the workings of IBM Db2 data warehouse system architecture, view use cases and understand the key capabilities and integrations available with IBM Db2 Warehouse. Then, learn about three types of data warehouse systems and learn about popular data warehouse system vendors. Be ready to help your organization assess new data warehouse system offerings when you know the five essential, critical criteria, including total cost of ownership criteria, to evaluate before changing to a new data warehouse system.
2 horas para concluir
6 vídeos (Total 33 mín.), 2 leituras, 2 testes
4 horas para concluir
Designing, Modeling and Implementing Data Warehouses
In this knowledge-packed module, you’ll explore general and reference enterprise data warehousing architecture. You’ll explore how data cubes relate to star schemas. Then learn how to slice, dice, drill up or down, roll up, and pivot relative to data cubes. Next, learn about the capabilities of materialized views, their benefits, and how to apply them. You’ll learn how data organization using facts and dimensions and their related tables to organize their information. Then, learning how to use normalization to create a Snowflake schema as an extension of Star schema. Learn about populating a data warehouse, incremental data updates, verifying data, querying data, interpreting an entity-relationship diagram for a star schema, using the, creating a materialized view and apply the CUBE and ROLLUP options. You’ll understand how organizations can benefit by implementing staging.
4 horas para concluir
8 vídeos (Total 56 mín.), 3 leituras, 6 testes
3 horas para concluir
Data Warehouse Analytics
In this module, you’ll fast-track your data analytics learning and gain hands-on data analytics experience using IBM Cognos Analytics. After registering with Cognos Analytics, you’ll explore the platform’s capabilities by creating visualizations, building a simple dashboard, and trying out its advanced features.
3 horas para concluir
6 vídeos (Total 26 mín.), 1 leitura, 2 testes
3 horas para concluir
Final Assignment and Final Quiz
In this module, you’ll complete your final course project, which brings together concepts and practices you previously learned about in the first three modules. In this final project, you design and load data into a data warehouse using facts and dimension tables. Then write aggregation queries using CUBE and ROLLUP and create materialized query tables, known as a materialized view. Complete your project by using IBM Cognos to create an analytics dashboard.
3 horas para concluir
3 leituras
Sobre Certificado Profissional Engenharia de dados da IBM
This Professional Certificate is for anyone who wants to develop job-ready skills, tools, and a portfolio for an entry-level data engineer position. Throughout the self-paced online courses, you will immerse yourself in the role of a data engineer and acquire the essential skills you need to work with a range of tools and databases to design, deploy, and manage structured and unstructured data.
Perguntas Frequentes – FAQ
When will I have access to the lectures and assignments?
O que recebo ao me inscrever para este certificado?
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.
