À propos de ce cours
4.4
360 notes
70 avis
This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain 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....
Globe

Cours en ligne à 100 %

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Calendar

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.
Clock

Approx. 15 hours to complete

Recommandé : 5 weeks of study, 3-5 hours/week...
Comment Dots

English

Sous-titres : English, Chinese (Simplified)...

Compétences que vous acquerrez

Business IntelligenceData AnalysisData Visualization (DataViz)Microstrategy
Globe

Cours en ligne à 100 %

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Calendar

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.
Clock

Approx. 15 hours to complete

Recommandé : 5 weeks of study, 3-5 hours/week...
Comment Dots

English

Sous-titres : English, Chinese (Simplified)...

Programme du cours : ce que vous apprendrez dans ce cours

Week
1
Clock
6 heures pour terminer

Decision Making and Decision Support Systems

Module 1 explains the role of computerized support for decision making and its importance. It starts by identifying the different types of decisions managers face, and the process through which they make decisions. It then focuses on decision-making styles, the four stages of Simon’s decision-making process, and common strategies and approaches of decision makers. In the next two lessons, you will learn the role of Decision Support Systems (DSS), understand its main components, the various DSS types and classification, and how DSS have changed over time. Finally, in lesson 4, we focus on how DSS supports each phase of decision making and summarize the evolution of DSS applications, and on how they have changed over time. I recommend that you go to Ready Made DSS sites and use some of DSS that are listed for various types of decisions. You will need to install MicroStrategy Desktop to analyze three stand-alone offline dashboards in a peer-evaluated exercise....
Reading
5 vidéos (Total 36 min), 19 lectures, 2 quiz
Video5 vidéos
Overview of Decision Making Video Lecture5 min
Conceptual Foundations of Decision Making Video Lecture11 min
Decision Support Systems Video Lecture8 min
Decision Making Support in Practice Video Lecture8 min
Reading19 lectures
Optional Text Book10 min
Additional Resources - Course Overview10 min
Powerpoint and Lecture Notes for Lesson 1.110 min
Additional Resources Lesson 1.110 min
Powerpoint and Lecture Notes for Lesson 1.210 min
Additional Resources Lesson 1.210 min
Periodicals10 min
Powerpoint and Lecture Notes for Lesson 1.310 min
Additional Resources for Lesson 1.310 min
Additional Web Resources10 min
Vendors and Software Companies10 min
Powerpoint and Lecture Notes for Lesson 1.410 min
Additional Resources for Lesson 1.410 min
Ready Made DSS Products and Services10 min
MicroStrategy Desktop Software Download and Installations Steps for PC and MAC10 min
MicroStrategy Desktop Connections to Oracle VM on PC and MAC10 min
MicroStrategy Desktop Welcome Training Video10 min
Dashboards Demonstration Videos10 min
Q & A and Errors Knowledge base10 min
Quiz1 exercice pour s'entraîner
Module 1 Practice Quiz10 min
Week
2
Clock
5 heures pour terminer

Business Intelligence Concepts and Platform Capabilities

Now that you understand the conceptual foundation of decision making and DSS, in module 2 we start by defining business intelligence (BI), BI architecture, and its components, and relate them to DSS. In lesson 2, you will learn the main components of BI platforms, their capabilities, and understand the competitive landscape of BI platforms. In lesson 3, you will learn the building blocks of business reports, the types of business reports, and the components and structure of business reporting systems. Finally, in lesson 4, you will learn different types of OLAP and their applications and comprehend the differences between OLAP and OLTP. You will need to use MicroStrategy Desktop to create effective and compelling data visualizations to analyze data and acquire insights into business practices in a peer-evaluated exercise. ...
Reading
5 vidéos (Total 52 min), 11 lectures, 3 quiz
Video5 vidéos
BI Platform Capabilities Video Lecture7 min
Training Video for Microstrategy Desktop BI Capabilities23 min
Business Reporting Video Lecture7 min
BI OLAP Styles Video Lecture5 min
Reading11 lectures
Powerpoint and Lecture Notes for Lesson 2.110 min
Additional Resources for Lesson 2.110 min
Training Video for Connecting Data in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 2.210 min
Additional Resources for Lesson 2.210 min
Powerpoint and Lecture Notes for Lesson 2.310 min
Additional Resources for Lesson 2.310 min
Training Videos for Connecting to Spreadsheets, Joining Datasets, and Data Blending in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 2. 410 min
Additional Resources for Lesson 2.410 min
Training Video for Wrangling and Profiling Data in MicroStrategy10 min
Quiz2 exercices pour s'entraîner
Module 2 Practice Quiz10 min
Modules 1 and 2 Graded Quiz #130 min
Week
3
Clock
5 heures pour terminer

