7 Fundamental Steps to Complete a Data Project

Data Basics Alivia Smith

It's hard to know where to start once you’ve decided that yes, you want to dive into the fascinating world of data and AI. Just looking at all the technologies you have to understand and all the tools you’re supposed to master is enough to make your dizzy.

Well, luckily for you, building your first data project is actually not as hard as it seems. And yes, starting on a tool that is designed to empower people of all backgrounds and levels of expertise such as Dataiku helps, but first you need to understand the data science process itself. Becoming data-powered is first and foremost about learning the basic steps and following them to go from raw data to building a machine learning model, and ultimately to operationalization.

The following is our take on the fundamental steps of a data project in this awesome age of AI, machine learning and big data!

Step 1: Understand the Business

Business goal in data projectUnderstanding the business or activity that your data project is part of is key to ensuring its success. To motivate the different actors necessary to getting your project from design to production, your project must be the answer to a clear organizational need. So before you even think about the data, go out and talk to the people in your organization whose processes or whose business you aim to improve with data. Then sit down to define a timeline and concrete key performance indicators. I know, planning and processes seem boring, but in the end, they are an essential first step to kickstart your data initiative!

If you’re working on a personal project, playing around with a dataset or an API, this step may seem irrelevant. It’s not. Simply downloading a cool open data set is not enough. In order to have motivation, direction and purpose, you have to fix yourself a clear objective of what you want to do with data: a concrete question to answer, a product to build, etc.

Step 2: Get Your Data

getting data in data projectOnce you’ve gotten your goal figured out, it’s time to start looking for your data. Mixing and merging data from as many data sources as possible is what makes a data project great, so look as far as possible.

Here are a few ways to get yourself some data:

Connect to a database: ask your data and IT teams for the data that’s available, or open your private database up, and start digging through it to understand what information your company has been collecting.

Use APIs: think of the APIs to all the tools your company’s been using, and the data these guys have been collecting. You have to work on getting these all set up so you can use those email open/click stats, the information your sales team put in Pipedrive or Salesforce, the support ticket somebody submitted, etc. If you’re not an expert coder, plugins in DSS give you lots of possibilities to bring in external data!

Look for open data: the Internet is full of datasets to enrich what you have with extra information; census data will help you add the average revenue for the district where your user lives, or open street maps can show you how many coffee shops are on his street. A lot of countries have open data platforms (like data gov in the US). If you're working on a fun project outside of work, these open data sets are also an incredible resource!

Step 3: Explore and clean your data

(AKA the dreaded data prep step that typically takes up to 80% of the time dedicated to a data project)

data cleaning in data projectOnce you’ve gotten your data, it’s time to get to work on it. Start digging to see what you’ve got and how you can link everything together to answer your original goal. Start taking notes on your first analyses, and ask questions to business people, or the IT guys, to understand what all your variables mean.

The next step (and by far the most dreaded one) is cleaning your data. You’ve probably noticed that even though you have a country feature for instance, you’ve got different spellings, or even missing data. It’s time to look at every one of your columns to make sure your data is homogeneous and clean.

Warning! This is probably the longest, most annoying step of your data project. Data scientists report data cleaning can take up to 80% of the time spent working on a project. So it's going to suck a little bit, but as long as you keep focused on the final goal, you’ll get through it.

Finally, one crucially important element of data preparation not to overlook is to make sure that your data and your project are compliant with data privacy regulations. Personal data privacy and protection is becoming a priority for users, organizations and legislators alike, and it should be one for you from the very start of your data journey. In order to execute privacy compliant projects, you’ll need to centralize all your data efforts, sources and datasets into one place or tool to facilitate governance. Then you’ll need to clearly tag datasets and projects that contain personal and/or sensitive data and would need to be treated differently.


Step 4: Enrich your dataset

enriching in data projectNow that you’ve got clean data, it’s time to manipulate it in order to get the most value out of it. You should start by joining all your different sources and group logs to narrow your data down to the essential features.

One example of that is to enrich your data by creating time-based features, such as:
Extracting date components (month, hour, day of week, week of year, etc.);
Calculating differences between date columns;
Flagging national holidays, etc.

