Data Mining

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.

**First meetup of the Columbus AI Engineering group.** We’ll kick things off with a practical, beginner-friendly discussion on: **How LLMs like ChatGPT actually work — and how to build real applications with them.** We’ll cover: * what’s actually happening under the hood (at a high level) * why LLMs behave the way they do (hallucinations, prompt sensitivity, etc.) * how people are building real systems with them today * where things break in practice This will be a **short, informal talk (\~15–20 min)** followed by open discussion and Q&A. Whether you’re an engineer, builder, or just curious about how modern AI systems work, you’re welcome to join. No slides, no fluff — just real conversation about real systems. We’ll hang out afterward and get to know each other.

**We'll have two meetings covering AI - this second one is for Positron** We will review which AI features are linked in for Positron, and how to use them. **Location:** The meetup will be at SPARK's ([https://annarborusa.org/](https://annarborusa.org/)) Ann Arbor site: [SPARK HQ (Ann Arbor)](https://urldefense.com/v3/__https://www.google.com/maps/place/Ann*Arbor*SPARK*Headquarters/@42.2792515,-83.7447708,17z/data=!3m1!4b1!4m5!3m4!1s0x883cae3effe193cb:0x5296a53db2a282bf!8m2!3d42.2792515!4d-83.7447708?hl=en-US__;Kysr!!HXCxUKc!3EEdBNXRJKknP6LCGkZetSuEsdtChFojQnOVitFUC5C0fyilqXEbiMstT9ajBR3Cw-55qoFkrElCjQvjMdTxUw$). There is on street parking, and parking at local structures. **This will be a hybrid meeting - the Zoom session starts at 6:30 PM.** **Time:** The doors will be open at 6:00, with pizza and beverages provided. We will have a meet-and-greet-and-pizza session, and then at 6:30 we'll have a presentation. **Zoom information:** https://us06web.zoom.us/j/86862937929?pwd=woa95D1r85dobjqxQ07NfBLNdTa9hc.1 Passcode: 705462 **If you can't get in, please call me at: 734 223-3307** **Document source:**

**Improving Office in Franklinton** Physical location: Improving Office 330 Rush Alley Suite #150 Columbus, OH 43215 Schedule: 6:00 p.m.: Socialize, eat, and drink. Improving will be providing pizza and beverages. 6:30 to 8:00 pm. Main meeting and presentation(s). Topic: Type Annotations with John Cassidy We meet on the last Monday of each Month. Presentations are given by members and friends of this group. If you would like to do a presentation (small or large) on a python topic, please contact Central OH Python at centralohpython@gmail.com

**💘 Virtual Speed Dating – Columbus, Ohio, USA Singles, Matched by Personality** A simple, fun way to meet local singles without leaving the house. It's straightforward: take a short personality quiz, hop on Zoom, and meet Columbus, Ohio, USA singles in guided one-on-one rounds. Matches revealed after. **Choose your age range to sign up:** - **Ages 18-32** → [REGISTER HERE](https://tempodating.com/product?productId=390.0&productType=onlineSpeedDating&city=Columbus%2C%20Ohio%2C%20USA&groupurlname=pure-local-singles-speed-dating-group&ar=18-32&face_v=19.0) - **Ages 30-46** → [REGISTER HERE](https://tempodating.com/product?productId=390.0&productType=onlineSpeedDating&city=Columbus%2C%20Ohio%2C%20USA&groupurlname=pure-local-singles-speed-dating-group&ar=30-46&face_v=19.0) - **Ages 40-58** → [REGISTER HERE](https://tempodating.com/product?productId=390.0&productType=onlineSpeedDating&city=Columbus%2C%20Ohio%2C%20USA&groupurlname=pure-local-singles-speed-dating-group&ar=40-58&face_v=19.0) - **Ages 55+** → [REGISTER HERE](https://tempodating.com/product?productId=390.0&productType=onlineSpeedDating&city=Columbus%2C%20Ohio%2C%20USA&groupurlname=pure-local-singles-speed-dating-group&ar=55+&face_v=19.0) **⚠️ Your RSVP doesn't confirm a place.** Click your age group link below, register, and take the personality quiz to secure your spot. Limited places. --- 🎯 **Perfect for:** - Busy professionals who value their time - Introverts who do better in one-on-one chats - Anyone who prefers connecting online before meeting in person - Singles in Columbus, Ohio, USA who want to meet locals from home **Event Details** - **Format:** Virtual on Zoom – hosted and structured - **Location:** Your place – couch, desk, wherever works - **Host:** Experienced host running the evening - **Vibe:** Relaxed one-on-one chats with Columbus, Ohio, USA locals **How It Works** 1. **Sign up** – Click the link for your age range above. 2. **Take the personality quiz** – We use it to match you with compatible Columbus, Ohio, USA singles. 3. **Log in** – Join the Zoom session from home. The host runs everything. 4. **Meet your matches** – Rotate through quick chats with compatible Columbus, Ohio, USA singles. 5. **See your matches** – Find out who you clicked with after the event. ⭐ *"Way better than apps. Real conversations with real people."* – Columbus, Ohio, USA attendee --- ✨ Real people, real conversations — all from home. 🫶 ✨

**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 **Abstract** Web Forms gave .NET developers a powerful abstraction for building reusable UI controls long before design systems were a thing. Web Components finally bring that same idea to the browser natively. This session explores how the Web Forms mindset translates into Custom Elements, Shadow DOM, and HTML templates. We’ll examine how Web Components enable design systems that work across frameworks, how they differ from server‑driven controls, and why they’re becoming a foundational layer for modern UI. Whether you’re maintaining legacy apps or building greenfield projects, you’ll leave with a practical understanding of how to apply familiar patterns in a modern, standards‑based way. **YouTube Link** TBA

**New Dojo Location!** **Knotty Pine Brewing** 1765 W 3rd Ave, Columbus, OH 43212 We're going to try a new dojo location for a few weeks and see how it works Dojos are informal Python group study sessions where everyone interested in Python gathers to learn about Python, help others with Python, or just hang out. Everyone is welcome from Python beginners to experts. Bringing a laptop is encouraged (we'll have extension cords and power strips). If there's something you want to learn leave a comment on this invite so we can plan ahead. We're looking for topic suggestions and people interested in presenting at our monthly meetings. To this end we've set up a survey form at [https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc](https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc)