Skip to content
AdatisAdatis
  • Home
  • Services
    • Advise
      • Data Strategy
      • Data Governance
      • Solution Envisioning
      • Data Maturity Assessment for Organisations
      • Business Change Management
      • AI Proof of Concept
      • Azure Data Warehouse Health Check
    • Accelerate
      • Rapid Data Analytics Deployment
      • Rapid Azure Landing Zone
      • Rapid Power BI Business Value
      • Rapid Data Lake Ingestion Service
      • Rapid Azure Sentinel Deployment
      • Rapid Data Governance Quickstart
      • AI Model Review
    • Deliver
      • Microsoft Fabric
      • Data Architecture
      • Modern Data Warehouse
      • Data Analytics & Visualisation
      • Data Science & AI
      • Data Migration & Application Integration
      • Power BI
    • Operate
      • Managed Services
      • Microsoft CSP Licensing
      • Database Administrator as a Service
      • Power BI as a Service
  • Experience
    • Retail & Consumer Goods
    • Education
    • Government
    • Healthcare
    • Utilities
    • Travel and Tourism
    • Leisure and Hospitality
    • Pharmaceutical
    • Media & Entertainment
    • Financial Services & Insurance
    • Manufacturing
    • Legal
    • Nonprofit Data Warehouse QuickStart
    • Customer Success Stories
  • About
    • People
    • Our Team
  • Careers
  • Blog
  • Contact

Our Blog

Knowledge sharing is a huge part of our culture. We've written over 500 blog posts on a diverse range of topics (not just geek stuff).

Culture News & Events Thought Leadership Tech
Building Data Apps with Python’s Streamlit

Off-the-shelf solutions for interactive data app development such as Microsoft

27
Nov
Power BI to Power AI – Part 3

This post is the third part of a blog series

