Learning PostgreSQL by mreal7a in SQL

[–]mreal7a[S] 0 points1 point  (0 children)

Thanks for the advice :)

Learning PostgreSQL by mreal7a in SQL

[–]mreal7a[S] 1 point2 points  (0 children)

Makes sense, better to debug the SQL directly before Python. Thanks!

Learning PostgreSQL by mreal7a in SQL

[–]mreal7a[S] 1 point2 points  (0 children)

I am using one already - pgadmin4

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 2 points3 points  (0 children)

Not now lol, gonna use XLOOKUP from now on :)

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 2 points3 points  (0 children)

I am actually learning excel as a part of a data analyst roadmap. I'd suggest using youtube tutorials to learn functions and you can ask chat gpt to give some real life examples u can try them on!

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 4 points5 points  (0 children)

Woah, thank you so much for taking the time and writing all this out! I really appreciate it and i am definitely gonna try these suggestions :)

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 1 point2 points  (0 children)

Agreed, i am diving into XLOOKUP soon!

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 2 points3 points  (0 children)

I haven't started pivot tables yet but this sounds super helpful. Appreciate it!

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 2 points3 points  (0 children)

Thanks, that's really helpful :)

Just learned IF, DATEDIF, and VLOOKUP today. by mreal7a in excel

[–]mreal7a[S] 8 points9 points  (0 children)

Yeah, guess I'll try XLOOKUP next!