<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1134480483323201&amp;ev=PageView&amp;noscript=1">

Essential Skills

for business & data professionals

What Is the Difference Between Excel and Power BI?

What Is the Difference Between Excel and Power BI?

For many years, Excel has been the most widely used data analysis software for most businesses. However, in recent years, you may have become aware of Power BI, which is another newer Microsoft product. You might feel that Microsoft is nudging people towards Power BI and wondering is it right ... Read more

How Do Outer Joins Work in Alteryx?

How Do Outer Joins Work in Alteryx?

In a previous post, we saw how the Join tool in Alteryx merges two tables into one. However, maybe you want to combine all the data from one of the input tables with the data in the inner join. An outer join lets you do this.

Read more
Tableau and Power BI: What's the Difference?

Tableau and Power BI: What's the Difference?

Tableau and Power BI are probably the two best-known products when it comes to self-service business intelligence and visualization tools. Although there are many similarities between the two products, there are also a number of differences. Deciding which is the right product is not easy, and ... Read more

How Public Data Can Be Valuable to Your Businesses

How Public Data Can Be Valuable to Your Businesses

We all know how important data is becoming to modern businesses. The amount of data floating around in modern companies is such that a wide range of insights can be gained just by analyzing the data present within your company. However, what you could more easily overlook is the value of ... Read more

How to Combine Multiple Tables Horizontally in Alteryx

How to Combine Multiple Tables Horizontally in Alteryx

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 ... Read more

The Best Publicly Available Data for Business

The Best Publicly Available Data for Business

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 ... Read more

How to Combine Multiple Tables Vertically in Alteryx

How to Combine Multiple Tables Vertically in Alteryx

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 more
Essential Key Metrics from a Leveraged Buyout

Essential Key Metrics from a Leveraged Buyout

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

What is the Difference Between Alteryx and Tableau?

What is the Difference Between Alteryx and Tableau?

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

5 Ways to Make the Most of Online Learning

5 Ways to Make the Most of Online Learning

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 ... Read more

How To Project Cash Flows After a Leveraged Buyout

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 ... Read more

When Designing Dashboards, Less Is More

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 ... Read more