How I Fix An Analytics Issue: Leveraging Cloud-based Analytics Tools To Extract Insights And Drive Business Decisions -

I ran a SQL query to segment the drop by geography, device, and browser.

Is this for a , a portfolio , or a job interview ?

"We need to roll back the 1.4.2 deployment for Safari users immediately to protect $350k in weekly revenue." I ran a SQL query to segment the

I calculated that if left unfixed, this glitch would cost the company $50,000 per day.

Armed with a dashboard that updated in real-time, I didn't just tell the CTO there was a bug—I showed the . Armed with a dashboard that updated in real-time,

I skipped the local spreadsheets and went straight to our . I needed the raw, real-time power of the BigQuery environment to see the full picture.

Knowing what happened wasn't enough; I needed to know the business impact. I leveraged a (like Looker or Tableau) connected directly to our cloud instance. Heatmapping: I visualized the user journey. Knowing what happened wasn't enough; I needed to

Within minutes, the cloud engine processed millions of rows. The culprit? Users on a specific version of Safari were seeing a 404 error at the final "Pay" button. 💡 Phase 2: Extracting the "Why"