Data Analysis

Question 1

Help answer questions about what has happened based on historical data

Answer 1

Descriptive Analytics

Question 2

Summarize large datasets to describe outcomes to stakeholders

Answer 2

Descriptive Analytics

Question 3

By developing key performance indicators (KPIs), these strategies can help track the success or failure of key objectives.

Answer 3

Descriptive Analytics

Question 4

Generate reports to provide a view of an organization’s sales and financial data.

Answer 4

Descriptive Analytics

Question 5

Identify anomalies in the data.

Answer 5

Diagnostic Analytics

Question 6

Answer questions about why events happened.

Answer 6

Diagnostic Analytics

Question 7

Supplement basic descriptive analytics, and they use the findings from descriptive analytics to discover the cause of these events.

Answer 7

Diagnostic Analytics

Question 8

Collect data that’s related to these anomalies.

Answer 8

Diagnostic Analytics

Question 9

Use statistical techniques to discover relationships and trends that explain these anomalies.

Answer 9

Diagnostic Analytics

Question 10

Help answer questions about what will happen in the future.

Answer 10

Predictive Analytics

Question 11

Use historical data to identify trends and determine if they’re likely to recur.

Answer 11

Predictive Analytics

Question 12

Help answer questions about which actions should be taken to achieve a goal or target.

Answer 12

Prescriptive Analytics

Question 13

Use insights from predictive analytics, organizations can make data-driven decisions.

Answer 13

Prescriptive Analytics

Question 14

Rely on machine learning strategies to find patterns in large datasets.

Answer 14

Prescriptive Analytics

Question 15

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.

Answer 15

Cognitive Analytics

Question 16

Help you learn what might happen if circumstances change and determine how you might handle these situations.

Answer 16

Cognitive Analytics

Question 17

Closer to the business and is a specialist in interpreting the data that comes from the visualization.

Answer 17

Business Analyst

Question 18

Enable businesses to maximize the value of their data assets through visualization and reporting tools such as Microsoft Power BI.

Answer 18

Data Analyst

Question 19

Responsible for profiling, cleaning, and transforming data.

Answer 19

Data Analyst

Question 20

Design and build scalable and effective data models, and enabling and implementing the advanced analytics capabilities into reports for analysis.

Answer 20

Data Analyst

Question 21

Turn raw data into relevant and meaningful insights.

Answer 21

Data Analyst

Question 22

Responsible for the management of Power BI assets, including reports, dashboards, workspaces, and the underlying datasets that are used in the reports.

Answer 22

Data Analyst

Question 23

Implement and configure proper security procedures, in conjunction with stakeholder requirements, to ensure the safekeeping of all Power BI assets and their data.

Answer 23

Data Analyst

Question 24

Work with data engineers to determine and locate appropriate data sources that meet stakeholder requirements.

Answer 24

Data Analyst

Question 25

Works with the data engineer to identify new processes or improve existing processes for collecting data for analysis.

Answer 25

Data Analyst

Question 26

Provision and set up data platform technologies that are on-premises and in the cloud.

Answer 26

Data Engineer

Question 27

Manage and secure the flow of structured and unstructured data from multiple sources.

Answer 27

Data Engineer

Question 28

Ensure that data services securely and seamlessly integrate across data services.

Answer 28

Data Engineer

Question 29

Use of on-premises and cloud data services and tools to ingest, egress, and transform data from multiple sources.

Answer 29

Data Engineer

Question 30

Collaborate with business stakeholders to identify and meet data requirements. They design and implement solutions.

Answer 30

Data Engineer

Question 31

Perform advanced analytics to extract value from data.

Answer 31

Data Scientist

Question 32

Might work in the realm of deep learning, performing iterative experiments to solve a complex data problem by using customized algorithms.

Answer 32

Data Scientist

Question 33

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.

Answer 33

Database administrator

Question 34

Responsible for the overall availability and consistent performance and optimizations of the database solutions.

Answer 34

Database administrator

Question 35

Monitors and manages the overall health of a database and the hardware that it resides on

Answer 35

Database administrator

Question 36

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.

