Client
EU Based e-Commerce Website
Date
Apr 30, 2024
Services
Google Analytics, Google BigQuery, Google Data Studio
Our Role
Business Intelligence Developer
Highlights
- Setup pipeline from Google Analytics to Google Bigquery
- Built Google Bigquery based codes and ETL pipelines to pull data like Internal Site search, Search Refinements, Search Exits etc (Code snapshot at bottom)
- Connected Google Data Studio to Google Bigquery, to create dashboards out of this data
- Connected with stakeholders and his team, to QA the dashboard and train them on the usgae of the dashboard
- Connected with the stakeholders to understand their requirements
KPIs & Metrics Tracked
- Internal Site Searches - How many people used internal site search?
- Internal Site Search Conversion Rate - How many people converted after using internal site search?
- Nil Search Results Rate - How many searches returned No results?
- Internal Search Exit Rate - How many people exited immediately after searching?
- Internal Search Refinement - How many people refined their search - as in reiterated a search keywork multiple times?
- Internal Search Add to Cart after Filtering - How many people used filters on search results, and added to cart post that?
[Solved] “File size limit Exceeded” error in Zeppelin (Amazon EMR Cluster)
When we import a JSON notebook into Zeppelin server, we are pretty aware that the size of the JSON notebook should not exceed 1 MB. But most of the times when creating a copy of the zeppelin notebook, we forget to clear output thus amounting to huge memory. This tutorial illustrates how to increase the
How to transfer files from Google Cloud Storage (GCS) into Amazon S3 bucket without downloading the files
This is also the best available method to transfer data from BigQuery to Amazon S3 (through GCS) This tutorial is written for beginners with zero scripting expertise and can be utilized by anyone Pre-Requirements To transfer the file from Google cloud storage into Amazon S3, you will need the following Access to create ‘VM Instances’
[Tutorial] Creating Mobile Responsive Dashboards in Tableau
With the penetration of mobiles increasing every day, usage of any software or web based application on mobiles becomes inevitable. And analytics domain is not an exception. The usage of mobile phones to view analytical Business Intelligence dashboards have increased significantly. Also, unlike in the past, apart from analysts and BAI colleagues, now even executives