Page 513 - Computer Software Application TP - Volume 1
P. 513
COMPUTER SOFTWARE APPLICATION - CITS
TASKS :
1 Load the “Sales Data” into Power Query.
2 Combine this table with a reference table containing information about each product, such as the “ProductID”
and “ProductCategory.” Assume this reference table is named “ProductInfo.”
3 Aggregate the combined data to calculate the total revenue for each product category.
4 Create a new column in the final table named “AverageRevenuePerUnit” that calculates the average revenue
per unit sold for each product category.
You have a “Monthly Sales” table containing information about sales data over several months. Your task is to
perform time series analysis to understand the trends in monthly sales.
Date Sales Amount
2022-01-01 10000
2022-02-01 12000
2022-03-01 15000
TASKS :
1 Load the “Monthly Sales” into Power Query.
2 Create a new column named “Month” that extracts the month and year from the “Date” column.
3 Calculate the month-to-month percentage change in sales and add it as a new column.
4 Identify any months with significant increases or decreases in sales.
498
CITS : IT & ITES - Computer Software Application - Exercise 76
