Coursera
Изучить
  • Обзор
  • Поиск
  • Для организаций
  • Войти
  • Зарегистрироваться

Business Intelligence Concepts, Tools, and Applications

ОбзорПрограмма курсаЧасто задаваемые вопросыАвторыСтоимостьРейтинги и отзывы

ГлавнаяНаука о данныхАнализ данных

Business Intelligence Concepts, Tools, and Applications

Система университетов штата Колорадо

Об этом курсе: 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.


Автор:  Система университетов штата Колорадо
Система университетов штата Колорадо

  • Jahangir Karimi

    Преподаватели:  Jahangir Karimi, Professor

    Information Systems University of Colorado Denver
Основные сведения
Course 4 of 5 in the Data Warehousing for Business Intelligence Specialization
Выполнение5 weeks of study, 3-5 hours/week
Язык
English, Субтитры: Chinese (Simplified)
Как пройти курсЧтобы пройти курс, выполните все оцениваемые задания.
Оценки пользователей
4.4 звезды
Средняя оценка пользователей: 4.4Посмотрите, что пишут учащиеся
Программа курса
НЕДЕЛЯ 1
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.
5 видео, 19 материалов для самостоятельного изучения, 1 practice quiz
  1. Видео: Course Introduction Video Lecture
  2. Reading: Optional Text Book
  3. Reading: Additional Resources - Course Overview
  4. Видео: Overview of Decision Making Video Lecture
  5. Reading: Powerpoint and Lecture Notes for Lesson 1.1
  6. Reading: Additional Resources Lesson 1.1
  7. Видео: Conceptual Foundations of Decision Making Video Lecture
  8. Reading: Powerpoint and Lecture Notes for Lesson 1.2
  9. Reading: Additional Resources Lesson 1.2
  10. Reading: Periodicals
  11. Видео: Decision Support Systems Video Lecture
  12. Reading: Powerpoint and Lecture Notes for Lesson 1.3
  13. Reading: Additional Resources for Lesson 1.3
  14. Reading: Additional Web Resources
  15. Reading: Vendors and Software Companies
  16. Видео: Decision Making Support in Practice Video Lecture
  17. Reading: Powerpoint and Lecture Notes for Lesson 1.4
  18. Reading: Additional Resources for Lesson 1.4
  19. Reading: Ready Made DSS Products and Services
  20. Reading: MicroStrategy Desktop Software Download and Installations Steps for PC and MAC
  21. Reading: MicroStrategy Desktop Connections to Oracle VM on PC and MAC
  22. Reading: MicroStrategy Desktop Welcome Training Video
  23. Reading: Dashboards Demonstration Videos
  24. Practice Quiz: Module 1 Practice Quiz
  25. Reading: Q & A and Errors Knowledge base
Оцениваемый: Assignment for Module 1: Offline Dashboards with Advanced Visualizations
НЕДЕЛЯ 2
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.
5 видео, 11 материалов для самостоятельного изучения, 1 practice quiz
  1. Видео: BI Concepts Video Lecture
  2. Reading: Powerpoint and Lecture Notes for Lesson 2.1
  3. Reading: Additional Resources for Lesson 2.1
  4. Reading: Training Video for Connecting Data in MicroStrategy Desktop
  5. Видео: BI Platform Capabilities Video Lecture
  6. Reading: Powerpoint and Lecture Notes for Lesson 2.2
  7. Reading: Additional Resources for Lesson 2.2
  8. Видео: Training Video for Microstrategy Desktop BI Capabilities
  9. Видео: Business Reporting Video Lecture
  10. Reading: Powerpoint and Lecture Notes for Lesson 2.3
  11. Reading: Additional Resources for Lesson 2.3
  12. Reading: Training Videos for Connecting to Spreadsheets, Joining Datasets, and Data Blending in MicroStrategy Desktop
  13. Видео: BI OLAP Styles Video Lecture
  14. Reading: Powerpoint and Lecture Notes for Lesson 2. 4
  15. Reading: Additional Resources for Lesson 2.4
  16. Reading: Training Video for Wrangling and Profiling Data in MicroStrategy
  17. Practice Quiz: Module 2 Practice Quiz
Оцениваемый: Assignment for Module 2: World Wide Carbon Emissions Scenario
Оцениваемый: Modules 1 and 2 Graded Quiz #1
НЕДЕЛЯ 3
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 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.
6 видео, 12 материалов для самостоятельного изучения, 1 practice quiz
  1. Видео: Data Visualization Video Lecture
  2. Reading: Powerpoint and Lecture Notes for Lesson 3.1
  3. Reading: Additional Resources for Lesson 3.1
  4. Reading: Training Video for Visual Insight in MicroStrategy Desktop
  5. Видео: Data Visualization Guidlines and Pitfalls Video Lecture
  6. Reading: Powerpoint and Lecture Notes for Lesson 3.2
  7. Reading: Additional Resources for Lesson 3.2
  8. Reading: Training Video for Exploring Data in MicroStrategy Desktop
  9. Видео: Comprehensive Training Video for Showing Data Visualization Steps
  10. Видео: Performance Dashboards Video Lecture
  11. Reading: Powerpoint and Lecture Notes for Lesson 3.3
  12. Reading: Additional Resources for Lesson 3.3
  13. Reading: Training Videos for Creating Dashboard in MicroStrategy Desktop
  14. Видео: Dashboard Design Guidelines and Pitfalls Video Lecture
  15. Reading: Powerpoint and Lecture Notes for Lesson 3.4
  16. Reading: Additional Resources for Lesson 3.4
  17. Reading: Training Video for Sharing a Dashboard in MicroStrategy Desktop
  18. Видео: Comprehensive Training Video for Creating Dashboard Using Advanced Visualization
  19. Practice Quiz: Module 3 Practice Quiz
