This Business Analytics internship program introduces key concepts, tools, and practices in analyzing data to help make better business decisions. The tasks are designed to be beginner-friendly, focusing on tools like Excel, Power BI, and Tableau, with progressively more challenging tasks. By completing these tasks, you will gain hands-on experience in business analytics, from data cleaning and visualization to deriving insights and reporting.
Notice: Complete a minimum of 2 tasks from the tasks listed below.
Task 1: Data Cleaning in Excel
Problem Statement:
Learn the basics of cleaning raw business data using Excel.
Steps to Complete:
- Download a raw dataset (e.g., sales or customer data).
- Identify and handle missing data, duplicates, and inconsistencies.
- Apply basic Excel functions like filtering, sorting, and removing duplicates.
Tools/Datasets/Platforms:
- Excel, Download Excel
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your cleaned dataset (10-15 seconds).
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 2: Descriptive Statistics in Excel
Problem Statement:
Use Excel to calculate descriptive statistics such as mean, median, mode, and standard deviation on a business dataset.
Steps to Complete:
- Import a dataset (e.g., employee performance data).
- Use Excel functions to compute mean, median, mode, and standard deviation.
- Analyze the dataset based on these metrics.
Tools/Datasets/Platforms:
- Excel
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your calculations.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 3: Data Visualization with Power BI
Problem Statement:
Create basic visualizations in Power BI to analyze a business dataset.
Steps to Complete:
- Import a dataset into Power BI (e.g., sales data).
- Create visualizations like bar charts, line graphs, or pie charts.
- Customize your visualizations to improve readability and clarity.
Tools/Datasets/Platforms:
- Power BI, Download Power BI
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your visualizations.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 4: Data Exploration with Tableau
Problem Statement:
Use Tableau to explore and visualize data to extract business insights.
Steps to Complete:
- Import a dataset (e.g., customer behavior data) into Tableau.
- Create exploratory visualizations to understand trends and patterns.
- Build a dashboard to summarize your findings.
Tools/Datasets/Platforms:
- Tableau, Download Tableau
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your dashboard.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 5: Business Forecasting Using Excel
Problem Statement:
Forecast future sales or revenue using historical data and Excel’s forecasting functions.
Steps to Complete:
- Import historical data (e.g., sales data) into Excel.
- Apply forecasting functions (like FORECAST.LINEAR) to predict future trends.
- Visualize the forecasted data using graphs.
Tools/Datasets/Platforms:
- Excel
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your forecast.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 6: Building a Sales Dashboard in Power BI
Problem Statement:
Design a sales dashboard in Power BI to monitor key performance metrics (KPIs).
Steps to Complete:
- Import sales data into Power BI.
- Create KPIs like total revenue, number of products sold, and top-selling products.
- Design an interactive dashboard to display these KPIs.
Tools/Datasets/Platforms:
- Power BI
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your dashboard.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 7: Customer Segmentation Analysis Using Tableau
Problem Statement:
Segment customers based on their purchasing behavior using Tableau.
Steps to Complete:
- Import customer data into Tableau.
- Use clustering algorithms or manual methods to group customers.
- Visualize the segments and analyze the behaviors of each group.
Tools/Datasets/Platforms:
- Tableau
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your segmentation analysis.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 8: Calculating Business Metrics with Excel
Problem Statement:
Calculate key business metrics like ROI, profit margins, and customer lifetime value using Excel.
Steps to Complete:
- Import a relevant dataset (e.g., marketing campaign data).
- Use Excel formulas to calculate the required business metrics.
- Analyze the performance of the business based on these metrics.
Tools/Datasets/Platforms:
- Excel
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your calculations.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 9: Sentiment Analysis on Customer Feedback
Problem Statement:
Perform sentiment analysis on customer reviews or feedback to determine overall customer sentiment.
Steps to Complete:
- Collect customer feedback data (can be a sample or from your own source).
- Use a sentiment analysis tool (e.g., Excel add-ons or Python libraries).
- Categorize the feedback into positive, negative, or neutral sentiments.
Tools/Datasets/Platforms:
- Excel, or Python libraries like NLTK
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your analysis.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 10: ETL Process with Power BI
Problem Statement:
Extract, transform, and load (ETL) business data using Power BI.
Steps to Complete:
- Extract data from a source (e.g., an Excel sheet or SQL database).
- Clean and transform the data using Power BI’s data transformation features.
- Load the transformed data into Power BI and visualize it.
Tools/Datasets/Platforms:
- Power BI
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your ETL process.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 11: Advanced Data Visualization in Tableau
Problem Statement:
Create advanced visualizations in Tableau to analyze complex business datasets.
Steps to Complete:
- Import a complex dataset (e.g., financial or operations data).
- Create advanced visualizations like heat maps, scatter plots, and geographical maps.
- Analyze the dataset to find actionable insights.
Tools/Datasets/Platforms:
- Tableau
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your visualization.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Task 12: A/B Testing with Excel
Problem Statement:
Run an A/B test on a marketing or business scenario to compare different strategies.
Steps to Complete:
- Collect data for two different strategies (e.g., different marketing campaigns).
- Use Excel to analyze the data and compare the performance of each strategy.
- Summarize your findings and make a recommendation.
Tools/Datasets/Platforms:
- Excel
You can use any tool/data.
How to Submit:
- Record a video/screen recording of your A/B test.
- Upload the video to LinkedIn or YouTube.
- Tag the following in your post:
- Submit the link in the submission form.
Conclusion:
This set of tasks will help you build essential skills in business analytics, from data cleaning to visualization and forecasting. Complete as many tasks as you can to gain hands-on experience!