Business intelligence and data warehousing
Descripción del Curso
After completing this course, a learner will be able to
● Create a Star o Snowflake data model Diagram through the Multidimensional Design from analytical business requirements and OLTP system
● Create a physical database system
● Extract, Transform and load data to a data-warehouse.
● Program analytical queries with SQL using MySQL
● Predictive analysis with RapidMiner
● Load relational or unstructured data to Hortonworks HDFS
● Execute Map-Reduce jobs to query data on HDFS for analytical purposes
For course 2 you will use the MYSQL language.
Software to download:
Hortonworks Hadoop framework
In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).