data analytics Archives - PULSE INFOMATICS

Solving line breaks and other unstructured data when importing CSV files

I’m going to provide a sample text file and a sample Excel VBA macro file for you to test. You can find the download below. Structured Data is Nice but Not Always Possible It would nice if every system had the ability to export data in more structured formats, like XML or json, rather than […]

Moving From Excel to MS Access & SQL Server for Cleaning Up, Extracting, & Reporting on Data

Summary In our own work with data analytics, in coaching financial & business analysts, and with data conversions, we often coach clients to learn and use Microsoft Access or SQL Server, rather than (or perhaps more accurately, in conjunction with) Microsoft Excel. In this article, we explore some of the reasons why. “I suppose it […]