Ce que vous devez savoir avant
Vous commencez
Débute 4 June 2026 12:18
Se termine 4 June 2026
Business intelligence and data warehousing
University of California, Irvine
13 Cours
UC Irvine est une université publique de recherche de renommée mondiale avec un engagement envers la recherche de pointe, des cursus universitaires de premier rang et un esprit innovant. UCI propose plus de 200 programmes académiques et abrite une population d'étudiants et de professeurs diversifiée.
Non spécifié
Amélioration optionnelle disponible
Tous niveaux
Progressez à votre rythme
Free
Amélioration optionnelle disponible
Aperçu
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
Enseigné par
María del Pilar Ángeles
