Build a foundation in working with data, organising information and communicating findings
Develop job-oriented data analysis skills using spreadsheets, Python libraries, SQL and Power BI to clean, analyse and present real-world datasets.
Curriculum
Suggested expanded practical course outline
Advanced Excel: formulas, functions and data validation
Advanced Excel: sorting, filtering, tables and conditional formatting
PivotTables, PivotCharts and interactive dashboards
Data cleaning and analysis in Excel
Python programming for data analysis
NumPy: arrays and numerical operations
Pandas: Series, DataFrames and data cleaning
Matplotlib: charts and data visualisation
SQL: queries, filtering, sorting and aggregation
SQL: joins, subqueries and working with relational data
Power BI: data import and Power Query
Power BI data modelling, DAX basics and visual reports
Business case studies, practical datasets and portfolio project
Career:
IT & ITES
Banking
Retail
FMCG
Operations teams
Industy Hiring
Explore the roles and sectors this course may support.
Junior Data Analyst
MIS Executive
Reporting Assistant
Data Entry / Quality Assistant
This expanded outline is a proposed course structure. Please confirm the final syllabus, software versions, duration, fees and project requirements with the institute. For more details about the complete syllabus, fees, batches, eligibility and admission, please contact the institute.
