Create following measures using sample excel dataset Measures you need to create : QC% = QC Vol./Received Vol. Internal Error% = Internal Error/QC Vol. Internal Accuracy % = 1-SUM(Internal Error/QC Vol.) External Error % = External Error/Received Vol. External Accuracy % = 1-SUM(External Error/Received Vol.) Questions based on Excel with Dataset Sheets (RLS, Downtime, AFKLM, Finnair) 1) Create drop down for month and process 2) Create Card for QC% Internal Error %, Internal Error Accuracy and Downtime 3) Create Bar Chart for process wise and further drill down by sub process wise volumes a) (forecast and received) b) (QC vol. and internal Error) c) (QC%, Internal Error % and External Error %) 4) Create table for process wise monthly downtime 5) Create row level security as per mentioned in RLS excel sheet RLS Sheet Table : Name Process Email id Prashant AFKLM ***** Nachiket Finnair ***** Downtime Sheet Table : Year Month Date Type of Downtime Process Type Downtime 2023 Jan-23 01-Jan-23 Network Downtime Finnair Network 00:00:00 2023 Jan-23 08-Jan-23 Network Downtime AFKLM Novus 08:45:00 AFKLM Sheet Table : Year Month Process Sub-Process Forecast Vol. Received Vol. QC Vol. Internal Error External Error 2024 Jan-24 AFKLM Stage#1 12835 12735 2910 6 0 2025 May-25 AFKLM Stage#15 XXXXX71 0 0 Finnair Sheet Table : Year Month Process Sub-Process Forecast Vol. Received Vol. QC Vol. Internal Error External Error 2024 Mar-24 Finnair Stage#3 1850 1499 1344 0 0 2025 Apr-25 Finnair Stage#1 5850 5035 402 4 0 This 1 Excel Sheet will be given to you & asked you to create a Dashboard. ALL THE BEST!!!

AnswerBot
2mo

Create a Power BI dashboard using measures and data from an Excel dataset to visualize QC and error metrics.

  • Measures Creation: Calculate QC%, Internal Error%, and External Error% using DAX formulas ba...read more

Help your peers!
Select
Add answer anonymously...

Top Power BI Developer Interview Questions Asked at WNS

Q. What is the difference between a Power BI Report and a Power BI App?
Q. Are you willing to relocate?
Q. Define schema for Power BI.
Power BI Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+

Reviews

10L+

Interviews

4 Cr+

Salaries

1.5 Cr+

Users

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits