Find top Python resources from global universities, cool projects, and learning materials for data analytics.
For promotions: @coderfun
Useful links: heylink.me/DataAnalytics
Post #1145
1.74K
๐ช๐ฎ๐ป๐ ๐๐ผ ๐ธ๐ป๐ผ๐ ๐๐ต๐ฎ๐ ๐ต๐ฎ๐ฝ๐ฝ๐ฒ๐ป๐ ๐ถ๐ป ๐ฎ ๐ฟ๐ฒ๐ฎ๐น ๐ฑ๐ฎ๐๐ฎ ๐ฎ๐ป๐ฎ๐น๐๐๐ ๐ถ๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐?
๐๐ฎ๐๐ถ๐ฐ ๐๐ป๐๐ฟ๐ผ๐ฑ๐๐ฐ๐๐ถ๐ผ๐ป
-Brief introduction about yourself.
-Explanation of how you developed an interest in learning Power BI despite having a chemical background.
๐ง๐ผ๐ผ๐น๐ ๐ฃ๐ฟ๐ผ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐
-Discussion about the tools you are proficient in.
-Detailed explanation of a project that demonstrated your proficiency in these tools.
๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐๐ ๐ฝ๐น๐ฎ๐ป๐ฎ๐๐ถ๐ผ๐ป
Explain about any Data Analytics Project you did, below are some follow-up questions for sales related data analysis project
Follow-up Question:
Was there any improvement in sales after building the report?
Provide a clear before and after scenario in sales post-report creation.
What areas did you identify where the company was losing sales, and what were your recommendations?
- How do you check the quality of data when it's given to you?
Explain your methods for ensuring data quality.
- How do you handle null values? Describe your approach to managing null values in datasets.
๐ฆ๐ค๐ ๐พ๐๐ฒ๐๐๐ถ๐ผ๐ป๐
-Explain the order in which SQL clauses are executed.
-Write a query to find the percentage of the 18-year-old population.
Details: You are given two tables:
Table 1: Contains states and their respective populations.
Table 2: Contains three columns (state, gender, and population of 18-year-olds).
-Explain window functions and how to rank values in SQL.
- Difference between JOIN and UNION.
-How to return unique values in SQL.
๐๐ฒ๐ต๐ฎ๐๐ถ๐ผ๐ฟ๐ฎ๐น ๐ค๐๐ฒ๐๐๐ถ๐ผ๐ป๐
-Solve a puzzle involving 3 gallons of water in one jar and 2 gallons in another to get exactly 4 gallons.
Step-by-step solution for the water puzzle.
- What skills have you learned on your own? Discuss the skills you self-taught and their impact on your career.
-Describe cases when you showcased team spirit.
-โญ ๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ ๐๐ฝ๐ฝ ๐ค๐๐ฒ๐๐๐ถ๐ผ๐ป
Scenario: Choose any social media app (I choose Discord).
Question: What function/feature would you add to the Discord app, and how would you track its success?
- Rate yourself on Excel, SQL, and Python out of 10.
- What are your strengths in data analytics?
I have curated best 80+ top-notch Data Analytics Resources ๐๐
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
Like if it helps :)
๐๐ฎ๐๐ถ๐ฐ ๐๐ป๐๐ฟ๐ผ๐ฑ๐๐ฐ๐๐ถ๐ผ๐ป
-Brief introduction about yourself.
-Explanation of how you developed an interest in learning Power BI despite having a chemical background.
๐ง๐ผ๐ผ๐น๐ ๐ฃ๐ฟ๐ผ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐
-Discussion about the tools you are proficient in.
-Detailed explanation of a project that demonstrated your proficiency in these tools.
๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐๐ ๐ฝ๐น๐ฎ๐ป๐ฎ๐๐ถ๐ผ๐ป
Explain about any Data Analytics Project you did, below are some follow-up questions for sales related data analysis project
Follow-up Question:
Was there any improvement in sales after building the report?
Provide a clear before and after scenario in sales post-report creation.
What areas did you identify where the company was losing sales, and what were your recommendations?
- How do you check the quality of data when it's given to you?
Explain your methods for ensuring data quality.
- How do you handle null values? Describe your approach to managing null values in datasets.
๐ฆ๐ค๐ ๐พ๐๐ฒ๐๐๐ถ๐ผ๐ป๐
-Explain the order in which SQL clauses are executed.
-Write a query to find the percentage of the 18-year-old population.
Details: You are given two tables:
Table 1: Contains states and their respective populations.
Table 2: Contains three columns (state, gender, and population of 18-year-olds).
-Explain window functions and how to rank values in SQL.
- Difference between JOIN and UNION.
-How to return unique values in SQL.
๐๐ฒ๐ต๐ฎ๐๐ถ๐ผ๐ฟ๐ฎ๐น ๐ค๐๐ฒ๐๐๐ถ๐ผ๐ป๐
-Solve a puzzle involving 3 gallons of water in one jar and 2 gallons in another to get exactly 4 gallons.
Step-by-step solution for the water puzzle.
- What skills have you learned on your own? Discuss the skills you self-taught and their impact on your career.
-Describe cases when you showcased team spirit.
-โญ ๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ ๐๐ฝ๐ฝ ๐ค๐๐ฒ๐๐๐ถ๐ผ๐ป
Scenario: Choose any social media app (I choose Discord).
Question: What function/feature would you add to the Discord app, and how would you track its success?
- Rate yourself on Excel, SQL, and Python out of 10.
- What are your strengths in data analytics?
I have curated best 80+ top-notch Data Analytics Resources ๐๐
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02
Like if it helps :)
- โค 4