Answer 36

Database administrator

Question 37

Process of profiling, cleaning, and transforming your data to get it ready to model and visualize.

Answer 37

Data Preparation

Question 38

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.

Answer 38

Data Preparation

Question 39

Understanding how you're going to get and connect to the data and the performance implications of the decisions.

Answer 39

Data Preparation

Question 40

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.

Answer 40

Data Modeling

Question 41

Prepare, Model, Visualize, Analyze and Manage

Answer 41

Data Analyst Tasks

Question 42

Has a direct effect on the performance of your report and overall data analysis.

Answer 42

Data Modeling

Question 43

Bring your data to life

Answer 43

Data Visualization

Question 44

Goal is to solve business problems.

Answer 44

Data Visualization

Question 45

Reports should be designed with accessibility in mind from the outset so that no special modifications are needed in the future.

Answer 45

Data Visualization

Question 46

Understanding and interpreting the information that is displayed on the report.

Answer 46

Data Analyzation

Question 47

Organizations can drill into the data to predict future patterns and trends, identify activities and behaviors, and enable businesses to ask the appropriate questions about their data.

Answer 47

Advanced Analytics

Question 48

AI integrations within Power BI can take your analysis to the next level. Integrations with Azure machine learning, cognitive services, and built-in AI visuals will help to enrich your data and analysis.

Answer 48

Data Analyzation

Question 49

Help reduce data silos within your organization.

Answer 49

Manage Data

Question 50

Reduce data silos with the use of shared datasets, and it allows you to reuse data that you have prepared and modeled.

Answer 50

Manage Data

Question 51

Microsoft Windows desktop application called Power BI Desktop

Answer 51

Power BI

Question 52

Online SaaS (Software as a Service) service called the Power BI service

Answer 52

Power BI

Question 53

Mobile Power BI apps that are available on any device, with native mobile BI apps for Windows, iOS, and Android.

Answer 53

Power BI

Question 54

Visualizations, Datasets, Reports, Dashboards, and Tiles

Answer 54

Power BI Building Blocks

Question 55

Visual representation of data, like a chart, a color-coded map, or other interesting things you can create to represent your data visually.

Answer 55

Visualizations

Question 56

Collection of data that Power BI uses to create its visualizations.

Answer 56

Datasets

Question 57

Combination of many different sources, which you can filter and combine to provide a unique collection of data for use in Power BI.

Answer 57

Datasets

Question 58

Collection of visualizations that appear together on one or more pages.

Answer 58

Reports

Question 59

Let you create many visualizations, on multiple pages if necessary, and let you arrange those visualizations in whatever way best tells your story.

Answer 59

Reports

Question 60

Single visualization on a report or a dashboard.

Answer 60

Tile

Question 61

Collection of preset, ready-made visuals and reports that are shared with an entire organization.

Answer 61

App

Question 62

Shows you the available sources of data in the Power BI service.

Answer 62

Canvas

Question 63

Identify each unique, non-null data row.

Answer 63

Primary Keys

Question 64

Reference rows in a different table

Answer 64

Foreign Keys

Question 65

Contain observational or event data values: sales orders, product counts, prices, transactional dates and times, and quantities.

Answer 65

Fact Tables

Question 66

Contain the details about the data in fact tables: products, locations, employees, and order types.

Answer 66

Dimension Tables

Question 67

Edit the name and description of the column.

Answer 67

Model - General Tab

Question 68

Add synonyms that can be used to identify the column when you are using the Q&A feature.

Answer 68

Model - General Tab

Question 69

Add a column into a folder to further organize the table structure.

Answer 69

Model - General Tab

Question 70

Hide or show the column.

Answer 70

Model - General Tab

Question 71

Change the data type.

Answer 71

Model - Formatting Tab

Question 72

Format the date.

Answer 72

Model - Formatting Tab

Question 73

Sort by a specific column.

Answer 73

Model - Advanced Tab

Question 74

Assign a specific category to the data.

Answer 74

Model - Advanced Tab

Question 75

Summarize the data.

Answer 75

Model - Advanced Tab

Question 76

