What are dbt meetups? dbt Meetups are networking events open to all folks working with data! Talks predominantly focus on community members' experience with dbt, however, you'll catch presentations on broader topics such as analytics engineering, data stacks, data ops, modeling, testing, and team structures.

🤝Organizer: dbt Labs (Amada Echeverría, Community Team) 🏠Venue/Host: Snowflake Office (Room: the Lodge on the 5th floor) @ One Crown Place, London EC2A 4EF, UK 🍕Catering: Refreshments will be provided

To attend, please read the Health and Safety Policy and Terms of Participation: https://www.getdbt.com/legal/health-and-safety-policy

📝Agenda

• 5:00 - 5:40 \| Check in/Registration (40 min)
• 5:40 - 5:45 \| Welcome Remarks by our meetup host\, Snowflake (5 min) and dbt Labs’ Community Team
• 5:45 - 6:05 \| Presentation 1: Kshitij Aranke (Senior Software Engineer @ dbt Labs) on ‘Hands-on with our latest innovations in dbt Core 1.10” (20 min)
• 6:05 - 6:15 \| Presentation 1 Q&A (10 min)
• 6:15 - 6:35 \| Fireside chat with Tristan Handy (Founder & CEO @ dbt Labs) and Alex Lambert (Director Solution Engineering UK @ Snowflake) on The Analytics Development Lifecycle (20 min)
• 6:35 - 6:45 \| Q&A for Tristan and Alex (10 min)
• 6:45 -6:50 \| Closing Remarks by Snowflake and dbt Labs’ Community Team (5 min)
• 6:50 - 8:00 \| Reception (Please be mindful that we need to leave the space by 8:30)

EVENT DETAILS: The doors open at 5pm. Presentations begin at 5:40pm. Food and refreshments will be provided. The venue has capacity limits, so please update your RSVP status on the Meetup to "Not Going" if you are unable to attend.

DIRECTIONS: Please bring an ID. The Snowflake office is located on the 5th and 6th floor of a multi-tenant building. Upon arrival visitors are greeted at ground floor reception and asked to check-in and sign Snowflake’s NDA via the Envoy check-in system. Visitors are either escorted to the lift area or await the host to pick them up.

➡️ Join the dbt Slack community: https://www.getdbt.com/community/ 🤝For the best Meetup experience, make sure to join the #local-ldn channel in dbt Slack (https://slack.getdbt.com/). ---------------------------------- dbt is the standard in data transformation, used by over 40,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust. Learn more: https://www.getdbt.com/

Details

We're delighted to announce our next meetup will be hosted by Wise.

Agenda: 6:00pm: Doors open, networking, food, drinks. 7:00pm: Talks start! 8:00pm: Talks finish, Q&A. 8:30pm: Further drinks and networking @ The Owl & Pussy Cat - Drinks sponsored by Omni

Speakers: How to Build a Market Leading Embedded Analytics Product in 2024 – Jonny Dungay - Primary Bid

How Analytics Engineering empowers 150+ Analysts at Wise - (21) Deckel de Lange, Yara Burvin & Moritz Kerstan - Wise

London Analytics Engineering Meetup is focused on discussing and spreading best practices in the growing field of analytics engineering. Whether you've set up the "Modern Data Stack" many times over or are brand new to tools like dbt, Looker, Snowflake, Bigquery and more, this is the meetup for you.

Agenda 18:00 - 18:15 - Welcome 18:15 - 19:00 - Old Name - New CLI - why you should take a look at sqlcmd - Rob Sewell Introduced with SQL Server 2005 and replacing osql, sqlcmd has been a part of SQL Server professionals toolbox for a long time now. Many people only know it from the sqlcmd mode switch in SSMS, while others use it within automation as a lightweight easily available query runner. I have long recommended that DBAs are familiar with using it as it may be the only option to query an instance in severe emergencies. Times they are a changing. There is a new sqlcmd available and it has some awesome new capabilities. Let me introduce you to the new sqlcmd in a fun filled demo session and show you the new things it can do and why they will be of benefit to all Data Professionals We will cover deploying a database into a container from a backup with one command. Querying it, Opening it in Azure Data Studio, all from the command line and much more.

