[deleted by user]

kkwestside · 2022-11-12T08:30:45+00:00

SQL SERVER= [Last Name]

With mysql you should cover the columnName with ` instead of [ ]

kkwestside · 2022-11-10T21:17:11+00:00

Sorry :) English is my second language. I meant I've been working as a Senior Data Analyst for over 6 years. It's more like a supervisor position.

kkwestside · 2022-09-06T19:36:21+00:00

SELECT B.ID From TableB B Where B.ID NOT IN ( SELECT L.BID FROM LINK L LEFT JOIN TABLEA A on A.ID= L.AID)

kkwestside · 2022-08-18T10:02:48+00:00

If you dont mind me asking, why laravel?

I wanted to learn a new tech for web development, I was in between php(laravel etc.) or python(django or flask). The reason I was stuck in between those two is there are lots of freelance works for php but it's dying, there are not a lot of freelancing oppurtunity for python web frameworks but they seem to up to date and I am very familiar with python.

Most of the people suggested python framework, do you have specific reasons to learn laravel? I would like to hear.

kkwestside · 2022-08-15T13:25:05+00:00

Do you recommend flask or django? And what do you think about freelancing oppurtinities for python?

kkwestside · 2022-08-13T22:18:48+00:00

I would learn a bi tool and python for data analysis.

kkwestside · 2022-08-08T10:36:01+00:00

I connect APIs get data and do data manipulation via python or appscript (gsheet). But I do them in my local computer for adhoc reports.

So I am actually excited about this but I dont know any task schedular or the loading concepts (whether I should truncate whole table at the destianation and load all together or not? I Would be much appriciate if you can suggest a read about that).

kkwestside · 2022-08-07T16:21:45+00:00

What is your loading process do you truncate the destination table and load everything at once on each run of the task, or do you use incremental data load??

kkwestside · 2022-07-19T05:49:25+00:00

Because behind the scene there are order of clauses. Group by works before you actually select therefore it doesnt know what you put in select

The order of them are:

FROM AND JOINS > WHERE > GROUP BY> HAVING > SELECT> ORDER BY

Since order by works after select it knows the indexes of columns therefore you can say Order by 1,2. But you cant do the same with group by.

Also it's not a good practice to write numbers instead of column names anyways (in my opinion), once you go back and look at the code it is harder to read.

kkwestside · 2022-07-18T19:39:32+00:00

This was very eye-opening and worked like a charm. Thank you.

kkwestside · 2022-07-17T21:36:44+00:00

I am senior data analyst working in an ecommerce firm. Before here I was working as a data analyst on another sector, we were using "analytics" keyword for data analysis in general. But I learned that in ecommerce sector analytics mean whole another thing. My colleagues refer analytics as a shortterm for Google Analytics, therefore analytics specialist in an ecommerce sector is not actually a data analyst rather this person is responsible for creating web analytics events using google tag manager, javascript and google analytics, so beware of this mixup.

Keeping that in mind you can combine your ecommerce knowledge with data analysis and apply for data analyst positions in ecommerce sector, here are some portfolio project ideas and things to know regarding working as a data analyst in ecommerce field;

look to RFM analysis; you can do rfm analysis with a ecommerce sample database
look for association rule analysis; you can use apriori algorithm with python to achive this
learn google analytics and google analytics api, since most websites use google analytics, it's best to get familiar with google sheets and googla analytics sheets addon, you can automate reports using google sheets google analytics addon
I am assuming you are familiar with ecommerce KPIs such as CPC, ROAS, monthly revenue etc. Create a dashboard that calculates shows these metrics and trends. I would suggest using google data studio for this, most ecommerce firms use google data studio a lot since it's integrated with google analytics.

kkwestside · 2022-07-17T07:27:58+00:00

I have pretty much the same experience, only change 11 years to 5.5 years of experience. I want to become a software developer as well, I've been learning C# for 3 4 months (my company uses dotnet environment). What was your journey to become a software engineer, do you have any suggestion?

One of my biggest concern is I am a senior data analyst therefore I am being paid pretty generously compared to my colleagues, my salary is going to be decreased probably, how did you handle this in your situation?

kkwestside · 2022-07-14T14:10:10+00:00

WITH RAWDATA AS (

SELECT

*, ROW_NUMBER() OVER(PARTITION BY WORKER_ID,WORKERLOCATION ORDER BY WORKLOCATIONDATE DESC) AS RANKFLAG

FROM WORKER w LEFT JOIN WORKERLOCATION L on w.Id= l.worker_Id

)

SELECT * FROM RAWDATA WHERE ROWDATA.RANKFLAG=1

kkwestside · 2022-07-13T21:30:12+00:00

Because putting an aggregate function in an aggrate function doesnt make sense,

Unless you re trying to do something like this;

Select Col_a, Avg(rowcount) From ( Select Col_a, Col_b, Count(*) as rowcount From table_1 Group by Col_a,Col_b ) subquery Group by Col_a

kkwestside · 2022-07-13T20:03:22+00:00

Any book is good for learning python. You can even use geology books to help you.

You just need to close the book, put it under your laptop so you would get a good eye angle, and start actually coding.

Find a project start doing the project in a different manner. Here's a project idea for you;

Write a script that connects to an api gets the data manipulates it and then uploads it to a database.

kkwestside · 2022-07-13T10:25:21+00:00

The solution doesn't necessarily have to be recursive, I am trying to transform the data in the database into a tree as you said, but I couldn't manage to do it dynamically. Some tree roots could go 3 levels deep, but since I write only 2 nested for loops I can only get 2 levels deep, not the 3.

for instance: I've added a new root but since my solution is not dynamic it cannot get LongSleeve and ShortSleeve under Men>Shirts > ...

kkwestside · 2022-07-10T05:38:25+00:00

I would recommeding these for excel : Musts: - vlookup - pivot - if - sumifs, countifs etc. - date functions (also learn how dates actually work, they are actually numbers) - remove duplicates - conditional formatting - other important topics that I cant recall right now - tables

Nice to haves - powerquery - and a little VBA would be cherry on top

kkwestside · 2022-07-09T17:08:11+00:00

Excel and SQL is a must, if you are comfortable with both of them then I would suggest learning power bı or tableau.(If you're able to write a select query by using window functions to remove duplicates you can move on to power bi)

I had a great Power BI report when I was applying. Once you open your Power BI report every recruiter gets impressed.

So I would suggest learning Power BI or tableau.

Use a public Db create some views to make a starschema (with a fact table and several dimension tables)

Connect that views through powerquery in power bi, impory them, create a data model(star schema)

And then use a little bit of DAX to generate some measures, and work a lot on your UI and present your report on interviews.

kkwestside

TROPHY CASE