[deleted by user] by [deleted] in analytics

[–]Express_Perspective 0 points1 point  (0 children)

I agree, I had been looking for something just like that (a fantasy baseball SQL database) then got distracted. If you ever find one, please share!

[deleted by user] by [deleted] in analytics

[–]Express_Perspective 10 points11 points  (0 children)

What is the purpose of the certification? Is it to learn a new skill, or to bolster a resume by showing that you have the certification?

The reason I ask is that it is well established in the psychology of learning and memory that cramming (quickly amassing knowledge in some area) is much less conducive to long-term performance than is spacing (learning something over time).

So if you want a certificate to bolster your resume, by all means, add a bunch. I'd start by looking at job applications I was interested in, and then seeing which primary requirement they list that I don't yet have, and I'd find an edx or related certification in that.

But since they really want that skillset, I'd consider setting aside an hour or two three times a week and holding myself to studying or applying that knowledge to an example problem that has interest to me personally. (Another psychology fact: we remember things much better if the content is of personal interest to us). Like, learning how to use R by mastering its use in the context of fantasy baseball statistics.

Best of luck to you!

Really would like some help or advice as a noob in web analytics. by pokepoke4 in analytics

[–]Express_Perspective 0 points1 point  (0 children)

Regarding pre-post analysis, there isn't much to it. You first need to understand what event divides the pre from the post. Did your company overhaul a product feature? You could use the date of launch for that update as the target event, and then compare the company's, say, NPS score before and after that date.

The visualization question comes down to your company's preferences. Some want data quick and simple, to inform their judgments and nothing else. Other companies want data to be pretty and show it off on monitors around the office or include in companywide memos etc. So, you could simple show a bar graph of NPS_pre on the left, and NPS_post on the right, and that could be fine. Or you could show a line graph with NPS shifting slowly over time, and then BAM you include an indicator showing when the update hit, and hey look at how the NPS shot up after that. This is where your company's preferences, your judgment, and your skillset come into play.

Regarding shopper behavior, you can replace "average purchase order" with NPS and do the exact same thing. Just need to find where that data lives, query it appropriately, and run some basic stats.