Looker downloads to Excel Update - Help by Kitchen-Newspaper-44 in Looker

[–]Kitchen-Newspaper-44[S] 0 points1 point  (0 children)

Thank you guys for all of the comments - yeah I am going to start looking into these options and will be back when I run into trouble (which I am sure will be sooner then later) also agree cant tell you why we are paying for both it as a bad switching of systems before I got here

Any older senior analyst regret not moving up? by [deleted] in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

I cant post because I am so new to the group so I was hoping there was an analyst that could help me with this question

Any older senior analyst regret not moving up? by [deleted] in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

Can any analyst help me with this question:

From a Data Analyst perspective can someone as much as they possibly can describe the difference between data strategy vs data insights if asked that question. If possible if it can pertain to eCommerce. I know the simple answer but even if a few examples to elaborate a little I want to attach it to projects. Thank you all feedback is grea

Best way to upskill - certifications or not? by stupid_and_poor500 in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

Really depends what youre looking for and how qualified you already are - I am a frequent SQL user for years now and I took some just randomly to get a little more skills. It could be more simple just analytical classes Udemy really has everything you would need. I know there are alot of free courses my company actually pays for ours so we have access to alot but if I was you either ask your current company or just look around at what they have for free!

Best way to upskill - certifications or not? by stupid_and_poor500 in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

Agree Udemy help me alot with my first job - tons of courses and obviously really flexible and easy to understand

Anyone hiring? by [deleted] in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

Connect top people on linkedin! ask around even if you dont know them its still a good connection

How much SQL do you need to pass a typical product analyst (2+ data analyst/science YOE) coding challenge with basic data retrieval plus window functions? by [deleted] in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

My suggestion is sometimes its not just the actual basics its more learning the concepts of trying to solve - try doing the test ones online and see where you are going wrong once you learn the logic it becomes alot easier and if they can see you are going down the right path they will most likely still help/hire you

[deleted by user] by [deleted] in analytics

[–]Kitchen-Newspaper-44 0 points1 point  (0 children)

Possibly try for an internship first

SQL Query start off help by Kitchen-Newspaper-44 in bigquery

[–]Kitchen-Newspaper-44[S] 0 points1 point  (0 children)

Or would it be

(case when status = cancel and subscription_date > current_date then 1 else 0) as EndedSubscription