Data Elixir - Issue 459

DevOps for data science. A curious SQL query. Quarto dashboards. RAG for production. Serving vector web maps. Data Visualisation Guide. ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

ISSUE 459 · October 31, 2023   🤖 ➕ Data Elixir = 💖💖💖 Data Elixir's SQL Tutor experiment has come a long way since its debut in March. It's now called "Data Pilot" and it's matured into a permanent resource. Data Pilot is knowledgeable on all topics in the newsletter over the past 4 years and it can help with research projects, code development, analysis, SQL, troubleshooting, and more. Check it out 👉🏼Data Elixir Labs    Data Teams How Figma’s data science and user research teams weave together insights that count In weaving, you thread crosswise yarns, known as weft, over and under lengthwise yarns, known as warp, to create whole cloth. Here's how a cross-functional team at Figma uses that analogy to weave together qualitative and quantitative insights to get to impact faster. Shortcut | Jenny Xie   Sponsored Link Where Data Meets Decision-Making If you’re looking to enter or advance in the tech-driven intelligence industry, then consider an online Master’s in Applied Intelligence from Georgetown University. You’ll learn to anticipate competitive activity, establish mitigation measures, and interpret events from a global perspective.       Reach Data Elixir readers by sponsoring an issue. Click here for details.   Posts & Tutorials The Case of a Curious SQL Query SQL is SQL and should return the same results, no matter the database, right? Well, not exactly. This post uses an impure SQL function to show how the inner workings of database engines are more nuanced than you might think. Null Bitmap | Justin Jaffray   Serving vector web maps using PMTiles & maplibre-gl Protomaps is an open source map of the world, deployable as a single static file. It's a big file but the way it's constructed, you can create new sub-files on the fly that match specific areas. The scheme is cheap and it's fast. This tutorial is a great walk-through of how it works, including lots of code snippets, screenshots, and linked references along the way. Simon Willison   Building RAG-based LLM Applications for Production Awesome guide to building RAG-based LLM applications. It's easy to follow and covers a wide variety of topics from data chunking and vector management to fine-tuning, prompting, data flywheels, lexical search, and more. Anyscale | Goku Mohandas and Philipp Moritz   AI Forward 2023: LLMs in the Enterprise - From Theory to Practice Learn how to overcome LLMOps challenges in pre- and post-production, build enterprise LLM infrastructure, and deliver measurable business value, including hands-on workshops and expert panel discussions with data science leaders. Register now for AI Forward 2023 — a FREE one-day virtual summit! // sponsored   Tools & Code Quarto Dashboards Dashboards are coming to Quarto! Components can include navigation bars, pages, tabsets, cards, and sidebars and will make it easy to create interactive dashboards using Python, R, Julia, and Observable.. Dashboards will be part of the upcoming Quarto 1.4 release but are available now as a "pre-release build." Follow the links. Quarto   marimo marimo is a next-generation Python notebook where every notebook is also shareable as an interactive web app: explore data, run experiments, build tools, and deploy apps, all from one seamless environment. GitHub | marimo-team   Resources DevOps for Data Science Great guide to DevOps from a data science perspective. It walks through best practices, IT/Admin tasks that you can do yourself, and finally, a section on why you shouldn't do IT/Admin tasks yourself. Ultimately, the ideas here will help you get your work into production.  Alex K Gold   Data Visualisation Guide This is a nice resource, covering a wide variety of topics in data visualization, from beginner to advanced. Sections cover design principles, visualization pitfalls, chart types, accessibility, grammar of graphics, and more. It covers a lot of ground and is very well organized. Data Europa     How did you like this issue of Data Elixir? 👎    1     2     3     4     5   👍       Was this email forwarded to you?  Sign up here >>     Data Elixir, LLC P.O. Box 21255 Boulder, CO 80308 Data Elixir® is curated and maintained by Lon Riesberg. If you have questions or suggestions, just reply back to this email. Unsubscribe