Utilize Data & Improve Enterprise Decision-Making. Describe business intelligence and practice different data modeling and manipulation techniques.

4.5

stars

57 ratings

Tim Carrington

Offered By

Database Design and Operational Business Intelligence SpecializationUniversity of California, Irvine

What you will learn

Develop an in-depth understanding of data warehouse design and data manipulation
Describe what business intelligence (BI) is and what it does
Gain hands-on experience in SQL coding, data mining models, and data visualization
Create an ERD that shows progression from conceptual to logical to physical design

Skills you will gain

Database (DB) Design
SAS Language
Data Warehousing
Data Visualization (DataViz)
Business Intelligence
SQL Overview
Statistical Analysis
Relational Database
Basic Descriptive Statistics
Data Mining for Clustering and Association
Data Clustering Algorithms
Multidimensional Modeling

About this Specialization

2,653 recent views

The goal of this specialization is to provide a comprehensive and holistic view of business intelligence and its enabling technologies, including relational databases, data warehousing, descriptive statistics, data mining, and visual analytics. Through this series of courses, you will explore relational database design, data manipulation through Extract/Transform/Load (ETL), gaining actionable insight through data analytics, data-based decision support, data visualization, and practical, hands-on experience with real-world business intelligence tools.

Applied Learning Project

Each module, students will participate in an authentic assessment of that module's concepts and skills. At the end of the specialization, students will apply their new skills by converting business data into an interactive visual analytics dashboard.

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approximately 3 months to complete

Suggested pace of 2 hours/week

English

Subtitles: English

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approximately 3 months to complete

Suggested pace of 2 hours/week

English

Subtitles: English

How the Specialization Works

Take Courses

A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.

Hands-on Project

Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.

Earn a Certificate

When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.

There are 3 Courses in this Specialization

Course1

Course 1

The Nature of Data and Relational Database Design

4.3

stars

53 ratings

•

10 reviews

This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD that shows progression from conceptual to logical to physical design, define DDL, DML, DCL, and TCL, and write SQL scripts to create a database and associated tables.

Course2

Course 2

Data Warehousing and Business Intelligence

4.7

stars

39 ratings

•

4 reviews

This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in managerial decision making. Data mining is one of the key enablers in the process of converting data stored in a data warehouse into actionable insight for better and faster decision making.

By the end of this course, students will be able to explain data warehousing and how it is used for business intelligence, explain different data warehousing architectures and multidimensional data modeling, and develop predictive data mining models, including classification and estimation models. IN addition, students will be able to develop explanatory data mining models, including clustering and association models.

Course3

Course 3

Business Intelligence and Visual Analytics

Building on “Data Warehousing and Business Intelligence,” this course focuses on data visualization and visual analytics. Starting with a thorough coverage of what data visualization is and what type of visualization is good for a given purpose, the course quickly dives into development of practical skills and knowledge about visual analytics by way of using one of the most popular visual analytics tools: SAS Viya, a cloud-based analytics platform. An overview of cloud architecture, automation, and machine learning is also provided.

Instructor

Tim Carrington

7,813 Learners

6 Courses

Offered by

University of California, Irvine

Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UCI’s unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities in many ways.

Frequently Asked Questions

What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Can I just enroll in a single course?
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Can I take the course for free?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. If you only want to read and view the course content, you can audit the course for free. If you cannot afford the fee, you can apply for financial aid.
Is this course really 100% online? Do I need to attend any classes in person?
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
How long does it take to complete the Specialization?
12 weeks
What background knowledge is necessary?
These courses are introductory, no experience in BI or database is needed. Experience with at least one programming language is recommended.
Do I need to take the courses in a specific order?
The recommended order for the courses is as follows: 1. The Nature of Data and Relational Database Design 2. Data Warehousing & Business Intelligence 3. Business Intelligence & Visual Analytics
Will I earn university credit for completing the Specialization?
You will receive a certificate but university credit is not awarded.
What will I be able to do upon completing the Specialization?
Upon completion of the Specialization, students will be able to do the following:
Describe what business intelligence (BI) is and what it does
Demonstrate structured data modeling and ETL (Extract, Transform, Load)
Gain practical SQL coding experience
Develop an in-depth understanding of data warehouse design and data manipulation
Design relational databases (RDBMS)
Explain types of SQL: DDL and DML
Describe data warehousing and multidimensional data modeling
Develop simple supervised and unsupervised data mining models
Differentiate between data visualization and visual analytics
Create data visualizations and dashboards and Visual Analytics: SAS Viya
Explain BI and data warehousing in the Cloud

More questions? Visit the Learner Help Center.