Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I recently attended a Power BI Developer Interview at one of the top consulting firm and cleared all the interview rounds and they wanted me to finish this test live in 20 minutes which I did. But they still rejected me saying they expected more in the front end and back end. Please guide me:
Import data
1. Open new Power BI dashboard and import source tables from ‘PBI Test Source Tables.xlsx’ into
Power BI via Power Query Editor. Make any necessary changes to tables.
2. In Power Query, make a new column that will identify the last month in the calendar and adds a
label “Current”, and the month before labeled “Prior”. Then all other months use the field
‘Month’. Name the new field “Month Select”
Set up Data Model
3. Define the fact tables and dimension tables
Open Response: Fact tables:
Dimension tables:
4. Connect all dimension tables to fact tables
Open Response: What keys did you use and explain why you selected the relationship
you did?
5. Calculate the net sales $ and net sales quantity
Create visuals
6. Create a dashboard with 4 visuals that shows you a breakdown of net sales $. The 4 visuals are:
a. Top left, Stacked bar of net sales by store stacked by category
b. Top right, trend chart of net sales by date
c. Bottom left, treemap of net sales breaking down key elements of the product in the best
way possible
d. Bottom right, table of all useful data at lowest level of granularity as well as net sales
7. Add a button to toggle between Net Sales $ and Net Sales Qty (label buttons $ and Qty) and
replace the net sales $ measure with this dynamic measure in the 4 visuals.
8. Add slicer on “Month Select” to only show current month in all visuals except for trend
9. Add relevant dimension fields to filter pane. Clean up filter pane so it just shows filters on all
pages. Color background of filter pane to be light blue.
Open new Power BI dashboard
Immediate red flag. They can't even use the right terminology.
What guidance do you expect?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.