Business intelligence and data warehousing from Coursera

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).

What's inside

Syllabus

Introduction to Business Intelligence as Analytical System

In the first module named Introduction to Business Intelligence as Analytical System, we will learn how the steps of the process of datawarehousing to automate analytical processes that companies need for their business strategies. Let's start!

Designing a Data Warehouse

After completing this module, a learner will be able to identify the entire process of datawarehousing, which consist on OLAP design concepts and multidimensional modelling. The learner will be able to design and create a data warehouse from OLAP requirements.

The ETL process and Analytical queries with SQL

After completing this module, a learner will differentiate from structured and unstructured data and will be able to extract, transform and load data into a datawarehouse. The student will also be able to program and execute OLAP queries with SQL.

Predictive Analytics with Data mining

After completing this module, a learner will identify the main data mining tasks and some algorithms for classification, regression and clustering for predictive and descriptive analysis on business intelligence.

The problem of integration and analysis of unstructured data

After completing this module, a learner will learn the types of data according to structure and how to integrate, store and analyze unstructured data.

Big Data and Hadoop Framework

After completing this module, a learner will understand the problem of big data, a possible solution to the analysis of big data with the Hadoop ecosystem and under which conditions should be apply each element of this ecosystem.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores multidimensional design and OLAP concepts for data warehousing

Covers both structured and unstructured data, addressing integration and analysis

Provides hands-on experience with industry-standard tools like MYSQL, RapidMiner, and Hadoop

Introduces Hadoop Framework and MapReduce for big data analysis

Offers predictive analysis with Data mining, enhancing data interpretation

Taught by María del Pilar Ángeles, an expert in business intelligence and data warehousing

Reviews summary

Business intelligence and data warehousing varied feedback

According to students, Business Intelligence and Data Warehousing explores the fundamentals needed to get started in the field of business intelligence and data warehousing with engaging assignments and weekly deadlines. However, some learners find the course a bit disorganized and feel that the instructor could provide better support and feedback.

Engaging assignments help motivate learners.

"I gave you 2 stars becuse of lack off review system you should remove that peers review to give someone and after you aprooved any submisson that option you should remove over all your learning technique is good"

"The background music does not help to concentrate in the content, there is no much detailed explanation, just a sort of lists of content given at a high speed (for un unknown reason) and the slides, and visual information is not of great help to understand the material, I am sorry, but I would not recoomend this course."

"This course was basically an introduction to what should I start reading into to do data warehousing analysis."

Many learners find the course to be disorganized.

"Not Recommended at all.. Pace of the course was so fast that it barely touches each topic.. background music and voice over was irritating."

Some learners feel the course lacks depth overall.

"I found this course very interesting as a topic, but the execution is not good... Prons: very interesting topic, a lot of information and good professorCons: There is a limited to no-guidance on how to perform the assignments..."

"This course was basically an introduction to what should I start reading into to do data warehousing analysis."

The instructor needs to provide better support and feedback.

"Extremely disappointing . Very unintelligent and no support from staff. I learnt nothing new. Increase the quality."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Business intelligence and data warehousing with these activities:

Read: Business Intelligence: A Managerial Perspective

Show steps

Familiarize yourself with key concepts and theories in business intelligence and data warehousing to strengthen your foundational understanding.

View Business Intelligence and Analytics: Systems... on Amazon

Show steps

Read Chapter 1: Introduction to Business Intelligence
Summarize the key concepts of business intelligence and data warehousing

Join a Data Science Study Group

Show steps

Connect with peers, share knowledge, and engage in discussions to enhance your understanding and broaden your perspectives in data science, including business intelligence and data warehousing.

Browse courses on Collaboration

Show steps

Find or join a data science study group
Participate in regular meetings and discussions

Complete SQL Tutorial on W3Schools

Show steps

Develop practical SQL skills to effectively query and manipulate data in the context of data warehousing and business intelligence.

Browse courses on SQL

Show steps

Go through the SQL tutorial on W3Schools
Complete the practice exercises provided in the tutorial

Four other activities

Expand to see all activities and additional details

Show all seven activities

Design a Star Schema Data Model

Show steps

Apply the concepts of data modeling to design a star schema, which is commonly used in data warehousing for efficient data analysis.

Browse courses on Data Modeling

Show steps

Identify the business requirements for the data model
Design the star schema using a modeling tool or software
Validate the data model with stakeholders

Solve LeetCode Problems on Linked Lists

Show steps

Strengthen your understanding of data structures and algorithms, which are essential for data warehousing and business intelligence systems.

Browse courses on Data Structures

Show steps

