WSQ Create interactive Dashboard in Excel
About This Course
This course is designed for individuals who want to develop data analysis and business intelligence skills using Microsoft Excel as a primary tool and prepare learners for roles where they can leverage data to make informed decisions and drive business growth. The objective of this course is to enable learners to implementing data analytics within the organisation to generate business insights and intelligence through the use of statistical and computational techniques and tools, algorithms, predictive data modelling and data visualisation.
What You'll Learn
LO1: Use data analytics tools and techniques to visualise trends and patterns according to data modelling principles
LO2: Apply data cleansing techniques and quality check to transform them into digestible data sets
LO3: Compute database queries according to data protection standards to extract relevant data across multiple sources
LO4: Analyse distinct data sets with defined statistical techniques and machine learning methods
LO5: Develop performance dashboards and insight reports by integrating functional languages to derive business insights
LO6: Optimise PivotTables in Excel to generate dynamic business insight reports tailored to specific domain contexts
LO7: Employ PivotCharts in Excel to merge data from diverse structures with interactive reporting features for presentation of business insights
Entry Requirements
Minimum Entry Requirements
Learner should have Secondary education and basic computer skills
Learner without the minimum educational profile but have relevant minimum 1 year working experience can be consider on a case by case basis.