InternshipTools and first-week setup
The tools a Business Intelligence intern uses and how to set up your workspace in week one.
These are the main tools for Business Intelligence tasks. You do not need all of them on day one; the Level 1 tasks tell you when to install each one.
- Excel
- SQL
- Power BI
- DAX
- Tableau Public
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 business-intelligence-bi-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.
Your first tasks
| Task | What to do |
|---|---|
| What BI is | Explain business intelligence, the difference between BI and data science, and three decisions BI helps a business make. |
| Excel essentials | Clean a messy sales sheet in Excel: remove duplicates, fix dates, split columns and use XLOOKUP. Share the before and after. |
| Pivot tables | Build pivot tables showing sales by region, month and product, with a pivot chart for each. |
| KPIs and metrics | Define 10 KPIs for a retail shop with formulas and explain which ones a manager would check daily. |