Joining tables together is a common task in Alteryx. In this post, we’ll discuss how to combine tables horizontally using the Join tool. The Join tool is used to combine tables which are linked by a common field. It is slightly more complex than the Union tool that we saw in a previous post, but […]
In most countries, increasing quantities of public data are being made available, particularly by public organisations. This data can be useful to many businesses, as it can be combined with your own information to improve the quality of your analytics. This post will identify a few of the most useful public data sources fro businesses.
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.
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 leveraged buyout, a company will usually acquire a large amount of debt after being bought by another company. It’s […]
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 other? And should you […]
Online learning has come of age and its popularity shows no sign of slowing down. Having a virtual classroom at your fingertips is often ideal for those with busy lifestyles, and a study by Learning House in 2015 shows that 78% of online learning students think their experience was of better or equal quality to previous classroom learning […]
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 company to have sufficient […]
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 how to maximize the impact of these charts. In this final post in our series, we’ll look at a couple of simple, but important tips for improving the effectiveness of dashboards.
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 therefore of vital importance when […]
Over a number of previous posts (here, here and here), we have learned about business dashboards in detail. We have learned how to select the right charts to add to the dashboard, and we have learned how best to create the dashboard once you have selected the charts. What we have not yet covered is […]
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 shrug these days. Perhaps it’s down to the relative anonymity, the fact that we’re part of […]
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 available.