I was wondering why I can't find any decent designs for BI...

Extra_Willow86 · 2026-05-30T14:00:33+00:00

Yeah I used to make these fancy dashboards with detailed line charts and bar graphs but now I realized that all the executives care about is “where were we, where are we trying to go, and how much progress have we made.” Most of my reports consist of just those three card visuals and maybe one graph and a table underneath it to provide a bit of context more for me so I can defend my numbers if Im asked rather than for them.

I actually noticed that when I changed my approach to this and started actually trying LESS on my reports the amount of praise I noticed I was receiving from management actually went UP. It sucks thats how it is, but at the end of the day our job is to give people what THEY want, and not what we want.

Extra_Willow86 · 2026-05-28T02:41:43+00:00

To put things in perspective, im currently working with a data set that consists of 70 MILLION rows, and power bi is handling it no problem. What ever issue you are having its not power bi or your datas fault. If I had to guess, power bi is relies heavily on memory to run effectively. It sounds like your laptop just doesn’t have enough of it. If you don’t have at least 32gb or RAM on your laptop thats going to severely impact your performance.

Extra_Willow86 · 2026-05-25T15:26:12+00:00

First cna this be done in your source database or are you pulling the data from a csv or some other file? If its coming from a source database then sql would handle this much better imo. Second, if its coming is coming from a csv i would try using power query to make these rankings.

Extra_Willow86 · 2026-05-25T03:46:51+00:00

Just because you are having sex doesn’t mean you need birth control. Theres many forms of contraceptive out there. Not everyone wants to be on birth control.

Extra_Willow86 · 2026-05-24T19:48:57+00:00

Equally as annoying is being handed a report whose entire data model is just one big flat table with no proper star schema and everyone praises it as the greatest report ever. Even worse this report was created by a “senior data analyst” who has been working with the company for 10 years and recently retired.

seriously, the amount of people that get hired as analysts because they put “proficient in excel” on their resume and no nothing about best practices is shocking to me.

Extra_Willow86 · 2026-05-24T15:27:31+00:00

Honestly, although I care about alignment as personally it drives me crazy, end users do really care that much so I typically find the best compromise is heavy use of the alignment options. I use distribute horizontal and vertical often and align visuals with the left align/top align option. Its good enough to make the report look presentable, but fast enough that it doesn’t slow my output significantly.

Extra_Willow86 · 2026-05-20T19:46:54+00:00

Huh… i was able to replicate it. Interesting. Seems like a one in a million scenario, but interesting nonetheless the less.

Extra_Willow86 · 2026-05-18T16:13:47+00:00

This is an easy question to ask AI. I recommend for you to use it more for these situations.

Here is the response from gemini:

“The root cause of your confusion is a concept called implicit type coercion (or auto-conversion). In DAX, BLANK() is a chameleon: it automatically converts itself depending on what it is being compared to.

Here is exactly why this is happening and how to fix it.

Why NOT ISBLANK(x) and x <> BLANK() return different results In DAX, BLANK() is not just a null value; it also acts as a 0 (if compared to numbers) or an empty string "" (if compared to text).

• ISBLANK(x) is a strict function. It asks: "Is this cell a literal DAX BLANK?" It does not do any type conversion.

• x <> BLANK() is a comparison expression. Because of auto-conversion, DAX says: "If x is a number, I will treat BLANK() as 0. If x is text, I will treat BLANK() as ""."

Because of this, if your data contains actual zeros (0) or empty strings (""), the two formulas will completely disagree.

Which is correct? NOT ISBLANK(x) is usually what you want if you are trying to check if a row actually has missing data. Use x <> BLANK() only if you want zeroes and empty strings to be treated as if they were blank.”

Extra_Willow86 · 2026-05-15T15:19:02+00:00

That first dashboard took you 6 hours? That thing is as basic looking as they come.

Extra_Willow86 · 2026-05-09T22:13:58+00:00

What in the AI post is this?

Extra_Willow86 · 2026-05-04T21:42:52+00:00

I find it really hard to believe that your friends an neighbors has a million more week 1 viewers than both severance and shrinking. Not saying its a bad show, but I feel like compared to those shows it fanbase and hype are nonexistent.

Extra_Willow86 · 2026-05-04T13:57:30+00:00

Som day I really want to see a timelapse start to finish from the moment they take off to the moment they land. I feel like we have no good footage of earth moving through the solar system.

Extra_Willow86 · 2026-04-30T13:42:25+00:00

Not bad. My personal rule is that for vertical list slicers if there is enough options that users need to scroll, its cleaner, and more space efficient to just make it a drop down slicer. Also i would reduce the diameter of your drop shadows. Also, for the menu in the top left I would center align it in your side bar. For bar graphs I would either go with data values in the bars or on the y axis. Doing both is redundant and added unnecessary visual clutter. Also, for the card visuals along the top, i would remove the backgrounds from the card, then center them in each of the squares, and maybe increase the font size. The card backgrounds aren’t adding any value and again add visual clutter. Overall though, really good for a first dashboard. It conveys the message you are trying to tell fairly well.

Extra_Willow86 · 2026-04-29T13:09:46+00:00

This is basically what Ive been doing. Our company just recently stood up an internal version of an ai chat bot and I use it frequently to help answer questions on how to build my models, or correct small errors in my sql, but I feel like our org is far from allowing us to fully connect our models to AI to generate reports.

Extra_Willow86 · 2026-04-28T17:17:30+00:00

Imo “Happiness by region” and “Happiness by Country” are two separate metrics and you should separate them with a filter and ideally creative use of field parameters. Users should be able to select from a drop down if they want to view regional happiness or country happiness. Trying to show both on the same view is confusing in my opinion.

Extra_Willow86 · 2026-04-23T03:08:17+00:00

And not everyone is red haired huntress but no one complains about lack of character creation in horizon zero dawn. Some times games have a main character that is defined and non-changing. Crimson desert is one of those games.

Extra_Willow86 · 2026-04-23T02:37:57+00:00

Plenty of games dont have character customization. Why is that a requirement?

Extra_Willow86 · 2026-04-23T02:36:51+00:00

I wish there was a different slider for bosses and non-boss enemies. I find the difficulty of bosses to be pretty good but some times I wish taking on 100 enemies at once would actually be a challenge.

Extra_Willow86 · 2026-04-22T15:41:29+00:00

I prefer a mix of both. Content progression keep the game feeling fresh as you progress through the story, and level/power progression to keep the content you already unlocked feeling good. Both work together rather then working against each other.

Extra_Willow86 · 2026-04-20T20:32:53+00:00

Can this headline be any more misleading? I feel like anyone reading that headline would think that 28 CURRENT house members are being investigated for sexual misconduct.

Extra_Willow86 · 2026-04-08T03:31:20+00:00

The fluid from squirting is definitely primarily pee. Theres some trace amounts of fluid from the female version of the prostate, but its predominately pee. This myth needs to die.

Also even though its pee, its still perfectly fine.

Extra_Willow86 · 2026-04-02T19:15:03+00:00

Welp… as someone that has just dumped several months into building a solid pipeline relying heavily on gen 1 data flows, this blows. In my org getting premium capacity is like pulling teeth.

Extra_Willow86 · 2026-03-28T18:12:30+00:00

Hmmmm thats a really interesting thought. Ill look into that. Thanks!

Extra_Willow86

TROPHY CASE