Managing Data for Business Insights
Leverage business data to improve productivity and increase profitability. Learn to get actionable insight into your organisation with our intensive course for business professionals.
Data innovation adds £20bn to the Scottish economy, and 55% of businesses in Scotland require data analytics skills.* Delivered across two structured modules, Managing Data for Business Insights involves three or six weeks of classes with up to two optional project weeks that will allow you to drive value from your own business data. Data literacy is a key skillset that will enable you and your team to manage data and access clear business insights from it. The value from your data will then help improve decision-making and operations. Available now through virtual learning.
*Sources: ScotlandIS, Scottish Enterprise
Module 1: Three weeks in class plus optional project week
At the end of Module 1, you will be able to access, clean, and analyse business data. Working more effectively you can efficiently manage datasets that will empower your learning and improve your decision-making. The course introduces best practice in data coding, version control, reproducibility and data ethics.
Week 01: Intro to data programming
- Unix, Git and Github
- Intro to R & R Studio (vectors, data structures)
- Coding best practices
- Control flow and functions
Week 02: Managing sources of data
- Reading and loading data
- Intro to SQL
- Connecting and writing to PostGres SQL
- Connecting R to databases
- Postico, Advanced SQL
- Table relationships and joins
- JSON and lists
- Data management and governance
Week 03: Manipulating data
- Intro to Tidyverse
- Manipulating data in R using dplyr
- Data cleaning
- Outliers and missing values
- Strings and regular expressions in R
Project Week (Week 4): Ethics and Dirty Data
- Present short presentation on ethics
- Dirty data project: clean, organise and analyse messy data
Module 2: Three weeks in class plus optional project week
Now that you have learned how to clean, organise and manipulate data you need to learn how to create powerful visualisations to provide insights and tell a story. In Module 2, you will learn how to choose the right visualisation for your data, and become proficient in data visualisation and communication using R. You will gain a strong foundation in descriptive and inferential statistics, and complete some advanced topics such as time series analysis and spatial analysis. You finish up the module by learning how to design and building interactive dashboards in R Shiny, and be able to complete a half day Tableau workshop. You will then have a chance to apply your skills in a group project which involves building a dashboard in R Shiny to satisfy a client brief. The group project also involves collaborative development using Git and Github, which is a key skill for coding in a team.
Week 01: Visualising Data
- Plotting in R with ggplot2
- Creating dashboards in Shiny
- Learn how to choose the right plot for your data
- How to create effective and engaging plots
Week 02: Probability and Statistics
- Descriptive statistics
- Inferential statistics
Week 03: Data Through Time
- Time and spatial analysis
- Synthetic data
- Dashboard design
- Data Storytelling
Project Week (Week 4): Dashboard Project
- Building a dashboard in R Shiny
- Collaborative development work with Git and GitHub
A typical day
Here’s what your day will look like while you train in our virtual classroom.
All the students and instructors meet for a daily stand up, and to do a review of the homework from the previous night.
Our Virtual Learning Experience simulates a classroom-based environment. Lessons are interactive, with instructor led live coding and student participation. The live lessons are also recorded and available for review afterwards.
A break for lunch so that students can take a breather, socialise and have some food.
Lessons continue in the afternoon, with some days involving afternoon lab work and others focusing more on additional teaching time.
The day recap is completed and students have an opportunity to start their homework.
Who is this course for?
This course is ideal for professionals from a wide range of business types and sizes, and leaders who currently utilise data or want to move to a data-led approach. As workplaces transition to digital, organisations need to become more flexible to adapt more quickly and leverage their ever-growing data resources to prepare for the future.
- Businesses currently working with spreadsheets
- All commercial sector
- Financial services, business analysts
- Leaders who want to derive more value from data and make more informed decisions
“It doesn’t matter how much experience you have with a computer, anyone can learn. I’m amazed at what I can do now.” Delphine, Data Analysis graduate
CodeClan instructors have lots of cross-industry experience, and are on-hand throughout the day to answer your questions.
“Data is one of the most exciting places to be.”
Del has a degree in physics and PhD in computational chemistry, has worked as a researcher and teacher at The Universities of Cambridge, Glasgow, Warwick and Stony Brook (USA), and as a software developer in Edinburgh.
“Data is not just boring spreadsheets.”
Steph has a PhD in cognitive neuroscience, has worked as a researcher and data analysis teacher at the University of Glasgow and UC Berkeley, and has spent time working in the pharmaceutical industry in Edinburgh as a lead data analyst.
“Now is a great time to get into data.”
Aileen has a degree in mathematics and statistics and a masters in actuarial maths. She qualified as an Associate actuary while working in investments and pensions before moving into analytical consulting. She is passionate about data for social impact and in the third sector.
Mhairi has a degree in mathematics and a masters in applied statistics and data mining. She has worked as a data scientist in a range of different industries. She now splits her time between teaching and doing freelance data science work.
Mandy has a degree in psychology with an emphasis on research methods, statistics and data analysis. She is passionate about the visualisation and communication of data.
These cohorts are open to everyone based in the UK, and we regularly announce new course dates.
|Location||Pre-course work||Classes start|
|Location||Pre-course work||Classes start|
*These cohorts will be delivered through CodeClan’s Virtual Interactive Learning Experience and available to complete remotely
Funding & Costs
Module 1: £3,000
Module 2: £3,000
Modules 1 and 2: £5,500*
*You must have completed the module 1 to continue on to module 2
A deposit of £750 is payable to secure your place once you are accepted, with the remaining fees due before the course begins.
Funding option for businesses in Scotland
The Digital Development Loan was created by the Scottish Government to provide loans to companies who wish to improve their digital capabilities and capacity. The loan also covers staff digital skills development as part of the Scottish Government’s drive to improve economic productivity.
Your laptop must be a MacBook Pro with least 8GB RAM and comfortably run the latest operating system. If your laptop is older than 2014 please check with Admissions to see if it is suitable to use. If you would like to hire a laptop from CodeClan, there is a rental fee of £150.