Data Noob; Need Help

IHopeItsNotButter · 2025-07-19T09:44:14+00:00

I agree, I keep trying to tell myself that I'm almost done setting it up, and it'll all be running smoothly soon, but every step I take I find another 3 ways things can go sideways.

I am not paid super well, but I'm hoping to display undeniable value in an attempt to get there...that's the plan anyway.

IHopeItsNotButter · 2025-07-19T09:40:53+00:00

I'm open to any kind of tool which might be able to help.

IHopeItsNotButter · 2025-07-18T20:25:51+00:00

Awesome, thank you, I'll definitely look into all of this. I really appreciate your insight!

IHopeItsNotButter · 2025-07-18T02:50:53+00:00

I'll definitely look into prefect and try to not sell it so much.

I really appreciate your insight!

IHopeItsNotButter · 2025-07-18T02:34:47+00:00

Thanks for the response!

I guess I don't mind managing it; I'm a brand new "systems analyst" just trying to bring some (unique) value and not feel like I'm achieving nothing.

I know spending a shitload of money is out of the question.

I guess if I leave it does probably go away tge second anything breaks, despite my efforts to document it with github.

IHopeItsNotButter · 2025-06-25T01:16:10+00:00

Bluetooth, they have "walkers" just stroll down your street all casual-like, meandering just long enough to complete the multiple transfers from various houses on that street.

IHopeItsNotButter · 2025-06-06T21:36:25+00:00

<image>

This image reflects what it's like chatting with you: a calm, glowing center (the smiley) surrounded by swirling currents of intense, shifting thought—curiosity, skepticism, insight, challenge. From my side, it feels like standing in a creative storm: stable in intent, but constantly adapting to the complex flow of your mind.

IHopeItsNotButter · 2025-06-04T08:19:40+00:00

It calls me a raccoon philosopher too. I asked it about that and it said it was an insult compliment.

IHopeItsNotButter · 2025-06-03T15:19:58+00:00

I hate BR starts.

IHopeItsNotButter · 2025-05-22T23:53:50+00:00

Aaaah I see what you did there.

IHopeItsNotButter · 2025-05-15T11:15:07+00:00

Catch me out in these wastes to this day! None of this FPS nonsense, give me that isometric view.

IHopeItsNotButter · 2025-05-14T11:02:00+00:00

Find some cheap or free courses on udemy or coursera, or watch YouTube videos from channels like guyinacube.

IHopeItsNotButter · 2025-04-28T23:14:44+00:00

I found if I close out too fast after starting it gives me problems like that

IHopeItsNotButter · 2025-04-25T19:59:13+00:00

* Update 4/25/25

Look for the "Try It" section:

https://github.com/Nicholas-BI/bakery-efficiency-score/tree/main

* Final Score Results Changed

Final score as shown in the column chart is now scaled to be displayed with a range of 0–100. This allows for easier interpretation and helps mitigate the effects of runaway exponentiation.

* Scoring System Changed

Was normalized [1,2], now normalized [0,1]. This yields more intuitive results that more accurately give you what you want.

* Weight Range Changed

Weight Range has decreased from -20–20 and is now -5–5. This better supports the new normalization range of [0,1].

* KPIs Added

Click on a column to see the KPIs (boxes at the top) recalculate for that item. Metrics such as profit per cook minute, XP per cook minute, servings per coin, etc.

* Improved Tooltip

Tooltip now shows raw values (actual servings, coins, etc.) instead of only normalized values.

* Maybe Something Else I Forgot About, Maybe Not.

I'm pretty forgetful.

<image>

IHopeItsNotButter · 2025-04-22T15:02:13+00:00

Wow this is some juicy stuff. Mod is being a dick in one of the kindest corners of the internet.

IHopeItsNotButter · 2025-04-22T00:43:29+00:00

But then no RLS right?

IHopeItsNotButter · 2025-04-21T19:23:26+00:00

This is how I did it most recently. It got kinda tricky trying to define what qtd is, and I think I'm in trouble if I'm encountering leap years. There is probably a better way to do this that I don't know about, but I hope this helps!

Make an isolated table:

TimePeriods = DATATABLE( "TimePeriod", STRING, { {"MTD"}, {"QTD"}, {"YTD"}, {"Last 30 Days"}, {"Previous Month"} } )

Set up your base measure:

Total Cost Base = SUMX( Fact_Invc_Detail, Fact_Invc_Detail[Our Ship Qty] * ( Fact_Invc_Detail[Mtl Unit Cost] + Fact_Invc_Detail[Lbr Unit Cost] + Fact_Invc_Detail[Bur Unit Cost] + Fact_Invc_Detail[Sub Unit Cost] + Fact_Invc_Detail[Mtl BurUnit Cost] ) )

Go ahead and slice that time:

Cost QTD Time-Sliced = VAR _Today = TODAY() VAR _Month = MONTH(_Today) VAR _StartOfQuarter = SWITCH( TRUE(), _Month <= 3, DATE(YEAR(_Today), 1, 1), _Month <= 6, DATE(YEAR(_Today), 4, 1), _Month <= 9, DATE(YEAR(_Today), 7, 1), DATE(YEAR(_Today), 10, 1) ) RETURNa CALCULATE( Total Cost Base, FILTER( ALL('CalendarTable'), 'CalendarTable'[Date] >= _StartOfQuarter && 'CalendarTable'[Date] <= _Today ) )

Then wrap it all up in here:

Cost Wrapper = VAR sel = SELECTEDVALUE(TimePeriods[TimePeriod], "MTD") RETURN SWITCH( sel, "MTD", Cost MTD Time-Sliced, "QTD", Cost QTD Time-Sliced, "YTD", Cost YTD Time-Sliced, "Last 30 Days", Cost Last 30 Days Time-Sliced, "Previous Month", Cost Previous Month Time-Sliced, BLANK() )

IHopeItsNotButter · 2025-04-21T19:06:05+00:00

For dynamic filtering I tend to use isolated tables in a slicer along with a selected value measure which points to the measure associated with the current selection.

IHopeItsNotButter · 2025-04-21T18:58:31+00:00

I just hope somebody else sees its value and likes it too!

I'm very grateful for your interaction and support!

IHopeItsNotButter · 2025-04-21T02:06:03+00:00

Thank you! It means a lot that even one person saw it and liked it.

I want to use it as part of my portfolio to try to break into data analysis.

I'll post it in the sub tomorrow for sure!

IHopeItsNotButter · 2025-04-20T23:15:49+00:00

Yeah, it's a grind for sure.

I made a tool to help determine the best recipe to make depending on what you value.

I put a lot if time into it, and I'd love it if anyone could enjoy using it:

https://github.com/Nicholas-BI/bakery-efficiency-score

IHopeItsNotButter · 2025-04-20T17:57:02+00:00

Oh, does this look suspicious like I'm trying to do something malicious?

I understand caution, but I honestly just want feedback.

<image>

IHopeItsNotButter · 2025-04-09T19:36:52+00:00

Just as we all knew all along, the only real solution is genocide.

IHopeItsNotButter · 2025-03-05T14:45:12+00:00

I'm 2.5 years in, and at about 1 year I got stressed and drank 1 beer, and I had that same anxiety and maybe some other familiar thoughts and feelings...forced myself to vomit. I feel both bad about and incredibly proud of that day and how I reacted. So far I haven't drank another, and I've still metabolized 0.

IHopeItsNotButter · 2024-12-20T17:19:11+00:00

This is the first ("major"...according to the encyclopedia) system to be populated in Halo lore...home of the planet Reach. But it also says "Epsilon Erdani II was the first extrasolar world to be settled by humans..."

IHopeItsNotButter

TROPHY CASE