Filter interviews by
SQL aggregation and join queries for data analysis.
Use GROUP BY clause for aggregation
Use aggregate functions like SUM, AVG, COUNT, etc.
Use JOIN clause to combine data from multiple tables
Types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full outer join: Returns all rows when there is a match in either table.
You can import data in Power BI using API by connecting to the API endpoint and specifying the required parameters.
Use the 'Get Data' option in Power BI to connect to the API endpoint
Specify the required authentication method (e.g. API key, OAuth)
Select the data you want to import and transform it as needed
Refresh the data periodically to keep it up to date
Extract numbers from strings in SQL
Use the SQL function REGEXP_REPLACE to remove non-numeric characters
Use the SQL function REGEXP_SUBSTR to extract numbers from strings
Consider using regular expressions to handle different number formats
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, ranks, and averages
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
They are typically used with the OVER() clause to define the window frame
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns rows when there is a match in either table.
Cross Join: Retur
Order of execution in SQL refers to the sequence in which different clauses are processed in a SQL query.
1. FROM clause is processed first to retrieve data from the specified tables.
2. WHERE clause is processed next to filter the rows based on specified conditions.
3. GROUP BY clause is processed to group the rows based on specified columns.
4. HAVING clause is processed to filter the grouped rows based on specified cond...
Use indexes, limit columns in SELECT, avoid using SELECT *, optimize joins
Use indexes on columns frequently used in WHERE clauses
Limit columns in SELECT to only those needed
Avoid using SELECT * to retrieve all columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
I applied via IIM Jobs and was interviewed before Sep 2021. There were 3 interview rounds.
I applied via LinkedIn and was interviewed before Jul 2023. There was 1 interview round.
How to use vloolup in 2 sheet
I appeared for an interview before Feb 2024.
I applied via Naukri.com and was interviewed in Nov 2021. There were 2 interview rounds.
Asking Questions related to their profile and work
I applied via LinkedIn and was interviewed in Oct 2023. There were 4 interview rounds.
About basic understanding of accounting and excel
The accounting process involves recording, summarizing, analyzing, and reporting financial transactions. Golden principles include consistency, relevance, reliability, and comparability.
Accounting process involves recording financial transactions, summarizing them into financial statements, analyzing the data, and reporting the results.
Golden principles of accounting include consistency (using the same accounting metho...
I applied via Naukri.com and was interviewed before Feb 2023. There were 2 interview rounds.
My long-term goal is to become a senior business analyst and eventually move into a management role within the company.
Continuously improve my analytical skills and knowledge of business processes
Seek opportunities for professional development and training
Build strong relationships with stakeholders and team members
Work towards obtaining relevant certifications such as CBAP or PMI-PBA
Global industry is experiencing fluctuating interest rates, focus on increasing profitability of companies like Swiggy, and market sizing guesstimates.
Interest rates are currently fluctuating due to economic uncertainties and central bank policies.
To increase profitability of Swiggy, focus on optimizing operational efficiency, expanding customer base, and enhancing delivery services.
Market sizing guesstimates involve e...
based on 1 interview
Interview experience
Data Engineer
7
salaries
| ₹9 L/yr - ₹20.5 L/yr |
Data Consultant
5
salaries
| ₹8.3 L/yr - ₹12 L/yr |
Senior Data Consultant
5
salaries
| ₹11 L/yr - ₹21 L/yr |
HR Manager
4
salaries
| ₹3 L/yr - ₹8.5 L/yr |
Data Analyst
4
salaries
| ₹9.3 L/yr - ₹14 L/yr |
Dhruv Research
S.M. Consultants
Cheers Interactive
Thoucentric