Search Adaface test library by skills or roles
⌘ K

The BI Developer Test is preferred by recruiters to assess on-the-job skills of candidates before an interview. It reduces technical screening time by 80% by enabling employers to identify qualified candidates.

Covered Skills:

  • Power Pivot
  • Power Query
  • Power Map
  • Data source connectors
  • Import to Power BI
  • Loading data
  • DAX
  • Power BI Conditional Column
  • Template files
  • Dashboard sharing
  • Direct Query
  • See full list

Adaface BI Developer Test is trusted by enterprises worldwide

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

Sample Adaface BI Developer Test Questions

These are just a small sample from our library of 10,000+ questions. The actual questions on this BI Developer Test will be non-googleable.

🧐 Question🔧 Skill💪 Difficulty⌛ Time
Change display icon
What steps would you take to change the following view so that Office Supplies is represented by a different symbol?
 image
A: Click on shapes in the marks area. Then select Office Supplies and the icon of choice and click okay.
B: Right-click on product category, select default properties, and select shape. Then select Office Supplies and the icon of choice and click okay.
C: Right click on the square and select "change shape" from the popup menu. Select the icon of choice and click okay.
D: A, B or C
E: None of these would work

Options:

  • A
  • B
  • C
  • D
  • E
TableauEasy2 min
CSV load data
Consider the following file:
 image
The file might have incomplete data stored with ! or ?. Which of the following R snippets will load the file completely?
 image

Options:

  • A
  • B
  • C
  • D
REasy2 min
Dataframe Transform
Review the following Dataframe 'bazinga':
 image
Which of the following commands would turn it into the Dataframe shown below:
 image
 image

Options:

  • A B C
  • A
  • B
  • C
  • A B
  • B C
  • A C
RMedium3 min
Multi Select
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Options:

  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
