Welcome to the Data Analytics Internship! This program is designed to enhance your skills in data analysis, focusing on beginner-friendly tools like Excel, Power BI, and Tableau. Through practical tasks, you will gain hands-on experience that prepares you for real-world data analytics challenges. Remember to complete at least two tasks and share your work on social media!
Notice: Complete a minimum of 2 tasks from the tasks listed below.
Task 1: Data Entry and Basic Functions in Excel
Problem Statement:
Familiarize yourself with Excel by entering data and using basic functions.
Steps to Complete:
- Create a new Excel workbook.
- Enter a sample dataset (e.g., sales data, student grades).
- Use basic functions such as SUM, AVERAGE, and COUNT to analyze the data.
Tools/Datasets/Platforms:
- Microsoft Excel.
You can use any dataset of your choice.
How to Submit:
- Record a video demonstrating your data entry and function usage.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 2: Creating Charts in Excel
Problem Statement:
Visualize data using different chart types in Excel.
Steps to Complete:
- Using the dataset from Task 1, create at least three different types of charts (e.g., bar chart, pie chart, line chart).
- Label your charts clearly and provide a brief analysis of what they represent.
Tools/Datasets/Platforms:
- Microsoft Excel.
You can use any dataset of your choice.
How to Submit:
- Record a video showcasing your charts and analysis.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 3: Introduction to Data Cleaning in Excel
Problem Statement:
Learn the basics of data cleaning using Excel.
Steps to Complete:
- Import a sample dataset with errors (e.g., duplicate entries, missing values).
- Identify and correct these errors using Excel functions like REMOVE DUPLICATES, TRIM, and FIND & REPLACE.
- Save the cleaned dataset.
Tools/Datasets/Platforms:
- Microsoft Excel.
You can use any dataset of your choice.
How to Submit:
- Record a video demonstrating your data cleaning process.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 4: Creating Interactive Dashboards in Excel
Problem Statement:
Build an interactive dashboard using Excel.
Steps to Complete:
- Create a summary of your dataset using PivotTables.
- Use slicers to create an interactive element in your dashboard.
- Design the dashboard layout for clarity and ease of use.
Tools/Datasets/Platforms:
- Microsoft Excel.
You can use any dataset of your choice.
How to Submit:
- Record a video demonstrating your interactive dashboard.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 5: Data Visualization with Power BI
Problem Statement:
Create basic visualizations using Power BI.
Steps to Complete:
- Import a sample dataset into Power BI.
- Create at least three different visualizations (e.g., bar chart, line chart).
- Design a simple report showcasing your visualizations.
Tools/Datasets/Platforms:
- Power BI.
You can use any dataset of your choice.
How to Submit:
- Record a video showcasing your Power BI report and visualizations.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 6: Building a Dashboard in Power BI
Problem Statement:
Design an interactive dashboard in Power BI.
Steps to Complete:
- Use a dataset to create a dashboard with multiple visualizations.
- Include interactive elements such as filters and slicers.
- Publish your dashboard for sharing.
Tools/Datasets/Platforms:
- Power BI.
You can use any dataset of your choice.
How to Submit:
- Record a video demonstrating your Power BI dashboard.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 7: Data Visualization with Tableau
Problem Statement:
Create visualizations using Tableau.
Steps to Complete:
- Load a sample dataset into Tableau.
- Create at least three different types of visualizations (e.g., bar, line, pie).
- Assemble the visualizations into a simple dashboard.
Tools/Datasets/Platforms:
- Tableau.
You can use any dataset of your choice.
How to Submit:
- Record a video showcasing your Tableau visualizations and dashboard.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 8: Creating a Story with Data in Tableau
Problem Statement:
Tell a story using data visualizations in Tableau.
Steps to Complete:
- Use a dataset to create a series of visualizations that lead to a conclusion.
- Add annotations and text to guide the viewer through your story.
- Publish your story as a Tableau Public link.
Tools/Datasets/Platforms:
- Tableau.
You can use any dataset of your choice.
How to Submit:
- Record a video presenting your data story in Tableau.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 9: Introduction to Data Analysis Concepts
Problem Statement:
Understand and explain basic data analysis concepts.
Steps to Complete:
- Research fundamental data analysis concepts (e.g., descriptive statistics, data types).
- Prepare a short presentation summarizing your findings.
- Include examples of how these concepts apply to real-world scenarios.
Tools/Datasets/Platforms:
- Any presentation software (PowerPoint, Google Slides).
You can use any dataset of your choice.
How to Submit:
- Record a video presenting your data analysis concepts.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 10: Exploring Data Insights
Problem Statement:
Analyze a dataset and identify key insights.
Steps to Complete:
- Choose a dataset and perform a basic analysis.
- Use Excel, Power BI, or Tableau to find trends and insights.
- Prepare a report summarizing your findings.
Tools/Datasets/Platforms:
- Excel, Power BI, or Tableau.
You can use any dataset of your choice.
How to Submit:
- Record a video presenting your insights and analysis.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 11: Preparing a Data Analytics Portfolio
Problem Statement:
Create a portfolio showcasing your data analytics work.
Steps to Complete:
- Compile your work from previous tasks into a single document or presentation.
- Include descriptions, visualizations, and key insights.
- Share your portfolio with peers and mentors for feedback.
Tools/Datasets/Platforms:
- Any document or presentation software.
You can use any dataset of your choice.
How to Submit:
- Record a video showcasing your portfolio.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Task 12: Capstone Project
Problem Statement:
Design and implement a comprehensive data analytics project.
Steps to Complete:
- Choose a real-world problem to solve using data analytics.
- Apply all stages from data collection to reporting.
- Present your findings and insights in a comprehensive report.
Tools/Datasets/Platforms:
- Excel, Power BI, Tableau, or any other analytics tool.
You can use any dataset of your choice.
How to Submit:
- Record a video presentation of your capstone project.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the video link in the submission form.
Conclusion
This internship aims to provide a comprehensive experience in data analytics through practical tasks and projects. Engage with your mentors and peers, and make the most of this learning opportunity!