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.
Database Design and Operational Business Intelligence Specialization
Discover new skills with $120 off courses from industry experts. Save now.
Database Design and Operational Business Intelligence Specialization
Utilize Data & Improve Enterprise Decision-Making. Describe business intelligence and practice different data modeling and manipulation techniques.
Instructor: Tim Carrington
5,360 already enrolled
Included with 
Get in-depth knowledge of a subject
(152 reviews)
Beginner level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject
(152 reviews)
Beginner level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
What you'll 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
Overview
Skills you'll gain
Tools you'll learn
What’s included
Shareable certificate
Add to your LinkedIn profile
Taught in English
12 practice exercises
Advance your subject-matter expertise
- Learn in-demand skills from university and industry experts
- Master a subject or tool with hands-on projects
- Develop a deep understanding of key concepts
- Earn a career certificate from University of California, Irvine
Specialization - 3 course series
What you'll learn
Create an ERD that shows progression from conceptual to logical to physical design
Conduct a basic descriptive statistical analysis and articulate the findings
Write SQL scripts to create a database and associated tables
Skills you'll gain
Category: SQL
Category: Database Design
Category: Business Analytics
Category: Database Management
Category: Decision Support Systems
Category: Extract, Transform, Load
Category: Descriptive Statistics
Category: Relational Databases
Category: Data Manipulation
Category: Business Intelligence
Category: Microsoft Excel
Category: Data Science
Category: Database Management Systems
Category: Data-Driven Decision-Making
Category: Data Literacy
Category: Statistical Analysis
Category: Statistics
What you'll learn
Explain different data warehousing architectures and multidimensional data modeling
Develop predictive data mining models, including classification and estimation models
Develop explanatory data mining models, including clustering and association models
Skills you'll gain
Category: Unsupervised Learning
Category: Data Mining
Category: Data Warehousing
Category: Star Schema
Category: Data Modeling
Category: Extract, Transform, Load
Category: Snowflake Schema
Category: Predictive Modeling
Category: Data Architecture
Category: Business Intelligence
Category: Business Analytics
Category: Market Analysis
Category: Databases
Category: Data-Driven Decision-Making
Category: Machine Learning Methods
Category: Data Science
Category: Statistical Methods
Category: Big Data
Category: Data Mart
Category: Cloud Computing
What you'll learn
Identify best practices for building data visualizations
Develop hands-on data visualization skills using SAS Viya
Explain advanced topics in business intelligence and data warehousing, such as cloud architecture, automation, and machine learning
Skills you'll gain
Category: SAS (Software)
Category: Machine Learning
Category: Data Warehousing
Category: Big Data
Category: Data Visualization Software
Category: Interactive Data Visualization
Category: Business Intelligence
Category: Data Visualization
Category: Business Reporting
Category: Dashboard
Category: Data Storytelling
Category: Cloud Computing
Category: Business Analytics
Category: Data Import/Export
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
12 weeks
These courses are introductory, no experience in BI or database is needed. Experience with at least one programming language is recommended.
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
More questions
Financial aid available,