I know what you are thinking. I was thinking the same thing before I started using the combination of the Index and Match functions. Vlookup is a function that allows you to find a value in the left most column of a cell range and then return a value from a cell a certain number…
If you have a routine process that you are doing in Excel, using VBA is a great solution get things done faster. VBA allows you to automate these routine processes. The trick is that most of us learn how to write in VBA using Record Macro (on the Developer tab of Excel) and just copy/alter…
There are often numerous ways to write a particular query or stored procedure. In some cases, the approach makes little difference. Other times it can lead to poor performance that wreaks havoc on an application or service. Taking care as you go will help to avoid slowdowns and prevent the need for rework when query…
We’ve all used an application or visited a site with the need to do a specific task. Sometimes it goes well, and you’re done in no time. Mission accomplished and on to something else. Conversely, sometimes things are overcomplicated and confusing. Maybe you can’t find what you’re looking for or if you do it’s after…
Recurring data feeds, not to be confused with APIs, allow for the exchange of large datasets, to keep two entities in sync at a designated interval. APIs generally return a small amount of data in real time. Consider these use cases: Both parties will need to agree on: Next, automate the process according to the…
After a merger or acquisition, the desired software landscape often requires consolidation of information, a need to combine data from separate systems. To successfully complete such M&A conversions, you may need to apply the art of weaving to maintain integrity and meaning within the data. A crucial first step is to understand what’s already…
In today’s world, as the frequency of mergers & acquisitions increases, there’s a corresponding increase in the need to ingest large amounts of digital information, combining new business data with the old. Data sets are rarely alike between companies that have the same basic products or services – or even when they use the same…