Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Celebal Technologies Team. If you also belong to the team, you can get access from here

Celebal Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Celebal Technologies Power BI Developer Interview Questions, Process, and Tips

Updated 13 Aug 2024

Top Celebal Technologies Power BI Developer Interview Questions and Answers

Celebal Technologies Power BI Developer Interview Experiences

3 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is append in power query
  • Ans. 

    Append in Power Query is used to combine multiple tables or queries into a single table or query.

    • Append is used to stack tables on top of each other, adding rows from one table to the end of another.

    • It is useful when you have multiple tables with the same structure and want to combine them into one.

    • You can append tables from different data sources or within the same data source.

    • For example, you can append sales data fr...

  • Answered by AI
  • Q2. What is merge in power query
  • Ans. 

    Merge in Power Query combines multiple tables into one by matching rows based on specified columns.

    • Merge is used to combine tables in Power Query

    • You can merge based on one or more columns

    • Different types of merges include inner, left outer, right outer, and full outer joins

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. What is filter context
  • Ans. 

    Filter context determines which rows of data are visible to calculations in DAX formulas.

    • Filter context is dynamic and changes based on user interactions.

    • It can be set by slicers, filters, or relationships between tables.

    • Filter context is used to calculate results based on the current filter selections.

    • It helps in determining which rows of data are included in calculations.

  • Answered by AI
  • Q2. What is summarize function
  • Ans. 

    Summarize function is used in Power BI to aggregate data based on specified columns.

    • Used to group data and perform aggregate functions like sum, count, average, etc.

    • Can be used in DAX formulas to create calculated columns or measures.

    • Example: SUMMARIZE('Table', 'Column1', 'Column2', SUM('Value'))

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Basics about power bi and dax

Interview Preparation Tips

Interview preparation tips for other job seekers - clear your basics

Power BI Developer Interview Questions Asked at Other Companies

asked in KPMG India
Q1. Types of joins in power Bi & SQL and how it works?
asked in KPMG India
Q2. Difference between Sum and Sumx? And also Summerize vs Summerized ... read more
Q3. what are the difference between page level and report level filte ... read more
asked in Infosys
Q4. What is difference between calculate column and measures?
asked in KPMG India
Q5. Difference between calculate and calculate table ?
Round 1 - Aptitude Test 

Aptitude consists of apti,reasoning, sql and power bi questions, some verbal questions too.

Round 2 - interview 

(1 Question)

  • Q1. Power bi and sql questions
Round 3 - HR 

(1 Question)

  • Q1. I did'nt cleared tr,so don't know about hr.

Interview Preparation Tips

Interview preparation tips for other job seekers - do more practice on your domain questions.

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What is a power bi
  • Ans. 

    Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.

    • Power BI is a Microsoft product used for data analysis and visualization.

    • It allows users to connect to various data sources and create interactive reports and dashboards.

    • Power BI provides a wide range of visualizations, such as charts, maps, and tables, to represent data.

    • Users can create custom calculat...

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Prepare for the basic questions that are very basic
  • Q2. What are the types of normalization
  • Ans. 

    Normalization is a database design technique that organizes data in a structured manner to eliminate redundancy and improve data integrity.

    • Normalization helps in reducing data redundancy by breaking down a large table into smaller, more manageable tables.

    • There are different normal forms, such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules and dependencies.

    • Normalization ensures data integrity by minimizing da...

  • Answered by AI
Round 1 - Assignment 
Round 2 - HR 

(8 Questions)

  • Q1. Why should we hire you?
  • Q2. Why are you looking for a change?
  • Q3. What are your strengths and weaknesses?
  • Q4. Where do you see yourself in 5 years?
  • Q5. What is your family background?
  • Q6. What are your salary expectations?
  • Q7. Share details of your previous job.
  • Q8. Tell me about yourself.

I applied via Naukri.com

Interview Questionnaire 

1 Question

  • Q1. TEL ME ABOUT YOUR SELF

Interview Preparation Tips

Interview preparation tips for other job seekers - Speck clearly
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(4 Questions)

  • Q1. Rls, bookmark, button, dashboard, report, sql joins
  • Q2. Visuals, slicers, filter, sync slicer
  • Q3. Excel vlookip, macros, hloopkup
  • Q4. Saas, paas, as, Rs, msbi

