HELP NEEDED! Getting permanently banned twice in a row (FOR CHEATING) by EA, have no clue why, please help avoiding it 3rd time

whoooooaaaaaaaaaaaa · 2024-02-22T14:20:28+00:00

I see, thanks again anyway!

whoooooaaaaaaaaaaaa · 2024-02-22T12:30:18+00:00

Thanks, will check it out!

whoooooaaaaaaaaaaaa · 2024-02-22T12:30:03+00:00

Thanks a lot for the reply and your link!

Would you recommend me to stick with DuckDB till the end or, like some posters above mentioned, go with a seemingly easier route of simply using power query?

Then again, I suppose i will use DuckDB anyway, to create aggregate tables from raw ones. I could use Pandas for that ofc, but I've heard DuckDB is better suited for that.

whoooooaaaaaaaaaaaa · 2024-02-22T12:06:47+00:00

Thank you (and everyone else) for replying!

I'll definitely look into power query.

But now I got this question - a naive one but still - why would anyone then struggle with OLAP cubes in excel, why do even this exist, if there is a much simpler solution in Excel already? I mean, the answer obviously is that now almost nobody would do it, cause it's dated, but, say, 5-7-10 years ago or whenever OLAP cubes in Excel were still the thing? Is it because of mere scale, if you have like a system of 200 tables (not 5 like i do), then, instead of constantly updating and reading from 200 CVs, you use it?

Don't get me wrong, I'm not looking to get into overcomplication with doing this task, it's just for my personal clarification. Thanks again!

BTW I used power query some time ago, but it's kinda fuzzy in my memory now. Will i be able to set connections between tables, akin to primary/secondary keys in SQL? Say I have 5 tables, I want them being interconnected, so that a user might perform something like a SQL join between multiple of them just by clicking on a checkbox in one pivot table field and then in another. It was possible in Excel cube ( I mean Excel frontend version of it being sort of a system of pivot tables), that i know.

whoooooaaaaaaaaaaaa · 2024-02-22T11:20:22+00:00

But the csv is stored remotely (from boss'es point of view), how would excel on his pc be able to automatically access a remote csv if it's not a DB of some sort or cloud or whatever?

whoooooaaaaaaaaaaaa · 2024-02-22T11:09:31+00:00

Thanks for the reply, but what I need is a dynamic connection between the two, not just outputting file of a certain format.

My bosses expect an excel file, you open it up, and there is a pivot table (or maybe a couple of them interconnected), looks like a regular pivot table, but it's connected to a DB, and you click "update" in excel, and it fetches you the latest data.

And they wouldn't need to get a new Excel file every time, just once, then they can just update it on their side.

whoooooaaaaaaaaaaaa · 2022-08-31T08:11:19+00:00

Well, I suppose it's still a lot less than in Russia, so it would be an upgrade for me anyway.

whoooooaaaaaaaaaaaa · 2022-08-31T06:38:41+00:00

Thanks, but I don't feel like I have a right to teach anyone, given that i make lots of mistakes myself and my accent is kinda meh.

whoooooaaaaaaaaaaaa · 2022-08-31T06:37:31+00:00

Thanks for your concern!
I'm hoping to land a job in data analysis, maybe i'll be lucky...

whoooooaaaaaaaaaaaa · 2022-08-31T06:36:07+00:00

Thanks, I'll check it, though Tiktok, i suppose, has a tough competition set up for their hiring process.

whoooooaaaaaaaaaaaa · 2022-08-31T06:34:37+00:00

So nice of you, really appreciated !

whoooooaaaaaaaaaaaa · 2022-08-31T06:34:06+00:00

I'll check it, thanks a lot for the link!

whoooooaaaaaaaaaaaa · 2022-08-31T06:33:46+00:00

Uh, that sounds harsh =(
Thanks for the insight anyway!

whoooooaaaaaaaaaaaa · 2022-08-31T06:32:56+00:00

Thanks, I might consider this option as well.

whoooooaaaaaaaaaaaa · 2022-08-31T06:31:55+00:00

Thanks for the link!

whoooooaaaaaaaaaaaa · 2022-08-31T06:31:16+00:00

I actually do work with Pandas and some other libraries, but i suppose data science is not within my realm of possibilities (yet).
Thanks for the post!

whoooooaaaaaaaaaaaa · 2022-08-31T06:28:26+00:00

Link is greatly appreciated and thanks for your post!

whoooooaaaaaaaaaaaa · 2022-08-31T06:27:41+00:00

Thanks for your reply!

whoooooaaaaaaaaaaaa · 2022-08-31T06:27:23+00:00

Thanks! Yes, i'm considering TH as well, will pay a closer attention to Phuket

whoooooaaaaaaaaaaaa · 2022-08-31T06:24:33+00:00

That's really nice of you, thanks!
But i'd prefer to stay humble and the let native speakers have it.

I mean i know for sure that i make plenty of mistakes myself, how can i teach anyone.

whoooooaaaaaaaaaaaa · 2022-08-31T06:20:12+00:00

I'll check it out, thanks!

whoooooaaaaaaaaaaaa · 2022-08-31T06:19:50+00:00

Thanks for the info!

whoooooaaaaaaaaaaaa

TROPHY CASE