Data Analyst Intern

Job Description: Data Analyst Internship (2 Months)

Position: Data Analyst Intern

Experience Level: Freshers/Students

Company: CareerNaksha

About the Role:

We are looking for a motivated and skilled Data Analyst Intern who can assist with data scraping, analysis, visualization, and research. You will have the opportunity to work on real-world data, contribute to building data tools, and create insightful dashboards using Power BI. This internship is ideal for someone who is eager to learn and gain hands-on experience in data analysis and business intelligence.

Key Responsibilities:

• Data Collection & Scraping:
• Build Python scripts to scrape data from websites and social media platforms.
• Gather data through APIs from social media sites (e.g., Twitter, Instagram) for analysis.
• Data Cleaning & Analysis:
• Clean and process raw data to ensure accuracy and usability.
• Analyze datasets to uncover trends, patterns, and actionable insights.
• Work with Python and tools like Pandas, NumPy, and Matplotlib for data analysis and visualization.
• Power BI Dashboard Creation:
• Create dynamic dashboards in Power BI to visualize data.
• Design visual reports to communicate key insights and recommendations to stakeholders.
• Tool Development:
• Assist in developing automated scraping tools to collect data on an ongoing basis.
• Optimize and maintain data scraping tools for accuracy and efficiency.
• Research:
• Conduct research on scraping techniques, APIs, and data collection methods.
• Stay updated on the latest trends and tools for data analysis and business intelligence.

Requirements:

• Education: Pursuing or recently completed a degree in Computer Science, Data Science, Engineering, Mathematics, or a related field.
• Technical Skills:
• Proficiency in Python for data scraping, data analysis, and automation.
• Basic understanding of web scraping libraries (e.g., BeautifulSoup, Scrapy).
• Familiarity with Power BI or any other data visualization tools.
• Knowledge of APIs for social media platforms (Twitter, Instagram, etc.) is a plus.
• Analytical Skills:
• Strong problem-solving and analytical mindset.
• Ability to work with large datasets and identify trends, insights, and opportunities.
• Research Skills:
• Ability to research and implement various scraping and data collection techniques.
• Communication Skills:
• Ability to present data insights clearly and effectively.

What You’ll Learn:

• Hands-on experience in data scraping, analysis, and visualization.
• Building and optimizing data tools and automated scraping systems.
• Working with real business challenges to derive meaningful insights from data.
• Creating interactive dashboards that influence decision-making in a business context.
• Exposure to real-world projects in a dynamic work environment.

This internship is perfect for someone looking to gain practical experience in data analysis, Python scripting, and Power BI dashboard creation. You'll be working on tasks that challenge both your technical and analytical skills while getting valuable industry exposure.

Task Assignment for Data Analyst Internship:

As part of the application process, you are required to complete the following assignment to demonstrate your skills in data scraping, analysis, and visualization.

Task: Data Scraping, Analysis, and Visualization Scenario:

You are tasked with analyzing product reviews and social media engagement for a specific product category (e.g., mobile phones or laptops) across e-commerce websites and social media platforms. The goal is to gather insights into customer sentiment, pricing trends, and engagement metrics to inform business decisions.

Assignment Instructions:

• Data Scraping:
• Website Scraping:
• Write a Python script to scrape product reviews and ratings from a popular e-commerce website (such as Amazon or Flipkart). Extract the following fields:
• Product name
• Product price
• Average rating
• Number of reviews
• Review text (optional: scrape a few recent reviews)
• Store the data in a CSV file.
• Social Media Data:
• Use any social media platform's API (e.g., Twitter API, Instagram Graph API) to extract engagement metrics for a specific product or brand. Extract:
• Post content
• Likes, comments, shares (or retweets)
• Hashtags used
• Store the data in a structured format (CSV or JSON).
• Data Cleaning and Analysis:
• Clean the datasets to ensure there are no missing or incorrect values.
• Analyze the data to identify key trends, such as:
• Price trends and how they relate to customer reviews and ratings.
• The correlation between social media engagement (likes, shares) and customer sentiment in reviews.
• Insights on popular hashtags and their impact on engagement.
• Visualization (Power BI):
• Import the cleaned dataset into Power BI.
• Create a dashboard that includes the following:
• A visual representation of product ratings and reviews across price ranges.
• A chart showing social media engagement metrics (e.g., likes, shares) over time.
• A correlation chart between social media posts and customer sentiment based on reviews.
• Deliverables:
• Submit your Python scripts for scraping both website and social media data.
• Provide the cleaned dataset (in CSV/Excel format).
• Share your Power BI dashboard (exported as a PDF or shareable Power BI link).
• Include a short document (1 page) summarizing your approach, key findings, and recommendations based on the analysis.

Evaluation Criteria:

• Python Skills: Efficiency and functionality of scraping scripts (website and social media).
• Data Cleaning: Quality of data cleaning and preparation for analysis.
• Analysis & Insights: Depth and relevance of insights drawn from the data.
• Power BI Dashboard: Clarity, usability, and effectiveness of visualizations.
• Presentation: Clear communication of your approach, findings, and recommendation