Topics covered:

1. What is Microsoft Fabric (and what does it have in common with the football team😉)?

2. What are the key pillars of Microsoft Fabric?

3. Why DirectLake for Power BI is (potentially) a REAL revolution?

4. Lakehouse, Warehouse...Understanding different "houses" in Microsoft Fabric

5. How much will it cost you?

6. What now for Azure Synapse Analytics?

https://data-mozart.com/microsoft-fabric-beyond-hype-and-marketing/

#PowerBI #synapseanalytics #MSBuild #data #ai

Blogged:
Adding label column for optionset in fact table
More nuances in making a useful facts table from Dynamics sales data #datawarehouse #synapseanalytics #100DaysToOffload
https://www.synesthesia.co.uk/note/2023/05/05/adding-label-column-for-optionset-in-fact-table/

My newest blog post demonstrates how to build #SynapseAnalytics pipelines test automation with #xunit and Azure #devops.

https://dev.to/jannepasanen/automated-testing-of-synapse-pipelines-using-xunit-and-azure-devops-5b5e

Blogged:
Adding columns to parquet-based fact table
Still learning the basics of working with Parquet files and PySpark #datawarehouse #synapseanalytics #100DaysToOffload
https://www.synesthesia.co.uk/note/2023/05/04/adding-columns-to-parquet-based-fact-table/

3. A few months ago, I started publishing a LinkedIn newsletter: Data Mozart on Tuesdays. I'm beyond excited that 7000+ individuals subscribed to receive the latest articles on #powerbi and #synapseanalytics. Thank you ALL!

4. My YouTube channel (yes, yes, I have it, although I'm struggling to find time to create more videos) reached almost 1.5k subscribers!

It's #PowerBI time!

After 3 days of FREE learning on #azure #synapseanalytics and #purview topics, let's move on to the core part of the #DP500 exam!

And, if you ask me, today's module is my favorite - Designing and building tabular models with Power BI.

It's still not late to join the learning tribe: https://learn.data-mozart.com/courses/mastering-dp-500-exam-azure-enterprise-data-analyst

Round-robin, replicated, or hash? Which table distribution option should you choose in the Dedicated SQL pool in #azure #synapseanalytics? How to leverage various query performance tuning options?

These are some of the questions we'll answer on Day 3 of the FREE learning journey on Mastering DP-500 Azure Enterprise Data Analyst certificate!

Join 1600+ data enthusiasts on this FREE learning journey!

Enroll: https://learn.data-mozart.com/courses/mastering-dp-500-exam-azure-enterprise-data-analyst

Details: https://data-mozart.com/free-learning-master-dp-500-skills-in-a-week/

Easter is coming, so it’s giving time! In the first week of April (the week before Easter), the course will be completely FREE to access!!! No strings attached! Yes, it’s true!

More details in the blog post: https://data-mozart.com/free-learning-master-dp-500-skills-in-a-week/

Please share and spread the word, so more people can take advantage of this unique offer!

#powerbi #synapseanalytics #dp500 #learning

Join me and the awesome Brum crew at
@MSDataGroupBrum
Thursday 1pm (UTC/GMT) in this demo-heavy session on Power BI & Synapse. We'll go through several features of each service and see whether they are actually useful.. 🤔https://meetup.com/microsoftdataplatformbirmingham/events/291201132/ #Azure #PowerBI #SynapseAnalytics

New blog: Azure Synapse Link for Dataverse: Understanding Advanced Configuration Settings https://serverlesssql.com/azure-synapse-link-for-dataverse-advanced/ #Azure #SynapseAnalytics #Dynamics #Dynamics365 #PowerPlatform #SynapseLink

We have an agenda for our next Azure Synapse Analytics conference Data Toboggan on Saturday January 28th! https://www.datatoboggan.co.uk/winter-edition-2023-agenda-saturday-january-28th/ #Azure #SynapseAnalytics #DataCommunity

Lovely #DataCommunity people (buttering you up…), as we’ve had lots of great sessions in for
@datatoboggan
we’re running 2 tracks again! If you’re available to help us moderate on Saturday 28th January could you reach out please? Thank you in advance #Azure #SynapseAnalytics

Enabling custom DNS entries on an Azure Synapse dedicated SQL pool inside an Azure Synapse workspace for disaster recovery scenarios. #cloud #data #synapseanalytics #analytics #azure #sql #disasterrecovery

https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/create-dns-alias-for-dedicated-sql-pool-in-synapse-workspace-for/ba-p/3675676

New blog: Azure Synapse Analytics in 2022 - A Retrospective... https://www.serverlesssql.com/general/azure-synapse-analytics-in-2022-retrospective/ #Azure #SynapseAnalytics #SynapseInfluencer #DataCommunity

New video: Setting up Dynamics 365 Sales data sync with Azure Synapse Analytics using Synapse Link https://youtu.be/WxNqT8OqdBE as a test the thumbnail and title is quite click-baity…I’m curious to see what happens with engagement #Azure #SynapseAnalytics #Dynamics365

Lots of #azure stuff learned during the past year. Still, I have to say the most interesting new acquaintance was #synapseanalytics. Interesting to see what features will be launched in 2023.

My next video is going to have a clickbait title and image just for a test of engagement…this is an example of what it’ll be…hmm torn with using a click bait title but I’ve fascinated to see what impact it’ll have #Azure #SynapseAnalytics

OK so I was able to create another Dynamics 365 Sales trial after the previous trial (same account) expired, so maybe there's no restrictions on how many trials you can have? Very useful to continue testing Synapse Link for Dataverse #Azure #SynapseAnalytics #Dynamics365

https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-mvp-corner-november-2022/ba-p/3696939 A great list of Synapse resources (thanks for the shout-out). Personal favourite is
Paul Andrew's
Data Mesh architecture in Azure (up to 16 blogs now) #Azure #SynapseAnalytics #SynapseInfluencers #DataCommunity

Call for Speakers is still open for our Azure Synapse Analytics winter conference on Saturday January 28th 2023! Time to get those Azure Synapse Analytics sessions in (45 minute and 10 minute talks available). https://sessionize.com/data-toboggan-2023/ Azure #SynapseAnalytics #SynapseInfluencers