Rob Sewell Be-Whiskered Automator of Things Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, SQLBits committee member, PSConf EU organiser, and co-leader of Data South West UK User Group. H has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities. He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more. He has a fabulous beard

17:30 - Pizza and networking

19:30 - 20:45 - Realtime streaming data with Microsoft Fabric - James Dales Realtime streaming data is now possible within Microsoft’s new SaaS environment, Microsoft Fabric, without any Azure resources required. In this session we’ll stream data from aircraft transponder data and other sensors directly into Microsoft Fabric via EventStream into KQL DB and OneLake, and analyse the results, both live and historic in Power BI. The session will be back to back demos as we build the whole solution from scratch – what could go wrong!?

James Dales James Dales is the Global Capability Lead for Microsoft Fabric and Power BI at Avanade and is a Microsoft FastTrack Recognised Solution Architect. As a Microsoft Data Platform MVP he is the co-leader of the London Power BI user group. In 2019 he became the first member of the Power BI Contributors Program, working alongside the Microsoft engineering team to build new functionality into the Power BI product itself. He has a keen interest in spatial analytics and is the author of the Icon Map custom visual.

PBI Manchester 27th July 2023 Location: Bruntwood Sci-Tech - 103, Oxford House, Oxford Rd, Manchester M1 7ED 5:40pm for a 6pm start (event will wrap up around 8:15pm)

Key note guest speakers

1. Rishi Sapra -
2. Mathias Thierbach

Who is Rishi ? He works as a Group Manager at Avanade - a Joint Venture between Accenture and Microsoft which has been MS Partner of the Year for the last 15 Years - specialising in Power BI. Prior to this he has spent 12 years in Consulting /Financial Services (Deloitte, HSBC, Barclays, KPMG) and is a qualified accountant with a background in Business modelling and process improvement. He is actively involved in the Power BI Community in London and has presented at Meetup groups and several global conferences. He also runs two core communities - LDI (www.learndatainsights.com) for people to take data analytics quizzes and courses and PPF (www.powerplatformfinance.com) for helping finance professionals apply the Power Platform technology stack in their roles.

Topic wise Rishi is planning on showing the (new) back end behind the Fabric quizzes he has on his LDI site https://learndatainsights.com/ - xml files for each quiz attempt pushed through real-time analytics in fabric with direct lake PBI on top

What's new for Power BI Source Control

Learn about three recent substantial innovations for Power BI Pro Developers: TMDL, Power BI Developer Mode, and Workspace Git Integration. TMDL, the new Tabular Model Definition Language, was announced in Public Preview in April 2023. It is a new declarative format for Power BI tabular models that is designed to be human readable and editable as well as collaborative. It is perfectly suited for use of source control and CI/CD when developing tabular models in a professional environment. Mathias contributed the language design and implementation to the Power BI product team as part of their Community Contributor Program. Learn from him, first-hand, what it is all about, how TMDL works, what problems it solves, and which tools are available. Power BI Developer Mode, released in Preview in Power BI Desktop June 2023, enables developer-centric workflows for reports and datasets. Instead of binary .PBIX files, Power BI projects are saved into a source-control friendly text format. Many people have been waiting for this feature for years! See how works, and what workflows it enables. Thirdly, the recent release of Microsoft Fabric has brought native git integration to Fabric/Power BI workspaces. Initially limited to Power BI reports and datasets, alongside Power BI Desktop Developer Mode. How is it enabled, what are the limitations during Preview, and what's coming?

• TMDL Announcement
• learn.microsoft.com: TMDL Overview
• Power BI Developer Mode (Release Plan)
• Introducing Git Integration
• Fabric Git Integration Docs

Bio

Owner of pbi-tools Ltd, Data Platform MVP, and Developer of pbi-tools and TMDL In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, the only complete source control solution for Power BI. During seven years of leading a data management team at YouGov, he experienced the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing source control and DevOps practices to the wider Power BI community now. In addition to his open source engagements, Mathias cares deeply about his role as an enterprise technology leader. Like many, once having started as a single contributor technologist, he had to pivot significantly when he moved into a manager role, responsible for building, stabilizing and growing a team of data engineers, analysts and architects. Mathias is now passionately sharing the many experiences and learnings that came out of that journey with the community.