top of page

Power BI Basic Practice Examples | Realcode4you

Day-1

1. What are the various versions of Power BI?


Day-2

2. Drag the Country from the region_data then in the report view and mention the name of the visual in the text box and add the labels in the visual.


Day-3 

3.  Create a basic map visual on the report page using the Global superstore and Use the region column in the slicer visual to get interacted with the map visual.

 

Day-4

4. Create a basic scatter plot using sales and Profit information and represent it (refer to region column), which helps identify the highest green color and lowest sales red color.


Day-5

 

5.  Create a line and clustered chart and compare this year vs last year's sales along with growth % ?

 

Day-6


6.  Import data from 2023 Worldwide Box Office - Box Office Mojo and add the past 3 years of data in the Power Query editor, create a master table of the past 3 years of data, and load only master data in the power bi query editor or power bi desktop?


7.  Delete unwanted columns, replace, or remove the error value in the master table and format the data and represent the column quality.


Day-7

8.  Add all 3 tables from the model and create a table to show the detailed information for each day wise the sum of order quantity, shipped quantity, and delivered quantity. Kindly use a card visual to show the difference between the total order quantity and the shipped quantity,the 2nd difference between total order quantity and delivered quantity, using quick measure.

9.  If there is a difficulty with tables having many-to-many relationships. Create an intermediate table (also known as a bridge table) to handle many-to-many relationship issues.

 

Day-8

10.  Refer to question no. 6! After importing all the 3 years of the data, kindly add the custom column of specific year data for e.g. (if you have imported the data for the year 2023, please create a new column called year and add 2023 for each row).

 

Day-9

 Refer to Global superstore data.

11.  Create a map visual and use the drill down to show detailed information for each country by state. (For detailed information you can use the region slicer).

 

Day-10

Refer to Financials sample data.

12. Create a clustered column chart referring to the order date and sales, then apply bookmarks based on date  year, quarter, and month.



13. Create a country overview page and add another page that contains detailed information about the country with drill through options.

 

14. Add the reset image in which all the filters should get removed and the report page should be default in the country information page.


Day-11

15. Create a new summarize table with selected columns (region, country, sum of sales) from the global superstore and filter the region based on the given conditions, Central Asia, North, South & East.

 

Day-12

16. Create a week column based on the order date from the global superstore data.e.g. required output “Week-5”


Day-13

17. Create a table visual to show the current month's sales vs last month's sales.


Day-14

18. Insert the scroller custom visual and add it to the report page referring to the country and profit column.

 

Day-15

19. Create a shared workspace and add the organization members to the workspace then publish the report.



If you need solution of above power bi task then you can hire our experts. We are group of top rated power bi experts and professionals that will help you to do your project with reasonable price.



Comments


bottom of page