I help people and teams learn data @ Maven Analytics
Joined March 2009
- Tweets206
- Following336
- Followers156
- Likes208
Free course access at Maven Analytics starts now.
From March 16-22, you can get free access to our Python for Data Science learning path:
5 courses
4 guided projects
AI, data science, and machine learning.
Plus 3 live events this week.
mavenanalytics.io/data-scien…
Love this framework from @mdancho84.
I always talk about “playing field Analysts” vs “scoreboard keeping Analysta” and this line of thinking feels similar 👏👏
It's 2023 and traditional data science is broken.
There's a new type of Data Professional forming.
Here are the 2023 #datascience #trends I'm seeing... 🧵
#datascientist #career
@bookingcom - final step of web checkout currently broken.
'Card Type' dropdown is empty, and it's a required field, so complete dead end.
Cleared cache, switched Firefox to Chrome, same behavior everywhere. Suspect this is universal to anyone using your web application. Oof.
A Gentle Introduction to Python’s Pandas Library — The First 5 Functions You Need to Know by Chris Bruehl
link.medium.com/rqsF1trWwzb
Simple SQL that’s so useful…
EXTRACT(DAY FROM ‘2023-03-24’)
In place of DAY, you can also use Month, Year, Quarter, Week, Hour, Minute, Second, and more.
What other simple SQL tricks have been game changers for you?
Learning SQL?
Try pattern matching using LIKE with wildcards.
It's simple, yet powerful. Here's a walkthrough...
In practice, the most common use cases tend to be looking for values that...
1) start with some pattern
2) end with some pattern
3) contains some pattern anywhere in the string
Learning SQL?
Subqueries, Common Table Expressions(CTE) and Temporary Tables can all be useful tools.
Here's what you need to know about them...
Want a long-form version of this with more examples?
Here you go:
mavenanalytics.io/blog/sql-s…