Showcase
Comparing two transactional datasets to identify differences
How do I structure a large dataset comparison project to illustrate transactional differences? Electronic systems, such as enterprise resource planning (ERP), capture data generated in business processes. There is often more than one system measuring the same but slightly varied facts about a process. Transactional systems provide us with a …
Empower decision-makers with fit-for-purpose information!
The art of decision support. An analytics project is constructed on the foundation of understanding the decisions users need to make. These decisions are data-driven and rely on information from fundamental systems or procedures. It is ideal for this data to be captured on a system; however, it often requires …
The business value of open access to data
Finding shared value in public-private data initiatives. In 1998, Al Gore, the then Vice President of the United States, delivered a speech about Digital Earth. This speech paved the way for a new business model for the data economy, where public access to information is funded through private sector business …
Boost your analytic workflow with Python and online web services!
How I automate vessel tracking to determine the last date a vessel sailed from a country. One of my favourite project types is integrating various data sources into one result set, especially when using external data with a well-known data set. It excites me to see how complementary data sets …
How to supercharge your budget with Google Sheets, Python, and SQL
Spreadsheet software, such as Microsoft Excel and Google Sheets, is a business necessity. It is a staple of planning, budgeting, and analysis, suitable for business areas where technological maturity is still developing. The latter is evident in emerging business areas or when exploring novel data acquisition methods. In these instances, …