• Introduction to data analytics
• Introduction to Excel and its formulas
• Understand, interpret and apply basic descriptive statistics
• Aggregating data
• Create basic visualisations
• Understand and interpret frequency distributions
• Introduction to exploratory analysis using Pivot tables
• Misleading statistics and how to avoid them
• Introduction to data analytics
• Transforming data, including cleaning and joining data
• Using exploratory analysis to identify trends and check hypothesis
• Use Power Query to transform data gathered from different sources
• Calculate and interpret measures of spread, including quartiles, percentiles and standard deviation
• Create powerful visualisations and interactive dashboards
• Understand correlation and how to effectively visualise it
• Storytelling with data
• Understand the uses and scope of PowerBI
• Calculated fields, sets and groups