Power BI DA-100 QUESTIONS &
ANSWERS 100% CORRECT!!
What are the divisions of the core components of analytics? - with answers:To analyze data, core
components of analytics are divided into the following categories:
-Descriptive
-Diagnostic
-Predictive
-Prescriptive
-Cognitive
What are descriptive analytics? - with answers:Descriptive analytics help answer questions about
what has happened based on historical data. Descriptive analytics techniques summarize large
datasets to describe outcomes to stakeholders.
What are examples of descriptive analytics? - with answers:An example of descriptive analytics
is generating reports to provide a view of an organization's sales and financial data.
What are diagnostic analytics? - with answers: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.
What are the steps of diagnostic analytics? - with answers:Performance indicators are further
investigated to discover why these events improved or became worse. Generally, this process
occurs in three steps:
1. Identify anomalies in the data. These anomalies might be unexpected changes in a metric or a
particular market.
2. Collect data that's related to these anomalies.
3. Use statistical techniques to discover relationships and trends that explain these anomalies.
,What are predictive analytics? - with answers:Predictive analytics help answer questions about
what will happen in the future. Predictive analytics techniques use historical data to identify
trends and determine if they're likely to recur.
What techniques does predictive analytics use? - with answers:Techniques include a variety of
statistical and machine learning techniques such as neural networks, decision trees, and
regression.
What are prescriptive analytics? - with answers:Prescriptive analytics help answer questions
about which actions should be taken to achieve a goal or target. By using insights from
predictive analytics, organizations can make data-driven decisions. This technique allows
businesses to make informed decisions in the face of uncertainty.
What tools does prescriptive analytics rely on? - with answers:Prescriptive analytics techniques
rely on machine learning strategies to find patterns in large datasets.
What are cognitive analytics? - with answers:Cognitive analytics attempt to draw inferences
from existing data and patterns, derive conclusions based on existing knowledge bases, and then
add these findings back into the knowledge base for future inferences, a self-learning feedback
loop. Cognitive analytics help you learn what might happen if circumstances change and
determine how you might handle these situations.
How are inferences structured for cognitive analytics? - with answers:Inferences aren't structured
queries based on a rules database; rather, they're unstructured hypotheses that are gathered from
several sources and expressed with varying degrees of confidence. Effective cognitive analytics
depend on machine learning algorithms, and will use several natural language processing
concepts to make sense of previously untapped data sources, such as call center conversation
logs and product reviews.
What are the different data roles? - with answers:-Business analyst
-Data analyst
-Data engineer
-Data scientist
-Database administrator
,What is the role of the business analyst? - with answers:While some similarities exist between a
data analyst and business analyst, the key differentiator between the two roles is what they do
with data. A business analyst is closer to the business and is a specialist in interpreting the data
that comes from the visualization.
What is the role of the data analyst? - with answers:A data analyst enables businesses to
maximize the value of their data assets through visualization and reporting tools such as
Microsoft Power BI. Data analysts are responsible for profiling, cleaning, and transforming data.
Their responsibilities also include designing and building scalable and effective data models, and
enabling and implementing the advanced analytics capabilities into reports for analysis.
What are the responsibilities of the data analyst with respect to Power BI - with answers:A data
analyst is also responsible for the management of Power BI assets, including reports, dashboards,
workspaces, and the underlying datasets that are used in the reports. They are tasked with
implementing and configuring proper security procedures, in conjunction with stakeholder
requirements, to ensure the safekeeping of all Power BI assets and their data.
How do data analyst interreact with the data engineer and database administrator? - with
answers:Data analysts work with data engineers to determine and locate appropriate data sources
that meet stakeholder requirements. Additionally, data analysts work with the data engineer and
database administrator to ensure that the analyst has proper access to the needed data sources.
The data analyst also works with the data engineer to identify new processes or improve existing
processes for collecting data for analysis.
What is the role of the data engineer? - with answers:Data engineers provision and set up data
platform technologies that are on-premises and in the cloud. They manage and secure the flow of
structured and unstructured data from multiple sources. The data platforms that they use can
include relational databases, nonrelational databases, data streams, and file stores. Data engineers
also ensure that data services securely and seamlessly integrate across data services.
Who does the data engineer work with? - with answers:As a data analyst, you would work
closely with a data engineer in making sure that you can access the variety of structured and
unstructured data sources because they will support you in optimizing data models, which are
typically served from a modern data warehouse or data lake.
, Who can become a data engineer? - with answers:Both database administrators and business
intelligence professionals can transition to a data engineer role; they need to learn the tools and
technology that are used to process large amounts of data.
What is the role of the data scientist? - with answers:Data scientists perform advanced analytics
to extract value from data. Their work can vary from descriptive analytics to predictive analytics.
Descriptive analytics evaluate data through a process known as exploratory data analysis (EDA).
Predictive analytics are used in machine learning to apply modeling techniques that can detect
anomalies or patterns. These analytics are important parts of forecast models.
What is the role of the database administrator? - with answers:A database administrator
implements and manages the operational aspects of cloud-native and hybrid data platform
solutions that are built on Microsoft Azure data services and Microsoft SQL Server. A data
administrator is responsible for the overall availability and consistent performance and
optimizations of the database solutions. They work with stakeholders to identify and implement
the policies, tools, and processes for data backup and recovery plans.
How does the data analyst divide most of their time? - with answers:As a data analyst, you'll
likely divide most of your time between the prepare and model tasks. Deficient or incorrect data
can have a major impact that results in invalid reports, a loss of trust, and a negative effect on
business decisions, which can lead to loss in revenue, a negative business impact, and more.
What needs to take place before the data analyst can prepare their report? - with answers:Before
a report can be created, data must be prepared. Data preparation is the process of profiling,
cleaning, and transforming your data to get it ready to model and visualize.
What is data preparation? - with answers:Data preparation is the process of taking raw data and
turning it into information that is trusted and understandable. It involves, among other things,
ensuring the integrity of the data, correcting wrong or inaccurate data, identifying missing data,
converting data from one structure to another or from one type to another, or even a task as
simple as making data more readable.
What follows data preparation? - with answers:When the data is in a proper state, it's ready to be
modeled. Data modeling is the process of determining how your tables are related to each other.
This process is done by defining and creating relationships between the tables. From that point,
you can enhance the model by defining metrics and adding custom calculations to enrich your
data.