Scribd
Upload
3 views2 pages

Power Bi Lab File Programs

The document outlines a series of tasks for data visualization and analysis using various datasets in Power BI. Tasks include creating bar charts, pie charts, line charts, and tree maps, as well as performing data cleaning and establishing relationships between datasets. Specific instructions are provided for visualizing sales data, revenue by product category, and costs by store ID, among other requirements.

Uploaded by

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

Power Bi Lab File Programs

The document outlines a series of tasks for data visualization and analysis using various datasets in Power BI. Tasks include creating bar charts, pie charts, line charts, and tree maps, as well as performing data cleaning and establishing relationships between datasets. Specific instructions are provided for visualizing sales data, revenue by product category, and costs by store ID, among other requirements.

Uploaded by

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

Programs for Lab File

1. Using the ny_property_sales.csv dataset, create both a vertical and horizontal bar chart
showing the sum of sales price by area. (Replace any null or incorrect values in the sale
price column if required.)
2. Using the sales2017_raw.csv dataset, perform data cleaning by removing blank rows,
choosing relevant columns, and correcting data types using Power Query Editor.
Apply “Replace Values” to fix missing or incorrect entries, and rename columns for clarity.
3. Using the [Link], product_hierarchy.csv, and sales_2017.csv datasets, build a
relationship model in Power BI. Create a visualization showing the sum of revenue by
product category, using the established relationships. Identify and note which product
category has the highest total revenue.
4. Using the relationship model created in Question 3, create a Pie Chart showing the sum of
revenue by state. Ensure the chart displays percentage values for each state and includes a
legend for clear identification.
5. Create a line chart using the appropriate date hierarchy to visualize the sum of revenue
over time. Use drill down mode to create separate views for sum of revenue by Year,
Quarter, Month, and Day. (Use the appropriate data sets and relationships).
6. Create a table visual showing Order Date, Revenue, and Number of Orders from the sales
data. Apply custom styles and colors for clarity and presentation.
Use conditional formatting with icons to highlight revenue in three ranges (Revenue >=0
and < 50%, another for revenue >=50% and < 80%, and revenue ≥ 80% and <= 100 %.)
7. Create a horizontal stacked bar chart showing the total cost for each Store ID, with the
costs categorized by Building Cost, Land and Development Cost, and Other Related Cost.
Use the data set [Link]. (Hint: Unpivot the three cost columns before
visualization).
8. Using the [Link] dataset, create a slicer visual that filters the sum of costs for stores
by implementing a hierarchy with Store City as the top level and Store ID as the second
level. Use this slicer to filter the horizontal bar depicting sum of total costs vs Store Id.
9. Create a tree map visualization displaying the sum of revenue by product category. For
each category, further break down the revenue by state within the tree map. (Hint: In the
visual’s details section, add State from the Cities dataset to achieve this hierarchy.) Use the
Product Hierarchy, Sales, and Cities datasets.
10. Create a bar chart showing the sum of revenue by weekdays (Hint: Use the Sales dataset to
create a separate Date Dimension table by referencing it, delete all columns except the
order_date and remove duplicate dates. Finally , use the “Column from Examples” feature
to create a separate column weekday_names.)

You might also like