David Mills
Dufrain - Azure Data Architect
Derby, United Kingdom
Actions
I am a Data Architect specialising in Microsoft Fabric and Azure, with 25 years of experience in data. As a 7x Microsoft Certified Professional, I design cloud-native Fabric data platforms optimised for performance, scalability, and security.
I have a strong passion for Fabric Security and Governance, sharing my insights through LinkedIn blogs, hosting Microsoft Fabric Analyst In A Day (FAIAD) workshops, and speaking at UK events like the Manchester Power BI & Fabric group.
With a proven track record, I help clients build end-to-end data platforms—both cloud and on-premises—including data warehousing, data modelling, ETL pipelines, real-time analytics, and Power BI reporting.
Area of Expertise
Topics
Real-Time Intelligence - Live Cryptocurrency Price Ingestion
Fabric Real-Time Intelligence is still a mystery to many clients I’ve spoken to recently. In this session I’d like to demystify the process and demonstrate how to build a Fabric RTI solution from scratch using a modern and unique use-case!
I'll show the audience how to ingest the top 10 crypto coin prices from the CoinGecko API into an Azure Event Hub. Then I’ll display how Microsoft Fabric Real-Time Intelligence ingests, transforms, alerts, and report on the data in real-time!
The session is split into 5 parts.
1) Python script calls CoinGecko API to retrieve real-time prices for the top 10 Cryptocurrencies.
2) Latest prices from the API call are ingested into an Azure Event Hub.
3) Connect Fabric EventStream to Azure Event Hub as the data source.
4) Populate Fabric KQL database (hot path) and Fabric Lakehouse (warm path).
5) Generate Fabric Real-Time Dashboard.
The key takeaways are showing the audience how an Azure Event Hub and Fabric Eventstreams communicate with each other. I also want to highlight how to build a Real-Time Intelligence Dashboard with the Crypto Price data.
I haven’t seen anybody demo this RTI scenario before and considering Crypto is a hot topic I think it would generate some crowd interest!
Note I have blogged about this on LinkedIn if you want to see how it’s done beforehand.
https://www.linkedin.com/feed/update/urn:li:ugcPost:7271835305752645633/
Thanks again for your consideration.
Very best wishes.
Dave.
Microsoft Fabric Security 101
In this session, I'll discuss the importance of implementing multi-layered security in a Fabric Data Platform and how Identity, Networking and Data Security should be interlinked.
I'll discuss key Fabric security layers including:
Physical Data Centre and Disaster Recovery: How does Microsoft protect your data at source with Azure Availability Zones and Disaster Recovery.
Entra ID: User Authentication. How does Microsoft ensure users are who they say they are?
Networking: How does Fabric deal with data sources protected by firewalls and private endpoints. Also an overview of Azure Private Link.
Admin Portal Config: How do you secure your Fabric Admin Configuration Settings.
Multi-Layer Security Model: How do you correctly set your Fabric workspace and item-level permissions.
Workspace Roles: How do you allocate privileged Workspace Roles to Users or Security Groups.
RLS,CLS,OLS: Once authenticated how do you allow your users access to what they allowed to see at the data level.
OneLake Security: How can you restrict access to Lakehouse Items separately from Workspace Roles.
Data Encryption: How does Microsoft deal with Fabric data encryption stored at rest and during in-flight transfer.
Note this session won’t just be slides.
I’ll show the audience three demos on using the following Fabric features:
1) Workspace Identities against a firewall protected storage account.
2) Managed Private Endpoints against an Azure SQL Database blocked by public access.
3) OneLake Security against specific Lakehouse tables and folders.
I’ve already delivered this session to the Manchester Power BI & Fabric User Group in the UK which was well received. The session is around 45 minutes leaving enough time for Q&A.
Thanks for your consideration and very best wishes!
David.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top