Data Analysis (Excel + SQL + Power BI)

Excel for Everyday Business Analysis;
– Clean and organize messy data fast (Remove duplicates, Text to Columns, Flash Fill)
– VLOOKUP, XLOOKUP, and INDEX/MATCH made simple
– PivotTables & PivotCharts (grouping dates, top 10 lists, % of total)
– Power Query basics: combine multiple files, unpivot, append data
– Real files you’ll actually see at work (sales reports, CRM exports, expense sheets)

Power BI – Build Dashboards People Love;
– Import and clean data directly in Power BI
– Create relationships between tables (drag-and-drop)
– Easy DAX: calculated columns, simple measures, Year-to-Date totals
– Build clean, interactive dashboards (slicers, drill-down, tooltips)
– Publish to Power BI Service and share links securely

Data Storytelling & Presentation;
– Turn numbers into clear recommendations
– Dashboard best practices (less clutter, smart colors, mobile view)
– Add titles, annotations, and one-click filters
– Export PDFs and record quick walkthrough videos (Loom)

Real-World Mini Projects;
– Sales performance dashboard
– Marketing campaign tracker
– Customer support KPI report
– Monthly operations summary

Get Hired as an Analyst;
– Build a simple portfolio (3 dashboards + short explanations)
– Analyst-friendly resume template & LinkedIn tips
– Where to find junior analyst jobs (job boards + companies that hire beginners)
– Most common interview questions + model answers