Data Analyst Intern

Position

Data Analyst Intern

Duration

2 Months

Location

Fatehgunj, Vadodara

Company

CareerNaksha

About us

'

CareerNaksha' is an ed-tech start-up based company at Vadodara. Here we work as a source of support when candidates experience difficulty finding jobs and choosing the right career path and also guide the clients through counseling for the completion of aptitude ,personality, and adjacent tests. Here we are looking for the aspirantor Social Media Intern who help us build and grow our online presence

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 VisualizationScenario

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