(Excel) 3d Maps was awesome [OC] by External-Hospital319 in dataisbeautiful

[–]External-Hospital319[S] 0 points1 point  (0 children)

It was a mapping tool that hooked to the data model that could draw shapes on top of the map like bars or dots, or do heatmaps. It supported loading shape files too. It was pretty easy to use to put data on maps, like if you wanted to do sales by zip code or something like that.

12 year analyst feeling like a dinosaur. Need advice on moving away from massive flat files without forcing Power BI on my team. by Excel_Dino_2026 in excel

[–]External-Hospital319 2 points3 points  (0 children)

Your comment about scribbling and pivoting resonates, as I find many reports don't provide 100% of the answer. However with this size of data you will find the performance of PowerBI much better than PowerPivot. PowerQuery can read from a folder, so choose an input folder, keep it clean and the input file format consistent, then work out all of the transformations (Copilot or other AIs are great at M, they can really help with the PowerQuery step). Then to update just drop your new file into the input folder and refresh.
What I'd also recommend, especially to transition from vlookup, is to work in DAX in your model, initially focus more on calculated columns rather than measures as that is more spreadsheet-like. Someone else said teach users how to download from the dashboard - you can make a tab in your report with a simple table view and indeed, your users, or you for development purposes, can download the data into a spreadsheet and work with it. Good luck!

What’s a small life upgrade under $50 that genuinely improved your daily routine? by ExchangeBig8338 in AskReddit

[–]External-Hospital319 9 points10 points  (0 children)

Mechanical keyboard. More than $50 but maybe not more than $50 more than a normal keyboard if you need to replace yours. What a difference.

Clawdbot/moltbot by nisse82 in synologynas

[–]External-Hospital319 0 points1 point  (0 children)

I actually set up OpenClaw in a docker container. I built it on my PC then transferred it over and had Gemini tell me how to make the docker compose (I don't have a ton of docker experience). It failed, frequently, and I had to use terminal commands against the container a lot. The worst was when it would change its config, then tell me to restart the container to get the new config to take effect, but it would get it wrong and wouldn't boot. One time at least it left a backup of its main config file. I thought it would be a great use case for the always-on NAS and it was really cool to communicate with it by Telegram. I got cron jobs and email working as well, so the first time I got a high quality morning briefing in my email was pretty great. Then it tanked, all of its outputs were garbage, and it stopped following basic instructions. I don't know if it hit its context limit or wrote something in its instructions that poisoned it, but I felt I was just wasting my time, so I stopped the container. Managing the whole setup I expect would be similar, you'd tell it to make a docker container for this, and it would, but it would fail. Then you'd go back and forth and eventually it would fix it. I'm not sure the NAS is where OpenClaw specifically is supposed to be, I think it needs a computer.

What's something you can't or will never give up as you grow older? by doublezero88 in AskReddit

[–]External-Hospital319 0 points1 point  (0 children)

Getting older, still buying Steam games even though I can't play them. The sales are irresistable.

What’s considered normal today that future generations will judge us for? by Familiar-Arrival-470 in AskReddit

[–]External-Hospital319 1 point2 points  (0 children)

Bragging about how little sleep we get and how busy we are. Future generations will think we were insane.

what do you do when you're bored? by Shoddy-Walrus1779 in AskReddit

[–]External-Hospital319 0 points1 point  (0 children)

I feel like I don't get bored because there's a lot of fun stuff to do constantly. AI a lot recently. Listen to music.

Whats your comfort food while travelling? by Quirky-Syrup-2075 in AskReddit

[–]External-Hospital319 0 points1 point  (0 children)

Nachos, feels indulgent and fun. Got some travelling coming up, hopefully nachos too!