Essential Skills

for business & data professionals

How To Project Cash Flows After a Leveraged Buyout

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 […]

When Designing Dashboards, Less Is 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 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.

How to Build the Debt Schedule for a Leveraged Buyout

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 […]

5 Ways You Can Maximize the Impact of Your Charts

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 […]

Improve the Layouts of Your Dashboards with These Quick Tips

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 dashboard when we have created all the visuals we need.

Cloud vs Local Installations: Where Should You Keep Your Data?

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 fear […]

How To Create Transaction Assumptions For Leveraged Buyouts

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 rollovers are accounted for. The transaction assumptions also […]

Choosing the Right Charts for Your Dashboard

As we explained in a previous post, a dashboard consists of a collection of charts and other visuals combined into a single screen interface. The choice of charts to use can have a big impact on the effectiveness of a dashboard. In this post, we’ll learn when to use some of the most common chart […]

What’s the Difference Between Excel and Tableau?

Excel has been the dominant software for data analysis for many years. Although people like to complain about Excel, there has to be some reason why it obtained that level of popularity in the first place, and in reality it is pretty useful for most businesses.

Learn How to Make Better Business Decisions with Influence Diagrams

When you’re modeling a business problem, it’s generally tempting to start the analytics as quickly as possible. Whether you’re using Excel or another promising new tool, this can be a bad idea. You should always spend some time structuring your model in order to understand the variables and how they interact with each other. Influence models […]

How to Design Business Dashboards: Think Before You Create

Dashboards are a popular, effective tool for managers and other business people to better understand their companies through data analytics. In recent years, the development and the growing popularity of visualization tools like Tableau and Power BI has facilitated the expansion of business dashboards.