Data Project Fundamentals: Skills and Techniques for Success

A hands-on guide to data projects from start to finish and beyond! Data profiling, modelling, unit testing and more!

This course aims to highlight the key skills that will make you stand out as a rounded Data Professional. You will cover the techniques, challenges and approaches undertaken in each of the logical stages of a data project. You will cover Data Profiling; Data Mapping and Transformation; Development; Data Modelling; Data Solution Design; Software Design; Unit Testing and Troubleshooting. The course aims to follow the natural life-cycle of a project.

What you’ll learn

  • Gain a comprehensive overview of the skills, thought processes and complexities that accompany a data-related task or project.
  • Discover the benefits of data profiling and unit testing.
  • Learn the techniques, challenges and approaches undertaken in each of the logical stages of a data project.
  • Learn the fundamentals of Structured Query Language with easy-to-follow examples and exercises.
  • Learn how applying the techniques in each phase of a data project leads to more robust, successful and maintainable solutions!.
  • Work with the course data using Jupyter Notebooks to back up the course concepts.
  • Appreciate the fundamentals of data modelling including Dimensional Modelling and Entity Relationship Diagrams.

Course Content

  • Course Introduction: Data Project Fundamentals –> 2 lectures • 11min.
  • Course Data and Code Download –> 1 lecture • 1min.
  • Introduction to Data Profiling –> 4 lectures • 18min.
  • Setting Up and Using Jupyter Notebooks –> 4 lectures • 20min.
  • Further Data Profiling, Data Mapping & Data Transformation –> 5 lectures • 50min.
  • Development –> 6 lectures • 51min.
  • Data Modelling –> 4 lectures • 31min.
  • Data Solution Design (Data Only) –> 8 lectures • 50min.
  • Software Design –> 3 lectures • 36min.
  • Testing and Troubleshooting –> 5 lectures • 34min.
  • Implementing Changes –> 3 lectures • 17min.
  • Wrap Up –> 1 lecture • 1min.

Auto Draft

Requirements

  • An understanding of 2-dimensional data structures and basic programming constructs, ideally some python, but this isn’t essential.
  • A willingness to challenge existing thought processes and ways of working!.

This course aims to highlight the key skills that will make you stand out as a rounded Data Professional. You will cover the techniques, challenges and approaches undertaken in each of the logical stages of a data project. You will cover Data Profiling; Data Mapping and Transformation; Development; Data Modelling; Data Solution Design; Software Design; Unit Testing and Troubleshooting. The course aims to follow the natural life-cycle of a project.

These topics will be demonstrated by a mixture of lectures, screencasts, quizzes and exercises. Practical retail data will bring it all to life with Python and Jupyter Notebooks used to illustrate the techniques.  Although Jupyter notebooks are used, a running them in the course is that it is not important how certain techniques are done, but that these techniques are understood and why they form a key part of the process.  So although the hands-on sections will definitely enhance the course experience they are not a prerequisite, and could also be tackled using alternative software.

Ultimately this course aims to fill the gaps between courses focused on specific programming, data analysis skills or data modelling skills. It should allow you to appreciate but also critically question your current data environment.  I believe this course offers something different and will make you stand back and think before heading full-steam into a data-related task.  This more complete understanding of Data Projects will make you a better, more rounded Data Professional.  Enjoy!

Get Tutorial