One of the most common activities in Alteryx is combining datasets together. In the business world, the data you want to analyse usually comes from more than one source, and you'll want to combine them to find the insights you need.
Read moreHugo Byrne
After creating any sort of financial model, you'll usually want to create some ratios or other metrics that analyse the figures you've produced. This is no different when modelling a leveraged buyout, or LBO. In a Read more
Alteryx and Tableau are two of the best known software products in the world of analytics. Both are used in many companies to obtain valuable insights from data. But what role does each of these products play in an organisation? Do the two products compete with each other or complement each ... Read more
Cash flows after a leveraged buyout can suffer as a result of taking on debt, the standard practice in the leveraged buyout (LBO) process. For the LBO to work, it's essential that the acquired company can afford the debt repayments that arise as a result of the transaction. This requires the ... Read more
Over the first four posts in this series, we’ve learned how to select charts, how to lay out a dashboard using those charts, and ... Read more
In a leveraged buyout using debt, one company purchases another using a significant amount of borrowed money to meet the cost of the acquisition. As a result, it is critically important that the company being acquired can afford to repay this debt in the future. Creating a debt schedule is ... Read more
Nowadays, we’re all probably desensitized to being spied on. Social networks store enormous amounts of data on us, generating light and heat online but nothing more. State sponsored surveillance, in the guise of “security” elicits little more than a ... Read more
In a corporate finance transaction, such as a Leveraged Buyout, a sources and uses table outlines all the sources of funding for the transaction, and all the uses of this funding. These two amounts should balance, indicating all the funding required to complete the transaction is ... Read more
In the last post on dashboards, we saw how to select the appropriate chart for a given situation. Now, we’ll move on to the next phase of the dashboard creation process, and learn how to lay out the ... Read more
Cloud computing has been a major growth area in the world of technology over the last decade or so. In our personal lives, we all use cloud-based Internet services, and store data on the cloud, probably without giving it any real thought at all. Yet for many businesses, the cloud is a place they ... Read more
Modeling a Leveraged Buyout (or LBO) in Excel is a process with several steps. The first step is to create transaction assumptions. Transaction assumptions help determine the actual funds required to complete the transaction. This can be quite different to the purchase price when fees and equity ... Read more