Data Platform Central

Request A Video Series: ​DAX – Weekly Cumulative Over Month

Power BI Quick Tip: Anomaly Detection in Line Charts​

Azure Data Factory/Synapse Pipeline Tip : Google Sheet Connector - An Intro

Azure Synapse Tip: ​Visualizing PowerApps Data Real-Time Using Synapse Link​

Azure Data Factory (ADF) Tip: ​Implementing Automatic File Processing Using Event Triggers​

Power BI Quick Tip: ​Implementing Object Level Security (OLS) in Power BI​

Power BI Quick Tip: Performing Correlation Analysis Using Correlation Matrix​

Azure Data Factory (ADF) How To Tip: Metadata-driven Copy Task = Flexible Copy Activity​

Power BI Quick Tip: ​Integrating Synapse Analytics to Power BI Workspace​

Ask A Question Series: ​ Power BI - Implementing Cross Highlighting Visuals​

PowerBI DAX Tip : Demystifying WINDOW Function

Transact SQL Quick Tip : ​Role Based Data Masking aka Dynamic Data Masking

Request A Video Series: ​DAX Tip – Last N Weekly Rolling Calculation​

Power App Tip: Implementing Custom AI Models in Power Apps Using AI Builder

Power BI Quick Tip : Generate Line Charts With Dynamic Measures And Comparators

Azure Data Factory / Synapse Pipeline (ADF) Quick Tip: Lake Databases – An Overview

Power BI Tip: Implementing Usage Tracing and Execution Monitoring in Power BI Workspace​

Power BI Quick Tip: ​Drill Down Combo Pro By ZoomCharts – An Overview

Azure Data Factory (ADF) Quick Tip: Using Graph API to Extract Azure AD Information

PowerBI DAX Tip : Demystifying Relative Position Logic in WINDOW Function

Power App Tip: Implementing AI Models in Power Apps

Request A Video Series: ​Deployment Pipelines – Migrate Power BI Artifacts Across Environments​

Power BI Quick Tip: Getting Most Out Of Formatted Tables​​

Azure Data Factory Quick Tip: Transfer Data From XML Document to Azure SQL Database

Power BI Power Automate Quick Tip: Append Push Datasets in Real-time Based on a SQL Server Table

Power BI Quick Tip: Using Dynamic M Query Parameters with SQL​​

Power App Tip : Create Simple App for Dataverse Data Manipulation & Analyze with Power BI

Power BI Quick Tip: ​Power BI + Power Automate = Powerful BI Automation ​

Azure Data Factory (ADF) Quick Tip: Implement Easy Data Validations Using Assert Transform​

Power BI Quick Tip: ​Utilizing XMLA Endpoints to Create and Deploy Power BI Models​

CosmosDB Quick Tip : JOINS & Subqueries Using SQL API​

Power BI Quick Tip: ​Visualizing Real-Time Cosmos DB Data Using Synapse Link​

Power BI Quick Tip: ODBC Sources And Architecture Mismatch​ in Paginated Reports

Request A Video Series: ​DAX – Weekly Cumulative Over Month

Ask A Question Series: ​Power BI – Convert Offset Value to Time​

Power BI Quick Tip: Using Fuzzy Lookup & Clustering in Power BI Dataflows

Power BI Quick Tip: ​JSON Table Inference – Extract Tabular Data From JSON

Azure Data Explorer Quick Tip: ​Introduction to Azure Data Explorer Clusters & Kusto QL

Ask A Question Series: ​Power BI – Highlight Row/Column Based on Slicer Selection

Azure Data Factory Quick Tip - Dynamic Copy Data Task By Parameterizing Linked Service Properties

Power BI Quick Tip: ​Step Folding Indicators in Power BI Dataflows​

Transact SQL Quick Tip : ​Data Masking in JSON Arrays Using JSON_MODIFY

Azure Synapse Tip: ​Implementing Spark Based Recommendation Engine in Azure Synapse​

Power BI DAX Tip : Demystifying INDEX Function

Synapse Pipeline (ADF) How To Tip: Conditional File Transfer Using Amazon S3 Connector

Power BI DAX Tip: ​Demystifying RANKX Function

Azure Data Factory (ADF) Quick Tip: Reusable Data Flows A.k.a Flowlet

Power BI Quick Tip: Introducing Data Marts

Azure Data Factory (ADF) Quick Tip: Invoking REST APIs Using External Call Transform

Power Query Quick Tip: ​Aggregated Filters Using Sub-Tables​

Power BI Quick Tip: ​Using Parquet File as a Source