Qué necesitas saber antes de
comenzar
Inicio 4 June 2026 05:05
Fin 4 June 2026
Business intelligence and data warehousing
University of California, Irvine
13 Cursos
UC Irvine es una universidad pública de investigación de renombre mundial comprometida con la investigación de vanguardia, la excelencia académica y un espíritu innovador. UCI ofrece más de 200 programas académicos y alberga una diversa población de estudiantes y profesores.
No especificado
Actualización opcional disponible
Todos los niveles
Avanza a tu propio ritmo
Free
Actualización opcional disponible
Resumen
Welcome to our specialized course on Business Intelligence and Data Warehousing offered by the University of California, Irvine, through Coursera. This comprehensive six-week course is designed with a mix of videos and documents to simplify your learning journey.
Discover the essential skills of identifying, designing, and developing analytical information systems, including Business Intelligence systems and Data Warehouses. Dive deep into the challenges of integrating and analyzing large volumes of unstructured data with techniques in data mining and utilizing the Hadoop framework.
By the end of this course, you will have the ability to:
- Design Star or Snowflake schema diagrams using Multidimensional Design based on analytical business requirements and OLTP systems.
- Construct a robust physical database system.
- Master the process of Extract, Transform, and Load (ETL) to move data into a data warehouse.
- Develop expertise in programming analytical queries using SQL with MySQL.
- Perform predictive analysis using RapidMiner.
- Efficiently load both relational and unstructured data into Hortonworks HDFS.
- Execute Map-Reduce jobs for querying data on HDFS for analytical insights.
This course will primarily utilize the MySQL programming language.
Additionally, participants will need to download and use software such as Rapidminer, MYSQL, Excel, and the Hortonworks Hadoop framework. For those using Mac / IOS operating systems, it will be necessary to operate a virtual machine (VirtualBox, VMware).
Categories:
Business Intelligence Courses, Data Warehousing Courses
Impartido por
María del Pilar Ángeles
