Skip to content

danieljasme-analyst/google-business-intelligence

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

39 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Google Business Intelligence Certificate — Portfolio

Candidate: Ahmad Daniel
Program: Google Business Intelligence Certificate — Portfolio

Candidate: Ahmad Daniel
Program: Google Business Intelligence Certificate on Coursera
Blog: danieljasme.hashnode.dev
Status: ✅ Complete


About This Portfolio

This repository documents my end-of-course projects from the Google Business Intelligence Certificate. Each course builds on the last — progressing from planning documents through data pipelines to fully deployed BI dashboards.

All projects use the Google Fiber scenario: a fictional case study where I am a BI analyst candidate tasked with building a call center analytics dashboard that helps leadership understand and reduce repeat customer calls.


Project Scenario: Google Fiber

Google Fiber provides people and businesses with fiber optic internet. The customer service team is interested in exploring trends in repeat calls to reduce the number of times customers have to call in order for an issue to be resolved.

My role: BI Analyst candidate building an end-to-end dashboard solution for the call center leadership team.

Business question:
How often are customers repeatedly contacting the customer service team, and what factors — market area, problem type, time of week — are driving those repeat calls?


Courses & Deliverables

Course Title Status Blog Post Key Deliverables
Course 1 Foundations of Business Intelligence ✅ Complete Read → Stakeholder Requirements, Project Requirements, Strategy Documents
Course 2 The Path to Insights: Data Models and Pipelines ✅ Complete Read → SQL pipeline, target table (1,350 rows)
Course 3 Decisions, Decisions: Dashboards and Reports ✅ Complete Read → Tableau dashboard (7 sheets, 4 dashboards), Executive Summary

Live Dashboard

🔗 **Google Fiber Repeat Calls Dashboard — Tableau Public **


Skills Demonstrated

  • Stakeholder requirements gathering and documentation
  • BI project planning and milestone management
  • KPI definition and SMART success criteria
  • SQL data pipeline design (BigQuery UNION ALL)
  • Data schema design and ETL pipeline development
  • Dashboard design and data visualization (Tableau Public)
  • Cross-functional communication and executive reporting

Contact

Blog: danieljasme.hashnode.dev
LinkedIn: www.linkedin.com/in/ahmad-daniel-63721b322


These projects are completed as part of the Google Business Intelligence Certificate program. The Google Fiber scenario is a fictional case study provided by the program for educational purposes. gle Business Intelligence Certificate https://grow.google/certificates/business-intelligence/ on Coursera
Blog: danieljasme.hashnode.dev
Status: ✅ Complete


About

End-of-course project portfolio for the Google Business Intelligence Certificate

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors