About the Course
This free business intelligence course provides an overview of the BI industry and best practices. Learn how BI differs from data science, as well as the key roles and processes involved
Apply Link
Business Intelligence Course Assessment Answers
Question 1
Business Intelligence – Definitions
Which of the following statements about business intelligence is NOT correct?
Business intelligence is the practice of turning data into actionable insights that allow business leaders to change or maintain a course of action.
Business intelligence focuses on predicting what will happen or which outcome is most likely.
Business intelligence requires different processes, tools, skills, and roles to work together.
The key skills of business intelligence include basic statistics, data transformation, data visualization, and business knowledge.
Question 2
BI Processes – Extract, Transform & Load (ETL)
ETL refers to any time when data is taken from one source, transformed in some way, and loaded into a different destination. Data Engineers do a lot of ETL between database systems, whilst Data Analysts extract data from files and databases and transform it for specific projects.
Which of the following best describes the extract, transform & load (ETL) task of the data analyst’s role?
Review Later
Write formulas to calculate business performance
Document data models and metric definitions
Import, combine, and transform data. Convert data into the desired format before loading the data into a file or data model
Combine tables to create data models that link related data
Question 3
Data Analyst – Common Tools
The Data Analyst is responsible for doing basic data transformation using SQL and Power Query, before building data models and metrics. Often, their role also overlaps with the Data Viz Specialist.
Select two tools that are most used for data transformation.
Review Later
Tableau
SQL
Power Query
Power Pivot
Question 4
The Business Intelligence Team
Understanding the source of your data is absolutely essential to great analysis. That means understanding where it came from, how it was collected, what assumptions were made, and exactly what it means?
If you had a query about the integrity of data in the company data warehouse, which of these team members would be most likely to answer your question?
Review Later
Data engineer
Data scientist
Data visualization specialist
Data analyst
Question 5
Types of Database Systems
Different types of database systems exist for different reasons. Some are optimized to capture and modify transactional data, whilst others are more suited to analysis.
With that in mind, what are the main functions of a data warehouse? Select ALL correct answers.
Review Later
Write formulas to calculate business metrics
Optimize data for analysis and human interaction
Stores raw data in its original format
Combine data from multiple sources
Question 6
BI Roles – The Data Engineer
The data engineer is one of the most technical roles in a Business Intelligence team.
Which of these tools might form part of the data engineer’s toolset? Select ALL correct answers.
Review Later
SQL
Hadoop
Microsoft Azure
Plotly
Power Pivot
Scala
Question 7
The BI Process
The Business Intelligence process combines roles, tools, and skills to turn data into actionable insights.
Put the BI process in the correct order:
Review Later
Report Sharing – 5
Data transformation using ETL – 2
Data Visualization and Storytelling – 4
Decision Making using data driven insights – 6
Data collection and storage – 1
Creating Data Models, Metrics, and Analysis – 3
Question 8
The BI Team – Roles and Responsibilities
There are many different processes and tools in business intelligence, each requiring different skills. For that reason, it’s natural that specific roles have evolved to deal with each process.
Match the job title to the correct definition:
Review Later
Data Engineer – A
Data AnalystA,- B
Data Visualization SpecialistB – C
Business Leaders – D
Question 9
Communicating with Data
Communicating with Data – Telling Stories
The term “data stories” is a buzz word in the world of BI. Which of the following might be the purposes of a data story? Select ALL correct answers.
Review Later
To provide details on the current data over time, across categories or locations.
To provide centralized data storage and can be used as the one version of the truth.
To help identify the root causes of an issue or success.
To help identify the actual or forecasted consequences of the current data.
Question 10
Communicating with Data
Communicating with Data – Creating Powerful Visuals
Visuals and dashboards are one of the final steps in the business intelligence process. They are THE key to enable business leaders to make great decisions, more often.
Which of the following should you include when creating stunning, insightful visuals?
Review Later
Chart and axis titles and units are clearly labeled
Bars are 3D and distracting
What is your favorite color?
Key data points of interest are highlighted
Color choices are accessible to color blind audiences
Color choices reflect the story you are trying to tell
Question 11
Key Concepts of Data
Key Concepts of Data – Data Structures
Data structures help store one or more values in an appropriate way for our analysis.
Match the types of data structure with their descriptions:
Review Later
Variables – B
TablesB – C
Lists – A
Question 12
Key Concepts of Data – Data Types
In this course, we highlighted 9 basic data types. Whilst they can be known by slightly different names in each tool, the reason they exist remains consistent.
Which of the following are reasons why defining data types is important? Select ALL correct answers.
Review Later
Defining data types help optimize the amount of memory used to store our data.
Data types assist software to understand how it can manipulate values.
Defining data types helps us focus attention on key messages in our visuals.
Question 13
Key Concepts of Data
Key Concepts of Data – Functions
Functions allow us to manipulate values. Which of the following is a Boolean function?
Review Later
AND(X = 1, Y = 2)
TODAY()
LEFT(A1,2)
ROUND(X,2)
Question 14
Key Concepts of Data – Consolidating Data
The Extract Transform & Load process includes the consolidation of data, often bringing data together from multiple tables.
If you want to combine the rows of multiple tables into one, as shown in the example below, which method will you use?
Linking tables
Appending tables
Joining tables
Relationships
Question 15
Key Concepts of Data – Table Joins
Another method of data consolidation is JOINing tables. This time, instead of appending additional rows, JOINing tables creates new columns of data, soured from a related table.
Which of the following are used to create links between the two tables being JOINed?
Review Later
House Keys
Primary Keys
Hot Keys
Foreign Keys
Question 16
Key Concepts of Data – File Types
Excel, CSV & JSON are all common file types in Business Intelligence. Each file type has a number of pros and cons.
Select ALL of the correct descriptions of a CSV file.
Review Later
It stores values in an efficient format.
It offers robust and centralized data storage.
It stores both formulas and formatting.
The values in the file are separated by commas.
Free Certificate Online download: Click Here