Caktus Blog
Web development blog with how-to's on UX, quality assurance, project management, and more.
-
Analyze data with SQL window functions
We regularly use tools like PostgreSQL, Pandas, and Jupyter Notebooks to analyze data here at Caktus. Recently, we were reviewing North Carolina traffic stop data for the NC Co... Read more
April 5, 2023 -
Begin your Data Analysis Journey with Pandas and Seaborn
Now that our dataset is organized as we want it to be, it's time to introduce Seaborn to the mixture. Part of the brilliance of Seaborn is its ability to simplify graphing data. Read more
March 28, 2023 -
Denormalization with JSON Fields for a Performance Boost
Is it better to flatten your data or normalize it? Why not both? Read more
March 22, 2023 -
Forging a New Path
I spent 20 years in Corporate America where I took my career as far as I could without holding a college degree, so I’m definitely not green when it comes to work experience. W... Read more
March 16, 2023 -
Fellowship: A Path to Caktus
During the past year, we’ve begun a new program for folks looking for training prior to beginning a career in web development. This program has paired Caktus with a local coding... Read more
March 14, 2023 -
How to Automate Google Sheets to ODK Central
ODK is a popular tool for offline data collection with a thriving user community. Like a number of other offline data collection tools, it uses the XLSForm standard for authori... Read more
March 8, 2023
