All Posts

Page 2 of 4

data analytics

Cracking the Tableau Certifications: My Honest Experience and Prep Strategy

A 5-year data analyst reviews Tableau certification prep. Discover the pros, cons, and real-world skills needed for the Desktop Specialist and Analyst exams.

data analytics

Chatting With Your Database: My Honest Take on No-Code SQL Automation

A data analyst's honest review of using natural language to SQL (NL2SQL) tools. Learn how to automate ad-hoc reporting and build a semantic layer safely.

Excel

AI-Powered Data Analysis in Excel: My Journey Beyond Basic Formulas

Learn how to integrate OpenAI API, Python, and GPT into Excel for advanced data analytics. Michael Park shares tips on automation and data cleaning.

data analytics

Talking to Your Data: My Honest Take on Generative AI for Analytics

Data analyst Michael Park reviews PandasAI for Generative AI projects. Learn how Natural Language Query changes Python data visualization and EDA.

data analytics

AI-Driven Data Analysis: A Senior Analyst’s Guide to Faster Insights

Learn how to use AI for SQL, Python, and data cleaning. Michael Park shares 5 years of analyst experience using Claude 3.5 Sonnet for faster insights.

data analytics

Building a Professional Data Portfolio: My Experience and Lessons Learned

Learn to build a professional data portfolio. Michael Park shares insights on SQL, data visualization, and avoiding common data security risks.

data analytics

Mastering SQL for Data Analytics: My Practical Path from Excel to AI-Driven Queries

Learn SQL for data analytics from Michael Park. Transition from Excel to MySQL, master joins, CTEs, and integrate AI for faster query optimization.

data analytics

Scaling Your Data Analytics: My Practical Guide to Cloud Warehousing

Join Michael Park as he explains how to scale data analytics using Cloud Data Warehouses. Learn SQL optimization, partitioning, and cost control tips.

data analytics

Essential Statistics for Data Science: A Python-Based Analytical Guide

Learn essential statistics for data analytics using Python. Michael Park covers EDA, hypothesis testing, regression, and A/B testing for business insights.

data analytics

Mastering Enterprise Cloud Data Warehousing for Marketing Strategy and Performance

Master cloud data analytics for marketing. Learn SQL, GA4 exports, and ROAS calculations using Google Cloud Platform for scalable business intelligence.

data analytics

Professional Spreadsheet Automation: A Data Analyst's Guide to Scalable Workflows

Learn professional spreadsheet automation using Google Apps Script, QUERY, and API integration. A comprehensive guide by data analyst Michael Park.

data analytics

Automating Data Analytics with Python Scripting: A Practitioner's Perspective

Learn how AI-assisted Python scripting transforms data analytics. Expert insights on transitioning from Excel to automated reporting and machine learning.