Monthly Subscription Starting at AED 99 + VAT

Business intelligence and data warehousing
  • Level Professional
  • Duration 10 hours
  • Course by Universidad Nacional Autónoma de México
  • Offered by

About

Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of high volume of unstructured data (big data) with data mining and the Hadoop framework. 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 Programming languages: For course 2 you will use the MYSQL language. Software to download: Rapidminer MYSQL Excel Hortonworks Hadoop framework In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).

Modules

Welcome!

    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Welcome!

1 Readings

  • Welcome to the course

Introduction to BI

    • 2 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Business intelligence

2 Videos

  • Introduction to BI
  • How data is analyzed?

Design and implement an analytical databases

    • 2 Videos
    • 1 Discussion
    • 1 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Designing a Data Warehouse

1 Peer Review

  • OLAP Bookstore Requirements

1 Discussions

  • Business intelligence project

2 Videos

  • Design and implement an analytical databases
  • Steps to Multidimensional model OLTP

Extract, transform and load data

    • 2 Videos
    • 1 Discussion
    • 1 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • The ETL process and Analytical queries with SQL

1 Peer Review

  • Bookstore Analytical Queries

1 Discussions

  • The ETL process

2 Videos

  • Extract, transform and load data
  • Typical OLAP operations

The process of data mining

    • 2 Videos
    • 1 Discussion
    • 2 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Data mining

2 Peer Review

  • Formative Exercises
  • Bookstore Data Mining Queries

1 Discussions

  • Predictive Analytics with Data mining

2 Videos

  • The process of data mining
  • ID3 Algorithms

Integrate, store and analyze unstructured data

    • 2 Videos
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Types of data

1 Discussions

  • Unstructured data

2 Videos

  • Data types according to structure of data
  • Integrate, store and analyze unstructured data

What Big Data is?

    • 2 Videos
    • 1 Discussion
    • 1 PeerReview
    • 2 Assignment
Show info about module content

2 Assignment

  • Concepts of Big Data and Hadoop Framework
  • Assesment

1 Peer Review

  • Labs Hadoop

1 Discussions

  • Analysis of data

2 Videos

  • What Big Data is?
  • Analysis of unstructured data

Auto Summary

Dive into the dynamic world of big data with the "Business Intelligence and Data Warehousing" specialization course. Curated for professionals in the Big Data and Analytics domain, this six-week intensive program is designed to empower you with the skills to identify, design, and develop sophisticated analytical information systems. Under the expert guidance of Coursera, you'll delve into the intricacies of Business Intelligence and data warehousing. The course covers critical aspects such as the integration and predictive analysis of vast amounts of unstructured data using data mining techniques and the Hadoop framework. By the end of the course, you'll master the following competencies: - Crafting Star and Snowflake data models through multidimensional design. - Constructing a physical database system. - Executing ETL (Extract, Transform, Load) processes for data warehouses. - Programming analytical SQL queries using MySQL. - Performing predictive analysis with RapidMiner. - Managing and analyzing data within Hortonworks HDFS. - Running Map-Reduce jobs for data querying on HDFS. To facilitate hands-on learning, you'll use essential tools like RapidMiner, MySQL, Excel, and the Hortonworks Hadoop framework. Mac/iOS users will need a virtual machine such as VirtualBox or VMware. With a focus on practical application, this course offers two subscription options: Starter and Professional, making it accessible and flexible for various learning needs. Join this professional-level course and elevate your expertise in big data analytics and business intelligence.

María del Pilar Ángeles
Instructor

María del Pilar Ángeles