The Antares Alien

Power BI | DAX

Blarg! Here, I write about Power BI stuff in a fun and unique way. I also occasionally write about video game development. Thanks for checking out my blog!

4 Easy Steps to Building Your First Power BI Dashboard

Have you decided to use Power BI for your business's reporting needs? Or are you just exploring what Power BI can do? In this article, I'll

Brent Jones

Jan 23, 2021

How to Create a Drill-Through page in Power BI

How to leverage Power BI's drill-through feature

Brent Jones

Sep 23, 2020

How to Remove the Header Info on Power BI Widgets

If you are like me, maybe you've wondered (and possibly been a little annoyed) how to remove the small pop-up menus that appear on each

Brent Jones

Jul 18, 2019

Exploring "Overtourism" with Power BI (Part 1)

The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including A

Brent Jones

Jun 8, 2019

Power Query: Merged Tables, Aggregate and Non-Aggregate Values

Why Power Query doesn't give you the option to expand a merged table with both non-aggregate values AND aggregate values. Let's take

Brent Jones

Apr 8, 2019

Power BI Design Challenge: Apple's "My Health" App

I wanted to make a Power BI dashboard from the step data that my iPhone records on its "My Health" app.

Brent Jones

Feb 19, 2019

What Kind of Video Game does the World Like to Buy?

I recently got my hands on a great data set related to video games sales worldwide. Not only does it includes sales data, but also genre, Me

Brent Jones

Dec 12, 2018

63% of Tweets About Airlines are Negative. A Power BI Analysis.

...63% of tweets about airline companies had a negative sentiment... make a heatmap from a Matrix visual.

Brent Jones

Dec 4, 2018

Does the 80/20 Rule Appear in Car Sales? A Power BI Analysis

I always here about the 80/20 rule in theory but I've never actually gone out and tried to find it myself. So I decided to test it out w

Brent Jones

Nov 27, 2018

Ease Your Mind With a Free Power BI Reference Guide!

Do you feel lost sometimes in Power BI? Don't worry! I compiled together some of the major areas of Power BI, Dax, and Power Query into

Brent Jones

Nov 17, 2018

Power BI: Top 10 Companies in GA - Plus Nested Queries

How do the top 10 companies in GA and their respective tax payment in 2018 line up? Plus, a look at nesting queries within queries.

Brent Jones

Nov 12, 2018

Improve Your Data Visuals: Stock Prices and Midterm Elections

Let's take a look at some real world data visualization examples and see how we can improve upon them with storytelling techniques. This

Brent Jones

Nov 6, 2018

Power BI: Ultimate Guide to Joining Tables

There are three approaches to joining tables in Power BI. One is on the relationships page, another is with Power Query, and another with DA

Brent Jones

Nov 5, 2018

How Mars's Gravity Affects you, and Spaghettification!? A Power BI Analysis.

There's a lot of talk around humans going to, and living on Mars recently. There are plenty of challenges that this brings - oxygen, tem

Brent Jones

Oct 23, 2018

Building a KPI Dashboard for a Recruiting Company!

For the past couple of years I've worked for a consulting firm and created several dashboards for various purposes.

Brent Jones

Oct 19, 2018

Best Book for Learning DAX and Power BI

Why Learn DAX? You may be thinking, "Oh, DAX is easy. I mean, it looks just like Excel formulas!". That's what I thought too..

Brent Jones

Oct 4, 2018

Analyze Your Business's Facebook Page with Power BI

Power BI comes with a Facebook connector that allows you to analyze any Facebook page's posts and comments - your business's page as

Brent Jones

Oct 1, 2018

Best Book to Learn Data Visualization

In this blog, I'll attempt to use some of the major principles in Cole Knaflic's book "Storytelling With Data" to create i

Brent Jones

Sep 25, 2018

Get Worksheet Data In the Current Workbook With Power Query

You may already be familiar with the "Get Data" function in Excel. You can use this feature to send data from your worksheet to Po

Brent Jones

Sep 21, 2018

5 Important Steps to Tell a Story with your Data

Data visualization isn't easy. Many times, it just ends with a quick Excel graph and maybe some explanatory text. As a result, the consu

Brent Jones

Sep 20, 2018