top of page
The Antares Alien
Power BI
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
Brent Jones
Jan 23, 2021
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
70 views
Brent Jones
Sep 23, 2020
How to Create a Drill-Through page in Power BI
How to leverage Power BI's drill-through feature
476 views
Brent Jones
Jul 18, 2019
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
826 views
Brent Jones
Jun 8, 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
217 views
Brent Jones
Apr 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
4,436 views
Brent Jones
Feb 19, 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.
687 views
Brent Jones
Dec 12, 2018
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
567 views
Brent Jones
Dec 4, 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.
70 views
Brent Jones
Nov 27, 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
140 views
Brent Jones
Nov 17, 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
67 views
Brent Jones
Nov 12, 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.
70 views
Brent Jones
Nov 6, 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
32 views
Brent Jones
Nov 5, 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
26,958 views
Brent Jones
Oct 23, 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
151 views
Brent Jones
Oct 19, 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.
51 views
Brent Jones
Oct 4, 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..
160 views
Brent Jones
Oct 1, 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
194 views
Brent Jones
Sep 25, 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
374 views
Brent Jones
Sep 21, 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
29,299 views
Brent Jones
Sep 20, 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
104 views
bottom of page