Tools and first-week setup

The tools a Data Analytics intern uses and how to set up your workspace in week one.

These are the main tools for Data Analytics tasks. You do not need all of them on day one; the Level 1 tasks tell you when to install each one.

Set up your workspace

Create a free GitHub account if you do not have one, with a professional username, and set up your LinkedIn profile: every task is submitted with a LinkedIn post.
Create one repository for the internship, for example data-analytics-internship, with a README that says who you are and what the repo holds.
Keep one folder per task, named with the task number and title, so mentors find your work quickly.
Commit small changes every day with clear messages. Your daily work report uses these commits as proof.
Never commit passwords, API keys or personal data. Put secrets in a .env file and add it to .gitignore.

Task	What to do
Excel essentials	Clean a messy sales sheet: remove duplicates, fix dates, split columns and use VLOOKUP/XLOOKUP. Share before/after files.
Pivot tables	Answer 8 business questions (top products, monthly trend, region share) with pivot tables and charts.
Descriptive statistics	Calculate mean, median, mode, standard deviation and percentiles for a dataset and explain what each tells you.
SQL basics	Write 20 queries on a sample sales database: filters, sorting, GROUP BY, HAVING and aggregates.