top of page

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!

Search


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
Â
bottom of page