Scribd
Upload
42 views2 pages

PowerBi Questions

The document outlines a series of tasks related to data manipulation and visualization for sales analysis. Key tasks include merging tables, creating relationships, calculating various date-related fields, and generating charts and dashboards to represent sales data. The responsibilities are assigned to different individuals for efficient execution of the tasks.

Uploaded by

14 A Atharav warade
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
42 views2 pages

PowerBi Questions

The document outlines a series of tasks related to data manipulation and visualization for sales analysis. Key tasks include merging tables, creating relationships, calculating various date-related fields, and generating charts and dashboards to represent sales data. The responsibilities are assigned to different individuals for efficient execution of the tasks.

Uploaded by

14 A Atharav warade
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

I .

Append/Union of Fact Internet sales and Fact internet sales new - SALES
II. Merge Products, ProductCategory and ProductSubCategory Tables
Soundarya 0. Create Relationships between Tables

Sobodia
1. Lookup the Productname from the Product sheet to Sales sheet.
2. Lookup the Customerfullname from the Customer Table and Unit Price from Product
Table to Sales sheet.

Samiksha 3. Calcuate the following fields from the Orderdatekey field (First Create a Date Field from
Orderdatekey)
A. Year
B. Monthno
C. Monthfullname
D. Quarter(Q1,Q2,Q3,Q4)
E. YearMonth ( YYYY-MMM)
F. Weekday Number
G. Weekday Name
H. Financial Month (** Financial Year starts from April and ends at March - April : 1,
May : 2 ….. March : 12)
I. Financial Quarter
4. Calculate the Sales amount using the columns (Unit price, Order quantity, Unit
discount)

Shwetha 5. Calculate the Productioncost using the columns (Unit cost, Order quantity)
6. Calculate the Profit. (Sales - ProductionCost)
7. Create a Pivot table for month and sales (provide the Year as filter to select a particular
Year)

Rubeena 8. Create a Bar chart to show Yearwise Sales


9. Create a Line Chart to show Monthwise sales
10. Create a Pie chart to show Quarterwise sales

Atharav
11. Create a Combo chart (bar and Line) to show Salesamount and Productioncost
together
12. Build addtional KPI/Charts for Performance by Products, Customers, Region
13. Create one or more Dashboards based on the requirement

You might also like