Choose 5 LeetCode problems on linked lists
Solve the problems using your preferred programming language
Review your solutions and identify areas for improvement

Build a Data Pipeline Using Apache Airflow

Show steps

Gain hands-on experience in building and managing data pipelines, which are crucial for automating data integration and transformation in data warehousing.

Browse courses on Data Pipelines

Show steps

Install Apache Airflow and set up a development environment
Design the data pipeline using Airflow operators and tasks
Deploy and monitor the data pipeline

Participate in a Kaggle Competition

Show steps

Challenge yourself by applying your data analysis skills in real-life scenarios, gain valuable experience, and contribute to the data science community.

Browse courses on Kaggle

Show steps

Choose a Kaggle competition that aligns with your interests
Build a model, analyze data, and submit your results
Review the competition leaderboard and learn from others

Career center

Learners who complete Business intelligence and data warehousing will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst collects, analyzes, and interprets data to extract meaningful insights and trends. They use this information to help businesses make informed decisions, improve operations, and increase profits. This course will provide you with the foundational skills you need to succeed in this role, including data mining, predictive analytics, and data visualization.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

A Business Intelligence Analyst uses data to identify trends, develop insights, and make recommendations that can help businesses improve their performance. This course will provide you with the knowledge and skills you need to succeed in this role, including data analysis, data mining, and predictive analytics.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist uses statistical and machine learning techniques to extract knowledge and insights from data. They use this information to solve business problems and make predictions. This course will provide you with the foundational skills you need to succeed in this role, including data mining, predictive analytics, and machine learning.

See salaries and explore the career path for Data Scientist

Data Engineer

A Data Engineer designs, builds, and maintains data systems and pipelines. They ensure that data is clean, accurate, and accessible to business users. This course will provide you with the skills you need to succeed in this role, including data modeling, data warehousing, and data integration.

See salaries and explore the career path for Data Engineer

Database Administrator

A Database Administrator manages and maintains databases. They ensure that databases are running smoothly and that data is secure. This course will provide you with the skills you need to succeed in this role, including database design, data warehousing, and data security.

See salaries and explore the career path for Database Administrator

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They use their knowledge of programming languages and software development tools to create software that meets the needs of businesses and users. This course may be helpful for those who wish to specialize in data-driven software development.

See salaries and explore the career path for Software Engineer

Data Architect

A Data Architect designs and oversees the implementation of data management systems. They ensure that data is managed in a way that meets the needs of the business. This course will provide you with the skills you need to succeed in this role, including data modeling, data warehousing, and data integration.

See salaries and explore the career path for Data Architect

Information Systems Manager

An Information Systems Manager plans, implements, and manages information systems. They ensure that information systems are aligned with the needs of the business. This course may be helpful for those who wish to specialize in data-driven information systems management.

See salaries and explore the career path for Information Systems Manager

Marketing Analyst

A Marketing Analyst uses data to understand consumer behavior and develop marketing campaigns. They use this information to help businesses increase sales and profits. This course will provide you with the skills you need to succeed in this role, including data analysis, data mining, and predictive analytics.

See salaries and explore the career path for Marketing Analyst

Financial Analyst

A Financial Analyst uses data to evaluate and make recommendations on financial investments. They use this information to help businesses make sound financial decisions. This course will provide you with the skills you need to succeed in this role, including data analysis, data mining, and predictive analytics.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

An Operations Research Analyst uses data to solve business problems and improve operations. They use this information to help businesses increase efficiency and profitability. This course will provide you with the skills you need to succeed in this role, including data analysis, data mining, and predictive analytics.

See salaries and explore the career path for Operations Research Analyst

Risk Analyst

A Risk Analyst uses data to assess and manage risk. They use this information to help businesses make informed decisions and protect against potential losses. This course will provide you with the skills you need to succeed in this role, including data analysis, data mining, and predictive analytics.

See salaries and explore the career path for Risk Analyst

Auditor

An Auditor examines financial and operational records to ensure accuracy and compliance. They use this information to help businesses identify and prevent fraud and errors. This course may be helpful for those who wish to specialize in data-driven auditing.

See salaries and explore the career path for Auditor

Consultant

A Consultant provides expert advice and guidance to businesses on a variety of topics. They use their knowledge and expertise to help businesses improve their performance and achieve their goals. This course may be helpful for those who wish to specialize in data-driven consulting.

See salaries and explore the career path for Consultant

Teacher

A Teacher educates and inspires students in a variety of subjects. They use their knowledge and skills to help students develop their academic and personal potential. This course may be helpful for those who wish to teach data science or related topics.

See salaries and explore the career path for Teacher