Terms, Definitions & How to get started — Since the introduction of Microsoft Fabric last week, users of Power BI Embedded are now able to leverage new capabilities of Microsoft Fabric while simultaneously keeping their Power BI Embedded technologies in combination with the usage of Power BI REST APIs[1]. What is Microsoft Fabric? Microsoft Fabric is an analytics platform that operates in…

Microsoft’s new End-to-End Data and Analytics Platform — Microsoft just has unveiled Microsoft Fabric, a new type of end-to-end data and analytics platform built on the company’s OneLake Data Lake. The platform also will support integration with other cloud storage services, such as Amazon S3 and Google Cloud Platform in the near future. Competitor Google has presented BigLake…

How to prevent erroneous and wrong Data in the Integration Process — In times of Big Data and Cloud, more and more data will be created and so also be transferred into data architectures like Data Warehouses , Data Lakes and Data Lakehouses. Therefore, it’s important to integrate data with a good data quality. Here are five common checks, every Data Engineer…

How Google wants you to save Money and Time when working with BigQuery — When working with Google’s Data Warehouse BigQuery, you can tune performance with using Clustering and Partitioning. Google now launches a Recommender for that. Partitioning tables in BigQuery can optimize your data storage. It divides a bigger table into various smaller ones that have more manageable parts. As a result, the…

Microsoft Power BI, Azure Synapse, and Azure Data Factory are unified to one Software — Microsoft launches Microsoft Fabric and Copilot for Microsoft Power BI. Fabric is for now in preview but should soon be an end-to-end, human-centered analytics product. Therefore, it brings together Microsoft Power BI, Azure Synapse, and Azure Data Factory into one unified software as a service (SaaS) platform[1][2].

Azure Synapse now with CDC for Cosmos DB Analytical Store — Microsoft has introduced a new feature regarding Data Warehouse Azure Synapse: Users can now make use of CDC for Cosmos DB Analytical Store. This means that when performing data integration via ETL or ELT processes, jobs have the ability to perform at a higher quality and thus be more effective…

How new Approaches should thrive Data-Driven Decisions — In this article, I want to explain what is meant by Next Generation Data Marts — a term which is often heard lately. Data Marts are still a very important feature when building up a data platform within your company. …

How you now anonymize Data more easily — Google has just announced the public preview of BigQuery differential privacy with SQL building blocks. You can use these functions to anonymize their data. Differential privacy includes four differential privacy aggregate functions that can be used to anonymize data[1]: AVG COUNT, SUM, PERCENTILE_CONT Differential privacy is a (mathematical) framework for…

How Snowflake is bringing new Options when working with Semi-Structured Data — Since I haven’t reported anything about Snowflake for a long time, there are now interesting news about SQL functionalities if you work with arrays, so besides structured data also with semi-structured data. Snowflake launches ServiceNow Connector How Snowflake wants to empower Businesses through Data Driven Decisionsmedium.com