Exam (elaborations)
DA-100 Exam with Questions with 100% Correct Answers |Verified
- Course
- Institution
DA-100 Exam with Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA-100 Exam with Questions with 100% CorrectAnswers |Verified
What follows data preparation? - ✔✔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.
With respect to modeling, if your Power BI report is performing slowly what do you need to do?
- ✔✔From a Power BI perspective, if your report is performing slowly, or your refreshes are
taking a long time, you will likely need to revisit the data preparation and modeling tasks to
optimize your report.
What should the visualizations achieve? - ✔✔A well-designed report should tell a compelling
story about that data, which will enable business decision makers to quickly gain needed
insights. By using appropriate visualizations and interactions, you can provide an effective
report that guides the reader through the content quickly and efficiently, therefore allowing the
reader to follow a narrative into the data.
What is important to keep in mind as you build reports? - ✔✔As you build reports, it is
important to think about people who will be accessing and reading the reports. Reports should
be designed with accessibility in mind from the outset so that no special modifications are
needed in the future.
What is the most important step of understanding and interpreting the information that is
displayed on the report? - ✔✔The analyze task is the important step of understanding and
interpreting the information that is displayed on the report. In your role as a data analyst, you
should understand the analytical capabilities of Power BI and use those capabilities to find
insights, identify patterns and trends, predict outcomes, and then communicate those insights
in a way that everyone can understand.
What does managing entail for the data analyst? - ✔✔Power BI consists of many
components, including reports, dashboards, workspaces, datasets, and more. As a data analyst,
,you are responsible for the management of these Power BI assets, overseeing the sharing and
distribution of items, such as reports and dashboards, and ensuring the security of Power BI
assets.
How does data management reduce duplication of efforts? - ✔✔Proper management can
also help reduce data silos within your organization. Data duplication can make managing and
introducing data latency difficult when resources are overused. Power BI helps reduce data
silos with the use of shared datasets, and it allows you to reuse data that you have prepared
and modeled. For key business data, endorsing a dataset as certified can help to ensure trust in
that data.
The management of Power BI assets helps reduce the duplication of efforts and helps ensure
security of the data.
What is Microsoft Power BI? - ✔✔Microsoft Power BI is a collection of software services,
apps, and connectors that work together to turn your unrelated sources of data into coherent,
visually immersive, and interactive insights.
What is the common flow of activity for working in Power BI? - ✔✔The common flow of
activity looks like this:
1. Bring data into Power BI Desktop, and create a report.
2. Publish to the Power BI service, where you can create new visualizations or build dashboards.
3. Share dashboards with others, especially people who are on the go.
4. View and interact with shared dashboards and reports in Power BI Mobile apps.
What are the basic building blocks in Power BI? - ✔✔Here are the basic building blocks in
Power BI:
-Visualizations
-Datasets
-Reports
-Dashboards
,-Tiles
What is a visualization? - ✔✔A visualization (sometimes also referred to as a visual) is a
visual representation of data, like a chart, a color-coded map, or other interesting things you
can create to represent your data visually.
What is the goal of a visual? - ✔✔The goal of a visual is to present data in a way that
provides context and insights, both of which would probably be difficult to discern from a raw
table of numbers or text.
What is the role of data connectors in Power BI? - ✔✔An important and enabling part of
Power BI is the multitude of data connectors that are included. Whether the data you want is in
Excel or a Microsoft SQL Server database, in Azure or Oracle, or in a service like Facebook,
Salesforce, or MailChimp, Power BI has built-in data connectors that let you easily connect to
that data, filter it if necessary, and bring it into your dataset.
What is a Power BI report? - ✔✔In Power BI, a report is a collection of visualizations that
appear together on one or more pages.
What is a Power BI dashboard? - ✔✔When you're ready to share a single page from a report,
or a collection of visualizations, you create a dashboard. Much like the dashboard in a car, a
Power BI dashboard is a collection of visuals from a single page that you can share with others.
Often, it's a selected group of visuals that provide quick insight into the data or story you're
trying to present.
What rules apply to Power BI dashboards? - ✔✔A dashboard must fit on a single page, often
called a canvas (the canvas is the blank backdrop in Power BI Desktop or the service, where you
put visualizations).
How can you share Power BI dashboards? - ✔✔You can share dashboards with other users
or groups, who can then interact with your dashboards when they're in the Power BI service or
on their mobile device.
, What is a tile in Power BI? - ✔✔In Power BI, a tile is a single visualization on a report or a
dashboard. It's the rectangular box that holds an individual visual. In the following image, you
see one tile, which is also surrounded by other tiles.
How do you connect data in Power BI? - ✔✔With Power BI, connecting to data is easy. From
the Power BI service, you can just select the Get Data button in the lower-left corner of the
home page.
What is the canvas? - ✔✔The canvas (the area in the center of the Power BI service) shows
you the available sources of data in the Power BI service. In addition to common data sources
like Microsoft Excel files, databases, or Microsoft Azure data, Power BI can just as easily
connect to a whole assortment of software services (also called SaaS providers or cloud
services): Salesforce, Facebook, Google Analytics, and more.
What is an app? - ✔✔Power BI's collection of visuals is called an app. Apps get you up and
running quickly, with data and dashboards that your organization has created for you. For
example, when you use the GitHub app, Power BI connects to your GitHub account (after you
provide your credentials) and then populates a predefined collection of visuals and dashboards
in Power BI.
How do you see what apps you can connect? - ✔✔You select the Get button in the Services
box
How do you update data in Power BI? - ✔✔You can also choose to update the dataset for an
app, or other data that you use in Power BI. To set update settings, select the schedule update
icon for the dataset to update, and then use the menu that appears. You can also select the
update icon (the circle with an arrow) next to the schedule update icon to update the dataset
immediately.
How do you schedule datasets to refresh? - ✔✔The Datasets tab is selected on the Settings
page that appears. In the right pane, select the arrow next to Scheduled refresh to expand that
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.24. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now