Power BI Tutorial For Beginners + Create Heatmap From Scratch + Free PBIX
Quiz by Nitin Gholap
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1What are the 3 busiest months for store number 3 based on the data presented in the video?January, February, NovemberMarch, April, MayJune, July, AugustSeptember, October, December30s
- Q2Which formula is used in the video to derive the day of the week from the date?DATEYEARWEEKDAYMONTH30s
- Q3What is the purpose of conditional formatting applied in the video?To change the font size of the tableTo hide certain rows and columnsTo highlight the highest and lowest values in the matrixTo add borders to the table30s
- Q4In the video, what is the name of the measure created to calculate the average quantity sold?Monthly SalesAverage QuantityDaily SalesTotal Quantity30s
- Q5Which of the following visualizations is NOT used in the final report created in the video?Horizontal Bar ChartPie ChartVertical Bar ChartMatrix30s
- Q6How does the slicer functionality work in Power BI according to the video?It changes the formatting of the entire reportIt adds additional data points to the visualizationsIt allows users to filter data based on a selected categoryIt removes unnecessary data points from the visualizations30s
- Q7What is the benefit of sorting the day of the week by day of the week number in the matrix visualization?To hide irrelevant data from the viewTo calculate the total sales for each day of the weekTo change the data type of the day of the week columnTo ensure the days are displayed in chronological order (Monday to Sunday)30s
- Q8In the video, how is the interaction between the charts modified to improve the report?By changing the color scheme of the chartsBy adding titles to each chartBy increasing the size of the chartsBy setting the interaction to filter instead of highlight30s
- Q9What alternative did the video suggest for swapping day and month with hours and weeks for analysis?A specific formula needs to be appliedAdditional data sources are requiredThe options are endless, all up to youThis functionality is not available in Power BI30s
- Q10What is the recommended way to change the overall color theme of the report in Power BI according to the video?By adding a slicer to filter the color schemeBy selecting a different theme from the View menuBy using conditional formatting to change the colorsBy manually editing the color of each chart element30s