Interview Preparation Tips

Topics to prepare for Wipro Power BI Developer interview:
  • Power query
Interview preparation tips for other job seekers - Nice experience given case study sql scenarios and Dax formula
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jul 2024.

Round 1 - Assignment 

Brief information about Business Intelligence (BI) tools.

Round 2 - Technical 

(3 Questions)

  • Q1. What is the role of Power BI in today's market?
  • Ans. 

    Power BI plays a crucial role in today's market by enabling organizations to visualize and analyze their data for better decision-making.

    • Power BI allows businesses to create interactive reports and dashboards for data visualization.

    • It helps in analyzing data trends, identifying patterns, and making informed decisions.

    • Power BI integrates with various data sources, making it easier to consolidate and analyze data from mu...

  • Answered by AI
  • Q2. What are the differences between Power BI and Tableau?
  • Ans. 

    Power BI is a Microsoft business analytics tool while Tableau is a data visualization tool.

    • Power BI is a Microsoft product while Tableau is developed by Tableau Software.

    • Power BI is more user-friendly for users familiar with Microsoft products.

    • Tableau has more advanced visualization capabilities compared to Power BI.

    • Power BI integrates well with other Microsoft products like Excel and Azure, while Tableau has more flex...

  • Answered by AI
  • Q3. What are some case studies that demonstrate the use of Power BI?
  • Ans. 

    Power BI has been used in various industries for data visualization and analysis.

    • Retail industry: analyzing sales data to identify trends and optimize inventory

    • Finance sector: creating interactive dashboards for financial reporting and analysis

    • Healthcare sector: tracking patient outcomes and hospital performance metrics

    • Manufacturing industry: monitoring production efficiency and supply chain management

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. What are your salary expectations?
  • Ans. 

    My salary expectations are in line with industry standards for a Power BI Developer with my level of experience.

    • I have researched the average salary range for Power BI Developers in this location

    • I am looking for a competitive salary that reflects my skills and experience

    • I am open to negotiation based on the overall compensation package offered

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. About Power BI Desktop and Service
Contribute & help others!
anonymous
You can choose to be anonymous

Celebal Technologies Interview FAQs

How many rounds are there in Celebal Technologies Power BI Developer interview?
Celebal Technologies interview process usually has 2 rounds. The most common rounds in the Celebal Technologies interview process are Technical, Aptitude Test and HR.
How to prepare for Celebal Technologies Power BI Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Celebal Technologies. The most common topics and skills that interviewers at Celebal Technologies expect are Business Intelligence, Power Bi, Requirement Gathering, SQL and SSAS.
What are the top questions asked in Celebal Technologies Power BI Developer interview?

Some of the top questions asked at the Celebal Technologies Power BI Developer interview -

  1. What is append in power qu...read more
  2. what is merge in power qu...read more
  3. what is filter cont...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

BNP Paribas India Solutions

No Interviews

INTERVIEWS

Celebal Technologies

No Interviews

INTERVIEWS

Philips Innovation Campus

No Interviews

SALARIES

BNP Paribas India Solutions

LIST OF COMPANIES

Bridge Group Solutions

Locations

INTERVIEWS

Travclan Technology India

No Interviews

INTERVIEWS

BNP Paribas India Solutions

No Interviews

INTERVIEWS

BNP Paribas India Solutions

No Interviews

Tell us how to improve this page.

Celebal Technologies Power BI Developer Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
Celebal Technologies Power BI Developer Salary
based on 75 salaries
₹4 L/yr - ₹10.3 L/yr
12% less than the average Power BI Developer Salary in India
View more details

Celebal Technologies Power BI Developer Reviews and Ratings

based on 4 reviews

4.4/5

Rating in categories

4.2

Skill development

3.4

Work-life balance

3.0

Salary

2.1

Job security

4.2

Company culture

3.4

Promotions

4.0

Work satisfaction

Explore 4 Reviews and Ratings
Data Engineer
381 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
250 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Engineer
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
123 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Celebal Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent