Category: Data Science
-
What we talk about when we talk about AI
Marshal McLuhan said something along the lines of people prefer to hear bad news because there’s always bad news and they know how to react to that. Say that’s too bad and move on. But when people hear good news they get uncomfortable because good news means change and people don’t know how to feel…
-
Building a Data Lake on AWS
Never Miss an Update! I kinda wandered into data engineering on accident. When I was a good little data analyst, I would spend some of my time optimizing queries and building automating reporting process. I learned more about how SQL databases work: that having a ton of joins slows queries down, why normalization exists for…
-
Custom Maps with Python
If you’re anything like me, a strategy gamer. You’ve spent way too many hours staring at this view of the Mediterranean. A good map should draw you in. I’m going to give you a quick guide in making one using Python. Github Link The code to make maps is relatively simple thanks to the matplotlib…
-
World War II in the Pacific Visualized
The Story this tells The Importance of Oil Roger said it best. Japan needed oil to fuel their war in China. The decisions to invade Indonesia and attack America were because of oil. and Japan’s ultimate defeat was a result of their industrial capacity grinding to a halt. The Navy and Submarines Amateurs talk about…
-
Webscraping in 15 Minutes
Data Science in a business context, is about leveraging Computing, Statistics, and expert domain knowledge together to solve problems and get results. Using the right tool for the job is where computing comes into play. Process improvement and Automation is the easiest way to create value with Data Science skills especially if you are starting…
-
Taking your SQL to the Next Level
Often when people learn SQL on the job or in school the being with writing queries, doing joins and maybe some update statements. This post is for those that are trying to move to the next level. This post will touch on the concepts data modeling, data normalization, Connecting to a SQL Database with Python,…
-
Setting up A Database Using SQL Server
I’ve done my fair share of free online course-ware. Something that has always bothered me with SQL courses, is that they tend to only focus on writing query’s. Querying data only works you have data to work with. This chicken and the egg problem is easily addressed though. If you keep reading, I’ll show you…
-
Web Scraping Data in Python
The internet is a gold mine for data analysts. Whether you are using google trends to identify search patterns, social media postings to judge sentiment, or analyzing company data for a potential investment, it’s all there. The only problem is turning the data into a usable format. HTML (Hypertext Markup Language) is the language that…
-
Data Cleaning and Visualization Basics
80/20 Pareto relationships are one of those things that once you learn what they are, you see everywhere. Pareto relationships follow an 80/20 ratio where 80% of the results come from 20% of the inputs. For example, in group projects for school, 20% of the members will do 80% of the work. Similarly, in dating…
-
Getting Started with Python for Data Science
I have received my share of unhelpful advice such as: follow your dreams, don’t eat eggs, and eat eggs. However, the most repetitive and annoying thing that I am told to do is “learn to code.” I would bet that most of the people that say learn to code do not know how to code…
He Was A Data Boi 