TechnologyTechnologyBeginnerTrending Members only
Data Analytics with Excel & SQL
Turn business data into answers with Excel and SQL, from clean data to clear dashboards.
4 weeks
Free for members
Members only · included with the membership card
Get membership card
Members only · free with the membership card
4 weeks of content
Access on mobile and desktop
Lifetime access after enrolment
Community access and peer learning
What you'll learn
Follow the analytics process and prepare clean, reliable data in Excel.
Use conditional formulas, lookups and pivot tables to answer business questions.
Understand relational databases and write SQL queries to filter, sort and summarise data.
Combine tables with joins, build a clear Excel dashboard and present a data-backed recommendation.
Curriculum
1Week 1
Analytics Foundations and Clean Data
5 lessons
Week 1
Analytics Foundations and Clean Data
The Data Analytics Process
Setting Up Spreadsheets the Right Way
Cleaning Data in Excel
Week 1 Quiz
Week 1 Assignment
2Week 2
Analysing Data in Excel
5 lessons
Week 2
Analysing Data in Excel
Formulas Analysts Use Every Day
Lookups: Bringing Data Together with XLOOKUP
Pivot Tables: Summaries in Seconds
Week 2 Quiz
Week 2 Assignment
3Week 3
SQL Basics
5 lessons
Week 3
SQL Basics
Databases, Tables and Keys
SELECT, WHERE and ORDER BY
Summarising with GROUP BY and Aggregates
Week 3 Quiz
Week 3 Assignment
4Week 4
Joins, Dashboards and Insights
5 lessons
Week 4
Joins, Dashboards and Insights
Combining Tables with JOIN
Building a Clear Excel Dashboard
From Analysis to Recommendation
Week 4 Quiz
Week 4 Assignment
About this course
Learn the full analytics workflow used by Indian companies: ask the right question, clean messy data in Excel, analyse it with formulas, lookups and pivot tables, query databases with SQL, and present a dashboard and recommendation that managers act on.
Requirements
- Basic computer skills
- Microsoft Excel or Google Sheets
- No prior SQL or programming needed
Who is this for
- Students aiming for analyst roles
- Professionals who work with reports and spreadsheets
- Career switchers moving into data
Free for members
Get membership card
Members only · free with the membership card
4 weeks of expert content
Hands-on projects & assignments
Lifetime access
Mobile & desktop access
Get membership card
Members only · free with the membership card