Joe G.

Data Analyst (SQL, Google Sheets, Looker Studio, Excel, Power BI)

SQL, Google Sheets, Looker Studio, Excel, Power BI, Python, AWS // Hello, I am an expert in working with data and I specialize in developing fully automated end-to-end dashboards and data pipelines. My skills are the following: ----------------------------------------- 📑 Google Sheets and Excel automation and data processing using highly complex dynamic array formulas for data prep and cleansing 🔵 SQL databases including design/architecture as well as developing complex custom queries for data processing and pipelining whether using a database such as Microsoft SQL Server, MySQL, PostgreSQL, or a cloud database such as Google BigQuery, or SnowFlake 📊 BI Dashboard development with Looker Studio and Power BI to gather data from multiple different data sources, and combine them together into one central dashboard. 🐍 Python automation and API development (Pandas, APIs, Postman, Webhooks, *Google Apps Script/JavaScript) ☁️ Cloud architecture, Linux servers, and function development for streaming data (GCP, AWS, Azure)