
Asked in WNS
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!
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.
Interview Questions Asked to Power BI Developer at Other Companies
Top Skill-Based Questions for WNS Power BI Developer
SQL Interview Questions and Answers
250 Questions
Data Management Interview Questions and Answers
250 Questions
Networking Interview Questions and Answers
250 Questions
Data Visualization Interview Questions and Answers
100 Questions
Power BI Interview Questions and Answers
30 Questions
Stay ahead in your career. Get AmbitionBox app


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
AmbitionBox Awards
Get AmbitionBox app