Determine if the column or table contains null values.

Answer 76

Model - Advanced Tab

Question 77

Source data tables are mature and ready for immediate use. Identify company holidays. Separate calendar and fiscal year. Identify weekends versus weekdays.

Answer 77

Source Data Date Table

Question 78

Dates = CALENDAR(DATE(2011, 5, 31), DATE(2021, 5, 31))

Answer 78

DAX Date Table

Question 79

The CALENDAR() function returns a contiguous range of dates based on a start and end date that are entered as arguments in the function.

Answer 79

DAX Date Table

Question 80

The CALENDARAUTO() function returns a contiguous, complete range of dates that are automatically determined from your dataset.

Answer 80

DAX Date Table

Question 81

MonthNum = MONTH(Dates[Date])

Answer 81

DAX Date Table

Question 82

WeekNum = WEEKNUM(Dates[Date])

Answer 82

DAX Date Table

Question 83

DayoftheWeek = FORMAT(Dates[Date].[Day], "DDDD")

Answer 83

DAX Date Table

Question 84

Use M-language, the development language that is used to build queries in Power Query.

Answer 84

Power Query Date Table

Question 85

Form through natural segments in your data.

Answer 85

Hierarchies

Question 86

The process of viewing multiple child levels based on a top-level parent.

Answer 86

Flatten the hierarchy

Question 87

Create multiple columns in a table to show the hierarchical path of the parent to the child in the same record.

Answer 87

Flatten the hierarchy

Question 88

Path() returns a text version of the hierarchical path which can be split into multiple columns and turned into a hierarchy

Answer 88

Flatten the hierarchy

Question 89

Have multiple valid relationships with fact tables, meaning that the same dimension can be used to filter multiple columns or tables of data. As a result, you can filter data differently depending on what information you need to retrieve.

Answer 89

Role-playing dimensions

Question 90

Requires complex DAX functions.

Answer 90

Role-playing dimensions

Question 91

Detail represented within your data

Answer 91

Data Granularity

Question 92

Describes a relationship in which you have many instances of a value in one column that are related to only one unique corresponding instance in another column.

Answer 92

Many-to-one or one-to-many cardinality

Question 93

Describes the directionality between fact and dimension tables.

Answer 93

Many-to-one or one-to-many cardinality

Question 94

Is the most common type of directionality and is the Power BI default when you are automatically creating relationships.

Answer 94

Many-to-one or one-to-many cardinality

Question 95

Describes a relationship in which only one instance of a value is common between two tables.

Answer 95

One-to-one cardinality

Question 96

Requires unique values in both tables.

Answer 96

One-to-one cardinality

Question 97

Is not recommended because this relationship stores redundant information and suggests that the model is not designed correctly. It is better practice to combine the tables.

Answer 97

One-to-one cardinality

Question 98

Describes a relationship where many values are in common between two tables.

Answer 98

Many-to-many cardinality

Question 99

Does not require unique values in either table in a relationship.

Answer 99

Many-to-many cardinality

Question 100

Is not recommended; a lack of unique values introduces ambiguity and your users might not know which column of values is referring to what.

Answer 100

Many-to-many cardinality

Question 101

Only one table in a relationship can be used to filter the data. For instance, Table 1 can be filtered by Table 2, but Table 2 cannot be filtered by Table 1.

Answer 101

Single cross-filter direction

Question 102

For a one-to-many or many-to-one relationship, the cross-filter direction will be from the "one" side, meaning that the filtering will occur in the table that has unique values.

Answer 102

Single cross-filter direction

Question 103

One table in a relationship can be used to filter the other. For instance, a dimension table can be filtered through the fact table, and the fact tables can be filtered through the dimension table.

Answer 103

Bi-direction Cross Filter

Question 104

You might have lower performance when using bi-directional cross-filtering with many-to-many relationships.

Answer 104

Bi-direction Cross Filter

Question 105

One-to-one relationships filter option.

Answer 105

Bi-direction Cross Filter

Question 106

Many-to-many relationships filter options

Answer 106

Bi-direction Cross Filter; Single cross-filter direction