Insights x Design

Community matters. Christophe O. is one of the people in the Tobiko open-source community who make a HUGE difference. Christophe flew from France to join us at the inaugural GROUP BY conference in San Francisco! It was a pleasure to award him and the other winners the Tobiko Community Award! This group of Data Engineers has done so much to support SQLMesh and grow the Tobiko community through conversations, open-source project contributions, and writing about it online. Thank you Christophe! If you want to join the RADDEST data community, check out the SQLMesh Slack ??https://lnkd.in/g9KTEYkq

Big News! Tobiko SQLMesh-Based Cloud is now GA ?? (with a fresh new website to match!) This extends SQLMesh with enterprise features: ? SSO ? RBAC ? Scheduler ? Alerts ? Debugger ? Warehouse Cost Tracking ? Advanced Change Categorization ? Cross-Database Diffing!!! (This might be my favorite) ? Cloud-only or Hybrid Deployment Quote from Tobias (Toby) on the launch “With Tobiko Cloud, we can have an understanding of who the users are, and so we can do things like role-based access control and other things for security and for data deployments, where you don’t want to necessarily have to give your developer access to your entire warehouse,”. Don't worry; we are still driving the development of open-source SQLMesh. Iaroslav Zeigerman will make sure of that ?? Let's GO! ?? Want to join the fun? Check out the Open Source SQLMesh SLACK ??https://lnkd.in/g5hYuVfs #dataengineering #opensource #dataanalytics

What' your favorite opensource data tech? Kafka? Iceberg? Unity? SQLMesh? DataHub? Arrow? ...etc. What should we check out? Comment below! ?? ?? Please Repost ??

Which is better - Enterprise or Startup? Don't join until you read this! Enterprises provide structure, support, and guardrails. You are limited in what you can do, and how much experimentation they allow. You need to play office politics to move up or get a project approved. Pressure is typically lower. Job security is generally better (but these days...who knows). Startups provide little structure and minimal support They give you the freedom to work on many things that you would never get to in a larger company. Communication is tight in a small company. You move fast. Pressure is high, but so are the rewards. Everyone gives 110%, and it's very obvious if you are holding back. I am thrilled to be at Tobiko. The talent is incredible. The product is disruptive. The SQLMesh community is ?? Which type of company do you work for? ?? like and repost!

Tyson, CEO of Tobiko, is kicking off the GROUP BY conference! So many awesome talks coming up today ?? In San Francisco? Come say hi ??

Learn the foundations of data models, when to use them, and why they matter so you can crush it on your next project! ?? Relational ?? Star ?? Wide-Column ?? Data Vault and more! Happy Learning! #dataanalytics #sql #dataengineering

????% ???? ???????? ???????????????? ??????'?? ???????????????????? ???????? ????????????. Knowing data models is a ???????????????????? and... ?????????? ??????????... ?????? ????????????????. Here are the top 5 data models you need to know: ??/ ???????????????????? ???????????? ??What: Tables with rows and columns.?? ??Why: Easy to understand, great for queries.?? ??When: Business apps with clear structures. ??/ ???????? ?????????????? ??What: Fact table with dimension tables.?? ??Why: Fast for reporting.?? ??When: BI and data warehouses. ??/ ???????? ???????????? ??What: Hubs, links, satellites.?? ??Why: Flexible, tracks history.?? ??When: Enterprise data warehouses. ??/ ????????/???????????????? ???????????? ??What: Flexible documents.?? ??Why: Great for varied data.?? ??When: Web and mobile apps. ??/ ????????-???????????? ???????????? ??What: Column families.?? ??Why: Handles big data.?? ??When: Big data analytics. ?? If this was helpful, ???????????? ?????????? to help fellow analysts! ?? ?????????? ???????? ?????????? ???? ?????? ?????? ????????? Share in the comments!? #DataModeling #DataAnalytics #DataEngineering

95% of analysts ignore window functions - but they’re a game-changer. Here’s 3 ways pro analysts use them: 1) RANK() to flag top performers without subqueries 2) LAG() to track trends row-by-row 3) SUM() OVER for instant running totals. One query with these cut my report time by 40%. Stop sleeping on them! Ready to learn? Check out - Alex Freberg on YouTube Jess Ramos, MSBA Chris Perry Christina Stathopoulos, MSc Practice on - DataLemur ?? (Ace the SQL & Data Interview) Data Science Infinity Khan Academy Save and repost! ?? What’s your favorite underused function in SQL?

3 books I wish I had when I started in data. ??/ ???????????????????????? ???????? ???????? By Cole Nussbaumer Knaflic Want to learn how charts work? This is it. It teaches you ?? Common visual pitfalls ?? Building robust storytelling frameworks ?? End-to-end case studies of presentation before/after IMO, this is the best visualization fundamentals book. ??/ ???????????????????????? ???? ???????? ?????????????????????? By Joe Reis and Matthew Housley For anybody working directly with data. Everything you wish you learned in your cs class, but ? Presented logically and clearly ? Includes real-work application of the fundamentals This is the perfect book for new learners or as a refresher. ??/ ???????? - ?????? ?????????????? ???? ???????????????????????? By Alison Wood Brooks I know we’re talking about data, not conversation, but this is a MUST-READ for anyone who has to speak with others (ie. everyone). The best data professionals connect with their stakeholders. They know how to present, engage, and listen. This book teaches you how to ?? Identify the priorities of conversation ?? Prepare and ENJOY communicating ?? Drive strategic impact with (and without) an agenda This book will 10x your knowledge of communication. ?????????????????? ??????????????: ?????? ?????? ???????? ???????????????????? By Renee Teate This book is an excellent overview of basic-intermediate SQL. Highly recommended! ?? Found this useful? Please repost! ?? ???????? ?????????? ?????????? ?????????? ?????? ?????????????????? ???? ?????? ???????? ???????????????????????????

You can become a Data Analyst in 2025! I've hired and mentored dozens of data analysts, and you need these skills to stand out in today's competitive market. Start with SQL fundamentals and build your Excel expertise. Advance to visualization tools that bring your insights to life. You NEED basic statistics. Show impact through real world projects and share them online. Ready to level up? Develop cloud, sqlmesh transformations, and stakeholder management skills to really stand out! I recommend AWS for cloud ?? What skill are you focused on? #DataAnalytics #dataengineering #sql Tableau Power BI Microsoft Amazon Web Services (AWS)