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
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
Included with 
Get in-depth knowledge of a subject
(153 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
(153 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
SQL, Database Design, Extract, Transform, Load, Relational Databases, Descriptive Statistics, Business Intelligence, Microsoft Excel, Decision Support Systems, Data Manipulation, Database Management, Business Analytics, Data Science, Data-Driven Decision-Making, Statistics, Statistical Analysis, Data Literacy, and Database Management Systems
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
Data Mining, Unsupervised Learning, Data Warehousing, Extract, Transform, Load, Data Architecture, Star Schema, Data Modeling, Predictive Modeling, Snowflake Schema, Cloud Computing, Business Analytics, Business Intelligence, Market Analysis, Statistical Methods, Data Mart, Machine Learning Methods, Data Science, Data-Driven Decision-Making, Big Data, and Databases
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
SAS (Software), Big Data, Machine Learning, Data Visualization Software, Cloud Computing Architecture, Data Warehousing, Interactive Data Visualization, Data Visualization, Dashboard, Data Storytelling, Business Analytics, Cloud Computing, Data Import/Export, Business Intelligence, and Business Reporting
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
Compare with similar products
| Rating | ||||
|---|---|---|---|---|
| Level | ||||
| Skills | ||||
| Tools | ||||
| Last updated | ||||
| Number of practice exercises | ||||
| Degree eligibility | ||||
| Part of Coursera Plus |
You might also like
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,