Оцениваемый: Assignment for Module 3: Design Dashboard for a Financial Service Company
НЕДЕЛЯ 4
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 data sets, and explore various visualization capabilities to find insights faster in a peer evaluated exercise.
5 видео, 11 материалов для самостоятельного изучения, 1 practice quiz
  1. Видео: Business Performance Management Video Lecture
  2. Reading: Powerpoint and Lecture Notes for Lesson 4.1
  3. Reading: Additional Resources for Lesson 4.1
  4. Reading: Training Videos for Enriching and Modeling Data with MicroStrategy
  5. Видео: Performance Measurement System Video Lecture
  6. Reading: Powerpoint and Lecture Notes for Lesson 4.2
  7. Reading: Additional Resources for Lesson 4.2
  8. Reading: Training Videos for Connecting to MDX and Excel Files and Creating a Mashups in MicroStrategy Desktop
  9. Видео: Balanced Scorecards Versus Six Sigma Video Lecture
  10. Reading: Powerpoint and Lecture Notes for Lesson 4.3
  11. Reading: Additional Resources for Lesson 4.3
  12. Видео: Training Video for MicroStrategy Desktop Business Performance Analysis
  13. Видео: Business Analytics Video Lecture
  14. Reading: Powerpoint and Lecture Notes for Lesson 4.4
  15. Reading: Additional Resources for Lesson 4.4
  16. Reading: Training Video for Connecting to Social Media Sources in MicroStrategy Desktop
  17. Practice Quiz: Module 4 Practice Quiz
Оцениваемый: Assignment for Module 4: Advanced Enterprise Data Discovery
НЕДЕЛЯ 5
BI Maturity, Strategy, and Summative Project
Module 5 covers BI maturity and strategy. You will learn different levels of BI maturity, the factors that impact BI maturity within an organization, and the main challenges and the potential solutions for a pervasive BI maturity within an organization. The last lesson will focus on the critical success factors for implementing a BI strategy, BI framework, and BI implementation targets. Finally, in your summative project, you will use MicroStrategy visual analytics capabilities to analyze KPIs for a fast food company to find the causes for problems .
3 видео, 4 материалов для самостоятельного изучения
  1. Видео: BI Maturity Video Lecture
  2. Reading: Powerpoint and Lecture Notes for Lesson 5.1
  3. Reading: Additional Resources for Lesson 5.1
  4. Видео: BI Strategy Video Lecture
  5. Reading: Powerpoint and Lecture Notes for Lesson 5.2
  6. Reading: Additional Resources for Lesson 5.2
  7. Видео: Course Closing Video
Оцениваемый: Summative Project: BPM For Blazin' Burger Fast Food Restaurant
Оцениваемый: Modules 3, 4, and 5 Graded Quiz #2

Часто задаваемые вопросы
Как это работает
Coursework
Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from Your Peers
Help from Your Peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates
Certificates

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

Авторы
Система университетов штата Колорадо
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.
Стоимость
Приобрести курс
Получить доступ к материалам курса

Доступен

Получить доступ к оцениваемым материалам курса

Доступен

Получить итоговую оценку

Доступен

Earn a shareable Course Certificate

Доступен

Рейтинги и отзывы
Оценка 4.4 из 5 по 335 отзывам
Jatin Nailwal

This course was great and learnt a lot from this. Lot of information with great examples.

Felix Munyoki

This is the perfect blend of theory and practice. Well organized, great assignments, lots of reading material and an experienced instructor. I need not say more.

Matthew LeVasseur

Great exercises building interactive dashboards with MicroStrategy

VC

Good course!!!!



Вас также могут заинтересовать
Johns Hopkins University
Data Science in Real Life
1 курс
Johns Hopkins University
Data Science in Real Life
Просмотреть курс
Johns Hopkins University
Managing Data Analysis
1 курс
Johns Hopkins University
Managing Data Analysis
Просмотреть курс
Johns Hopkins University
Building a Data Science Team
1 курс
Johns Hopkins University
Building a Data Science Team
Просмотреть курс
Система университетов штата Колорадо
Relational Database Support for Data Warehouses
1 курс
Система университетов штата Колорадо
Relational Database Support for Data Warehouses
Просмотреть курс
Система университетов штата Колорадо
Data Warehouse Concepts, Design, and Data Integration
1 курс
Система университетов штата Колорадо
Data Warehouse Concepts, Design, and Data Integration
Просмотреть курс
Coursera
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
Загрузить из App StoreЗагрузить в Google Play
  • Coursera
  • О проекте
  • Руководство
  • Карьера
  • Каталог
  • Сертификаты
  • Степени
  • Для бизнеса
  • Для правительственных организаций
  • Сообщество
  • Партнеры
  • Наставники
  • Переводчики
  • Разработчики
  • Бета-тестировщики
  • На связи
  • Блог
  • Facebook
  • LinkedIn
  • Twitter
  • Google+
  • Технический блог
  • Еще
  • Условия
  • Конфиденциальность
  • Помощь
  • Доступность
  • Пресса
  • Контакты
  • Справочник
  • Филиалы