Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
tzdq7
New Member

Power BI Developer Interview

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.

tzdq7_0-1730389879798.png

 

1 REPLY 1
lbendlin
Super User
Super User

Open new Power BI dashboard

Immediate red flag.  They can't even use the right terminology.

 

What guidance do you expect? 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors