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!

Traffic lights

Read about what's good

what should give you pause

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

Introduction to bi and data warehousing

According to learners, this course offers a solid introduction to Business Intelligence and Data Warehousing concepts, covering topics from data modeling to Big Data basics. Many praise the clear lectures and the instructor's expertise. However, a significant portion of students faced major difficulties with software setup, including setting up virtual machines and specific tools like Hortonworks Hadoop and RapidMiner. While the core theoretical content is strong, these technical challenges often prevent students from completing the practical exercises and are a consistent source of frustration, impacting the overall learning experience negatively for many.

Good for intro, potentially basic later.

"Great starting point for someone new to BI."

"Felt a bit basic if you already have some background."

"Could have gone deeper into certain tools or advanced techniques."

Instructor is knowledgeable and explains well.

"The instructor is very knowledgeable and explains the topics clearly."

"Lectures are well-structured and easy to follow."

"Appreciated the instructor's depth of understanding of the subject matter."

"The video lessons were informative and well-presented."

Provides a good overview of BI/DW concepts.

"The course gives a great overview of the fundamentals of Business Intelligence."

"Provides a solid introduction to the core concepts of data warehousing and BI."

"I got a very clear understanding of the overall BI process from this course."

"Excellent starting point for anyone new to the field."

Hands-on exercises are hindered by setup.

"The exercises seem relevant, but I couldn't do them because the software wouldn't work."

"The reliance on problematic software made the practical part almost useless."

"Couldn't follow along with the demos due to setup failures."

"Practical application was impossible due to technical barriers."

Significant difficulties with required software.

"The software setup is TERRIBLE, very outdated versions and incredibly difficult to get working."

"Spent days trying to get the VM and Hadoop running without success."

"Installation of RapidMiner and Hortonworks was a major pain point."

"Couldn't complete assignments due to persistent software configuration issues."

"The technical hurdles completely overshadowed the learning content for me."

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