Welcome to my profile! Feel free to connect on LinkedIn as well, or my blog on dev.to where I post notes and study materials related to what I'm learning.
My main interests are analytics engineering and data engineering. You'll find repositories here related to those topics as well as the occasional goofy side project, like auto-random-pointilism, which just makes random asbtract images in MS Paint.
My hobby work involves database development, ETL, and cloud data warehousing.
- SQL
- Complex joins
- Subqueries/CTEs
- Stored procedures
- CRUD operations
- Python
- Creating classes and functions
- Loops
- API requests
- pandas/numpy
- Database connections
- AWS connections
- Power BI
- Connecting to multiple data sources (csv, Excel, SQL Server, web)
- Data modeling (merging/appending queries, determining cardinality, building star schemas)
- Creating measures in DAX
- Creating visualizations, reports, and dashboards
- Data Analysis
- Exploratory data analysis
- Descriptive and inferential statistics
- Defining and measuring KPIs
- Docker
- Docker
- Spark with PySpark
- Azure Databricks
- Storytelling With Data by Cole Nussbaumer Knaflic
- Navigating the Labyrinth: An Executive Guide to Data Management by Laura Sebastian-Coleman
- Effective Pandas: Patterns for Data Manipulation by Matt Harrison
- Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann