Data Analyst Career Starter Pack: Excel, SQL, Power BI Projects + Portfolio Templates

Description

Want to become a Data Analyst? Start building practical projects instead of just watching tutorials.

The Factsbay Data Analyst Career Starter Pack takes you from “I know some Excel” to a job-ready portfolio in 60 days. You practise on realistic business datasets, solve real interview questions and finish with projects you can show recruiters.

What’s inside

• 📗 Excel: 20 practical exercises on an 11,000-row sales dataset, with a practice workbook and a solutions workbook containing working formulas
• 🗄️ SQL: 100 interview questions and queries, each with a tested query and its expected output, plus a ready-to-use database (SQLite, MySQL and PostgreSQL)
• 📊 Power BI: 5 dashboard projects (Sales, Customer Churn, Marketing ROI, HR Attrition, RFM & Delivery Ops), each with its data model, DAX measures and page layout
• 🧩 5 practical case studies with answer keys and model recommendations
• 🎤 45 data analyst scenario interview questions with model answers and HR-round prep
• 💼 Ready-to-edit portfolio templates: portfolio website, ATS-friendly resume (Word), GitHub README and LinkedIn profile + post templates
• 🗺️ 60-day learning roadmap with an Excel progress tracker and job-application tracker
• 📁 10 sample datasets (sales, customers, products, HR, marketing, telecom churn and a messy file for cleaning practice)

Who it’s for

• Graduates and freshers who need projects to show in place of experience
• IT employees moving into analytics
• Career switchers from sales, finance, operations or teaching
• Anyone preparing for a data analyst interview

Why this pack is different

• ✅ Every SQL answer is tested, and its expected output is shown so you know when you’re right
• ✅ Case-study answer keys are calculated from the actual data
• ✅ Realistic Indian business data: ₹, Indian cities, festive-season sales, LPA salaries
• ✅ Every project ends with a portfolio write-up and a resume bullet

What you’ll receive

An instant-download ZIP file (about 6 MB) containing PDFs, Excel workbooks, CSV datasets, SQL files, a Word resume template and an HTML website template.

Software needed: Microsoft Excel (2016 or later), DB Browser for SQLite (free) and Power BI Desktop (free, Windows).

New to analytics? Read more on our Factsbay blog. Power BI Desktop is free from Microsoft.

FAQ

Do I need prior experience? No. Excel and SQL start from the basics.
Can I use the projects in my portfolio? Yes. That’s what they’re designed for.
Is this a video course? No. It’s a hands-on practice pack: you learn by building.

Licensed for personal use only. Datasets are fictional and created for practice.