Data Analytics
- Data types
- Data Analytics overview
- Types of Data Analytics
- Data cleansing and imputation theory
- Graphical techniques
- Descriptive measures
Beginner
Data Analytics
Foundations in working with data, reporting and visualization.
01DA
LevelBeginner
Duration12 weeks
DeliveryLive online / in person
PracticeAssignments + capstone
Build practical capability, step by step.
Build a strong foundation in data analysis, statistics, spreadsheets, databases and business intelligence. The course connects analytical concepts with practical workflows so learners can examine information and communicate useful findings.
Who should join
- Students and fresh graduates
- Working professionals building data capability
- Career switchers moving into analytics roles
What you will gain
- Clean, explore and interpret structured data
- Apply statistical concepts to practical questions
- Build analysis workflows with Excel and SQL
- Create reports and dashboards in Power BI
What the course covers
Fundamental Statistics
- Data types
- Measures of central tendency and dispersion
- Sampling
- Confidence intervals and hypothesis testing
- Univariate, bivariate and multivariate relationships
- Correlation and regression
Excel
- Data structure
- Data handling, sorting and formatting
- Conditional formatting
- Analytical functions
- Table operations
- Pivot tables and aggregation
- Variance analysis
- What-if analysis
- Excel charts and add-on tools
SQL
- Introduction to SQL
- Foundation of tables
- Queries and manipulation
- Aggregation
- Joins and functions
- Subqueries with complex conditions
Power BI
- Data upload and manipulation
- Visualisation
- Reports and dashboards
- Publish workbooks
- Table relationships