Power EXAM BI DA-100: Analyzing Data with Microsoft Power BI 2021
4 views 0 purchase
Course
BI DA-100
Institution
BI DA-100
What are the divisions of the core components of analytics? correct answer- To analyze
data, core components of analytics are divided into the following categories:
-Descriptive
-Diagnostic
-Predictive
-Prescriptive
-Cognitive
What are descriptive analytics? correct answer- Descriptive analy...
power exam bi da 100 analyzing data with microsoft power bi
what are the divisions of the core components of analytics
what are descriptive analytics
what are examples of descriptive analytics
Written for
BI DA-100
All documents for this subject (4)
Seller
Follow
EvaTee
Reviews received
Content preview
Power EXAM BI DA-100: Analyzing
Data with Microsoft Power BI
What are the divisions of the core components of analytics? correct answer- To analyze
data, core components of analytics are divided into the following categories:
-Descriptive
-Diagnostic
-Predictive
-Prescriptive
-Cognitive
What are descriptive analytics? correct answer- 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? correct answer- An example of descriptive
analytics is generating reports to provide a view of an organization's sales and financial
data.
What are 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.
What are the steps of diagnostic analytics? correct answer- 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? correct answer- 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? correct answer- Techniques include a
variety of statistical and machine learning techniques such as neural networks, decision
trees, and regression.
What are prescriptive analytics? correct answer- 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? correct answer- Prescriptive analytics
techniques rely on machine learning strategies to find patterns in large datasets.
What are cognitive analytics? correct answer- 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? correct answer- 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? correct answer- -Business analyst
-Data analyst
-Data engineer
-Data scientist
-Database administrator
What is the role of the business analyst? correct answer- 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? correct answer- 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 correct
answer- 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?
correct answer- 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? correct answer- 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? correct answer- 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? correct answer- 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? correct answer- 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? correct answer- 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? correct answer- 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EvaTee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
