A list of the best tools for all your CSV-related needs when trying to merge, validate, explore or just convert CSV files.
Panagiotis Tzamtzis - Digital analytics consultant & Web developer
"Να είσαι θερμοστάτης, όχι θερμόμετρο" είναι μια φράση που άκουσα πριν μερικά χρόνια από έναν guru του χώρου και μου έχει μείνει καρφωμένη στο μυαλό από τότε! Το θερμόμετρο είναι μια συσκευή η οποία μόνο καταγράφει δεδομένα, ενώ ένας θερμοστάτης μετατρέπει τα δεδομένα και σε ενέργειες. Αν καταφέρουμε να έχουμε περισσότερους "έξυπνους θερμοστάτες" στην διάθεση μας όταν αναλύουμε δεδομένα, θα μπορέσουμε να διαχειριστούμε και πολύ μεγαλύτερο όγκο αλλά και να επιταχύνουμε τις αντιδράσεις μας σε αυτά.
A list of time-saving, cost-saving and life-saving SQL query hacks you need to know if you consider yourself an advanced BigQuery user.
Recently I came across an interesting project by Sean Thomas Burke called Sitemapper. This is a mini framework, which can be used to parse through sitemap XML files to get all included URLs. Such functionality is necessary when crawling through websites, as the sitemap (usually) holds an up-to-date list of all website URLs. In most cases this list should be enough when designing a crawler and you wouldn’t need to crawl manually the website and create a list of URLs. Sitemap parser: Sitemapper Sitemapper is a well-maintained and well-documented, open-source library offering the following features: Follows redirects Supports gzip sitemaps...
I came across an interesting alternative approach from Philip Walton. He explains clearly why all websites cannot work with the default definition of a page view in Analytics and how we someone could start using the page’s visibility state (using the Page visibility API). Unfortunately this post was originally published in 2017 and still until today, even though Single Page Application (SPA) websites are widely used, we reply mostly on complicated implementations to virtually create page views for analytics tracking. Another alternative to this problem is to use an Event Driven Data Layer (EDDL), but I like the simplicity of...
Enterprise websites split across many regions and locales are huge, but every page matters. Keeping track of the website’s quality, across all pages and on different devices, is a complicated and time-consuming process. It requires the constant evaluation of page performance, web analytics implementation accuracy, accessibility, and SEO audits.Baresquare developed an automated solution to keep track of website changes and website quality. This is a scalable solution built on GCP, with cost and resources customized to the website’s size. The solution utilizes a customized version of Lighthouse SDK and a BigQuery database for keeping track of results. Analyzing results is...
A new trend is rising in the analytics and web marketing community! Lists of 50 things you believe about your industry. This list was created based on my experience working in digital analytics projects since 2008 and from numerous conversations I had while organizing the Digital analytics meetup, Thessaloniki since 2017.
Recently Apple & Google announced a partnership, which would allow them to create a digital contact tracing solution, that would work for iOS and Android phones on a global level. Can such a widespread application work safely?
In the following article, I shared a few thoughts on the risks and opportunities for the Greek government, the EU and every citizen. It's clear that we will have to face a lot of difficult decisions in the coming years, in the dawn of a new era which relies heavily on data.
I was very pleased to exchange and share some thoughts with Sotiris Kyriakidis from the Greek news agency “Praktoreio” on how big data can help the current battle against the Coronavirus (Covid-19). It’s the first pandemic (at least in my lifetime), where data scientists or just a data enthusiast can play an important part in how governments handle the Coronavirus crisis. I would be glad to hear your thoughts. (Unfortunately the interview is only available in Greek) Τα «big data» ως τεχνολογικό όπλο για την αντιμετώπιση ασθενειών Εμβόλια, φάρμακα, θεραπείες, έρευνα είναι μερικές μόνο από τις ανθρώπινες δραστηριότητες στον τομέα...
