Upload Button Icon Add office photos
Engaged Employer

i

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

Dentsu World Services Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Dentsu World Services Accounts Manager Interview Questions and Answers

Updated 18 Sep 2024

Dentsu World Services Accounts Manager Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
4-6 weeks
Result
No response

I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Walk through CV
  • Ans. 

    I have over 5 years of experience in accounts management, with a strong track record of improving financial processes and increasing efficiency.

    • Started career as an Accounts Assistant at XYZ Company

    • Promoted to Accounts Manager at ABC Company

    • Implemented new accounting software resulting in 20% reduction in processing time

    • Managed a team of 5 accountants and successfully streamlined financial reporting

  • Answered by AI
  • Q2. Tools you use for research and planning
  • Ans. 

    I use various tools such as Excel, QuickBooks, and industry-specific software for research and planning.

    • Excel for data analysis and creating financial reports

    • QuickBooks for managing accounts and financial transactions

    • Industry-specific software for specialized research and planning tasks

  • Answered by AI
  • Q3. Case study: make a 1cr plan
  • Ans. 

    Develop a 1cr plan for a case study

    • Analyze the current financial situation of the company

    • Identify key areas for investment and growth

    • Create a detailed budget outlining expenses and revenue projections

    • Implement strategies to increase profitability and achieve the 1cr goal

    • Monitor progress regularly and make adjustments as needed

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Dentsu has a horrible culture. After taking 4 rounds the HR never reverts back nor on being contacted you get revert that HR has left the company so he won’t be able to help.

They ask you if you are ready to work long hours everyday since that is the ask of the job role.

Even had a bad experience with the one who was interviewing, behaviour was very arrogant.

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Approached by Company

Round 1 - Technical 

(2 Questions)

  • Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
  • Q2. Joining tables with different joins
  • Ans. 

    Joining tables with different joins in SQL

    • Use INNER JOIN to return rows when there is at least one match in both tables

    • Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

    • Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

    • Use FULL JOIN to return rows when there is a match in one of the tables

  • Answered by AI

Skills evaluated in this interview

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

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Coding Test 

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Round 2 - Technical 

(1 Question)

  • Q1. Simple questions on SQL were asked.
Round 3 - One-on-one 

(5 Questions)

  • Q1. What is pivot table in Excel?
  • Ans. 

    A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

    • Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

    • You can easily rearrange the layout of the data to view it from different perspectives.

    • Pivot tables can perform functions like sum, average, count, and more on the data.

    • They are useful for creating reports...

  • Answered by AI
  • Q2. What is 'Data Validation' in Excel?
  • Ans. 

    Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.

    • Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

    • Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

    • Data ...

  • Answered by AI
  • Q3. What is the order of execution of an SQL query?
  • Ans. 

    The order of execution of an SQL query involves multiple steps to retrieve data from a database.

    • 1. Parsing: The SQL query is first parsed to check for syntax errors.

    • 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

    • 3. Compilation: The optimized query is compiled into an executable form.

    • 4. Execution: The compiled query is executed by the database engine t...

  • Answered by AI
  • Q4. What is the difference between Tree Map and Heatmap in Tableau?
  • Ans. 

    Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.

    • Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

    • Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

    • Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...

  • Answered by AI
  • Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
  • Ans. 

    Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.

    • Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

    • Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

    • Extract Data can improve per...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Affine Data Analyst interview:
  • SQL
  • Power Bi
  • Tableau
  • Excel

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Affine user image Vikranth Ravikanthi

posted on 16 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL Questions on Aggregations

Data Analyst Interview Questions & Answers

Affine user image Sai Shreyas B.K

posted on 28 Sep 2024

Interview experience
4
Good
Difficulty level
Hard
Process Duration
-
Result
Not Selected

I appeared for an interview in Aug 2024.

Round 1 - Coding Test 

The sql questions were hard

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

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

Round 1 - Coding Test 

Duration was 1 hour, Topics covered were DSA, Concurrency in golang, Databse questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep learing DSA everyday and Master tthe most important topics in your programming language
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I appeared for an interview in Jun 2024.

Round 1 - Coding Test 

Easy SQL questions related to sub query

Round 2 - Coding Test 

SQL moderate questions related to joins and window functions

Round 3 - One-on-one 

(1 Question)

  • Q1. Asked about specific tools related to requirement

Interview Preparation Tips

Interview preparation tips for other job seekers - No advice, prepare based on JD
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Form based JS questions. String questions in javascript
  • Q2. React interview questions with some state management follow up questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up on js ,es6, node.js

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2023. There were 4 interview rounds.

Round 1 - Coding Test 

Some MCQ questions based on the language of your choice and 1 SQL question.

Round 2 - Technical 

(1 Question)

  • Q1. JS fundamentals, programming concepts, sorting algos and basic coding question.
Round 3 - Technical 

(1 Question)

  • Q1. Similar to Round 2
Round 4 - One-on-one 

(1 Question)

  • Q1. Overview of my experience and projects at previous company and programming basics.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on sorting algos, js fundamentals, SQL for software engineering role (not for data roles).

Dentsu World Services Interview FAQs

How many rounds are there in Dentsu World Services Accounts Manager interview?
Dentsu World Services interview process usually has 1 rounds. The most common rounds in the Dentsu World Services interview process are Technical.
What are the top questions asked in Dentsu World Services Accounts Manager interview?

Some of the top questions asked at the Dentsu World Services Accounts Manager interview -

  1. Tools you use for research and plann...read more
  2. Case study: make a 1cr p...read more
  3. Walk through...read more

Tell us how to improve this page.

Dentsu World Services Accounts Manager Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

kipi.ai Interview Questions
4.2
 • 57 Interviews
Affine Interview Questions
3.3
 • 49 Interviews
Cyfuture Interview Questions
3.0
 • 45 Interviews
View all
Software Engineer
38 salaries
unlock blur

₹4 L/yr - ₹15.3 L/yr

Senior Software Engineer
20 salaries
unlock blur

₹11 L/yr - ₹22 L/yr

QA Engineer
15 salaries
unlock blur

₹6 L/yr - ₹12 L/yr

QA Lead
12 salaries
unlock blur

₹14 L/yr - ₹22 L/yr

Senior Project Manager
9 salaries
unlock blur

₹30 L/yr - ₹36.4 L/yr

Explore more salaries
Compare Dentsu World Services with

Medcode

4.5
Compare

Maxgen Technologies

4.5
Compare

Cyfuture

3.0
Compare

Value Point Systems

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview