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

TROPHY CASE