Test your knowledge

Hi,
Here's the task for you all..!


Basic Concepts for Data Analyst (SQL)

𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨 𝐰𝐢𝐭𝐡 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧 𝐟𝐨𝐫 𝐉𝐨𝐢𝐧𝐬

1.𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:
Let's say we have two tables, "employees" and "departments". The "employees" table contains information about employees such as their ID, name, department ID, and salary. The "departments" table contains information about departments including their ID and name.

We want to retrieve a list of all employees along with the department they belong to, including those employees who are not currently assigned to any department.

2.𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:
Consider two tables, "orders" and "customers". The "orders" table contains information about orders placed by customers, including order ID, customer ID, and order date. The "customers" table contains information about customers, including customer ID, name, and email.

We want to retrieve a list of all orders along with the details of the customers who placed those orders, including orders without corresponding customer records.

𝕋𝕣𝕪 𝕥𝕠 𝕥𝕙𝕚𝕟𝕜 𝕠𝕗 𝕒 𝕤𝕠𝕝𝕦𝕥𝕚𝕠𝕟
And drop it in comments ...!



Like this if you want me to post a solution by evening or tomorrow

Myntra is hiring!
Position: Data Analyst
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 7- 11 LPA (Expected)
Experience: 1 year experience
Location: Bengaluru

Follow @codingdidi

📌Apply Now: https://boards.greenhouse.io/myntra/jobs/7422819002?gh_src=bb272d8c2

Hi, Here's the document with the complete 30 days powerbi roadmap..!


https://www.instagram.com/reel/C65aGLOrM_L/?igsh=MTgzZGEzYnQ1MmtlMA==


Follow @codingdidi

Advarra is hiring!
Position: Data Engineer
Qualifications: Bachelor’s Degree
Salary: 8 - 12 LPA (Expected)
Batch: 2018/ 2019/ 2020/ 2021/ 2022/ 2023
Location: Bengaluru , India

📌Apply Now: https://recruiting.ultipro.com/ADV1023AVR/JobBoard/6051d363-03fe-4650-945e-f836306a8388/OpportunityDetail?opportunityId=a6e8f12e-792c-4100-a4d7-0c154aa84b2f&utm_source=LINKEDIN

Another pandas video is out!!

English:-
https://youtu.be/9BurT1sSFqw?si=XTtb_4LShVyuIzbU

HINDI:-https://youtu.be/EStq_qB4ywI?si=VwvrU-L3jIH8WdyP


Go check it out...!

Comment down your views.!

Today, let's learn about Advanced Data Analysis:

1. Regression Analysis: Regression analysis is a statistical method used to explore the relationship between one dependent variable and one or more independent variables. Excel provides built-in tools for performing linear regression analysis, which can help you understand the strength and nature of the relationship between variables, make predictions, and identify outliers.

2. Data Forecasting with Excel: Excel offers several methods for data forecasting, including exponential smoothing, moving averages, and trend analysis. These methods allow you to analyze historical data trends and make predictions about future values based on those trends. Excel's forecasting tools provide visualizations and statistical measures to help you assess the accuracy and reliability of your forecasts.

For example:
- You can use regression analysis in Excel to analyze the relationship between advertising expenditure and sales revenue. By performing a regression analysis, you can determine the extent to which advertising spending influences sales and make predictions about future sales based on different advertising budgets.
- Excel's forecasting tools can be used to predict future sales volumes based on historical sales data. You can apply different forecasting methods, such as exponential smoothing or moving averages, to identify patterns and trends in the data and make predictions about future sales performance.

Advanced data analysis techniques such as regression analysis and data forecasting enable you to gain deeper insights into your data and make more informed decisions.


Like for more such content 👍❤️

Hope it helps :)

My brief introduction 🤠:-

Especially for those who are still worried about their career in tech.

For those who still wonders whether NON-TECH to TECH transition is a marketing gimmick or impossible.


Link:- https://www.linkedin.com/posts/akansha-yadav24_nontech-tech-datascientist-activity-7195855996416638977-qBiA?utm_source=share&utm_medium=member_android



https://linktr.ee/codingdidi

Follow @Codingdidi ✅

Gururo is hiring!
Position: Applied Data Scientist
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 9 LPA (Expected)
Experience: Fresher
Location: Remote

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7195971520194650115/