Data Visualization and Dashboard Design

This module continues on the top job responsibilities of BI analysts by focusing on creating data visualizations and dashboards. You will first learn the importance of data visualization and different types of data that can be visually represented. You will then learn about the types of basic and composite charts. This will help you to determine which visualization is most effective to display data for a given data set and to identify best practices for designing data visualizations. In lesson 3, you will learn the common characteristics of a dashboard, the types of dashboards, and the list attributes of metrics usually included in dashboards. Finally, in lesson 4, you will learn the guidelines for designing dashboard and the common pitfalls of dashboard design. You will need to use MicroStrategy Desktop Visual Insight to design a dashboard for a Financial Services company in a peer-evaluated exercise....
Reading
6 vidéos (Total 57 min), 12 lectures, 2 quiz
Video6 vidéos
Data Visualization Guidlines and Pitfalls Video Lecture6 min
Comprehensive Training Video for Showing Data Visualization Steps6 min
Performance Dashboards Video Lecture8 min
Dashboard Design Guidelines and Pitfalls Video Lecture9 min
Comprehensive Training Video for Creating Dashboard Using Advanced Visualization17 min
Reading12 lectures
Powerpoint and Lecture Notes for Lesson 3.110 min
Additional Resources for Lesson 3.110 min
Training Video for Visual Insight in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 3.210 min
Additional Resources for Lesson 3.210 min
Training Video for Exploring Data in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 3.310 min
Additional Resources for Lesson 3.310 min
Training Videos for Creating Dashboard in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 3.410 min
Additional Resources for Lesson 3.410 min
Training Video for Sharing a Dashboard in MicroStrategy Desktop10 min
Quiz1 exercice pour s'entraîner
Module 3 Practice Quiz10 min
Week
4
Clock
5 heures pour terminer

Business Performance Management Systems

This module focuses on how BI is used for Business Performance Management (BPM). You will learn the main components of BPM as well as the four phases of BPM cycle and how organizations typically deploy BPM. In lesson 2, you will learn the purpose of Performance Measurement System and how organizations need to define the key performance indicators (KPIs) for their performance management system. In lesson 3, you will learn the four balanced scorecards perspectives and the differences between dashboards and scorecards. You will also be able to compare and contrast the benefits of using balanced scorecard versus using Six Sigma in a performance measurement system. Finally, in lesson 4, you will learn the role of visual and business analytics (BA) in BI and how various forms of BA are supported in practice. At the end of the module, you will apply these concepts to create a dashboard, blend it with external datasets, and explore various visualization capabilities to find insights faster in a peer-evaluated exercise....
Reading
5 vidéos (Total 48 min), 11 lectures, 2 quiz
Video5 vidéos
Performance Measurement System Video Lecture6 min
Balanced Scorecards Versus Six Sigma Video Lecture10 min
Training Video for MicroStrategy Desktop Business Performance Analysis12 min
Business Analytics Video Lecture9 min
Reading11 lectures
Powerpoint and Lecture Notes for Lesson 4.110 min
Additional Resources for Lesson 4.110 min
Training Videos for Enriching and Modeling Data with MicroStrategy10 min
Powerpoint and Lecture Notes for Lesson 4.210 min
Additional Resources for Lesson 4.210 min
Training Videos for Connecting to MDX and Excel Files and Creating a Mashups in MicroStrategy Desktop10 min
Powerpoint and Lecture Notes for Lesson 4.310 min
Additional Resources for Lesson 4.310 min
Powerpoint and Lecture Notes for Lesson 4.410 min
Additional Resources for Lesson 4.410 min
Training Video for Connecting to Social Media Sources in MicroStrategy Desktop10 min
Quiz1 exercice pour s'entraîner
Module 4 Practice Quiz10 min
4.4
Direction Signs

25%

a commencé une nouvelle carrière après avoir terminé ces cours
Briefcase

83%

a bénéficié d'un avantage concret dans sa carrière grâce à ce cours

Meilleurs avis

par NAMar 25th 2016

The Course is well laid out with plenty of assignments that allow you master the BI by using Microstrategy. Thanks to professor Karimi, it was by far the best BI course that I have ever taken.

par GLJul 22nd 2017

Very good course , with very explanatory and additional material. Deep diving with exercises and especially the last assignment where total understanding was required in order to fulfil it.

Enseignant

Jahangir Karimi

Professor
Information Systems University of Colorado Denver

À propos de University of Colorado System

The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond....

À propos de la Spécialisation Data Warehousing for Business Intelligence

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience....
Data Warehousing for Business Intelligence

Foire Aux Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • 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. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.