Homepage
Open in app
Sign in
Get started
Creative Data
Improving social good by the power of data and analytics.
Azure
Power BI
Databricks
Fabric
Archive
Company
Follow
Latest
Data Warehouse (Polaris) vs. Data Lakehouse (Spark) in Microsoft Fabric
Data Warehouse (Polaris) vs. Data Lakehouse (Spark) in Microsoft Fabric
A comparison from a data workload perspective
Patrick Pichler
Oct 23, 2023
Headless BI vs. Self-service BI
Headless BI vs. Self-service BI
Brief introduction to Headless BI and putting Power BI into its context
Patrick Pichler
Jan 10, 2023
Custom Logging in Azure Data Factory and Azure Synapse Analytics
Custom Logging in Azure Data Factory and Azure Synapse Analytics
How to implement a custom logger for Azure Data Factory and Azure Synapse Analytics by querying pipeline run information via REST API
Patrick Pichler
Nov 9, 2022
Boosting Databricks ODBC Driver Performance
Boosting Databricks ODBC Driver Performance
The top 3 aspects to consider to get the most out of the Databricks ODBC driver by interacting with Delta Lake tables
Patrick Pichler
Oct 24, 2022
Sending Emails natively from Azure Data Factory or Synapse Pipelines
Sending Emails natively from Azure Data Factory or Synapse Pipelines
How to send emails programmatically via the Microsoft Graph API instead of relying on any other service like Azure Logic Apps
Patrick Pichler
Oct 21, 2022
Automating Export To File with Power BI Pro
Automating Export To File with Power BI Pro
How to export reports programmatically with a Power BI Pro license only and send it to an arbitrary number of users via Azure Data Factory
Patrick Pichler
Sep 15, 2022
Using Variables in Databricks Workflows
Using Variables in Databricks Workflows
How to pass on values to downstream tasks in Databricks Workflows by leveraging Job Task Values
Patrick Pichler
Jul 21, 2022
Real-time Monitoring of Apache Spark Streaming Jobs with Power BI
Real-time Monitoring of Apache Spark Streaming Jobs with Power BI
How to push Apache Spark’s streaming metrics into Power BI in real-time
Patrick Pichler
Apr 26, 2022
Interactive Analytics on Azure Event Hub with Trino
Interactive Analytics on Azure Event Hub with Trino
How Trino enables you to run interactive SQL queries on top of Azure Event Hub streaming data
Patrick Pichler
Apr 20, 2022
RStudio and Databricks Better Together
RStudio and Databricks Better Together
All you need to know for running RStudio and Databricks side-by-side
Patrick Pichler
Feb 23, 2022
Azure Synapse Analytics Serverless SQL Pool Guidelines
Azure Synapse Analytics Serverless SQL Pool Guidelines
How to achieve the best performance and a smooth experience by working with serverless SQL pools for building successful data lakes
Patrick Pichler
Aug 20, 2021
Comparing Selected Categories in Power BI
Comparing Selected Categories in Power BI
How to compare multiple selected categories in Power BI without duplicating tables, slicers or visuals
Patrick Pichler
Aug 12, 2021
Data Warehouse Automation Using dbt on (Azure) SQL Server
Data Warehouse Automation Using dbt on (Azure) SQL Server
5 things you should be aware of before adapting dbt on (Azure) SQL Server for automating data warehousing/modeling
Patrick Pichler
Aug 6, 2021
Open Streaming Data Architecture Using Azure
Open Streaming Data Architecture Using Azure
An open and portable approach for integrating and persisting real-time data on a distributed storage at low cost
Patrick Pichler
Jul 16, 2021
Driving Insights at Scale Using a Common Data Model (CDM) on Azure Data Lake
Driving Insights at Scale Using a Common Data Model (CDM) on Azure Data Lake
Why the Common Data Model is about to be the keystone of modern data insights architectures on Azure and how to use it with Power BI…
Patrick Pichler
Apr 9, 2021
About Creative Data
Latest Stories
Archive
About Medium
Terms
Privacy
Teams