27
Nov
Data Factory
Data Factory in Fabric
23
Nov
An Introduction to Semantic Link in Microsoft Fabric
15
Nov
Prompt Engineering and Creating a Python Function to Query OpenAI
15
Nov
Exploring different options for collaborative workspaces: Hex, Hyperquery & Deepnote
07
Nov
Dataverse Integration with Microsoft Fabric
12
Oct
Data Activator as it is now…
11
Oct
Synapse Link for Dataverse – Delta Lake Export
26
Sep
Power BI Time Series Analysis: How to create a Moving Average on time series data and enhance the Decision-Making process
11
Sep
Forget Python! Building Models in Power Query
17
Aug
Unravelling Data Ageing and Azure Access Tiers – Part 2
28
Jul
Introduction to Microsoft Power BI Developer Mode
12
Jul
Lambda Architecture: Synapse Analytics vs Microsoft Fabric
09
Jun
Exploring MS Fabric: A Power BI View
09
Jun
Calculating Working Hours Between Two DateTime Columns in PowerBI with a PowerQuery Custom Function
20
May
Exploring the Potential of Managed Airflow in Azure Data Factory
13
Apr
Fully Automating the Deployment of a Self-Hosted Integration Runtime
04
Apr
The future of Virtual Reality and Augmented Reality in Data
07
Mar
Understanding Data Lineage: Uploading custom Azure Purview Processes using Python
10
Feb
Use of Azure Data Explorer and Azure Stream Analytics in IoT solutions
19
Dec
Timespan Fact Table
29
Nov
How to Use a Python Azure Function to Send Messages to an Event Hub
04
Nov
Everything you need to know about Snapshot Fact Tables
01
Nov
Meet our recommended Cloud Solution Provider (CSP) – Telefónica Tech
28
Sep
Data and AI event for Higher Education
Advancing Academia – Data and AI event for Higher Education
18
Aug
Configuring initialisation scripts for Azure Databricks
01
Aug
Artificial Intelligence database
How Artificial Intelligence and Data Add Value to Businesses
23
May
Databricks Vs Synapse Spark Pools – What, When and Where?
03
May
Power BI to Power AI – Part 2
27
Apr
Geospatial Sample architecture overview
19
Apr
Data Lakehouses for Dummies
13
Apr
Digital Twins Representation
Enable Smart Facility Management with Azure Digital Twins
06
Apr
Migrating On-Prem SSIS workload to Azure
30
Mar
Send B2B data with Azure Logic Apps and Enterprise Integration Pack
24
Mar
Scoring a Machine Learning Model using Synapse SQL
02
Mar
Power BI to Power AI – Part 1
18
Feb
Getting Started With Azure BICEP
07
Feb
Part 1 – Introduction to Geospatial data
24
Jan
Logic Apps: Saving files sent via Emails into Blob Storage
20
Jan
Create and setup B2B Integration Account in Azure
14
Jan
Time to move to the cloud? What to expect when migrating to Azure
16
Dec
Serverless Transformation Data Pipelines with Serverless SQL Pools
13
Dec
Basic structure of x12 Edi message
06
Dec
MultiVendor Cloud Security with the Microsoft Stack
29
Nov
Azure Logic Apps B2B EDI integration capabilities
02
Nov
Create Integration Services (SSIS) solution
28
Oct
How does Terraform work?
20
Oct
Overview of Data Migration Assistant (DMA)
11
Oct
Cloud Migration
29
Sep
Using Azure Data Studio SQL Notebooks
24
Sep
Databricks for Dummies: An Introduction to Databricks
10
Sep
Prepare and pass DP-300 (Administrating relational databases on Microsoft Azure) 
01
Sep
Resolving merge conflicts in Azure DevOps via extension
17
Aug
image of people looking at a computer screen
What Adatis and Microsoft’s Cloud Solution Provider (CSP) Licencing can offer you
13
Aug
People sitting around the table having a team meeting
How To Build Accountable Project Teams
04
Aug
Rapidly Deploying Azure Policies In Terraform
26
Jul
Integrating SAP with Power BI
21
Jul
Is it time to outsource your Database Administrator role?
13
Jul
Useful Metadata Generated SQL Queries
08
Jul
Skewness in Azure Synapse hash-distributed tables visualised with Power BI
07
Jun
What is automation testing and Why do you need it?
17
May
Databricks Repos – What it is and how we can use it
11
May
MLFlow: Introduction to Model Registry
30
Apr
Meet the Team – Richard Whitehead, Senior Agile Project Manager
23
Apr
MLFlow: Introduction to MLFlow Tracking
06
Apr
Querying and Importing Data from Excel to SSMS
19
Mar
Data Engineering for Graduates and New Starters
04
Mar
Visualising your Infrastructure with Terraform Graph With VS-Code
09
Feb
Data Lineage with Azure Purview
12
Jan
Use cases for Recursive CTEs
17
Dec
Getting Started with Azure Purview
11
Dec
An Introduction to ApexSQL Complete – Integration with SSMS
09
Dec
Integration Runtimes in Azure Data Factory
30
Nov
A Cost Comparison between PaaS and IaaS Cloud Architectures
20
Nov
Deep Dive into the Common Data Model Video Presentation
23
Oct
Optical Character Recognition (OCR) using Tesseract and Databricks
19
Oct
An experiment with Azure Custom Vision
12
Oct
Exploring the Power BI Tenant Settings (Part 1)
28
Sep
Data Vault Architecture
A Gentle Introduction to Data Vault
22
Sep
Azure Data Explorer… what about it?
21
Sep
How big is your PBIX?
18
Sep
Cyber-Security Use Case methodology for Rapid Azure Sentinel
16
Sep
The Common Data Model in Azure Data Lake Storage – Azure Data Services – Data Factory Data Flow
08
Sep
The Common Data Model in Azure Data Lake Storage – Azure Data Services – Databricks
03
Sep
Running ML Predictions in SQL Server
01
Sep
Gain Rapid Power BI Business Value with an Adatis Proof of Concept
27
Aug
Automating creation of Databricks Pools via PowerShell
25
Aug
Nine Things Organisations Need to Consider When Thinking About Data Maturity
18
Aug
Project Forecasting – why it’s important (even in agile!)
13
Aug
The Adatis Maturity Assessment Framework
04
Aug
Dynamic Datasets in Power BI
24
Jul
GraphFrames: An overview
22
Jul
Rapid Azure Landing Zone Deployments
14
Jul
Creating a roadmap to implement a modern data warehouse
13
Jul
Risk management
Risk Management. We’ve Got It Nailed, Don’t We?
08
Jul
The Adatis Rapid Analytics Deployment Service
07
Jul
Design tips to level up your Power BI Dashboard
30
Jun
Data Clustering with Python
26
Jun
Snowflake – Part 2: Provisioning and Potential Red Flags
23
Jun
Use cases for Common Table Expressions (CTEs)
19
Jun
Meandering Through R (Part 2: Communicating Data)
17
Jun
Power BI Page Report Tooltips
Data Storytelling with Power BI – Part 3
12
Jun
Top 10 Power BI Best Practice Tips (Part 3)
08
Jun
Power BI Page Report Tooltips
Data Storytelling with Power BI – Part 2
04
Jun
Storytelling with Power BI reports
Data Storytelling with Power BI – Part 1
27
May
Finding duplicate objects following Git merges
13
May
Personal Azure Firewall Rule PowerShell Script for PaaS Resources
06
May
Power BI Connectivity Types
06
May
Agile Testing
29
Apr
Successful Enterprise Roll-Out of Power BI (Part 3)
21
Apr
Meandering Through R (Part 1: Working with Data)
16
Apr
Can a Shared Resource Model be of Help Now?
03
Apr
Performance enhancements in Delta Lake
30
Mar
Using Azure Key Vault secrets in Azure Databricks
26
Mar
Evaluating Models in Azure Machine Learning (Part 2: Regression)
18
Mar
The Common Data Model in Azure Data Lake Storage – Azure Data Services
16
Mar
Get Started with Azure Cognitive Search
11
Mar
How to convert a Phone PowerApp to Tablet layout
09
Mar
PowerBI Embedded - App Owns Data -
Power BI Embedded for your customers – Part 2
06
Mar
    About

    Here the Adatis team share their musings and latest perspectives on all things advanced data analytics.

    Categories
    Tag Cloud
    AI Analysis Services Artificial Intelligence Automation Azure Azure Databricks Azure Data Factory Azure DataWarehouse Big Data Business Intelligence C# company culture Dashboards data analytics Databricks Data Lake Data Science Data Warehousing DevOps ETL Excel Infrastructure Machine Learning Master Data Management Master Data Services MDM MDS MDX PerformancePoint PowerBI Power BI PowerBIDesktop PowerPivot Power Query Python R Reporting Services SQL SQL Server SQL Server 2005 SQL Server 2008 SSAS SSIS SSRS Tabular
    Archives
    • November 2023 (8)
    • October 2023 (2)
    • September 2023 (3)
    • August 2023 (1)
    • July 2023 (5)
    • June 2023 (3)
    • May 2023 (5)
    • April 2023 (3)
    • March 2023 (2)
    • February 2023 (1)
    • December 2022 (1)
    • November 2022 (3)
    • October 2022 (1)
    • September 2022 (1)
    • August 2022 (3)
    • July 2022 (1)
    • May 2022 (2)
    • April 2022 (4)
    • March 2022 (4)
    • February 2022 (3)
    • January 2022 (3)
    • December 2021 (3)
    • November 2021 (3)
    • October 2021 (5)
    • September 2021 (5)
    • August 2021 (3)
    • July 2021 (6)
    • June 2021 (3)
    • May 2021 (7)
    • April 2021 (7)
    • March 2021 (3)
    • February 2021 (5)
    • January 2021 (3)
    • December 2020 (7)
    • November 2020 (5)
    • October 2020 (6)
    • September 2020 (11)
    • August 2020 (5)
    • July 2020 (10)
    • June 2020 (9)
    • May 2020 (9)
    • April 2020 (8)
    • March 2020 (11)
    • February 2020 (15)
    • January 2020 (13)
    • December 2019 (11)
    • November 2019 (17)
    • October 2019 (13)
    • September 2019 (6)
    • July 2019 (2)
    • June 2019 (3)
    • May 2019 (3)
    • April 2019 (5)
    • March 2019 (4)
    • February 2019 (7)
    • January 2019 (12)
    • December 2018 (9)
    • November 2018 (7)
    • October 2018 (7)
    • September 2018 (4)
    • August 2018 (3)
    • July 2018 (3)
    • June 2018 (5)
    • May 2018 (4)
    • April 2018 (4)
    • March 2018 (13)
    • February 2018 (16)
    • January 2018 (15)
    • December 2017 (7)
    • November 2017 (3)
    • October 2017 (8)
    • September 2017 (4)
    • August 2017 (5)
    • July 2017 (9)
    • June 2017 (7)
    • May 2017 (8)
    • April 2017 (17)
    • March 2017 (2)
    • February 2017 (8)
    • January 2017 (12)
    • December 2016 (4)
    • November 2016 (11)
    • October 2016 (8)
    • September 2016 (2)
    • August 2016 (3)
    • July 2016 (2)
    • June 2016 (1)
    • May 2016 (9)
    • April 2016 (2)
    • March 2016 (5)
    • February 2016 (6)
    • January 2016 (5)
    • December 2015 (7)
    • November 2015 (10)
    • October 2015 (2)
    • September 2015 (9)
    • August 2015 (1)
    • July 2015 (1)
    • June 2015 (4)
    • May 2015 (4)
    • April 2015 (2)
    • March 2015 (6)
    • February 2015 (5)
    • January 2015 (1)
    • December 2014 (1)
    • November 2014 (7)
    • October 2014 (5)
    • September 2014 (5)
    • August 2014 (1)
    • July 2014 (4)
    • June 2014 (2)
    • May 2014 (2)
    • April 2014 (1)
    • March 2014 (3)
    • February 2014 (2)
    • January 2014 (3)
    • November 2013 (1)
    • October 2013 (1)
    • September 2013 (4)
    • August 2013 (1)
    • July 2013 (2)
    • June 2013 (3)
    • May 2013 (2)
    • April 2013 (1)
    • March 2013 (1)
    • February 2013 (4)
    • December 2012 (1)
    • November 2012 (2)
    • October 2012 (4)
    • September 2012 (2)
    • March 2012 (3)
    • February 2012 (2)
    • January 2012 (1)
    • November 2011 (7)
    • October 2011 (2)
    • September 2011 (2)
    • August 2011 (3)
    • July 2011 (6)
    • June 2011 (3)
    • May 2011 (3)
    • April 2011 (1)
    • March 2011 (4)
    • February 2011 (1)
    • January 2011 (2)
    • September 2010 (2)
    • August 2010 (1)
    • July 2010 (1)
    • June 2010 (4)
    • May 2010 (3)
    • April 2010 (2)
    • March 2010 (4)
    • February 2010 (4)
    • December 2009 (2)
    • November 2009 (4)
    • October 2009 (4)
    • March 2009 (2)
    • February 2009 (2)
    • January 2009 (4)
    • December 2008 (5)
    • November 2008 (9)
    • October 2008 (11)
    • September 2008 (6)
    • August 2008 (11)
    • July 2008 (11)
    • June 2008 (11)
    • May 2008 (12)
    • April 2008 (11)
    • March 2008 (10)
    • February 2008 (9)
    • January 2008 (4)
    • December 2007 (7)
    • November 2007 (7)
    • October 2007 (7)
    • September 2007 (3)
    • August 2007 (7)
    • July 2007 (4)
    • June 2007 (13)
    • May 2007 (5)
    • January 2007 (1)
    • October 2006 (1)
    • August 2006 (1)
    • June 2006 (2)
    • May 2006 (1)
    • April 2006 (1)
    • March 2006 (2)
    • February 2006 (3)
    Recent Comments
    • Rajat Singh on The future of Virtual Reality and Augmented Reality in Data
    • Best Data science course in Chennai with placement on Data Science: what it is and why it matters
    • Mitesh Chauhan on Fully Automating the Deployment of a Self-Hosted Integration Runtime
    • automotive Ecm repair on The future of Virtual Reality and Augmented Reality in Data
    • godparent on Adding a Calculated Field to an Excel Pivot Table With Analysis Services
