Business intelligence and data warehousing
- Offered byCoursera
Business intelligence and data warehousing at Coursera Overview
Duration | 10 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Business intelligence and data warehousing at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 2 of 4 in the Database systems Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Intermediate Level
- Approx. 10 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Business intelligence and data warehousing at Coursera Course details
- 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).
Business intelligence and data warehousing at Coursera Curriculum
Introduction to Business Intelligence as Analytical System
Introduction to BI
How data is analyzed?
Welcome to the course
Business intelligence
Designing a Data Warehouse
Design and implement an analytical databases
Steps to Multidimensional model OLTP
Designing a Data Warehouse
The ETL process and Analytical queries with SQL
Extract, transform and load data
Typical OLAP operations
The ETL process and Analytical queries with SQL
Predictive Analytics with Data mining
The process of data mining
ID3 Algorithms
Data mining
The problem of integration and analysis of unstructured data
Data types according to structure of data
Integrate, store and analyze unstructured data
Types of data
Big Data and Hadoop Framework
What Big Data is?
Analysis of unstructured data
Concepts of Big Data and Hadoop Framework
Assesment
Business intelligence and data warehousing at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?