Upload Button Icon Add office photos

Filter interviews by

CTS Consulting & Technical Support Power BI Developer Interview Questions and Answers

Updated 23 Nov 2024

CTS Consulting & Technical Support Power BI Developer Interview Experiences

1 interview found

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

Wjat is ppwer bi and get the dax

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

Interview questions from similar companies

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

(2 Questions)

  • Q1. Connectivity mode
  • Q2. RLS
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Tell me about Yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall, my experience was terrible due to the highly unprofessional behavior from Hexaware. During the interview, the interviewer left abruptly without any explanation and never returned. Despite following up multiple times, I received no response from Hexaware. This lack of communication and professionalism is disappointing. I would advise job seekers to consider this before applying.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Oct 2022.

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 tips
Round 2 - Technical 

(1 Question)

  • Q1. What is the difference between star schema and snowflake schema?
  • Ans. 

    Star schema has a single fact table connected to multiple dimension tables, while snowflake schema has normalized dimension tables.

    • Star schema denormalizes dimension tables, making it easier to query but potentially less efficient for storage.

    • Snowflake schema normalizes dimension tables, reducing redundancy but potentially making queries more complex.

    • Star schema is commonly used for data warehouses with denormalized da...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. What is the use of GROUP BY clause?
  • Ans. 

    The GROUP BY clause is used in SQL to group rows that have the same values into summary rows.

    • It is used with aggregate functions like COUNT, SUM, AVG, etc.

    • It helps in summarizing data and generating reports.

    • It is often used in conjunction with the HAVING clause to filter grouped data.

    • Example: SELECT department, COUNT(employee_id) FROM employees GROUP BY department;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't go for this worst company. They deceive you by saying that they have a lot of learning opportunities but will put you into short term projects and once you get released from the project, they will not assign any project and will throw you out after your bench period ends.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. All basic questions in first round and little technical in second round. The interview process is very friendly. No need to worry.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be sure what you are telling.

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 - 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 tips
Round 2 - Technical 

(2 Questions)

  • Q1. ROW LEVEL SECURITY
  • Q2. SUM, SUMIF SUMIFS AND DELETE TRUNCATE
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference Between direct query mode and import mode
  • Ans. 

    Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.

    • Direct query mode connects to data source in real-time, providing up-to-date data

    • Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes

    • Direct query mode is suitable for large datasets that require real-time updates

    • Import mode is suitable for smaller datas

  • Answered by AI
  • Q2. Define powerBI in layman poin of view
  • Ans. 

    PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.

    • PowerBI helps in creating interactive reports and dashboards

    • It allows users to connect to various data sources like Excel, SQL databases, and cloud services

    • Users can create custom visualizations and share insights with others

    • PowerBI can be used for data exploration, data modeling, and data storytelling

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. How the end user access the report
  • Ans. 

    End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.

    • End users can access the report through Power BI Service by logging in with their credentials

    • End users can also access the report through Power BI Mobile App on their smartphones or tablets

    • Reports can be embedded in other applications using Power BI Embedded feature

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic questions

Interview Questionnaire 

4 Questions

  • Q1. How many types of subscription in power BI report reserver
  • Ans. 

    There are two types of subscriptions in Power BI Report Server.

    • The two types of subscriptions are Power BI Report Server Standard and Power BI Report Server Enterprise.

    • The Standard subscription allows for a single server deployment, while the Enterprise subscription allows for a distributed deployment.

    • The Enterprise subscription also includes additional features such as high availability and disaster recovery.

    • Both subs...

  • Answered by AI
  • Q2. Email subscription, data driven subscription
  • Q3. Why are you using Sql server agent ?
  • Ans. 

    Sql server agent is used for scheduling and automating tasks in SQL Server.

    • Automates routine tasks like backups, index maintenance, etc.

    • Allows scheduling of jobs to run at specific times or intervals.

    • Provides alerts and notifications for job failures.

    • Can be used to execute PowerShell scripts or SSIS packages.

    • Helps improve database performance and reliability.

  • Answered by AI
  • Q4. Before creating the need check the sql server agent running or not if sql server Agent is not running the report schedules will be getting failed.

Skills evaluated in this interview

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

CTS Consulting & Technical Support Interview FAQs

How many rounds are there in CTS Consulting & Technical Support Power BI Developer interview?
CTS Consulting & Technical Support interview process usually has 1 rounds. The most common rounds in the CTS Consulting & Technical Support interview process are Coding Test.

Tell us how to improve this page.

CTS Consulting & Technical Support Power BI Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
CTS Consulting & Technical Support Power BI Developer Salary
based on 14 salaries
₹3.6 L/yr - ₹11 L/yr
At par with the average Power BI Developer Salary in India
View more details
Associate
602 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
481 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Programmer Analyst
297 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
243 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
212 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare CTS Consulting & Technical Support 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