Category: Google Cloud platform

Google Cloud platform
Alessandro Fiori

BigQuery and spreadsheets: how to integrate them?

We all use Google services to manage email, write documents, create presentations, and do calculations. But have you ever wondered how these tools can be used to increase your work productivity? With Google’s simple spreadsheets and powerful BigQuery data warehouse, we can analyze large amounts of data without having to be an expert. Let’s find out how to easily integrate these two tools for our projects.

Leggi Tutto »
data studio dashboard
Google Cloud platform
Andrea Avignone

Google Data Studio – The MySQL connector (Part 2)

In this second part of the MySQL Connector tutorial for Google Data Studio, we will integrate new advanced charts in our dashboard. The final sales report is therefore expected to provide a complete analysis concerning the given company. Eventually, we will briefly introduce the phpMyAdmin interface to access our MySQL databases.

Leggi Tutto »
data studio dashboard
Google Cloud platform
Andrea Avignone

Google Data Studio – The MySQL connector (Part 1)

One of the most exciting aspects about Google Data Studio is its flexibility to accept data from several distinct sources. During this tutorial, we will explore the MySQL connector provided by the platform to access your MySQL database in order to create an interesting sales report, highlighting significant trends with charts and tables.

Leggi Tutto »
Google Cloud platform
Andrea Avignone

Google Data Studio: introduction to charts

Once you become familiar with the Google Data Studio platform, the next natural step is to play with the breadth of available charts. They can be especially useful for highlighting trends and analysis of various kinds, making the final report much more useful and satisfying. In this tutorial, we will explore the main elements to customize your project.

Leggi Tutto »
google data studio report
Google Cloud platform
Andrea Avignone

Google Data Studio: introduction and first steps

Creating proper dashboards for data visualisation has now a crucial role to highlight interesting insights and support companies. Google Data Studio is a user-friendly tool to design attractive reports based on different database connectors. This tutorial shows the basic functionalities useful for beginners to start creating their own personal dashboards.

Leggi Tutto »
Google Cloud platform
Alessandro Fiori

Google Cloud Storage: solution for data lakes

Google offers several solutions to implement a data lake. Of these, the most popular is Cloud Storage because of its versatility in data management and low cost. However, configuring the service requires some considerations depending on its use. Let’s discover its features and how to optimize performance and costs.

Leggi Tutto »
Google Cloud platform
Alessandro Fiori

Data lakes: GCP solutions

In the world of Big Data, raw data management plays a vital role. In most cases, it is not possible to load the data provided by different applications into data warehouses in order to create Machine Learning models or dashboards. Data lakes, i.e. raw data staging areas, play a key role to perform the necessary transformation pipelines. Let’s find out what solutions are offered by Google Cloud to implement a data lake.

Leggi Tutto »
Google Cloud platform
Alessandro Fiori

BigQuery: performance optimization

Although BigQuery is a very good tool for querying terabytes, best practices should be adopted to improve performance. Let’s discover tricks for writing queries that execute quickly and save on execution costs. We also look at how you can optimize table storage through partitioning and clustering.

Leggi Tutto »
Google Cloud platform
Alessandro Fiori

BigQuery: WINDOWS analytics

In many application scenarios, the statistics you need to extract refer to different groupings on the source data. By defining aggregation windows, you can calculate statistics within the same query. Moreover, if necessary, you can also provide different levels of data granularity through the ARRAY data type. Let’s discover these advanced features through two real-world examples.

Leggi Tutto »
Google Cloud platform
Alessandro Fiori

BigQuery: GIS functions and Geo Vis

Geographic data plays a very important role in various analyses. BigQuery includes GIS functions in addition to the SQL standard to query, manipulate and analyze this kind of information. Let’s find out how to use and visualize them using Geo Vis.

Leggi Tutto »

Progetta con MongoDB!!!

Acquista il nuovo libro che ti aiuterà a usare correttamente MongoDB per le tue applicazioni. Disponibile ora su Amazon!

Design with MongoDB

Design with MongoDB!!!

Buy the new book that will help you to use MongoDB correctly for your applications. Available now on Amazon!