University of California, Irvine
Database Design and Operational Business Intelligence Specialization
University of California, Irvine

Database Design and Operational Business Intelligence Specialization

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

Tim Carrington

Instructor: Tim Carrington

Included with Coursera Plus

Get in-depth knowledge of a subject
4.5

(153 reviews)

Beginner level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
4.5

(153 reviews)

Beginner level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
12 practice exercises

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

Database Design, SQL, Extract, Transform, Load, Database Management, Business Intelligence, Business Analytics, Data Science, Relational Databases, Data Manipulation, Decision Support Systems, Microsoft Excel, Descriptive Statistics, Data-Driven Decision-Making, Statistical Analysis, Data Literacy, Database Management Systems, and 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

Data Warehousing, Unsupervised Learning, Data Mining, Data Modeling, Snowflake Schema, Extract, Transform, Load, Star Schema, Predictive Modeling, Data Architecture, Statistical Methods, Business Intelligence, Big Data, Cloud Computing, Market Analysis, Databases, Data-Driven Decision-Making, Data Mart, Machine Learning Methods, Data Science, and Business Analytics

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), Data Warehousing, Machine Learning, Interactive Data Visualization, Data Visualization Software, Cloud Computing Architecture, Big Data, Business Analytics, Business Intelligence, Data Import/Export, Data Storytelling, Cloud Computing, Dashboard, Business Reporting, and Data Visualization

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

Tim Carrington
University of California, Irvine
6 Courses38,791 learners

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."
Coursera Plus

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