Data Analytics
Training Provider: SINGAPORE NATIONAL EMPLOYERS FEDERATION
Course Reference: TGS-2023037531
S$275
Original: S$550
Save S$275
About This Course
Understand the key concepts relating to the application of data analytics in business.
- Understand and apply key statistical analysis concepts.
- Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques.
- Summarise data sets using pivot tables and pivot charts.
- Understand and apply data visualization techniques and tools.
- Create and share reports and dashboards in a data visualization tool.
What You'll Learn
Identify the main phases of data analysis: business understanding, data understanding, data preparation, modelling, evaluation, deployment.
- Recognise data protection considerations when
- Recognise data protection considerations when analysing data like: anonymise personal data if possible, comply with applicable data protection regulations.
- Calculate the central tendency value of a data set using a function: mean, median, mode.
- Calculate the variation of a data set: quartile, variance, range.
- Import data into a spreadsheet application: .csv file, spreadsheet, website table, database table.
- Validate that given values belong to a reference data set using the vlookup function.
- Extract values from a string using text functions: left, right, len, mid, find.
- Format a data set as a built-in table.
- Change the method of aggregation for a value: sum, average, count, minimum, maximum.
- Display multiple aggregation values.
- Display values as: % calculation, difference from specific values, running total, ranked.
- Automatically, manually group data and rename groups.
- Ungroup data.
- Insert and use slicers to filter single, multiple pivot tables.
- Insert and filter a timeline.
- Insert a pivot chart for an existing pivot table.
- Create a pivot chart from fields in a data set.
- Understand the concept of data visualization using reports and dashboards. Outline common visualizations like: charts, key performance indicators (KPIs), maps.
- Recognise common data visualization tools and their functions like: visualise data, publish and share business intelligence.
- Import a data set from a spreadsheet into a data visualization tool and save the file.
- Create tables in a report.
- Visualise data as a chart: column, bar, line, pie.
- Apply, edit font and background conditional formatting to show: high/low values, above/below average values.
- Apply, edit data bars.
- Apply, edit visual leve
- Recognise data protection considerations when
- Recognise data protection considerations when analysing data like: anonymise personal data if possible, comply with applicable data protection regulations.
- Calculate the central tendency value of a data set using a function: mean, median, mode.
- Calculate the variation of a data set: quartile, variance, range.
- Import data into a spreadsheet application: .csv file, spreadsheet, website table, database table.
- Validate that given values belong to a reference data set using the vlookup function.
- Extract values from a string using text functions: left, right, len, mid, find.
- Format a data set as a built-in table.
- Change the method of aggregation for a value: sum, average, count, minimum, maximum.
- Display multiple aggregation values.
- Display values as: % calculation, difference from specific values, running total, ranked.
- Automatically, manually group data and rename groups.
- Ungroup data.
- Insert and use slicers to filter single, multiple pivot tables.
- Insert and filter a timeline.
- Insert a pivot chart for an existing pivot table.
- Create a pivot chart from fields in a data set.
- Understand the concept of data visualization using reports and dashboards. Outline common visualizations like: charts, key performance indicators (KPIs), maps.
- Recognise common data visualization tools and their functions like: visualise data, publish and share business intelligence.
- Import a data set from a spreadsheet into a data visualization tool and save the file.
- Create tables in a report.
- Visualise data as a chart: column, bar, line, pie.
- Apply, edit font and background conditional formatting to show: high/low values, above/below average values.
- Apply, edit data bars.
- Apply, edit visual leve
Entry Requirements
Have some basic skills in Excel and experience working with Excel at work.
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from SINGAPORE NATIONAL EMPLOYERS FEDERATION
This course will address the skills and knowledge required by assistant managers, supervisors and t...
This course will address the skills and knowledge required by assistant managers, supervisors and t...
1. Analyse environment, organi-sation and stakeholders to identify gaps for improvement
2. Develop ...