- Level Foundation
- Duration 22 hours
- Course by University of Colorado System
-
Offered by
About
This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. Effectively and efficiently mining data is the very center of any modern business's competitive strategy, and a data warehouse is a core component of this data mining. The ability to quickly look back at early trends and have the accurate data " properly formatted " is essential to good decision making. By enabling this historical overview, a data warehouse allows decision makers to learn from past trends and challenges. In essence, the benefit of a data warehouse is continuous improvement. By the end of the course, you will be able to enhance Conformity And Quality of Data by gaining the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You'll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards. The course gives an overview of how business intelligence technologies can support decision making across any number of business sectors. These technologies have had a profound impact on corporate strategy, performance, and competitiveness and broadly encompass decision support systems, business intelligence systems, and visual analytics. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. This course is intended for business and computer science university students, IT professionals, program managers, business analysts and anyone with career interests in business intelligence. In order to be successful in this course, you should have either completed Course 3 of the Data Warehousing for Business Intelligence Specialization or have some prior experience with data visualization and document management.Modules
Course Overview
1
Videos
- Course Introduction Video Lecture
2
Readings
- Optional Text Book
- Additional Resources - Course Overview
Lesson 1.1: Overview of Decision Making
1
Videos
- Overview of Decision Making Video Lecture
2
Readings
- Powerpoint and Lecture Notes for Lesson 1.1
- Additional Resources Lesson 1.1
Lesson 1.2: Conceptual Foundations of Decision Making
1
Videos
- Conceptual Foundations of Decision Making Video Lecture
3
Readings
- Powerpoint and Lecture Notes for Lesson 1.2
- Additional Resources Lesson 1.2
- Periodicals
Lesson 1.3: Decision Support Systems
1
Videos
- Decision Support Systems Video Lecture
4
Readings
- Powerpoint and Lecture Notes for Lesson 1.3
- Additional Resources for Lesson 1.3
- Additional Web Resources
- Vendors and Software Companies
Lesson 1. 4: DSS in Practice
1
Videos
- Decision Making Support in Practice Video Lecture
3
Readings
- Powerpoint and Lecture Notes for Lesson 1.4
- Additional Resources for Lesson 1.4
- Ready Made DSS Products and Services
Module 1: Software Requirements, Practice Quiz, and Assignment
1
Assignment
- Module 1 Practice Quiz
1
Peer Review
- Build and Interactive Dossier for Powerful Data Discovery
7
Readings
- MicroStrategy Workstation Software Download and Installation for PC and Mac
- MicroStrategy Workstation Connections to Oracle VM on PC and MAC
- Walking through MicroStrategy interface
- Exploring Sample Dossiers in Library
- MicroStrategy Dynamic Dashboards
- Q&A and Errors Knowledge base
- How visualizations are used for analysis?
Lesson 2.1: BI Concepts
1
Videos
- BI Concepts Video Lecture
3
Readings
- PowerPoint and Lecture Notes for Lesson 2.1
- Additional Resources for Lesson 2.1
- Training Video for Connecting Data in MicroStrategy Workstation
Lesson 2.2 : BI Platform Capabilities
1
Videos
- BI Platform Capabilities Video Lecture
3
Readings
- PowerPoint and Lecture Notes for Lesson 2.2
- Additional Resources for Lesson 2.2
- What's new in Workstation for 2024
Lesson 2. 3: Business Reporting
1
Videos
- Business Reporting Video Lecture
3
Readings
- PowerPoint and Lecture Notes for Lesson 2.3
- Additional Resources for Lesson 2.3
- Training Videos for Connecting to Spreadsheets, Joining Datasets, and Data Blending in MicroStrategy Workstation
Lesson 2. 4: BI OLAP Styles
1
Videos
- BI OLAP Styles Video Lecture
3
Readings
- PowerPoint and Lecture Notes for Lesson 2. 4
- Additional Resources for Lesson 2.4
- Training Video for Wrangling and Profiling Data in MicroStrategy
Module 2: Practice Quiz, Peer Review Assignment, and Graded Quiz
1
Assignment
- Module 2 Practice Quiz
1
Peer Review
- Assignment for Module 2: World Wide Carbon Emissions Scenario
Graded Quiz #1: Please complete this GRADED quiz, which covers content from Modules 1 and 2
1
Assignment
- Modules 1 and 2 Graded Quiz #1
Lesson 3.1: Data Visualization
1
Videos
- Data Visualization Video Lecture
3
Readings
- Powerpoint and Lecture Notes for Lesson 3.1
- Additional Resources for Lesson 3.1
- Training Videos for Building Business Dashboards with MicroStrategy
Lesson 3. 2: Data Visualization Guidelines and Pitfalls
1
Videos
- Data Visualization Guidlines and Pitfalls Video Lecture
4
Readings
- Powerpoint and Lecture Notes for Lesson 3.2
- Additional Resources for Lesson 3.2
- Training Video for Exploring Data in MicroStrategy
- Comprehensive Training Video for Showing Data Visualization Steps
Lesson 3. 3: Performance Dashboards
1
Videos
- Performance Dashboards Video Lecture
3
Readings
- Powerpoint and Lecture Notes for Lesson 3.3
- Additional Resources for Lesson 3.3
- Training Videos for Building Visualizations in MicroStrategy
Lesson 3. 4: Dashboard Design Guidelines and Pitfalls
1
Videos
- Dashboard Design Guidelines and Pitfalls Video Lecture
4
Readings
- Powerpoint and Lecture Notes for Lesson 3.4
- Additional Resources for Lesson 3.4
- Training Video for Enhancing and Sharing a Dashboard in MicroStrategy
- Comprehensive Training Video for Creating Dashboard Using Advanced Visualization
Module 3: Practice Quiz and Peer Review Assignment
1
Assignment
- Module 3 Practice Quiz
1
Peer Review
- Assignment for Module 3: Enrollment in Distance Education
Lesson 4. 1: Business Performance Management
1
Videos
- Business Performance Management Video Lecture
2
Readings
- Powerpoint and Lecture Notes for Lesson 4.1
- Additional Resources for Lesson 4.1
Lesson 4.2 : Performance Measurement System
1
Videos
- Performance Measurement System Video Lecture
3
Readings
- Powerpoint and Lecture Notes for Lesson 4.2
- Additional Resources for Lesson 4.2
- Training Videos for Data Source Connectivity and Adding Data to MicroStrategy
Lesson 4. 3 : Balanced Scorecards and Six Sigma
2
Videos
- Balanced Scorecards Versus Six Sigma Video Lecture
- Training Video for MicroStrategy Workstation Business Performance Analysis
2
Readings
- Powerpoint and Lecture Notes for Lesson 4.3
- Additional Resources for Lesson 4.3
Lesson 4. 4: Business Analytics
1
Videos
- Business Analytics Video Lecture
2
Readings
- Powerpoint and Lecture Notes for Lesson 4.4
- Additional Resources for Lesson 4.4
Module 4: Practice Quiz and Assignment
1
Assignment
- Module 4 Practice Quiz
1
Peer Review
- Assignment for Module 4: Dossier with Salesforce.com data
Lesson 5.1: BI Maturity
1
Peer Review
- Summative Project: BPM For Blazing' Burger Fast Food Restaurant
1
Videos
- BI Maturity Video Lecture
2
Readings
- PowerPoint and Lecture Notes for Lesson 5.1
- Additional Resources for Lesson 5.1
Lesson 5.2: BI Strategy
1
Videos
- BI Strategy Video Lecture
3
Readings
- PowerPoint and Lecture Notes for Lesson 5.2
- Additional Resources for Lesson 5.2
- MicroStrategy Cloud Platform
Graded Quiz #2: Please complete this GRADED quiz, which covers content from Modules 3, 4 and 5.
1
Assignment
- Modules 3, 4, and 5 Graded Quiz #2
Closing Video
1
Videos
- Course Closing Video
Auto Summary
"Business Intelligence Concepts, Tools, and Applications" is a foundational course offered by Coursera in the domain of Data Science & AI. It focuses on utilizing data warehouses for business intelligence, enhancing data conformity and quality, and leveraging tools like MicroStrategy's OLAP and Visualization. Ideal for university students, IT professionals, and business analysts, the course spans 1320 minutes and offers a starter subscription. Taught by industry experts, it covers decision support systems, visual analytics, and business performance management. Prior experience in data visualization or completion of the preceding course in the specialization is recommended.

Jahangir Karimi