Over time you learn more things and do better (DATA TLV puzzles and excitement)

-

        

I took the first sip from my morning coffee when the last summit session had started, somewhere around 15:00. I heavily sank to a sofa and realized that this is the first time I had a chance to sit down today. Another organizer was sitting nearby with the exact "stick a fork in me, I am done" look, staring nowhere. "Oh, I am so tired" - that was my 18-year-old nephew Sonya anchored on the other side of the sofa. She had helped us with registrations and timekeeping in classes and has absorbed all speakers' disappointment with outdated presentation equipment. "Most speakers finish before their time", she said with an exhausted look. "Very smart and intelligent people. I didn't understand anything they talked about."

I wish we knew how to make sure the summit meets everyone's expectations.

Every sponsor wants to deliver a session. The more sponsored sessions mean fewer slots for community speakers sessions. The toughest part of summit organization is selecting sessions that will enter the agenda when there are too many submissions. How do you say to someone you work with, your friend, that his session was not accepted? How to deal with sadness in their eyes? To allow more community speakers to speak, organizers open more parallel rooms. Accepted speakers will be pleased but attendees start to complain that it's hard to decide which class to attend. They feel that no matter which session they choose, they are missing something more interesting. At the same time, speakers complain that their rooms are not full. Another tremendous challenge is to figure out, how many people will show up. How can we calculate the approximate attendance when most people don't RSVP. How had Corona affected in-person events? Are people hungry for frontal meetups or have got used to learning from home? 

The more attendees you assume, the more budget you need. This triggers more sponsors and fewer community sessions. Now we have got the deadlock.

Why do we do this heavy work every year? What do we get out of it? Is that about grateful, tired and overloaded with new knowledge attendees with their hands full of free swag? 

You can't make everybody happy. Unless you are chocolate. 

Me and my cold coffee have left the venue like the captain that is the last one off the ship. People who haven't shown up were lying on a floor in a pile of tags.

It is hard to believe that more than four hundred people a few hours ago crowded the place, finally happy to meet old friends, after two years of lockdown, masks, and online meetups. Fabulous to see them talking to each other and eating ice cream. Smiling, exchanging ideas, and solving each other challenges. Drinking alcohol cocktails between sessions. Hugging each other on magnetic pictures that will find their way to the home refrigerators to remind us about the Data TLV summit, the annual Data People gathering.





Comments

Post a Comment

Popular posts from this blog

SQL Awesomeness: Finding a QUALIFY query clause in the depths of the database ocean

-
Image
After so many years of writing SQL queries, I cannot believe I never came across a QUALIFY query clause. It feels like discovering a treasure in the depths of the database ocean. Even ChatGPT was not aware of it! QUALIFY query clause was invented by Teradata and is not a part of SQL Standart but apparently, multiple database vendors are supporting it, for instance, Snowflake and Databricks. QUALIFY clause solves the challenge when applying a window function as a query filter. SQL Standart and most database vendors will not allow to run of a window function as a part of a WHERE clause because window functions get evaluated after the HAVING clause. We typically create a CTE or subquery adding a window function to be able to filter on a it at a later query stage. Here is an example of how you can use QUALIFY to piece-of-cake filter on the window function.  I will use the Snowflake database, as an example. Let us consider that we have a list of queries and we need to find the last query ex
Read more

Look back and realize how far you came

-
Image
It appeared out of nowhere while I was having a strong argument with the ton of dust that had taken over my computer room. My former favourite book, "Advanced Transact-SQL for SQL server 2000" brought an upset look to my face, the one I usually get from our NetApp admin. He usually gives me such a look when I ask him for more disk space. At the time of SQL 2000 there were far less good SQL books available than today and amazing SQL programming tricks were living on Itzik’s book pages; and, similar to the Rubeus Hagrid’s “The Monster Book of Monsters” it attacked anyone who attempted to open it, unleashing wild and exciting brilliant ideas. Nowadays there are a lot of SQL books but not all of them are worth reading. Some of them should be strongly avoided and if you touch them you should immediately wash your hands and have a drink or three. A few month ago I was asked to technically review some new SQL Server book. Reading their missleading claims of how the optim
Read more

The Greatest Reasons to use or not to use a Centralized Data Access Architecture

-
Image
When developing a modern Data Platform Layer, one of the main decisions is whether to opt for centralized or decentralized data access architecture.  There is no “one-fits-all” solution, both have advantages and disadvantages. A Centralized Data Access Architecture would usually mean duplicating data from the operational layer into the analytical layer and applying various transformations to data to support and speed up data analytics. Operational online transaction processing Layer , where all microservices and their operational databases are located. Analytical Data Layer , where we would have data lakes that support data Scientists' work and a data warehouse, that supports Business Intelligence. Transformations, ETL or ELT data pipelines , which are moving data from the operational layer into the analytical layer. I f we opt for a Centralized Data Access architecture, what would be the benefits and the drawbacks? CONSISTENCY : consolidating data into a central location can
Read more