Data Analysis - The process

The Data Analysis process can be complex, so the information below, has broken down the process to simplify the subject in layman's terms.

Importing Data (Extract the data)

Import the data into a format that is recognizable by programs such as Excel and Power Bi

Clean the Data

Add New Columns
Use Dax formulas
Spell checking
Remove Duplicate Rows
Find and Replace Text
Change Case of Text
Fix Date and Times
Merge, Spit and Join Data
Transform and rearrange columns and rows

Transform the data

Merge and Join Data
Rebuilding missing Data
Standardization
Normalization
De-duplication
Verification and Enrichment
Use Pivot and Unpivot tables for better visualization

Export/Upload the Data

Convert the Data File into a readable format, such as a PDF, Word file etc

What Our Clients Say

Mr Sean Cassey

Really fantastic service provided by Clean Data. Meticulous at every stage, couldn't ask for anymore. The results to my business has been outstanding with what seems to be an endless increase in sales and productivity . Spot on Clean Data