Welcome to my profile! Feel free to connect on LinkedIn as well!
My main interests are analytics engineering and data engineering. 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
- Azure
- Building and maintaining Azure Data Factory Pipelines
- Creating and managing Azure storage accounts and containers
- Databricks