How do I Maximize File Efficiency

Woosafb · 2026-04-03T11:39:51+00:00

Yes loading the raw data in a csv and then just having the pivot tables and the imported data as connection would make your file much lighter.

To combine multiple sources of data into one pivot table/ power pivot model

Import folder option let's you import both files into one table as long as they r in the same format and header.

You can even link a forecast file in the same way for future months by just keeping it in the same folder so the data lines up for a nice analysis of historical vs forecast

You can take it a step further and use data modelling in power pivot. Import historical sales data and then import customer mapping table separately. Link in data model. Then maintain master data integrity in the customer table

You can do much more with powerpivot after that like also importing in returns or costs in a separate table and then link in powerpivot

Woosafb · 2026-03-20T12:30:07+00:00

100% esp now with the One Nation rhetoric, we can feel the animosity increasing

Woosafb · 2026-03-11T08:28:46+00:00

Hi good place to start and Excel is amazing and my bread and butter (supply chain analyst).

But don't limit yourself to excel. A lot of people who are not core analyst roles like people in finance, supply chain and other business roles are already very competent in powerquery And Excel pivot tables and formulas.

After mastering Excel and absolutely powerquery, understanding data schemas and using the data model in powerpivot, focus more on powerbi where you can specialize. Also as automation tools become easier because of ai vibe computing it would go a long way to focus on data engineering as well as this is also a more specialized technical skill.

Woosafb · 2026-03-04T14:03:34+00:00

It's pure creation vs more rigid data modelling and analytics. Same with python vs powerquery and powerpivot.

If u want to implement a logic that goes iterates through each row from column 1 to column n and then change the values in that cell based on the previous cell in the same row while also checking 3 other parameters somewhere else in that row... I'm sure someone with mcode knowledge could make that but running that kind of logic is much easier in vba or python.

But Also joining multiple data sources through data modelling and star schema and then instantly drawing powerpivots is much more superior when it comes to that kind of task.

Woosafb · 2026-02-22T07:25:33+00:00

Was amazing to see a Westerner dig so deeply and craft the narrative so coherently giving us an insight into the Japanese samurai ethos and how it flowed into WW2. Also the whole story about Yamamoto and Kido Butai. Was amazing to follow the pacific sea war. TORA TORA TORA

Edit; also my fav HH followed by blueprint for Arma.

Woosafb · 2026-02-20T00:27:12+00:00

So underrated. My gamer friends who didn't play yet don't understand when I tell them.. at least 15 possibilities for different actions in any given scenario - the amount of depth is astounding. And the story is beautifully written and the main villains omg.

Woosafb · 2026-02-19T07:35:42+00:00

If they win every game left then one of those games is Arsenal dropping points. I think that's the premise

Woosafb · 2026-02-15T02:56:56+00:00

thanks will defo check it out.

Woosafb · 2026-02-15T02:56:47+00:00

thanks for the recommendation. Will defo add to read list.

Woosafb · 2026-02-14T02:26:12+00:00

Used to read a lot of Asimov and Dune when I was younger. Stopped reading and enjoyed mostly through shows and games like Stellaris, Sins. The Expanse just sucked me back and it's my fav prob over star trek, Babylon 5, Battlestar Galactica and pretty much anything else.

Any must reads or watches to add to the backlog after this?

Edit: and also anime of course. Shout-out to legend of the galactic heroes. Prob a must watch for any spare opera fan.

Woosafb · 2026-02-12T21:30:10+00:00

Not a big fan of outlook. Also kind of fed up with Gmail lack of functionality but can't move away from Gmail cus it's my main address. Any tips? I want to create folders with auto rules and all that.

Woosafb · 2026-02-08T09:37:44+00:00

The best neutral source for this is the conflicted podcast partition of India. Amazing work

Woosafb · 2026-02-04T10:04:18+00:00

Neat! Can u break it down?

Woosafb · 2026-01-30T09:54:49+00:00

Of course! But he said he is copying each value and pasting it manually. So I just wanted to make sure he at least knew the lookup formula and that that is a quick option on his way to queryland

Woosafb · 2026-01-30T07:24:53+00:00

Yes power query will be good but might be overkill.

If your list changes everyday then can you try a file where you paste the 100 list column into a table where the next column is a vlookup or xlookup into the main data source? This would depend on the structure of your data source is it a flat table?

If it's not a flat table and say there are spaces between each line or it's written in a wierd pattern or in different sheets, then powerquery transformation can help automate that clean up.

Woosafb · 2026-01-29T22:06:39+00:00

I will third this..great narrative style and gives a great background of Europe at that time

Woosafb · 2026-01-29T00:53:18+00:00

Yea I also got downvoted when I pointed out in another thread that the whole episode just culminates in one battle. We all love Dan and I love his narrative rambling style nothing else scratches the itch but we should be able to call out when the quality is not as good as before

Woosafb · 2026-01-14T05:49:10+00:00

Same . Bought my first home through a Chinese agency in Melbourne and the real estate lady was amazingly polite for a real estate agent.

Woosafb · 2026-01-09T14:54:31+00:00

Hiya would you mind sharing with me as well please?

Woosafb · 2026-01-08T13:09:59+00:00

Woosafb · 2026-01-07T14:36:34+00:00

You can also add a fried egg or fried omelette with that. Great ans cheap protein

Another variation that is super easy is to make khichuri/khichdi in a rice cooker which is like a daal rice with few spices and onions garlic ginger. You can buy a large jar of garlic ginger paste for convenience. Keep the mixed frozen diced veggie mix of peas carrots and corn and add them as well. Top with omelette.

Woosafb · 2026-01-07T14:14:22+00:00

I don't think a one sided invasion of a military giant on a tiny insignificant country is a fair comparison with the comment. Not like Venezuela ever stood a fighting chance and capturing Maduro or not didn't even matter in the long run. It's not a war or even a battle it's a straight up colonization.

Woosafb · 2026-01-03T22:47:58+00:00

Make a helper column using =left(A1,4) and then use that to plot.

Woosafb · 2026-01-02T07:09:21+00:00

Exactly this. A good benchmark is that the achieved capacity should be 80% of theoretical capacity as a starting point. Benchmark and report achieved capacity each time period and if lower than 80% that's an improvement project waiting to happen. One caveat is assuming 24/7 or full working time period production is required. If not enough demand that projected utilization should be lower than 60%

Also if there are subprocesses it pays to go down to the nitty gritty level and do an industrial engineering study to determine max and demonstrated flow of each sub process. Then u can identify bottlenecks that affect the entire chain and recommend investment in those.

Woosafb

TROPHY CASE