This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Tag: Database
-
List of Low-Code/No-Code Framework
No-code and Low-code development platforms allow individuals worldwide to build their businesses and applications to serve them without writing code. The platforms sit at the intersection of the IT Department and pretty much every other department in a company.
-
#simpleit: How to build a data platform without a budget
This article is for small companies that may not have a dedicated data team or just a single resource to operate a data platform. The focus of this article is on a small business data platform setup. This article will show how to create the best data platform for your organization without a data budget.…
-
#dataset: Creating a dataset using an API with Python
For any data analytics project I do, the first thing that I need is a dataset. I have put together a list of online datasets that you can use for your various analytics, there are sometimes you wish to extract data on your own and begin your own investigation.
-
What is Reverse ETL?
The data engineering industry has evolved from Extract, Transform, Load (ETL) to ELT, where raw data is copied from the source system loaded into a data warehouse or data lake and then transformed. The current trend is to adopt a new approach, called “reverse ETL,” the process of moving data from a data warehouse into third-party…
-
How to build a centralized and secured Data Catalog on Google Cloud Platform
Time is money, to organize your data in a Data Catalog is one of the first steps to give visibility to organizations’ data and to save time by employees to find data in the organization.
-
#datapipeline the hourly electricity rate
I spent my Christmas holiday in the southern part of Sweden, the weather was cold with several days of temperatures down under -10 celsius. In the news were stories about new price records for a KwH of electricity. I started to get worried that our electricity bill for December or for the whole winter period…
-
BigQuery federated queries against WordPress Cloud SQL Database
BigQuery has added a new feature, in which you can connect to a Cloud SQL instance and make federated queries. In this how-to, I will explain how I made an external connection from BigQuery, then using federated queries to query my cloud SQL WordPress database and made a Top Story report in Google Data Studio.
-
Migrate your WordPress local MySQL to Cloud SQL
Regardless of where you hosting your WordPress site, you can use Cloud SQL to be your backend database. In this How-to, I will explain the steps I took to migrate from the WordPress local MySQL to Cloud SQL.
-
Data Studio is so much easier to work with than Tableau
Tableau is an old product which I worked with from 2009 tills I discovered Data Studio and switched. I will give my view of why I think Data Studio is easier to work with.
-
Do you have the right tools for your data
As organizations chase the dream of a data-driven business, the data literacy gap continues to widen. Data is a gold mine that can help organizations drive growth and revenue.