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.
Give your career the gift of Coursera Plus with $160 off, billed annually. Save today.
Business Intelligence Concepts, Tools, and Applications
This course is part of Data Warehousing for Business Intelligence Specialization
Instructor: Jahangir Karimi
47,869 already enrolled
Included with
(630 reviews)
Skills you'll gain
Details to know
Add to your LinkedIn profile
6 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 5 modules in this course
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 their main components, the various DSS types and classifications, and how DSS has 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 how they have changed over time. I recommend that you go to Ready Made DSS sites and use some of the 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.
What's included
5 videos21 readings1 assignment1 peer review
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, and 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 compelling data visualizations to analyze data and acquire insights into business practices in a peer-evaluated exercise.
What's included
4 videos12 readings2 assignments1 peer review
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 of attributes of metrics usually included in dashboards. Finally, in lesson 3, you will learn the guidelines for designing a 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.
What's included
4 videos14 readings1 assignment1 peer review
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 the BPM cycle and how organizations typically deploy BPM. In lesson 2, you will learn the purpose of the 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 scorecard perspectives and the differences between dashboards and scorecards. You will also be able to compare and contrast the benefits of using a 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.
What's included
5 videos9 readings1 assignment1 peer review
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 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 of problems.
What's included
3 videos5 readings1 assignment1 peer review
Instructor
Offered by
Recommended if you're interested in Data Analysis
University of California, Irvine
Universidad Nacional Autónoma de México
University of Colorado System
Coursera Instructor Network
Why people choose Coursera for their career
Learner reviews
Showing 3 of 630
630 reviews
- 5 stars
62.83%
- 4 stars
27.08%
- 3 stars
5.82%
- 2 stars
1.88%
- 1 star
2.36%
New to Data Analysis? Start here.
Open new doors with Coursera Plus
Unlimited access to 7,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
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
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.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.