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!

Power BI: Easily Find a Column Name with this Function

I was recently working on a project where there were over 28 thousand tables in the database.

Brent Jones

Jun 19, 2020

Displaying Unity's Game Build Log

If you ever want or need to display Unity's build report with graphs and charts, you can do that with Power BI. The set up takes a coupl

Brent Jones

Oct 28, 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

Brent Jones

Jul 18, 2019

Exploring "Overtourism" with Power BI (Part 2)

Continuing from part 1, here I'll describe a little bit more of what I found interesting. Tourist to Population Ratio - I ended up addin

Brent Jones

Jun 9, 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

What are the Most Common Ju-Jutsu Injuries? Power BI Viz

I've recently started training in MMA and Brazilian Ju-Jutsu. I've done a little Kickboxing in the past before, but Ju-Jutsu is comp

Brent Jones

May 15, 2019

Easily Make Your Own Custom Visuals With Charticulator!

Have you ever wondered how you can get that cool circular, spikey, donut-esque looking chart that's being featured on PowerBi.com?

Brent Jones

Jan 20, 2019

Power BI: What Do Successful Kickstarter Projects Have in Common?

Are there any trends among successful Kickstarter projects? Conversely, are there any trends for failed projects?

Brent Jones

Jan 1, 2019

Look Up! UFO's Show Up In Summer.

Are there any correlations or trends among UFO sightings? Do they tend to occur in a specific month or time of year? Any location? Do they o

Brent Jones

Dec 26, 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

Brent Jones

Dec 12, 2018

Power BI Dataflows and How Are They Different From Datasets?

What are Dataflows? Dataflows are a new feature released in September of 2018 for Power BI. Just going by the name...

Brent Jones

Dec 6, 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

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

Analyzing the "All Time Best" Video Games with Power BI

Are there any trends among top selling video games? I decided to tackle that question with some help from our good friend Power BI.

Brent Jones

Oct 12, 2018

How to use Power BI Role Level Security

RLS is a security feature in Power BI that allows you to limit the data shown to users based on their role in your organization. It may soun

Brent Jones

Oct 9, 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

2 Easy Steps to Creating User Input Variables with Power BI

Read about how to easily create user input variables for your dashboard users! Example with the classic train problem.

Brent Jones

Sep 14, 2018

Creating a Zooming Mandelbrot Fractal with Python in Power BI

Read about how to create a zooming feature of the Mandelbrot fractal with Power BI and Python!

Brent Jones

Sep 12, 2018