Data Analytics

Overview

Making sense of new data is vital to allow organisations to carry out business, respond to changes, and take advantage of new opportunities. In this module, you will study data quality and learn how to apply data quality measures to real-life data sets. This training course provides a hands-on introduction to gaining the skills to practise professional data analysis strategies and techniques that can be applied in a multitude of different environments. 

 

Course Overview

Week 1

• Overview – sources of data, traditional/structured vs. non-traditional/unstructured
• Assessment brief

Week 2

• Consequences of poor data quality
• Decision-making processes within organisations

Week 3

• Using data to support decisions and discussion of outliers
• Data cleansing, formatting and filtering techniques

Week 4

• Data cleansing, Extract-Transform-Load / Extract-Load-Transform processes, mapped to CrispDM 

Week 5

• Introduction to WEKA
• Association Rule Mining using Apriori in WEKA

Week 6

• Clustering using WEKA to underpin theory 

Week 7

• Exploring issues with big data 

Week 8

• Data visualisation
• Basic excel charts to aid visualisation

Week 9

• Discussion on cloud data analytics 

Week 10

• Dashboards, design issues

Weeks 11- 13

• Assessment completion

 

Course aims

Data analysis is only as good as the data sources and understanding of the tools and techniques needed to maximise the use of existing company data.

Part of this course will examine what data is, how to process data into information and hopefully leave the organisation with knowledge and wisdom.

 

Benefits

Many organisations have vast databases/data sets with a limited understanding of what to do with the data, so this course will highlight how to improve the quality of data and what type of decisions could be made with basic company data. With better data and the correct tools, better decisions could be made.

The learner will be exposed to data in all its forms and processes to ensure that data is fit for its purpose. They will also be exposed to tools that could aid with decision-making, along with issues with respect to big data and cloud data analytics.

 

Award

After completing this course, you will receive 20 free credits which can then be used for future learning.

 

Funding

The Staffordshire E-Skills & Entrepreneurship Gateway (SEGway) is part funded by the European Social Fund.