PowerBI Module 1 - Getting started
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
What is Data Analytics and why is it important -
correct answer ✅With data and information as the most strategic
asset of a business, the underlying challenge that organisations
have today is understanding and using their data to positively affect
change within the business. Businesses continue to struggle to use
their data in a meaningful and productive way, which impacts their
ability to act.
Example of Data Analysis with a retail Company -
correct answer ✅daily/monthly sale patterns. Common data
segments that you might want to examine include day-over-day,
week-over-week, and month-over-month so that you can compare
how sales have been to where they were in the same week last
year, for example.
Why is understanding the data important -
correct answer ✅The key to unlocking this data is being able to tell
a story with it. In today's highly competitive and fast-paced
business world, crafting reports that tell that story is what helps
business leaders take action on the data.
,PowerBI Module 1 - Getting started
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
What challenges do businesses face when understanding data -
correct answer ✅The underlying challenge that businesses face
today is understanding and using their data in such a way that
impacts their business and ultimately their bottom line. You need to
be able to look at the data and facilitate trusted business decisions.
Then, you need the ability to look at metrics and clearly understand
the meaning behind those metrics.
How is data conveyed to businesses and decision markers -
correct answer ✅While telling the story is important, where that
story is told is also crucial, ensuring that the story is told to the right
people. Also, make sure that people can discover the story, that
they know where to find it, and that it is part of the regular
interactions.
Steps in Data Analysis -
correct answer ✅Before data can be used to tell a story, it must be
run through a process that makes it usable in the story. Data
analysis is the process of identifying, cleaning, transforming, and
modelling data to discover meaningful and useful information.
, PowerBI Module 1 - Getting started
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
To analyse data, core components of analytics are divided into the
following categories -
correct answer ✅. DDPPC. Descriptive, Diagnostic,
Predictive ,Prescriptive, and Cognitive
Descriptive analytics -
correct answer ✅Descriptive analytics help answer questions
about what has happened based on historical data. Descriptive
analytics techniques summarise large datasets to describe
outcomes to stakeholders. Performance tracker like KPI, ROI, sales,
financial data, etc. Describes the what
Diagnostic analytics -
correct answer ✅Diagnostic analytics help answer questions about
why events happened. Diagnostic analytics techniques supplement
basic descriptive analytics, and they use the findings from
descriptive analytics to discover the cause of these events.
Describes the way
Steps in Diagnostic Analytics -
correct answer ✅Identify anomalies in the data. These anomalies
might be unexpected changes in a metric or a particular market.
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
What is Data Analytics and why is it important -
correct answer ✅With data and information as the most strategic
asset of a business, the underlying challenge that organisations
have today is understanding and using their data to positively affect
change within the business. Businesses continue to struggle to use
their data in a meaningful and productive way, which impacts their
ability to act.
Example of Data Analysis with a retail Company -
correct answer ✅daily/monthly sale patterns. Common data
segments that you might want to examine include day-over-day,
week-over-week, and month-over-month so that you can compare
how sales have been to where they were in the same week last
year, for example.
Why is understanding the data important -
correct answer ✅The key to unlocking this data is being able to tell
a story with it. In today's highly competitive and fast-paced
business world, crafting reports that tell that story is what helps
business leaders take action on the data.
,PowerBI Module 1 - Getting started
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
What challenges do businesses face when understanding data -
correct answer ✅The underlying challenge that businesses face
today is understanding and using their data in such a way that
impacts their business and ultimately their bottom line. You need to
be able to look at the data and facilitate trusted business decisions.
Then, you need the ability to look at metrics and clearly understand
the meaning behind those metrics.
How is data conveyed to businesses and decision markers -
correct answer ✅While telling the story is important, where that
story is told is also crucial, ensuring that the story is told to the right
people. Also, make sure that people can discover the story, that
they know where to find it, and that it is part of the regular
interactions.
Steps in Data Analysis -
correct answer ✅Before data can be used to tell a story, it must be
run through a process that makes it usable in the story. Data
analysis is the process of identifying, cleaning, transforming, and
modelling data to discover meaningful and useful information.
, PowerBI Module 1 - Getting started
with Microsoft Data Analytics Exam
Questions & Answers (Grade A+)
To analyse data, core components of analytics are divided into the
following categories -
correct answer ✅. DDPPC. Descriptive, Diagnostic,
Predictive ,Prescriptive, and Cognitive
Descriptive analytics -
correct answer ✅Descriptive analytics help answer questions
about what has happened based on historical data. Descriptive
analytics techniques summarise large datasets to describe
outcomes to stakeholders. Performance tracker like KPI, ROI, sales,
financial data, etc. Describes the what
Diagnostic analytics -
correct answer ✅Diagnostic analytics help answer questions about
why events happened. Diagnostic analytics techniques supplement
basic descriptive analytics, and they use the findings from
descriptive analytics to discover the cause of these events.
Describes the way
Steps in Diagnostic Analytics -
correct answer ✅Identify anomalies in the data. These anomalies
might be unexpected changes in a metric or a particular market.
