Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
you can create the relationship?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
Query Editor?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
Which DAX expression should you use?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
reporting requirements of the regional managers. What should you do?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
How should you create the visualization? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.


Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made
toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference:
[https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi](https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi)
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
What should you include in the solution?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
department.
What should you create?
Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.


Quiz
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text
files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format
of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table
have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales
data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
• Executives require a visual that shows sales by region.
• Regional managers require a visual to analyze weekly sales and returns.
• Sales managers must be able to see the sales data of their respective region only.
• The sales managers require a visual to analyze sales performance versus sales targets.
• The sale department requires reports that contain the number of sales transactions.
• Users must be able to see the month in reports as shown in the following example: Feb 2020.
• The customer service department requires a visual that can be filtered by both sales month and
ship month independently.
connection'
Microsoft Power BI Data Analyst Practice test unlocks all online simulator questions
Thank you for choosing the free version of the Microsoft Power BI Data Analyst practice test! Further deepen your knowledge on Microsoft Simulator; by unlocking the full version of our Microsoft Power BI Data Analyst Simulator you will be able to take tests with over 463 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 463 questions.
BUY NOWWhat to expect from our Microsoft Power BI Data Analyst practice tests and how to prepare for any exam?
The Microsoft Power BI Data Analyst Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Microsoft Power BI Data Analyst exam. The Microsoft Power BI Data Analyst practice tests consist of 463 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Microsoft Power BI Data Analyst database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Microsoft Power BI Data Analyst Simulator will also give you an idea of the time it will take to complete each section of the Microsoft Power BI Data Analyst practice test . It is important to note that the Microsoft Power BI Data Analyst Simulator does not replace the classic Microsoft Power BI Data Analyst study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Microsoft Power BI Data Analyst exam.
BUY NOWMicrosoft Power BI Data Analyst Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Microsoft Power BI Data Analyst Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Microsoft Power BI Data Analyst Simulator and how our unique Microsoft Power BI Data Analyst Database made up of real questions:
Info quiz:
- Quiz name:Microsoft Power BI Data Analyst
- Total number of questions:463
- Number of questions for the test:50
- Pass score:80%
You can prepare for the Microsoft Power BI Data Analyst exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Microsoft Power BI Data Analyst Simulator.
Use our Mobile App, available for both Android and iOS devices, with our Microsoft Power BI Data Analyst Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.
Our Mobile App contains all Microsoft Power BI Data Analyst practice tests which consist of 463 questions and also provide study material to pass the final Microsoft Power BI Data Analyst exam with guaranteed success. Our Microsoft Power BI Data Analyst database contain hundreds of questions and Microsoft Tests related to Microsoft Power BI Data Analyst Exam. This way you can practice anywhere you want, even offline without the internet.
BUY NOW