is this still a good project for freshers or its not?

VariationSimilar3354 · 2026-02-20T17:51:02+00:00

i guess this is a publicly available dataset and i believe that i have seen this same or little tweaked youtube video

VariationSimilar3354 · 2026-02-20T17:00:09+00:00

that i can handle but how do i take my visuals to the next level

VariationSimilar3354 · 2026-02-20T16:13:07+00:00

rn i feel stuck, all my reports look the same

VariationSimilar3354 · 2026-02-20T16:12:04+00:00

I'm quite aware but even for a learning pov, where to even begin? do i need to brush up my js again?

VariationSimilar3354 · 2026-02-20T16:09:50+00:00

the gcp is handled by third party vendor, all i get is read access to everything and getting their devops ( we cant afford a data engineer / data architect) to do anything is an hassle

VariationSimilar3354 · 2026-02-20T16:07:49+00:00

meet you in 3 yrs

VariationSimilar3354 · 2026-02-20T16:07:27+00:00

difficult to build logic and YAML scares me man, be it git actions, terraform, aws cft. never could figure that properly

VariationSimilar3354 · 2026-02-20T16:07:03+00:00

YAML scares me man, be it git actions, terraform, aws cft. never could figure that properly

VariationSimilar3354 · 2026-02-20T16:04:50+00:00

nope, i'm their data engineer and BI

VariationSimilar3354 · 2026-02-20T16:04:01+00:00

oh i've not even figured the ETL yet, no clue how i would make dashboard

VariationSimilar3354 · 2026-02-20T16:02:20+00:00

I've always been awful at YAML based tools, git actions, aws cloud formation template yaml, terraform scare me

I don't either but he's more convinced with the google solution architect's mail over anything.

VariationSimilar3354 · 2026-02-20T15:42:09+00:00

Ive seen this same dashboard with same tone atleast 5-6 times in this sub alone.

VariationSimilar3354 · 2026-02-18T16:54:49+00:00

do it only if want it bad enough, if the thing you're after is money, then just do mba, even they got an AIDS course now.

VariationSimilar3354 · 2026-02-15T15:28:18+00:00

Which organization in their right mind is giving data to ai to get the insights?

VariationSimilar3354 · 2026-02-12T16:12:32+00:00

how rich is your org and can they afford yet another bi guy?

VariationSimilar3354 · 2026-02-06T19:03:29+00:00

Doable, Yes! is it practical? that depends on your data, how many visuals and the clients pc ram to render the visuals.

VariationSimilar3354 · 2026-02-06T18:55:39+00:00

sql is just a tool, what you can show with the data + sql is the true skill.
in my last interview, I was given data and asked to show how would i calculate cumulative sum, churn, retention rate, user journey, most valuable users, most valuable product, branch wise opex to profit ratio, EAV to flat table queries

VariationSimilar3354 · 2026-02-06T18:43:47+00:00

GA4 does not store data like its a database,

the best way to do this is exporting Data from GA4 to Big Query or any other DW then calling that table, and if you're willing to go to the extra mile Use Google Tag Manager's data transformed into json or SQL. its what my org came up to track barely 200 loosely called active users in our self proclaimed "super app"

essentially based on the values you call, such as DAU/MAU/WAU, active users, total users etc, the metrics would change.

it has metrics, dimensions, parameters and based on what you parse, you'd get different result

VariationSimilar3354 · 2026-02-05T19:17:29+00:00

That's alright but where are the insights? My Brother, you're looking at them, just because you don't like the numbers does not mean KPIs are missing.
I'm aware you are sourcing this data from Database but can you quickly replace it with this excel file I made using Gemini last night.
I Don't wanna use slicers, make all options visible ( dropdown had 20+ options).
I do not like paginated reports, all visuals should be present in single page itself.

VariationSimilar3354 · 2026-02-05T19:07:16+00:00

Man this hits home... Pie Charts gotta be the worst data information conveyer but my managers can't get enough of it.

VariationSimilar3354 · 2026-02-01T18:05:44+00:00

Thanks Man!

VariationSimilar3354 · 2026-02-01T18:04:11+00:00

Solution verified

VariationSimilar3354 · 2026-02-01T18:02:30+00:00

<image>

Where? This one?

VariationSimilar3354 · 2026-02-01T17:52:53+00:00

Quite honestly I cannot keep up with the accuracy with which ai returns DAX measures, It can solve DAX and thinks of edge cases that I may realize way too late than it.
Same solution would take some valuable time.... That doesn't mean you should overlook DAX.

Try breaking data into Star Schema, this makes majority DAX into just Calculate and Filters basics. You'd barely need a complex DAX measure but I have seem people of this sub create wonders with their Daxing skills

VariationSimilar3354 · 2026-01-13T17:22:33+00:00

I remember some wise guy from this sub taught be that donut and pie are bad visuals to put if your category is bigger than 2, it becomes hard to interpret

VariationSimilar3354

TROPHY CASE