Month: September 2020

NoSQL Databases in GCP

NoSQL Database Services | Cloud Datastore, Cloud Firestore, and Cloud Bigtable

Introduction The relational database (RDBMS) model completely dominated database technology for over 20 years. Today this “one size fits all” stability has been disrupted by a relatively recent explosion of new database technologies. These paradigm-busting technologies are powering the “Big Data” and “NoSQL” revolutions, as well as forcing fundamental changes in databases across the board. …

NoSQL Database Services | Cloud Datastore, Cloud Firestore, and Cloud Bigtable Read More »

Bigquery

Building a data warehouse solution using BigQuery | GCP BigQuery

An enterprise data warehouse brings the data together and makes it available for querying and data processing, it should consolidate data from many sources. All data in a data warehouse should be available for querying and it’s important to ensure that those queries are quick. Another reason to consolidate all of your data besides standardizing …

Building a data warehouse solution using BigQuery | GCP BigQuery Read More »

Building a data pipeline using Dataflow | GCP Dataflow

Data uncover deep insights, support informed decisions, and enhances efficient processes. But when data coming from various sources, in varying formats, and stored across different infrastructures, so here are data pipelines are coming as the first step to centralizing data for reliable business intelligence, operational insights, and analytics. By contrast, the data pipeline is a …

Building a data pipeline using Dataflow | GCP Dataflow Read More »

Introduction to Impala .. Architecture and Components | Impala

Cloudera Impala provides fast, interactive SQL queries directly on your Apache Hadoop data stored in HDFS or HBase. In addition to using the same unified storage platform, Impala also uses the same metadata, SQL syntax (Hive SQL), ODBC driver, and user interface (Cloudera Impala query UI in Hue) as Apache Hive. This provides a familiar …

Introduction to Impala .. Architecture and Components | Impala Read More »

Introduction to DAX

DAX stands for Data Analysis Expressions a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Also, It’s a formula language associated with the Data Model of Microsoft Excel Power Pivot and with Microsoft Power BI. There’s a definition called DAX function which …

Introduction to DAX Read More »