Bremen, Germany hashmat@bahadari.de bahadari.de

Data

Data cleansing and migration

Scattered, inconsistent spreadsheets become a clean data foundation for apps and automation.

Data flow: cleansing and migration
SourcesPower QueryUsageExcel file AExcel file BCSV-Exportappendsplit, typeremove duplicatesvalidateSharePointlistPower AppsPower AutomateReports

Typical situation

Master data sits in several Excel files with different columns, duplicates and multiple values per cell. Nothing can be automated on top of that.

Solution

  1. MergeAppend sources with Power Query and align them to one schema.
  2. Split and typeMultiple values into separate rows, names and addresses into separate columns.
  3. ValidateRemove duplicates, check required fields, clear ghost rows.
  4. MigrateImport as a formatted table into a SharePoint list with suitable column types.

Benefits

  • One reliable data source
  • Foundation for apps, flows and reports
  • Repeatable when new data arrives

Technical detail

Power Query (append queries, split column by delimiter, data types), checking the true last used range, import via “List from Excel”.

Let’s talk about your IT.

In a free 30-minute call we clarify where you stand and what’s worth doing.

Book an appointmentSend an email