Building Data Apps with Python’s Streamlit

Off-the-shelf solutions for interactive data app development such as Microsoft Power BI are great –

27
Nov
Power BI to Power AI – Part 3

This post is the third part of a blog series on the AI features of

27
Nov
Data Factory
Data Factory in Fabric

As data engineers, we use Azure Data Factory on a daily basis to collect datasets

23
Nov
An Introduction to Semantic Link in Microsoft Fabric

Having previously worked in the water & energy industries, I recently created a utilities PowerBI

15
Nov
Prompt Engineering and Creating a Python Function to Query OpenAI

Artificial intelligence tools, like Chat GPT, are all the buzz right now, and rightfully so

15
Nov
Exploring different options for collaborative workspaces: Hex, Hyperquery & Deepnote

Real-time collaboration, code completion and data versioning are just a few of the latest capabilities

07
Nov
Dataverse Integration with Microsoft Fabric

If like me, you’ve been keeping tabs on what Microsoft has been up to in

12
Oct
Data Activator as it is now…

Fabric is the newest all-in-one analytics solution from Microsoft. It combines multiple components (some existing,

11
Oct

Office locations

London
8 Boundary Row
London
SE1 8HP

Aberdeen
Burghmuir Way
Inverurie
AB51 4FT

Surrey
Farnham Business Park
Farnham
GU9 8QT

Bulgaria
Sofia Tower 2, Level 3
"Aleksandar Stamboliyski" Blvd 101
Sofia, 1303

India
Marigold IT Park, Marisoft 1, 2nd Floor
Kalyani Nagar Pune – 411014.
Maharashtra, India

Glasgow
3rd Floor
The Garment Factory
10 Montrose Street
Glasgow
G1 1RE

Manchester
Chancery Place
50 Brown Street
Manchester
M2 2JG

Get in touch

0219 696 302(0) 44+

enquiries@adatis.co.uk

Our Social Channels

  • Home
  • Services
  • Experience
  • About
  • Careers
  • Blog
  • Contact
2023 © Adatis all rights reserved   Company Number: 05727383   VAT Registered: GB 887761165

Privacy Policy | Cookies Policy

  • Home
  • Services
    • Advise
      • Data Strategy
      • Data Governance
      • Solution Envisioning
      • Data Maturity Assessment for Organisations
      • Business Change Management
      • AI Proof of Concept
      • Azure Data Warehouse Health Check
    • Accelerate
      • Rapid Data Analytics Deployment
      • Rapid Azure Landing Zone
      • Rapid Power BI Business Value
      • Rapid Data Lake Ingestion Service
      • Rapid Azure Sentinel Deployment
      • Rapid Data Governance Quickstart
      • AI Model Review
    • Deliver
      • Microsoft Fabric
      • Data Architecture
      • Modern Data Warehouse
      • Data Analytics & Visualisation
      • Data Science & AI
      • Data Migration & Application Integration
      • Power BI
    • Operate
      • Managed Services
      • Microsoft CSP Licensing
      • Database Administrator as a Service
      • Power BI as a Service
  • Experience
    • Retail & Consumer Goods
    • Education
    • Government
    • Healthcare
    • Utilities
    • Travel and Tourism
    • Leisure and Hospitality
    • Pharmaceutical
    • Media & Entertainment
    • Financial Services & Insurance
    • Manufacturing
    • Legal
    • Nonprofit Data Warehouse QuickStart
    • Customer Success Stories
  • About
    • People
    • Our Team
  • Careers
  • Blog
  • Contact
  • Customer Login