JACKLINE
DA-100 With 100% COMPREHENSIVE QUESTIONS AND ANSWERS GRADED A+
Terms in this set (141)
DA-100
1/113
,10/30/24, 3:09 PM
1 A
Case Study 1 - Litware, Inc.
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.
2/113
,10/30/24, 3:09 PM
sales performance versus sales
targets.
contain the number of sales
transactions.
as shown in the following
visual that can be filtered by both
sales month and ship month independently.
creating the data model.
number filter.
sales_amount column.
DA-100
3/113
, 10/30/24, 3:09 PM
2 A
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses
Microsoft Power Bl dashboards and reports. The
company plans to Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able
leverage data from Microsoft SQL Server to see the
databases, Microsoft Excel files, text files, and month in reports as shown in the following example: Feb 2020.
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
4/113
DA-100 With 100% COMPREHENSIVE QUESTIONS AND ANSWERS GRADED A+
Terms in this set (141)
DA-100
1/113
,10/30/24, 3:09 PM
1 A
Case Study 1 - Litware, Inc.
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.
2/113
,10/30/24, 3:09 PM
sales performance versus sales
targets.
contain the number of sales
transactions.
as shown in the following
visual that can be filtered by both
sales month and ship month independently.
creating the data model.
number filter.
sales_amount column.
DA-100
3/113
, 10/30/24, 3:09 PM
2 A
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses
Microsoft Power Bl dashboards and reports. The
company plans to Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able
leverage data from Microsoft SQL Server to see the
databases, Microsoft Excel files, text files, and month in reports as shown in the following example: Feb 2020.
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
4/113
