Portfolio

I have an entry in the database (OrderID : 10807) and it not showing up. I going to use a cast function to modify the sql to show this order. How do I do it? Thanks

FB Pixels and FB Conversion API are the package deal in the era of iOS, GDPR and Ad Blocker. My article on LinkedIn https://lnkd.in/g7f9xDab

You can track FB Ads in Google Analytics (GA) with URL Dynamic Parameters. With FB Ads data in GA, this means the same data can be push to Google Data Studio. Have anyone try this?

Hi everyone - I am looking for a new perm role and would appreciate your support. Thank you in advance for any connections, advice, or opportunities you can offer. #OpenToWork #Singapore #ireland #...

Generate BigQuery credentials To let dbt connect to your warehouse, you'll need generate a keyfile. This is like using a database user name and password with most other data warehouses. (but withou...

Assigning your own labels to a column in SQL An example for mysql “mysql> SELECT emp_id, -> 'ACTIVE' AS status, -> emp_id * 3.14159 AS empid_x_pi, -> UPPER(lname) AS last_name_upper -> FROM employee;”

You can set the default region and zones that gcloud uses if you are always working within one region/zone and you don't want to append the --zone flag every time. To do this, run these commands: g...

Instead of using the Cloud Console to create a virtual machine instance, you can use the command line tool gcloud, which is pre-installed in Google Cloud Shell. Cloud Shell is a Debian-based virtua...

Confirm that NGINX is running: “ps auwx | grep nginx” To see the web page, return to the Cloud Console and click the External IP link in the row for your machine, or add the External IP value to ht...

Successfully completed Creating New BigQuery Datasets and Visualizing Insights

Created a marketing digital touch-point frameworks ' Awareness, Consideration, Conversion, Loyalty'

Published on WordPress 10 “Not to Miss” Things To Do in Dublin

Changed background colour by editing CSS file, commit and stage changes via Git completely in-browser thanks to cloud computing. (with nothing to install locally)

The new Google Analytics 4 (GA4 ) allows you to bundle all your reports into a 'Collection' folder. You can access the reports on the left hand side of the menu.

if (data.resource && data.resource.type && data.resource.type === "bigquery_resource" && data.protoPayload && data.protoPayload.serviceData) { for (var event in data.protoPayload.serviceData) { var...

Useful SQLite tip: any time you use "select a, b, min(c) from x group by a" SQLite will pick the row that contains that minimum c value and use that as the source of the other columns - see "Bare c...

checking out the first draft of Emily Riederer 'Navigating the complexities of real-world data analysis'

On the 2nd day with #Polywork. So there is no way for people to respond to what I put up here?

Isn't it today a public holiday in Singapore? A govt agency responses to my queries I send out yesterday. It amazing.

I'm super excited to check out Polywork as one of the first early adopters. Oh and btw Titan is by far the most superior of the AI-Assistants! 🔥 😎 🤖