Programa Especializado - Almacenamiento de Datos para Inteligencia Empresarial

Comienza el abr. 03

Pruébalo gratis

Enroll to start your 7-day full access free trial.

Programa Especializado - Almacenamiento de Datos para Inteligencia Empresarial

Harness Business Data. Build a fully-optimized business data warehouse in five courses.

Sobre este Programa Especializado

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.

Creada por:

Socios de la industria:

courses
5 courses

Sigue el orden sugerido o elige el tuyo.

projects
Proyectos

Diseñado para ayudarte a practicar y aplicar las habilidades que aprendiste.

certificates
Certificados

Resalta tus nuevas habilidades en tu currículum o LinkedIn.

Pruébalo gratis
Enroll and get full access to every course in the Specialization for 7 days. Cancel any time.
Cursos
Advanced Specialization.
Designed for those already in the industry.
  1. CURSO 1

    Fundamentos de la Gestión de Bases de Datos

    Próxima sesión: abr. 3 — may. 29.
    Dedicación
    7 weeks of study, 4-6 hours/week
    Subtítulos
    English, Chinese (Simplified)

    Acerca del Curso

    Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.
  2. CURSO 2

    Conceptos, Diseño e Integración de Almacenes de Datos

    Sesión actual: mar. 27 — may. 8.
    Subtítulos
    English

    Acerca del Curso

    Este es el segundo curso en la especialización Almacenes de datos para Inteligencia de Negocios. Es preferible que los cursos sean tomados de forma secuencial. En este curso, usted aprendera conceptos y habilidades excitantes para el diseño de almacenes de datos y la creación de flujos de trabajo de integración de datos. Estas son habilidades fundamentales para los desarrolladores y administradores de almacenes de datos. Adquirirá nuevas experiencias en el diseño de almacenes de datos y el uso de productos de código abierto para manipular tablas pivote y crear flujos de trabajo de integración de datos. También obtendrá una panorámica conceptual sobre los modelos de madurez, arquitecturas, modelos multidimensionales y prácticas de administración, brindando una perspectiva organizacional del desarrollo de los almacenes de datos. Si ya usted es un profesional de tecnologías de información o negocio y quiere convertirse en diseñador o administrador de almacenes de datos, este curso le dará el conocimiento y las habilidades necesarias. Al finalizar el curso, usted tendrá experiencia en el diseño, panorámica del software y contexto de organización que lo prepara para lograr el éxito con proyectos de desarrollo de almacenes de datos. En este curso, usted creará diseños de almacenes de datos y flujos de trabajo de integración de datos que satisfagan las necesidades de inteligencia de negocio de las organizaciones. Al terminar este curso, será capaz de: * Evaluar una organización en cuanto a la madurez del almacén de datos y la alineación a la arquitectura de negocio; * Realizar el diseño de un almacén de datos y reflexionar en metodologías de diseño y objetivos de diseño alternativos; * Crear flujos de trabajo de integración de datos usando software de código abierto destacado; * Reflexionar en el rol de cambio de datos, restricciones de actualización, equilibrio en la frequencia de actualización y metas en la calidad de los datos en el diseño de los procesos de integración de datos; y * Realizar operaciones sobre tablas pivote para satisfacer solicitudes típicas de análisis del negocio usando software de código abierto destacados
  3. CURSO 3

    Relational Database Support for Data Warehouses

    Sesión actual: mar. 27 — may. 8.
    Subtítulos
    English

    Acerca del Curso

    Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts.
  4. CURSO 4

    Conceptos, Herramientas y Aplicaciones de Inteligencia Empresarial

    Sesión actual: mar. 27 — may. 8.
    Dedicación
    5 semanas de estudio, 3-5 horas/semana
    Subtítulos
    English, Chinese (Simplified)

    Acerca del Curso

    This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards. The course gives an overview of how business intelligence technologies can support decision making across any number of business sectors. These technologies have had a profound impact on corporate strategy, performance, and competitiveness and broadly encompass decision support systems, business intelligence systems, and visual analytics. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics.
  5. CURSO 5

    Diseñar y Construir un Almacén de Datos para Mejorar la Inteligencia Empresarial

    Próxima sesión: jun. 12 — jul. 31.
    Dedicación
    6 weeks of study, 3-5 hours/week
    Subtítulos
    English

    Sobre el Proyecto Final

    The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you’ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations. In the first part of the capstone course, you’ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You’ll first architect a warehouse schema and dimensional model for a small data warehouse. You’ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you’ll write SQL statements for analytical query requirements and create materialized views to support summary data management. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you’ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you’ll be proud to show to your current and prospective employers.

Creadores

  • Sistema Universitario de Colorado

    The University of Colorado promotes innovation, encourages discovery, and supports the extension of knowledge in ways unique to the state of Colorado and worldwide.

    The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond.

  • Jahangir Karimi

    Jahangir Karimi

    Professor
  • Michael Mannino

    Michael Mannino

    Associate Professor

FAQs

More questions? Visit the Learner Help Center.