✅@codingdidi

Learn Machine Learning for Free using this!


https://www.instagram.com/reel/C67-p9oLuBV/?igsh=MXA2eDU1cTRoNXRvaA==



Repo link:-
https://github.com/microsoft/ML-For-Beginners?WT.mc_id=academic-105485-koreyst


Follow @codingdidi✅

𝑰𝒏𝒕𝒆𝒓𝒗𝒊𝒆𝒘 𝒒𝒖𝒆𝒔𝒕𝒊𝒐𝒏𝒔 𝒇𝒐𝒓 𝒇𝒓𝒆𝒔𝒉𝒆𝒓 𝒂𝒏𝒅 𝒎𝒊𝒅-𝒍𝒆𝒗𝒆𝒍 𝑩𝒖𝒔𝒊𝒏𝒆𝒔𝒔 𝑨𝒏𝒂𝒍𝒚𝒔𝒕 𝒑𝒐𝒔𝒊𝒕𝒊𝒐𝒏𝒔 𝒂𝒕 𝑭𝒍𝒊𝒑𝒌𝒂𝒓𝒕.

1. Can you explain the role of a Business Analyst in an e-commerce company like Flipkart?

2. What motivated you to pursue a career in business analysis, particularly in the e-commerce domain?

3. Describe a recent project or assignment where you had to gather and analyze data to solve a business problem.

4. How do you ensure that the data you analyze is accurate and reliable?

5. What tools and techniques are you familiar with for data analysis and visualization?

6. Can you provide an example of a time when you effectively communicated technical information to a non-technical audience?

7. How do you prioritize tasks and manage your time effectively when working on multiple projects?

8. Have you worked with SQL for data querying and manipulation? If so, can you provide an example of a query you've written?

9. How do you approach identifying and documenting business requirements for a new project or feature?

10. Describe a situation where you had to work collaboratively with stakeholders from different departments or teams. How did you ensure alignment and achieve consensus?

11. What steps would you take to analyze the current situation and propose recommendations to improve the conversion rate on Flipkart's mobile app?

12. Have you worked with Agile methodologies in your previous projects? If so, how do you adapt them to suit the needs of your team and project?

13. Can you discuss any recent trends or challenges in the e-commerce industry, and how they might impact Flipkart's business?

14. How do you stay updated with industry news and emerging technologies relevant to business analysis?

15. Give an example of a time when you had to adapt to changes in project requirements or priorities. How did you handle it?

16. Describe a situation where you identified a problem or opportunity that others overlooked. How did you address it, and what was the outcome?

17. What strategies do you use to ensure effective communication and collaboration within a team?

18. How do you handle disagreements or conflicts within a team during the analysis process?

19. Can you discuss a challenging project you worked on and how you overcame obstacles to achieve success?

20. Why do you think you would be a good fit for the Business Analyst role at Flipkart, and what unique skills or experiences do you bring to the table?

Here is the solution of last post:

1.Scenerio solution - LEFT JOIN Used:

In this scenario, we will use a LEFT JOIN to retrieve all records from the "employees" table and only the matching records from the "departments" table.

SELECT employees.*, departments.name AS department_name
FROM employees
LEFT JOIN departments ON employees.department_id = departments.id;

2.Scenerio solution - LEFT JOIN Used:

In this scenario, we will use a LEFT JOIN to retrieve all records from the "orders" table and only the matching records from the "customers" table.

SELECT orders.*, customers.name, customers.email
FROM orders
LEFT JOIN customers ON orders.customer_id = customers.customer_id;



Hope it helps :)

𝐓𝐨𝐩 𝐜𝐨𝐦𝐩𝐚𝐧𝐲 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐈𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐒𝐐𝐋 𝐑𝐞𝐚𝐥 𝐖𝐨𝐫𝐥𝐝 𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:

𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:
You're a data analyst working for a retail company that wants to optimize its sales strategies. The company has a SQL Server database that contains various tables related to sales transactions, customer information, product details, and store locations. Your task is to analyze the data and provide insights to improve sales performance.

𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟏:
Using SQL Server, how would you determine the top-selling products for the current month?


𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟐:
How would you analyze customer purchasing behavior to identify potential upsell or cross-sell opportunities?


𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟑:
How would you assess the performance of different store locations in terms of sales revenue?

DROP YOUR SOLUTIONS!


Like for more ❤️

Hope it helps :)

Hi, here you go with a pdf which consists of SQL INTERVIEW QUESTIONS ‼️

https://www.instagram.com/reel/C6-jWJrLg9s/?igsh=enJybmhsdGxtNGVl


Follow @codingdidi

Tune AI is hiring for multiple profile !
Position: Machine Learning Engineer
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 15 LPA (Expected)
Experience: Fresher & Experience
Location: Remote

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7196523039616827393/

AB InBev is hiring for multiple profile !
Position: Junior Data Scientist
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 15 LPA (Expected)
Experience:1 year Experience
Location: Remote

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7196523039616827393/

Solution

𝐓𝐨𝐩 𝐜𝐨𝐦𝐩𝐚𝐧𝐲 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐈𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐒𝐐𝐋 𝐑𝐞𝐚𝐥 𝐖𝐨𝐫𝐥𝐝 𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:

𝐒𝐜𝐞𝐧𝐞𝐫𝐢𝐨:
You're a data analyst working for a retail company that wants to optimize its sales strategies. The company has a SQL Server database that contains various tables related to sales transactions, customer information, product details, and store locations. Your task is to analyze the data and provide insights to improve sales performance.

𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟏:
Using SQL Server, how would you determine the top-selling products for the current month?
𝐀𝐧𝐚𝐥𝐲𝐳𝐞𝟏:
To determine the top-selling products for the current month, I would start by querying the sales transactions table to retrieve all sales made within the current month. I would then join this table with the product table using the product ID to get the product names and group the results by product name while summing up the quantities sold. Finally, I would order the results by the total quantity sold in descending order and limit the output to the top N products.

𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟐:
How would you analyze customer purchasing behavior to identify potential upsell or cross-sell opportunities?
𝐀𝐧𝐚𝐥𝐲𝐳𝐞 𝟐:
To analyze customer purchasing behavior and identify upsell or cross-sell opportunities, I would examine the sales transactions table and look for patterns in customer buying habits. This could involve identifying frequently co-purchased products or analyzing the average order value per customer. Additionally, I might segment customers based on their purchase history, demographics, or other relevant factors to tailor specific upsell or cross-sell strategies.

𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧 𝟑:
How would you assess the performance of different store locations in terms of sales revenue?
𝐀𝐧𝐚𝐥𝐲𝐳𝐞 𝟑:
To assess the performance of different store locations in terms of sales revenue, I would query the sales transactions table and join it with the store locations table using the store ID. Then, I would group the results by store location and calculate the total sales revenue for each location by summing up the transaction amounts. Finally, I would order the results by sales revenue in descending order to identify the top-performing locations.

Like for more ❤️

Hope it helps :)

NatWest Group is hiring for multiple profile !
Position: Data Scientist
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 15 LPA (Expected)
Experience: Fresher
Location: Bangalore

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7196856292341096448/


Cognizant is hiring for multiple profile !
Position: Machine Learning Engineer
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 15 LPA (Expected)
Experience: Fresher & Experience
Location: Bangalore

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7196856292341096448/

Axtria - Ingenious Insights is hiring for multiple profile !
Position: Machine Learning Engineer
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6- 15 LPA (Expected)
Experience:1 yearExperience
Location: Remote

📌Apply Now: https://www.linkedin.com/feed/update/urn:li:share:7196856292341096448/

Hello everyone!

New YouTube video is live now!


👉👉👉👉Go check it out!



This video breaks down EVERYTHING you need to know:

✔ What is ChatGPT 40?

✔ Who can access it (Free tier available!)

✔ Powerful new features: Text, Images, Memory & More!

✔ ChatGPT 40 vs Other Models: Is it the BEST?

✔ Will Al replace Analysts & Engineers?

✔ Get ready for the future of Al with ChatGPT 40!

https://youtu.be/C6C6OIOl1dU?si=m8GQsEpZr2SfC2Uh


⚠️⚠️

This is exclusively for telegram and instagram followers

Drop the interesting comments in this video. 😍 I'll choose the best comments and will collaborate with you on insta/YT 📷.



✅Follow @codingdidi❤️