Google Business Intelligence Professional Certificate Project

Google Fiber

Goal: analyze repeated calls

Date created: Oct 2, 2023

Project documents:

1. Project Requirements Document:

2. Stakeholders Requirements Document:

3. Strategy Document:

Extract:

I extracted the CSV file from Google Dataflow by the following SQL code:

SELECT*
FROM `your project table location for market_1`
UNION ALL
SELECT*
FROM `your project table location for market_2`
UNION ALL
SELECT*
FROM `your project table location for market_3`

Transform:

• All the null values for contact_1, contact_2.. contact_7 have been transformed to 0 in Tableau.

• I created a custom measure by writing the following code in Tableau to sum all repeated calls and save it as 'Repeated Calls':

ZN(SUM(([Contacts N 1])+ ZN([Contacts N 2]) + ZN([Contacts N 3]) + ZN([Contacts N 4])
+ ZN([Contacts N 5]) + ZN([Contacts N 6]) + ZN([Contacts N 7])))

Load:

The data has been successfully loaded to Tableau.

Charts and Dashboard Design:

Here are the charts and dashboard I made due to project documents:

Done.

Thanks for reading!