14-11-2025
1
14-11-2025
2
14-11-2025
3
14-11-2025
10
11
12
4
14-11-2025
13
14
15
5
14-11-2025
16
17
18
6
14-11-2025
19
20
21
7
14-11-2025
22
23
24
8
14-11-2025
25
26
27
9
14-11-2025
28
29
30
10
14-11-2025
31
32
Project
Situation: You have just been hired as Business Intelligence Analyst
by AdventureWorks, a global manufacturing company that
produces cycling equipment and accessories
Brief: Track KPIs (sales, revenue, profit, returns), compare regional
performance, analyze product-level trends, and identify high-value
customers
Objective: Use Power BI
33
11
14-11-2025
Leader in BI
platform
34
Why Power BI?
Connect, transform Connect, transform and load millions of rows of data
and load •Access data from virtually anywhere and create fully automated workflows to extract, transform and load data for analysis
Build relational models to blend data from multiple sources
Build •Create table relationship to analyze holistic performance across an entire relational data model
Define complex calculations using Data Analysis Expressions (DAX)
Define •Enhance datasets and enable advanced analytics with powerful and portable DAX expressions
Bring data to life with interactive reports and dashboards
Bring •Build professional quality reports and dashboards with best-in-class visualization tools
Develop a versatile, in-demand skill set
Develop •Power BI is the industry leader in self-reliance BI, and the skills you build will be highly transferrable
35
36
12
14-11-2025
From Etan T Langer (Analytics Manager)
Subject: Welcome abroad!
Hello and welcome to the team,
We are excited that you will be helping us develop our new
internal reports in Power BI. Looks like you have gotten
started, but we have some new data to add.
Assignment -1
Could you please create two new queries to connect to
the Product Category Lookup and product Subcategory
Lookup files attached and help with a few modifications to
the product table?
Thanks
-ETL
37
• Create queries to connect to two new csv
files
• Name your queries Product Category
Lookup and Product Subcategory Lookup
• Confirm that column headers have been
promoted and that all data types are
Key correct
Objectives • Add a new column to extract all characters
before the dash “-” in the Product SKU
column and name it “SKU Type”
• Replace zeros “0” in the Product Style with
“NA”
• Close and load to your model
38
From Etan T Langer (Analytics Manager)
Subject: Customer Domain!
Hi,
We are looking to better understand where our customers
may be coming from based on their email domains.
Assignment -2
Could you please create a new column in the customer
table that will allow us to do this?
Thanks
-ETL
39
13
14-11-2025
• Duplicate the email address column and
name it “Domain name”
• In the new column, remove all
text/characters except for the domain
Key name
Objectives • Use transformation steps to clean up
and capitalize the domain names (i.e.
“Adventure Works”)
• Save and apply changes
40
From Etan T Langer (Analytics Manager)
Subject: Need some stats for leadership !
Hi,
Leadership is asking us to validate some high-level stats
about our products and customers. Can you please help
me answer the following questions?
Assignment -3
We don’t really need to store these values anywhere, so
make sure to restore the tables back to their original state
once you are done pulling the stats.
Thanks
-ETL
41
• What is our average product costs?
• How many colors do we sell our
products in?
Key • How many distinct customers do we
have?
Objectives
• What is the maximum annual customer
income
• Return the table to its original state.
42
14
14-11-2025
From Etan T Langer (Analytics Manager)
Subject: New Date Field!
Hi,
We need to add few fields to our calendar table to help us
analyze sales trending over time
Assignment -4
Could you please add the following columns when you get
a chance?
Thanks
-ETL
43
• Month Name (e.g. “January”)
• Month Number (e.g. “1”)
Key • Start of the year (e.g. “1/1/2020”)
Objectives
• Year (e.g. “2020”)
44
Tableau: Challenge 1
Its end of the financial year and that means for annual bonuses!
The store operates in three regions and only top performing
employee in each region qualifies for a bonus
Find out which three employees are eligible to get a bonus for this
year
Employees are measure on total value of sales ($)
45
15