Another way of enriching data can be done through joining datasets - essentially, retrieving columns from one dataset or tab into a reference dataset. This is a key element of any analysis, but it can quickly become a nightmare when you have an abundance of sources. Luckily, some tools such as Dataiku allow you to blend data through a simplified process, by easily retrieving data or joining datasets based on specific, fine-tuned criteria.

When collecting, preparing and manipulating your data, you need to be extra careful not to insert unintended bias or other undesirable patterns into it. Indeed, the data that is used in building machine learning models and AI algorithms is often a representation of the outside world, and thus can be deeply biased against certain groups and individuals. But one of the things that make people fear data and AI the most is that the algorithm isn’t able to recognize bias. So when you train your model on biased data, it will interpret recurring bias as a decision to reproduce and not something to correct.

This is why an important part of the data manipulation process is making sure that the used datasets aren’t reproducing or reinforcing any bias that could lead to biased, unjust or unfair outputs. Accounting for the machine learning model’s decision-making process and being able to interpret it is nowadays as important a quality for a data scientist, if not even more, as being able to build models in the first place.


Step 5: Build visualizations

building insights and graphs in data projectYou now have a nice dataset (or maybe several), so this is a good time to start exploring it by building graphs. When you’re dealing with large volumes of data, visualization is the best way to explore and communicate your findings.

The tricky part here is to be able to dig into your graphs at any time and answer any question someone would have about a given insight. That’s when the data preparation comes in handy: you’re the guy or gal who did all the dirty work, so you know the data like the palm of your hand!

giphyIf this is the final step of your project, it’s important to use APIs and plugins so you can push those insights to where your end users want to have them.

Graphs are also another way to enrich your dataset and develop more interesting features. For example, by putting your data points on a map you could perhaps notice that specific geographic zones are more telling than specific countries or cities.

Step 6: Get Predictive

building insights and graphs in data projectThis is when the real fun starts. Machine learning algorithms can help you go a step further into getting insights and predicting future trends.

By working with clustering algorithms (aka unsupervised), you can build models to uncover trends in the data that were not distinguishable in graphs and stats. These create groups of similar events (or clusters) and more or less explicitly express what feature is decisive in these results.

More advanced data scientists can go even further and predict future trends with supervised algorithms. By analyzing past data, they find features that have impacted past trends, and use them to build predictions. More than just gaining knowledge, this final step can lead to building whole new products and processes.

Even if you’re not quite there yet in your personal data journey or that of your organization, it’s important to understand the process so all the parties involved will be able to understand what comes out in the end.

Finally, in order to realize real value from your project, your predictive model must not sit on the shelf; it needs to be operationalized. Operationalization (o16n) simply means deploying a machine learning model for use across an organization. Operationalization is vital for your organization and for you to realize the full benefits of your data science efforts.

Capture d’écran 2019-07-04 à 18.20.17

Step 7: Iterate

building insights and graphs in data projectThe main goal in any business project is to prove its effectiveness as fast as possible to justify, well, your job. The same goes for data projects. By gaining time on data cleaning and enriching, you can go to the end of the project fast and get your first results.

According to O’Reilly, one of the biggest mistakes that people make with regard to machine learning is thinking that once a model is built and goes live, it will continue working as normal indefinitely. On the contrary, models will actually degrade in quality over time if they’re not continuously improved and fed new data.

Ironically, in order to successfully complete your first data project, you need to recognize that your model will never be fully “complete” - in order for it to remain useful and accurate, you need to constantly reevaluate, retrain it and develop new features. A data scientist’s job is never really done, but that’s what makes working with data all the more fascinating! 

the dataiku data process

Once you’ve mastered all the basics of completing data projects and building ML models, why not automate the process and save even more time?

Learn how by downloading the AutoML white paper!

Let's go >

You May Also Like

On Ethical Data Science & Dropping the Best Model Approach

Read More

Meet Cyprien, Dataiku’s Youngest Certified User

Read More

5 Pieces of Good News for Data Analysts in 2020

Read More