<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1134480483323201&amp;ev=PageView&amp;noscript=1">
4 Steps for Integrating US Census Data with Your Company's Data

4 Steps for Integrating US Census Data with Your Company's Data

Using public data can help improve the quality of your data analysis. It allows you to fill in any gaps in your data or to create more insights into your company's data. We'll show you how to go about getting data from a public source, and in particular how to integrate public data with our ... Read more

3 Step Guide: Get US Census Data into Power BI

3 Step Guide: Get US Census Data into Power BI

Integrating public data into your analysis can provide powerful insights. However this task rarely comes easily, as public data tends to come in an awkward format or a different format to the one you prefer to work with. We'll show you how to do this in 3 steps

  1. Download a dataset on ... Read more
First Steps in Alteryx: Importing Excel Files

First Steps in Alteryx: Importing Excel Files

In a previous post, we gave a general guide on how you can import files into Alteryx. In this post, we'll look specifically at Excel files.

Read more
CAPM vs APT. Which One Is Right for You?

CAPM vs APT. Which One Is Right for You?

The Capital Asset Pricing Model (CAPM) and Arbitrage Pricing Theory (APT) are two of the most popular asset pricing models used by analysts ... Read more

How to Make the Most of Public Data For Your Business

How to Make the Most of Public Data For Your Business

By now, almost every business around has figured out that data and analytics represent a big opportunity to generate compelling insights into the company, and thereby improve outcomes. However, some businesses put themselves at risk when they fail to ask where that data should come from.

Read more
First Steps in Alteyrx: How to Import Your Data

First Steps in Alteyrx: How to Import Your Data

A lot of your work with Alteryx will involve using and manipulating a wide variety of data sources. One of the strengths of Alteryx is that you can import data from many different sources into it, from databases to Excel files and many more.

Read more
Leveraged Buyouts: How to Estimate Your Returns

Leveraged Buyouts: How to Estimate Your Returns

An absolutely critical stage in calculating a Leveraged Buyout model is to measure the returns achieved by the investor. In this post we'll measure the return achieved by a ... Read more

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