Skip to content
Data Insight Consulting
Finance, Operations and Business Intelligence Solutions
  • Home
  • About
    • Contact
    • Special
  • Data Strategy
  • T-SQL
  • Excel VBA
  • Tableau
  • Power BI
  • Blog

Tag: Process Automation

TSQL Merge Worked Example

Unlock T-SQL Merge Statements with this Worked Example

There are many scenarios where you need to update, delete or insert new records in a table. The T-SQL Merge…

Continue Reading →

Posted in: Business Intelligence, T-SQL Filed under: Data Analytics, Data Tactics, Process Automation, T-SQL
VBA to Automate Reporting from Multiple Files

Excel VBA to Consolidated Reporting with a Single Easy Click

2d Comments

Lots of staff, lots of work… lots of spreadsheets. This does not need to be a mess. Excel VBA to…

Continue Reading →

Posted in: Excel VBA Filed under: Data insight, Data Tactics, Excel 2016, Excel VBA, Process Automation
Excel VBA - Dynamically Creating Files

Watch Excel VBA create complex Excel files, reduce risk and improve quality

2d Comments

VBA can build tailored Apps As businesses evolve and develop, the need to track different information for clients, projects or…

Continue Reading →

Posted in: Excel VBA Filed under: Data Tactics, Excel 2016, Excel VBA, Process Automation, SME Businesses

Recent Posts

  • 3 Practical Tips using TSQL Windows Functions
  • A two-step Guide to making FP&A Awesome
  • Unlock T-SQL Merge Statements with this Worked Example

Recent Comments

  • Robyn on 3 Practical Tips using TSQL Windows Functions
  • Hasan on Turn boring survey results into powerful interactive visualizations with Tableau
  • Tim on Learn how to automate the loading and formatting of CSV files with clever Excel VBA

Join the Data Insights Newsletter

Copyright © 2025 Data Insight Consulting