Dun & Bradstreet Data Analyst Interview Questions and Answers

3 SQL questions were given

Q1. It was based upon my work experience and technical questions from SQL
Add your answer

Q1. Salary discussion
Add your answer

Q1. Questions from SQL,UNIX,PYTHON,AWS
Add your answer

Q1. Current Project
Ans. 
Currently working on analyzing customer data for a retail company.
• Analyzing customer purchase history

• Identifying trends and patterns in customer behavior

• Segmenting customers based on demographics and purchase preferences
Answered by AI
Add your answer

Q1. Expected Salary,Process, Offer letter
Add your answer

Q1. What is reverse merger
Ans. 
Reverse merger is a process by which a private company acquires a public company to bypass the lengthy and complex process of going public.
• A reverse merger involves a private company merging with a public company that is already listed on a stock exchange.

• The private company then becomes a subsidiary of the public company, allowing it to go public without an initial public offering (IPO).

• This process is often used by p...read more
Answered by AI
Add your answer
Q2. Questions related to capital market
Add your answer

Technology making ours less human ( 15 min) online

Q1. Tell me about yourself
Add your answer
Q2. Tell me about you inters hip
Add your answer
Q3. Fixed assets with example
Ans. 
Fixed assets are long-term tangible assets that are used in the production of goods or services and are not intended for sale.
• Fixed assets are physical assets such as buildings, machinery, equipment, vehicles, and land.

• They are not intended for sale and are used for the production of goods or services over a long period of time.

• Examples of fixed assets include manufacturing plants, office buildings, delivery trucks, an
Answered by AI
Add your answer
Q4. Capital assets with example
Ans. 
Capital assets are long-term assets that are used in the production of goods or services and are not easily converted into cash.
• Capital assets are typically tangible assets such as buildings, machinery, equipment, and vehicles.

• They are used by a company to generate revenue over an extended period of time.

• Examples of capital assets include manufacturing plants, delivery trucks, office furniture, and computer systems.
Answered by AI
Add your answer
Q5. Why we use current ration
Ans. 
Current ratio is used to assess a company's ability to pay its short-term obligations with its short-term assets.
• Current ratio is a liquidity ratio that measures a company's ability to cover its short-term liabilities with its short-term assets.

• It is calculated by dividing current assets by current liabilities.

• A current ratio of 1 or higher is generally considered healthy, as it indicates that a company has enough curr...read more
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Strength and weakness.
Add your answer

A topic was given on microsoft teams with bunch of other students

Q1. Tell me about yourself?
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets to extract valuable insights

• Proficient in using tools like Excel, SQL, and Python for data analysis

• Skilled in creating visualizations and reports to communicate findings

• Strong problem-solving and critical thinking skills

• Excellent communication and presentation abilities
Answered by AI
Add your answer
Q2. Internship experience
Ans. 
I completed a data analysis internship at XYZ Company where I worked on various projects.
• Utilized SQL to extract and analyze data from databases

• Created visualizations using Tableau to present findings to stakeholders

• Collaborated with team members to clean and prepare data for analysis
Answered by AI
Add your answer
Q3. Other cash flow statement and balance sheet related questions.
Add your answer

Q1. Accounting Tools you know?
Ans. 
I am familiar with tools like QuickBooks, Xero, and SAP for accounting purposes.
• QuickBooks

• Xero

• SAP
Answered by AI
Add your answer
Q2. Equity related questions?
Add your answer
Q3. What is the treatment of depreciation for assets?
Ans. 
Depreciation is the allocation of the cost of an asset over its useful life.
• Depreciation is a non-cash expense that reduces the value of an asset over time.

• It is used to reflect the wear and tear, obsolescence, or decrease in value of the asset.

• Common methods of depreciation include straight-line, double declining balance, and units of production.

• Depreciation expense is recorded on the income statement, while accumulat...read more
Answered by AI
Add your answer
Q4. Derivative & treatment if loss happen?
Ans. 
Derivative is a financial instrument used to hedge against losses. Treatments for losses include risk management strategies and adjusting investment portfolios.
• Derivatives can be used to offset potential losses in investments.

• Risk management strategies such as diversification and stop-loss orders can help mitigate losses.

• Adjusting investment portfolios by reallocating assets or hedging with options can also help manage
Answered by AI
Add your answer
Q5. Economy of scale?
Ans. 
Economy of scale refers to the cost advantages that a business can achieve by increasing production levels, leading to lower average costs.
• Economy of scale occurs when the average cost of production decreases as the quantity of goods produced increases.

• This can be achieved through bulk purchasing, specialization of labor, and efficient use of resources.

• Examples include large manufacturing companies producing goods at a...read more
Answered by AI
Add your answer

Q1. Types of ratios
Ans. 
Types of ratios include liquidity ratios, profitability ratios, and efficiency ratios.
• Liquidity ratios measure a company's ability to pay off short-term debts.

• Profitability ratios assess a company's ability to generate profit.

• Efficiency ratios evaluate how well a company utilizes its assets to generate revenue.

• Examples include current ratio, return on equity, and asset turnover ratio.
Answered by AI
Add your answer