Insights x Design

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)

Take time to recharge! Go touch grass (or if you're in Arizona, go touch dirt...or cactus ??) Making time to take care of myself, especially with a giant to-do list for work and home, is something I wish I'd known earlier. What do you do to recharge?

Who remembers #scala? Yeah...that was a fun 6 months of my life I'll never get back ?? What languages have you wasted time learning? #data #dataengineering

My computer rebooted 2 MINUTES BEFORE A 2000 PERSON PRESENTATION!!! ?? Chaos is constant in the life of a speaker. What did I do? * Messaged the conference organizer to stall while I reconsidered my life decisions. * Grabbed another laptop and started it up. * Logged into the conference and started speaking with the audience while I reviewed my deck on the other monitor. * Gave an overview of the talk and background when I realized part of my deck was missing. I connected my iPad to screenshare so that I could draw the missing diagrams. The audience surprisingly LOVED this. * Presented as normal, hand drew the missing slides in front of the audience (charged them extra for admission to see the best artist in the world ??) Conversations are dynamic. Sometimes the best moments are unplanned! ?? What are your "presentation chaos" stories? #datastorytelling #presentation #speaking

You up? Please validate my existence and watch my talk "????-?????????? ???????? ???????? ???????? ????????????????." at Azure AI Connect ?? ?? ?????? ????????????? Gartner predicts that 60% of AI projects will fail by 2026 because of poor data quality. ?????? ???????? ???????? ????-?????????? ???????? ????????-???????????? ????????????????????????: ???????????? ?????????????? ?????? ??????????????! H?e?r?e?'?s? t?h?e? d?e?t?a?i?l?s?:? ?? March 14, 2025 ? 6am pst, 9am est ?? https://lnkd.in/gBTNqnJB ???? ?????????? ???? ????, ?? ??????'?? ????????...??????????? See you there! #dataengineering #ai #dataanalytics Tobiko