Software Security

**A software engineers guide to LLMs** In this talk Richard Conway will break down what LLMs are layer by layer, how they work, how they use software principles to work and how to use them in software. This will be a fluid talk with a lot of philosophy, maths from school and how to build your software understanding things like hallucinations and new techniques that can make your management of LLMs more deterministic. We'll consider a lot of things here including the new code generation tools which have developers quivering in their boots, what they mean for our industry and how to use them for effect. Lots of mini-demos and great discussions, good people, beer and pizza! **About the speaker** Richard Conway co-founded the user group, along with Andy Cross, Joe Hancock and Chris Parsons. He is a Microsoft AI MVP and a Microsoft Regional Director and has been writing software in one form or another since his fingers were large enough to hit a ZX81 keyboard.

April Edition ✨✨! We will be at Kraken Tech (Octopus Energy Group), London office! (in-person only event, no streaming) **Talks:** **Digitising Historical Caving Data with Django** - *Andrew Northall* Building an automated pipeline with Django which can extract, structure and publish 2,700+ historical printed reports from scanned PDF copies. *Andrew Northall* is a Python & Django specialist who maintains several open source Django projects/services for the caving and amateur radio communities. **llms.txt for Django: what works** - *Thibaud Colas* The llms.txt format is an emerging standard to structure information for Large Language Models. It’s a desirable addition to the docs of Python packages. Let’s review how to adopt it! We’ll discuss the fundamentals of the format and its benefits as a user of the docs, and as a maintainer. How to produce and consume those files across different tools (Sphinx, mkdocs, Django). How to optimize them for different LLMs with an eval suite. Tools and techniques you should be able to reuse through other engineering tasks with LLMs. *Thibaud Colas* works at Torchbox as developer, core contributor to the Wagtail CMS build on Django. **Want to share your Django or Python knowledge?** We’d love to feature your talk! Just fill out our [speaker form](https://forms.gle/LkaRdKVTF9ApbrEq7) to propose a talk! **Agenda:** • 6:15pm Doors open, socialising • 6:30pm Food and drinks offered by our sponsor • 7:00pm Doors close \*\* • 7:15pm Introduction, News, Talks • 8:30pm Socialising • 9:30pm Fin **Please make sure to arrive between 6:15 PM and 6:55 PM**. If you arrive earlier than 6:15 PM or later than 6:55 PM, you can take a seat in the seating area located in the downstairs reception. **Please note that we cannot accommodate arrivals after 7:15 PM.** Our meetups are governed by a [Code of Conduct](https://www.djangolondon.com/code-of-conduct/). Please take a few minutes to read it. This meetup is sponsored by: • [Kraken Tech (Octopus Energy Group)](https://kraken.tech/): "Kraken is a revolutionary energy tech platform built with predominantly Python & Django. We Serve 54 million households worldwide and have 38GW of contracted capacity." • [JetBrains](https://www.jetbrains.com/): "We make professional software development a more productive and enjoyable experience." Website: [https://djangolondon.com](https://djangolondon.com/) BlueSky: [@djangolondon.com](https://bsky.app/profile/djangolondon.com) Github: [github.com/djangolondon](https://github.com/djangolondon/) Open Collective: [opencollective.com/the-london-django-meetup-group](https://opencollective.com/the-london-django-meetup-group/)

**Venue:** Riverbank House, 2 Swan Ln, London EC4R 3AD **Please note:** 1\. 🚨🚨🚨 A valid photo ID is required by building security\. 🚨🚨🚨 2\. This event follows the [NumFOCUS Code of Conduct](https://numfocus.org/code-of-conduct). Please familiarise yourself with it before attending. If your RSVP status says "You're going" you will be able to get in. No need to show your RSVP confirmation when signing in. If you can no longer make it, please unRSVP as soon as possible. **Code of Conduct:** This event follows the NumFOCUS Code of Conduct. Please get in touch with the organisers with any questions or concerns. As always, there will be free food and drinks, generously provided by our host, Man Group. **Main Talks** 1. **[Nicoleta Lazar](https://www.linkedin.com/in/nicoleta-lazar-921a6864/) Query federation in modern OLAP databases** As analytics ecosystems grow more diverse, organisations increasingly need to query data across warehouses, data lakes, and operational systems without excessive data movement or duplication. **Query federation** has become essential by enabling unified SQL access and intelligent predicate pushdown into heterogeneous sources. This talk introduces the core principles of federation and why it matters for modern OLAP workloads. Using StarRocks as a model system, we highlight its vectorised execution engine, native connectors, and deep Apache Iceberg integration that together deliver high-performance lakehouse querying. 2. [Ben Guerin](https://www.linkedin.com/in/bjhguerin/) **How I Learned to Stop Worrying and Let Claude Code Write the Python [the story of [ismypubfucked.com](http://ismypubfucked.com/ "http://ismypubfucked.com")]** 43,000 pubs. Official VOA data. One question. [ismypubfucked.com](http://ismypubfucked.com/ "http://ismypubfucked.com") got 400k visits in two weeks and wall-to-wall media coverage: from the Mirror to the Telegraph to City AM. I'm not a Python developer. I used Claude Code to wrangle government spreadsheets, match them to OpenStreetMap, and ship a working site. All in less than 6 hours from initial idea to a live website. The AI wrote the Python, I just knew what story the data could tell. This talk covers what happens when tools like Claude Code unlock Python for people who think in narratives rather than syntax, and what a decade of building viral campaigns has taught me about making people actually give a shit about spreadsheets. **Lightning Talks** 1. **TBC** 2. **TBC** \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- **Logistics** Doors open at **6.30 pm** (get there early as you'll need to sign in with building security). Talks start at **7:00 pm**, with drinks afterwards from **9:00 pm** at The Banker (EC4). We have reduced capacity for this event, but there will be plenty of people to discuss data science questions with. Please unRSVP in good time if you realise you can't make it. We're limited by building security on the number of attendees, so please free up your place for your fellow community members. If you want me to trim lightning talks down to two or shorten any abstracts, say which ones.

Vibe Coding Collective is teaming up with **ElevenLabs** to push the boundaries of sound-first vibe coded apps. For one night, we’re getting full access to their tech to explore what’s possible when vibe coding meets voice and music generation. Whether you want to build a voice-controlled game, an AI storyteller, or a children’s app, this is your playground. Use any tools you like (Lovable, Google AI Studio, v0, Cursor, Replit…) and plug in ElevenLabs' power. 🍻 **Format 🛠️** We’ll be teaming up in small groups (2–3 people). We'll provide a specific "Voice & Vibe" challenge, then it’s heads-down building. The goal is to **vibe, experiment with sound, and see how voice and music changes the way we interact with vibe coding**. ## New to vibe coding or voice tech? ✨ No worries! We’ll provide a special **ElevenLabs Starter Kit** with API recipes and prompt examples so even total beginners can get an AI talking in minutes. ## Schedule 🕒 *(Aim to arrive by 6:50 PM so we can get your API access sorted!)* * 7:00 – ElevenLabs Presentation & Tech Demo * 7:20 – The Challenge + Team Formation 🤝 * 7:30 – Round 1: Build & Hear 💻 * 8:15 – Break (Grab a drink, hear what others are cooking) 🍺 * 8:30 – Round 2: Polish & Play 🏗️ * 9:00 – The "Vibe Check" Demos 📺 (Show/Hear what you built!) * 9:20 – Hang out, network, make friends ✌️ ## Who is it for? Anyone! Curious coders, GameDevs, artists, musicians, sound designers, voice actors, entrepreneurs. If you’ve ever wanted to talk to your computer (and have it talk back), you belong here. ## What to bring: * Laptop! 💻 * Headphones (Essential for testing those voice vibes!) 🎧 * Vibes ⚡ ## Location 📍 London College of Political Technology Newspeak House 133-135 Bethnal Green Road London E2 7DG 👉 No gatekeeping. No silence (this time). Just new voices and friends! Disclaimer: By signing up, you consent to the collection and sharing of your name, email address, photos, videos, and software, unless you explicitly opt out by informing the organizers.

Registration Portal: [Event Registration Portal](https://luma.com/cclondon26?utm_source=sherif) About Event ​"Why are there no coffeeshops open late? But what if I want to co-work at night?!?" - everyone on Twitter ​Cerebras is excited to present, Cafe Compute. The first, late-night pop-up coffeeshop with a barista bar ☕️, cozy snacks and couches 🛋️, and more. ​​​​​​This event is brought to you in collaboration with OpenAI. ​​Cerebras is the world’s fastest AI inference, up to 15x faster than leading GPUs. Cerebras Inference is powered by our Wafer-Scale Engine (WSE-3) - the world's largest AI chip. Experience the speed for yourself with OpenAI Codex-Spark, powered on Cerebras, and get free compute at cerebras.ai. Location Please register to see the exact location of this event.

Two hour activity session for children aged 6-11 **£30 CASH PER CHILD** - **payable on the door.** BITCOIN DISCOUNT [HERE ](https://btcpay.btc.aw/apps/rvvVwGSSSiJ7UgtzjmBdxy1Uq6a/pos) Come along to Cyphermunk House for a special holiday session for CYPHERTOTS to get interactive with Bitcoin fundamentals like proof of work and the timechain through real world activites and games. For ages 6-11. All welcome.

Take a break from the busy calendar and join us for **a relaxed offline coffee circle** designed for women in cybersecurity. This is your chance to connect with others in a friendly, relaxed setting. No slides, no speeches, no sales pitches, **just genuine conversation**. We’ll talk about everything from the latest trends in cyber to career journeys, challenges, and even life outside of tech. Whether you’re just starting out or have years of experience, you’ll find a welcoming space to **share ideas, ask questions, and build meaningful connections.** Bring your curiosity, and let’s make cybersecurity conversations as warm and inviting as a good cup of coffee! Meeting Point: Inside the Café. Look for me with an embroidered black tote bag.

**Join us for a joint meetup with our friends from Qodo and Tessl** AI coding agents are increasingly embedded in production workflows, but their failure modes are often poorly understood, difficult to detect, and even harder to evaluate systematically. ​This session examines how agent-based systems degrade under real-world conditions, focusing on three critical dimensions: reliability, code quality, and security. We’ll look at where current evaluation approaches fall short, how non-determinism and context drift impact correctness, and why seemingly “successful” generations can still introduce latent defects or vulnerabilities. ​If you’re building, evaluating, or deploying AI agents in production systems, this session will provide a grounded view of where they fail and what it takes to make them robust **Agenda** * ​​​6:00pm Venue opens * ​Join us for Drinks and Pizza! * ​​​6:30pm **Hidden Failure Modes for AI Agents** by Nupur Sharma * ​6:50pm Panel Discussion * ​**Panelists** * ​**Simon Maple -** Developer Relations at Tessl * ​**Brian Vermeer** \- Staff Developer Advocate at Snyk * ​**Nupur Sharma -** Solutions Engineer at Qodo * ​**Kunal Kushwaha -** Senior Developer Advocate EMEA at Cast AI **SPEAKERS** **​** **Simon Maple - Developer Relations at Tessl** ​Simon Maple is the Head of Developer Relations at Tessl, and AI Native Dev co-host. Previously, Simon was the Field CTO, and VP Developer Relations at Snyk, ZeroTurnaround, and IBM. He became a Java Champion in 2014, JavaOne Rockstar speaker in 2014 and 2017, Duke’s Choice award winner, Virtual JUG founder and organiser, and London Java Community co-leader ​ ​**Brian Vermeer** \- Staff Developer Advocate at Snyk ​Staff Developer Advocate for Snyk, Java Champion, and Software Engineer with over a decade of hands-on experience in creating and maintaining software. He is passionate about Java, (Pure) Functional Programming and Cybersecurity. Brian is a JUG leader for the Virtual JUG and the NLJUG. He also co-leads the DevSecCon community and is a community manager for Foojay. He is a regular international speaker on mostly Java-related conferences like JavaOne, Devnexus, Devoxx, Jfokus, JavaZone and many more. Besides all that, Brian is a military reserve for the Royal Netherlands Air Force and a Taekwondo Master / Teacher. ​ ​**Nupur Sharma -** Solutions Engineer at Qodo ​ ​**Kunal Kushwaha -** Senior Developer Advocate EMEA at Cast AI ***

Elixir London Meetup; February 2026 edition. All are welcome. **Session 1: Anton Borisov - Distilling Kafka's Binary Protocol into Elixir** We'll trace a produce request to show what any Kafka client has to get right. In the BEAM ecosystem, erlkaf wraps librdkafka, brod implements the protocol in Erlang, and [kafka_ex](https://hex.pm/packages/kafka_ex) goes pure Elixir. Kafka_ex's approach is to generate serializers at compile time from Kafka's own schema definitions: plain structs, pattern matching, structural boilerplate isolated from the logic you actually think about. That design is what let us jump two major versions ahead and adapt to significant protocol changes. Let's dig into the idea, the code, and the tradeoffs. **Session 2: Evadne Wu** **\- JavaScript Execution Strategies in Elixir\-based Agent Frameworks** We'll look at integration points between elixir agents (in the AI fashion) and JavaScript execution, and all the foot guns involved. *The event is kindly sponsored by* [Fresha](https://www.fresha.com). **Time** Doors open at 18, start at 18.30. **Venue** Fresha The Bower, 207-211, Old St, Tower, London EC1V 9NR **Refreshments** Food and drinks will be provisioned on the day. **IMPORTANT**: **If you wish to take photos and post online during the event, please notify organisers first, so that attendees can opt-out from being in photos.**

**Explore AI over dinner at a Michelin-listed London restaurant. Tools, opportunities and real conversation.** Each Meet2Click Curated Conversation dinner centres around a carefully chosen topic or shared interest, designed to spark thoughtful conversation and meaningful connection. **Curious about how AI is changing our lives — and want to explore it in a relaxed dinner setting?** Artificial Intelligence is evolving rapidly. New tools, ideas, and breakthroughs are reshaping how we work, create, and think. Instead of abstract debate, this evening is about sharing what we’re discovering in real life. Two days before the dinner, guests will receive a short, accessible overview of interesting AI tools — simply to spark ideas. At the table, we’ll explore: • What AI tools have you tried recently? • What discovery or breakthrough impressed you most? • Where do you see the greatest opportunities emerging? No technical background required. **Launch Season Benefit** During our initial Meet2Click dinners, guests will enjoy **up to 50% off food** at the restaurant. This introductory benefit is available for a limited launch period. Food and drinks are paid individually, directly with the restaurant. **Details** Location: restaurant Bala Baya, Arch 25, Old Union Yard Arches 229, Union Street, London SE1 Date: 8 April 2026, 19.00h **Ticket price:** £15 per person *(includes your seat and contribution to the evening — food and drinks ordered and paid individually at the restaurant)* Seats are intentionally limited to encourage meaningful conversation and genuine connection. Just an open, relaxed exchange of ideas over dinner.

We are back! This is going to be a monthly IN PERSON meet up in London. A very big thank you goes to Accurx who is hosting us in their amazing Shoreditch offices. This will include access to facilities including coffee! 😻☕️ **Want to know more? 👇** As with all CoffeeOps, this is an interactive, chatty, build your own adventure type of meet-up. Instead of booking in experts to *learn* *from*, we gather a group of practitioners to ***learn*** ***with***. We have been running for over 4 years now and often get feedback that this is the most useful meetup people join! The event is approximately 90 minutes and always starts by brainstorming topics to discuss. The group then votes on the most relevant/interesting to them and we then cycle through the topics trying to discuss each deeply, but in a time bound slot. To get an idea of topics, you can check out our remote board [here](https://easyretro.io/publicboard/h404NF84Uje4tCcxpJdHr4Ycs9B3/a4a35d2b-181b-409b-832e-a729be1af79c). The general gist is anything is fair game, though we tend to revolve around software delivery and definitely lean towards the more Ops-y or DevOps-y side of things.

**Please register on [Eventbrite](https://www.eventbrite.com/e/ljc-meet-up-at-tessl-java-and-gen-ai-jvm-agents-with-embabel-tickets-1985712292922) to join in-person.** **About this event** vJUG Connect is teaming up with the London Java Community for a special evening exploring the future of Java in the age of Generative AI. Join us both online and in London for a deep dive into how JVM developers can lead the next wave of innovation with agent-based systems. We’re excited to host Rod Johnson, creator of Spring, as he introduces Embabel, a new framework designed to push Java and Kotlin to the forefront of agentic AI. From building safe, testable, and enterprise-ready AI agents to rethinking how Java fits into the Gen AI ecosystem, this session will give you a front-row seat to what’s next. Whether you join us virtually or in person at Tessl HQ, expect an evening of cutting-edge ideas, practical insights, and great conversations with the Java community. Can’t make it in person? Join us virtually, register here: [https://luma.com/s9rp5nem](https://luma.com/s9rp5nem) **Agenda:** ​6:00pm – Doors open (live stream begins on YouTube with vJUG) ​6:45pm - Kick off and message from our partners ​7:00pm – Session kicks off Java and Gen AI: JVM Agents With Embabel by Rod Johnson (Spring Creator) (live stream ends) ​8pm – Networking 9pm – Wrap-up **​Java and Gen AI: JVM Agents With Embabel by Rod Johnson (Spring Creator)** Since the emergence of Gen AI, it's become obvious that agents will be a big part of our future as both technologists and citizens. Building predictable, safe, manageable, testable agents that integrate with existing enterprise systems is critically important to us all. ​In this session, Rod Johnson will show how JVM developers can be central to unlocking the business value of agentic AI, using the Embabel agent framework: [https://github.com/embabel/embabel-agent](https://github.com/embabel/embabel-agent) Embabel is an innovative framework for Java and Kotlin developers, seamlessly integrated with Spring. Built in Kotlin, it aims not to play catchup with Python frameworks like Crew AI, but to leapfrog them to be the best agent framework, period. ​Embabel innovates in several ways. It introduces a planning step that maximizes autonomy while maintaining determinism and safety. It is type safe, ensuring excellent toolability and avoiding errors in prompts. It enables developers to use a rich domain model, defining not just types but behavior exposed to user code and to LLMs as tools. ​ Read more about the [vision](https://medium.com/@springrod/the-embabel-vision-967654f13793?utm_source=luma); and also the call to action for Java developers in recent Devoxx keynote: [https://www.youtube.com/watch?v=dbx1_P7W1DM](https://www.youtube.com/watch?v=dbx1_P7W1DM&utm_source=luma) **​Rod Johnson, Creator of the Spring Framework and Embabel Agent Framework** ​ Rod Johnson is a developer, author, entrepreneur and advisor. He is the creator of the Spring Framework and Embabel agent framework. ​Twitter: [https://x.com/springrod](https://x.com/springrod) ​LinkedIn: [https://www.linkedin.com/in/johnsonroda/](https://www.linkedin.com/in/johnsonroda/) Huge thanks to our friends at Tessl for sponsoring this event and supporting our community. This event is organised by [RecWorks](https://recworks.co.uk/) on behalf of the London Java Community. The London Java Community is sponsored by Hazelcast, Neo4j, Redis, and Discover You can see our latest jobs [here](https://recworks.co.uk/java-developer-jobs-london/) You can see our privacy policy [here](https://recworks.co.uk/privacy-policy/) Continue the conversation at our Slack Group: [https://londonjavacommunity.slack.com](https://londonjavacommunity.slack.com/) Sign up here if you're not a member: [https://bcrw.typeform.com/to/IIyQxd](https://bcrw.typeform.com/to/IIyQxd)

PHP London Pub Social – April 9th, Jack Horner, Tottenham Court Road Join us for an informal PHP London pub social at the Jack Horner on Tottenham Court Road! We've got a reserved space from 6:30pm to 8:30pm on Thursday 9th April - a mix of seating and standing with a few tables. This is a relaxed, no-agenda evening — just good conversation with fellow PHP developers over a drink. Whether you're a long-time community regular or coming along for the first time, all are welcome. Places are limited.

Columbus Code & Coffee is an inclusive, informal co-working session. People of all skill levels attend, and we love it that way. Many people (optionally) bring projects to work on, and many other people (optionally) socialize the entire time. It's entirely up to you! **What to Expect at the Intro Circle** \~\~\~\~\~\~\~\~\~\~\~\~\~ Near the beginning of the event (1:30 pm), we do a standup: * Organizer announcements, updates, and logistics Round 1 - (7 secs max): * Your name * What you're working on * What you can help others with Round 2: * Community events you wanna plug. If none, that's cool too. Round 3: * Job opportunities you're hiring for OR announce that you are looking for one. If none, that's cool. After the introduction circle, everything is self-organized! Feel free to work alone, pair up, attend one of our workshops/presentations, or mingle!

Want to be a speaker? submit your talk to our Call for Presenters!!! https://sessionize.com/cbus-hug-2026/

**Important time note:** Please plan on arriving between 5:30 and 6:00 as the elevators lock after 6 and you'll need to message us and we'll need to come get you. The building address is 4450 Bridge Park The entrance is 6620 Mooney St, Suite 400 You will need to scan your ID at the door to get a visitor badge. **Abstract** GitHub Copilot is powerful, but what if you could scale from a solo AI assistant to an entire team of specialized agents working in parallel? This session introduces Squad: an open-source framework for multi-agent orchestration that lets you define teams of AI agents with specific roles, responsibilities, and expertise. We'll progress from Copilot basics to the Copilot CLI, explore how Agents add autonomy, and see how Instructions and Skills let you customize agent behavior. Then, the climax: a live demo where a Squad team of 3 agents (Lead, Developer, Tester) stands up and builds a working application in real-time, showcasing true multi-agent collaboration. Whether you're new to AI or exploring how to scale your use of Copilot, this session will show you what's possible when agents work as a team. **YouTube Link** TBD

The global Azure community is coming together again, and Columbus is officially on the map. View the session lineup and speakers at [Global Azure Columbus 2026](https://coazure.github.io/cbus-global-azure-2026/) On **Saturday, April 18, 2026**, the Azure Columbus Meetup, DevOps Meetup, and Code and Coffee Meetup are hosting our local edition of Global Azure 2026. This is a free, community-driven event packed with learning, networking, and all things Microsoft Azure. Whether you’re building modern cloud-native apps, experimenting with AI agents, deploying containers, automating infrastructure, or just beginning your Azure journey, this event is for you! **What to Expect** * Engaging technical sessions * Real-world Azure architecture & cloud-native patterns * AI, agents, automation, and modern DevOps * Food and drinks (because learning burns calories) * Time to connect with fellow engineers, architects, and cloud enthusiasts **Who Should Attend?** * Software engineers (any language, any stack) * Cloud architects * DevOps engineers * Data professionals * AI explorers * Platform builders * Anyone who loves solving hard problems with great tools If you build, deploy, automate, scale, monitor, or optimize in Azure, you’ll feel right at home. **Why Global Azure?** Global Azure is a worldwide community event where Azure user groups host learning sessions on the same day across the globe. It’s grassroots. It’s technical. It’s practical. And it’s powered by people who genuinely love sharing what they’ve learned. And yes, it’s free to attend!

Come out to Improving for our monthly iOS and Mac meetings. This Month's Presentation: Nothing yet. (You should volunteer). What is Cocoaheads (http://cocoaheads.org/)? CocoaHeads is a group devoted to discussion of Apple Computer's Cocoa Framework for programming on MacOS X and iOS (including the iPhone, iPad and Apple Watch). During monthly meetings, members present on their projects and offer tutorials on various programming topics. What is BuckeyeCocoa (http://buckeyecocoa.org/)? BuckeyeCocoa is a group of Objective-C/Swift developers/enthusiasts. We host monthly Cocoaheads and near-weekly NSCoder meetings in Columbus, Ohio. The meetings are free to attend. Presentations! Presenters welcome! We are always in need of people willing to present material. Any Swift and/or Objective-C related topic is welcome. Times can be 5 minutes (i.e. lightning talks) to a maximum of 2 hours. Interested? Contact info is on the BuckeyeCocoa website. To volunteer for a presentation contact us at @BuckeyeCocoa on Twitter. Follow us on Twitter! @BuckeyeCocoa (https://twitter.com/#!/Buckeyecocoa/) For more information: http://buckeyecocoa.org/

Join us for an engaging panel discussion on **AI Agentic Coding** and how autonomous AI systems are transforming the way software is built. Experts in AI, software engineering, and developer tools will share insights on how agentic AI—systems that can plan, reason, and execute coding tasks—is reshaping modern development workflows. The discussion will cover topics such as AI-assisted development, productivity gains, challenges around reliability and governance, and what the future of software engineering may look like with AI agents as collaborators. Whether you’re a developer, tech leader, or AI enthusiast, this session is a great opportunity to learn, ask questions, and explore how agentic AI is redefining coding

The Fellowship of the Star Schema: Transforming OLTP Data for Power BI One does not simply build reports on OLTP data. Join us on an epic journey from the depths of raw, normalized tables to the shining halls of a well-modeled star schema fit for Power BI greatness. We will demystify the differences between OLTP and OLAP, walk through star schema vs snowflake (and why Power BI has a clear favorite), and show you the compression differences between normalized and columnar storage that will make you never look at an OLTP model the same way again. We will cover the different types of dimensions, when to use them, and how to handle Slowly Changing Dimensions without losing your mind. You will leave knowing exactly how to identify a bad model, how to convert OLTP data into a clean star schema, and how to forge relationships that rule them all. Whether you are a data wizard, a curious hobbit, or somewhere in between, your models will never be the same.