SQLMedium2 min
Netflix Fav Movie
We are building a Netflix clone where users can stream movies. Our service tracks and logs usage for each user. Each log contains the name of the movie, length of the movie (in minutes) and number of minutes of the movie watched by the user. Can you help with some data analysis?
Our code needs to return the Favorite movie: the name of the movie with the highest percentage of movie watched by the user. If a user watched 30mins out of 60mins for movie1 (50%) and 75min out of 100min of movie2 (75%), the movie with the highest percentage of movie watched by the user is movie2 (Assume that the values are such that there can never be a tie for this spot).
    CodingMedium40 min
    DAX
    We want to create a DAX formula in Power BI that automatically calculates the previous month number. If month is May, the formula would return 4. We have already created the DAX formula: 
    
    Today Month = MONTH (Sales[Todays Date])
    
    Which of the DAX formulas below would be the right choice next?
    
    A: Previous Month = Sales[Today Month]-1
    B: Previous Month = PREVIOUSMONTH(Sales[Today Month])
    C: Previous Month = STARTOFMONTH(Sales[Today Month])-1
    D: Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) (correct)

    Options:

    • A
    • B
    • C
    • D
    Power BIEasy3 min
    ZeroDivisionError and IndexError
    What will the following Python code output?
    
     image

    Options:

    • B C D E
    • B C E
    • C D E
    • C E
    • C
    • A D
    • A D E
    • A E
    Exceptions
    PythonMedium2 min
    Session
     image
    The function high_sess should compute the highest number of events per session of each user in the database by reading a comma-separated value input file of session data. The result should be returned from the function as a dictionary. The first column of each line in the input file is expected to contain the user’s name represented as a string. The second column is expected to contain an integer representing the events in a session. Here is an example input file:
    
    Tony,10
    Stark,12
    Black,25
    Your program should ignore a non-conforming line like this one.
    Stark,3
    Widow,6
    Widow,14
    The resulting return value for this file should be the following dictionary: { 'Stark':12, 'Black':25, 'Tony':10, 'Widow':14 }
    
    What should replace the CODE TO FILL line to complete the function?
    
     image

    Options:

    • OPTION 1
    • OPTION 2
    • OPTION 3
    • OPTION 4
    File Handling Dictionary
    PythonHard2 min
    Max Code
    Below are code lines to create a Python function. Ignoring indentation, what lines should be used and in what order for the following function to be complete:
    
     image

    Options:

    • 2, 8, 4, 5, 6
    • 2, 3, 7, 5, 6
    • 3, 2, 7, 5, 9
    • 3, 2, 4, 5, 9
    • 2, 3, 4, 1, 6
    • 2, 3, 7, 1, 6
    Arrays
    PythonEasy2 min
    Select & IN
    Consider the following SQL table:
    
     image
    Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
    
     image

    Options:

    • A
    • B
    • C
    • D
    • E
    SQLEasy3 min
    With, AVG & SUM
    Consider the following SQL table:
    
     image
    How many tuples does the following query return?
    
     image

    Options:

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    SQLMedium2 min

    How to use the Adaface BI Developer Test

    Start screening candidates within minutes with the ready-to-go BI Developer Test

    1. Choose the most appropriate test for your role

    2. Start inviting candidates to complete the assessment

    3. Receive real time notifications and shortlist the best candidates

    OR Customize the Adaface BI Developer Test according to your job description

    1. Get a custom assessment from our library of 500+ skills within 48 hours

    2. Start inviting candidates to complete the assesment

    3. Receive real time notifications and shortlist the best candidates

    About the Adaface BI Developer Test

    Topics:

    Power Pivot enables you to import millions of rows from heterogeneous sources of data into a single Excel sheet.

    Power Pivot

    Power Query helps in finding, editing and loading external data.

    Power Query

    Power Map is an Excel add-in that provides a powerful set of tools to help us visualize and gain insight into large sets of data that have a geo-coded component.

    Power Map
    Data source connectors
    Import to Power BI
    Loading data

    To do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX).

    DAX
    Power BI Conditional Column
    Template files
    Dashboard sharing
    Direct Query
    Visualising data

    Slicers in Power BI are the simple forms of filters that play a key role in designing customized charts and reports on the Power BI Desktop.

    Slicers
    Bookmarks
    Dates

    Content packs for services are pre-built solutions for popular services.

    Content packs
    Data View
    Data Integration
    File Optimization

    Power Desktop is an aggregated tool of Power Query, Power View, and Power Pivot.

    Power BI Desktop
    Data sources
    Data connectors
    Data types
    Marks
    Extracts
    Sort & Filters
    Actions
    Drill
    Aggregations
    Tableau Desktop
    Layouts
    Formatting
    Distribution & Publishing
    Charts & graphs
    Dashboards
    Formatting
    Custom fields and calculations
    Tableau Server
    Dimensions and measures
    Calculations & LOD
    Parameters and Legends
    Analytics with R & tools
    Introduction to Statistics
    Data Manipulation using R
    Machine Learning Techniques using R
    Exploratory Data Analysis
    Regression Analysis
    Data Science Basics
    String Manipulation
    Vector
    Matrix
    Dataframe
    CSV
    Rmarkdown
    linear regression

    A confusion matrix can be used to evaluate the accuracy of the model built.

    confusion matrix
    Random Forest
    Analytics with R & tools
    package
    R6 Class
    shinyR

    The apply function allows one to make entry-by-entry changes to data frames and matrices.

    apply function
    Clustering
    kmeans clustering
    hierarchical clustering

    Rattle is a popular GUI for data mining using R.

    rattle
    White Noise model

    Principal Component Analysis is a method for dimensionality reduction.

    Principal Component Analysis

    initialize() function is used to initialize the private data members while declaring the object.

    initialize()
    evaluate_model()
    Predictive Mean Matching
    preloaded datasets
    next
    custom function
    by()
    factor variable
    Radix
    R decision tree
    Data import
    Strings and Numbers
    String Formatting
    Lists, Dictionaries, Tuples, and Sets
    Collections
    Functions and lambdas
    Decorators
    Scope
    args/kwargs and default parameter values
    The concept of mutability
    Built-in Functions
    Debugging and Error Handling
    Type hinting
    Modules and installing libraries
    Object-Oriented Programming
    Functional Programming
    Lambdas
    Decorators
    Generators
    Composition and Inheritance
    File I/O
    Database interactions
    Unit testing
    Regex (Regular Expressions)
    Web Scraping
    Algorithms and Data Structures
    Asynchronous programming
    Closures
    The Relational Model
    SQL Basics
    SQL Functions
    Data Modification Language
    Data Query Language
    CRUD
    SQL Filtering / WHERE Statement
    Subqueries
    Indexes
    3 Valued Logic
    SQL JOINS
    Window Functions
    Date Filtering and Timestamps
    Aggregate Functions
    Operator Precedence
    ORDER BY
    GROUP BY
    Top-Down Design
    Bottom-Up Design
    Entity Relationship Diagram
    Normalization
    Database Types
    Multi-Table SELECT
    Permission Management
    Backup Strategies
    Transactions
    Data Types
    Views
    Sharding
    Replication
    Backups
    Vertical + Horizontal Scaling
    Distributed vs Centralized Databases
    Database Security
    SQL Injections
    Access Control

    How is this BI Developer Test customized?

    1
    2
    3

    FAQs

    What is a custom assessment?

    Every role is different and requires a custom assessment to identify top candidates efficiently. Adaface subject matter experts understand your job description/ role requirements and pick the most relevant questions from our library of 10000+ questions to create a technical assessment that helps you find the qualified candidates in your candidate pipeline quickly. All custom assessments are set up based on the job description, role requirements, must-have skills, experience level and salary range within a maximum of 48 hours and you will get an email notification once it goes live.

    Check out a sample assessment here (no credit card required).

    Can I combine multiple skills into one custom assessment?

    Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify.

    How is Adaface different from other assessment tools?

    We believe that status quo tech assessment platforms are not a fair way for companies to evaluate engineers because they focus on trick questions/ puzzles/ niche algorithms. We started Adaface to help companies find great engineers by assessing on-the-job skills required for a role. Read more about why we started Adaface.

    Here's what's different with Adaface:

    • High quality non-googleable questions that test for on-the-job skills as opposed to theoretical knowledge.
    • A friendly conversational assessment with a chatbot, instead of sending a "test" to a candidate. This translates to a higher completion rate. Adaface assessments (86% candidate completion rate), as opposed to traditional tests (40-50% candidate completion rate)
    • Customized assessments for 700+ skills at different experience levels.

    Do you have any anti-cheating or proctoring features in place?

    We have the following anti-cheating features in place:

    • Web proctoring
    • Webcam proctoring
    • Plagairism detection
    • Non-googleable questions
    • Secure browser

    Read more about the proctoring features.

    How do I interpret test scores?

    The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

    What experience level can I use this test for?

    Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

    Does every candidate get the same questions?

    Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

    I'm a candidate. Can I try a practice test?

    No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

    What is the cost of using this test?

    You can check out our pricing plans.

    Can I get a free trial?

    The platform is completely self-serve, so here's one way to proceed:

    • You can sign up for free to get a feel for how it works.
    • The free trial includes one sample assessment (Java/ JavaScript) that you will find in your dashboard when you sign up. You can use it to review the quality of questions, and the candidate experience of a conversational test on Adaface.
    • To review the quality of questions, you can also review our public questions for 50+ skills here.
    • Once you're convinced that you want to try it out with real assessments and candidates, you can pick a plan according to your requirements.

    I just moved to a paid plan. How can I request a custom assessment?

    Here is a quick guide on how to request a custom assessment on Adaface.

    Singapore government logo

    The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.


    Human Resources Manager

    Singapore Government

    85%
    reduction in screening time

    How Adaface Is Different

    Adaface conversational assessments are reflective of on-the-job skills and see an 86% completion rate as compared to ~50% for traditional assessment platforms.

    OLD WAY

    TRADITIONAL TESTS

    Theoretical questions/ puzzles

    Feels like a test

    One-size-fits-all assessments

    😞
    HIRE IN
    Weeks/Months

    NEW WAY

    ADAFACE ASSESSMENTS

    Questions for on-the-job skills

    Conversational

    Customized
    assessments

    😀️
    HIRE IN
    Days

    With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!


    Brandon Lee, Head of People, Love, Bonito

    hashtag image heart icon Brandon
    Join 1200+ companies in 75+ countries.
    Try the most candidate friendly skills assessment tool today.
    Have any questions about the Adaface BI Developer Test?
    Have any questions about the Adaface BI Developer Test?
    Chat with us ✨
    Terms Privacy Trust Guide