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

Author: Tim

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
Business Frameworks - Frameworks for Data Insight

Two Powerful Frameworks for Finding Data Insight

1 Comment

Many times I’ve worked with a business to ‘find insight’ from their data. I use a wide range of techniques.…

Continue Reading →

Posted in: Actionable Insights Filed under: Actionable Insight, Data Analytics, Data insight, Data Strategy
Dynamic Dropdowns in Excel and VBA

Amaze your boss with dynamic cascading dropdowns in Excel

4d Comments

To improve the quality of data and reduce the likelihood of errors dropdowns in Excel can be a good choice.…

Continue Reading →

Posted in: Excel VBA Filed under: Data Tactics, Excel 2016, Excel Dropdowns, Excel VBA
Extracting Data Directly from PDFs with Tableau using an IMAX example

Save time by extracting Data directly from PDFs with Tableau

4d Comments

Information is everywhere and sometimes that information is in a PDF. Perhaps some historic reporting or something interesting from the…

Continue Reading →

Posted in: Tableau Visualization Filed under: Data Analytics, Extract Data from PDF, Tableau, Tableau Visualization, visualization
Visualizing survey data in Tableau

Turn boring survey results into powerful interactive visualizations with Tableau

5d Comments

Surveys… simple yet capable of unlocking amazing insight. Visualizing survey data using a tool like Tableau and making those visualizations…

Continue Reading →

Posted in: Tableau Visualization Filed under: survey, Tableau, visualization, Visualization Insight
A Questions Framework can help ensure your're looking in the right Haystack

How to use Question Frameworks to discover critical business insight

5d Comments

Given the volume of data, the task of finding actionable insight is daunting. Where to start. Using a Questions Framework…

Continue Reading →

Posted in: Actionable Insights Filed under: Actionable Insight, Business Intelligence, Data insight, Question Framework
Excel VBA to load CSV Files

Learn how to automate the loading and formatting of CSV files with clever Excel VBA

18d Comments

We’ve all seen countless .csv files.  They’re great… sometimes.  But many times the .csv file is not quite what is…

Continue Reading →

Posted in: Excel VBA Filed under: Automating CSV, Excel 2016, Excel VBA

Post navigation

Page 2 of 3
← Previous 1 2 3 Next →

Join the Data Insights Newsletter

Copyright © 2025 Data Insight Consulting