Exam (elaborations)
DA-100 Power BI Exam Study Guide | 400+ Questions with 100% Correct Answers |Verified
- Course
- Institution
DA-100 Power BI Exam Study Guide | 400+ Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA-100 Power BI Exam Study Guide | 400+Questions with 100% Correct Answers |Verified
Business Analyst - ✔✔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. Often, the roles of data analyst and business analyst could be the responsibility of
a single person.
Data Analyst - ✔✔(Prepare, Model, Visualize, Analyze, Manage)
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. A data analyst works with the pertinent stakeholders to identify
appropriate and necessary data and reporting requirements, and then they are tasked with
turning raw data into relevant and meaningful insights.
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.
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.
Data Engineer - ✔✔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.
Data engineers collaborate with business stakeholders to identify and meet data requirements.
They design and implement solutions.
While some alignment might exist in the tasks and responsibilities of a data engineer and a
database administrator, a data engineer's scope of work goes well beyond looking after a
database and the server where it's hosted and likely doesn't include the overall operational
data management.
A data engineer adds tremendous value to business intelligence and data science projects.
When the data engineer brings data together, often described as data wrangling, projects move
faster because data scientists can focus on their own areas of work.
Data Scientist - ✔✔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.
Descriptive and predictive analytics are only partial aspects of data scientists' work. Some data
scientists might work in the realm of deep learning, performing iterative experiments to solve a
complex data problem by using customized algorithms.
A data scientist looks at data to determine the questions that need answers and will often
devise a hypothesis or an experiment and then turn to the data analyst to assist with the data
visualization and reporting.
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.
The role of a database administrator is different from the role of a data engineer. A database
administrator monitors and manages the overall health of a database and the hardware that it
,resides on, whereas a data engineer is involved in the process of data wrangling, in other
words, ingesting, transforming, validating, and cleaning data to meet business needs and
requirements.
The database administrator is also responsible for managing the overall security of the data,
granting and restricting user access and privileges to the data as determined by business needs
and requirements.
Common Flow of Activity in Power BI - ✔✔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.
Building Blocks in Power BI - ✔✔1. Visualizations -- visual representation of data, like a chart,
or color-coded map
2. Datasets -- collection of data that PBI uses to create its visualizations
3. Reports -- collection of visualizations that appear together on one or more pages. Can create
in PBI desktop or PBI service
4. Dashboards -- A single page from a report; a collection of visuals from a single page / canvas
5. Tiles -- a single visualization (the rectangular box that holds the visual). When creating a
report you can change the size and position of the tiles but when viewing or consuming you
can't move them but can interact with it
What is Power BI? - ✔✔Power BI is a collection of services, apps, and connectors that lets
you connect to your data, wherever it happens to reside, filter it if necessary, and then bring it
into Power BI to create compelling visualizations that you can share with others.
What are the three elements of Power BI? - ✔✔Power BI Desktop
Power BI Service
Power BI Mobile
, Power BI Service - ✔✔
Power BI Apps - ✔✔An app is a collection of preset, ready-made visuals and reports that are
shared with an entire organization.
1. Go to Power BI Service
2. Select Get Data (lower left corner) --> can use data from different SaaS providers e.g.
Salesforce, Facebook, Google Analytics
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.
What is included when an app is created in Power BI Service? - ✔✔Ex: Get Data --> Service --
> GitHub
In addition to the app dashboard, the report that was generated (as part of the GitHub app) and
used to create the dashboard is available, as is the dataset (the collection of data pulled from
GitHub) that was created during data import and used to create the GitHub report.
(Dashboard, report, and dataset)
How to update data in Power BI service? - ✔✔Can refresh on the dataset directly
Can schedule a refresh under the settings tab
PowerQuery - ✔✔query engine used by Power BI and Excel
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.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now