←
Ergest Xheblati7,017 posts
Ergest Xheblati avatar

Ergest Xheblati

@ergestx

unlocking inherent potential in people and organizations

◷ Joined November 2008▧ 404 Photos and videos
Ergest Xheblati avatar
Ergest Xheblati@ergestx·22 Feb 2024

A brief re-introduction for all my new followers. I’m Ergest (rhymes with “her guest”) I’ve spent the last decade and a half in the field of data working on everything from data engineering to data science. In 2022 I self published a book called Minimum Viable SQL Patterns (link below) In 2023 I started a newsletter called Data Patterns that combines technical aspects of data with business impact (link below) My current focus is on upgrading the methodologies used in the field of data.

Ergest Xheblati avatar
Ergest Xheblati@ergestx·5h

LLMs are very good at convergent thinking but suck at divergent thinking. When you need to combine multiple ideas to a single answer they work great but when you need an idea out of left field, they’re terrible.

Ergest Xheblati avatar
Ergest Xheblati@ergestx·14 Dec 2024

There’s only two paths for dashboards: either they never get used or they end up becoming complex applications that people use to run SQL queries and export the results to Excel.

Post attachment
Ergest Xheblati avatar
Ergest Xheblati@ergestx·6 Nov 2024

The effort required to write a good LLM prompt is nearly equal to the effort required to design a good system. Because GIGO. Similarly the amount of effort and knowledge required to judge a good output is nearly the same so a great understanding of the fundamentals of software engineering is still essential. Therefore the only advantage of an LLM is the ability to generate code that matches your design faster than you can type it. Still I’ve been quite amazed by what even minimal prompting can do assuming I know exactly what I’m doing

Ergest Xheblati avatar
Ergest Xheblati@ergestx·4 Nov 2024

The only way to succeed as an AI company long term is to collect and hoard proprietary, hard to get data.

Ergest Xheblati avatar
Ergest Xheblati@ergestx·3 Nov 2024

The true purpose (and promise) of analytics has always been uncovering asymmetric opportunities hiding in plain sight. Things like underpriced assets, leverage points, etc. Let's look at some examples: In the movie Moneyball (based on the book by the same title) analytics is shown to uncover asymmetric returns from a simple baseball statistic called on-base percentage (OBP). Since what you want is to score more runs than your opponent and the best way to score runs is to get on base, it makes sense that players that get on base a lot increase your chance of scoring more runs. The reason why players with high OBP were undervalued was because the prevailing notion was that the only stats that mattered were batting average (AVG) and home runs (HR) Players with high OBP but low AVG and HR were frowned upon. Nowadays this is common sense and many teams already do it therefore the leverage point has to be found elsewhere and has become far more obscure. Don't like sports? Take quantitative trading. The whole point of factor analysis is to find a way to price assets such that you pay as little as possible for as high a return as possible. Factor investing for instance is the study of financial metrics that indicate good companies to invest in. In business, uncovering a single leverage point could be worth hundreds of millions of dollars. For example finding that 90% of revenue comes from 10% of clients allows you to focus your efforts on those clients, maximize their impact then use ML/DS to profile them and find more of them. THIS is the real power of analytics and the BEST value it can offer a business.

Ergest Xheblati avatar
Ergest Xheblati@ergestx·27 Oct 2024

There are two trends in the field of data I’m following very closely: 1. The rise of the “AI analyst” including agentic AI, text to SQL, etc. 2. The rise of commodified data warehouses. The first one is doomed to fail without a solid foundation of a well designed warehouse, clean data, well defined metrics. Imagine selling luxury sofas to home owners who haven’t even built the foundation yet. The second one I’m very excited about because it’s a huge opportunity to instantly level up a large number of companies and can also fuel the growth of the first trend.

Ergest Xheblati avatar
Ergest Xheblati@ergestx·23 Oct 2024

Watching the comeback on Netflix about the 2004 Boston Redsox, which I saw live 20 years ago and I’m shocked at how many of the player names I remember!

Ergest Xheblati avatar
Ergest Xheblati@ergestx·23 Oct 2024

I thought I’d never get here but my musical tastes have evolved to favor complex compositions. So for example: 1. I no longer listen to pop 2. Hard rock I used to favor in high school now sounds like pop 3. Power metal I got into later now sounds like hard rock 4. I’ve started to listen to more symphonic metal (specifically Epica, Kamelot, Nightwish) and some darkish metal stuff (Wintersun, Insomnium, Sleep Token) Any recommendations for similar bands?

Ergest Xheblati avatar
Ergest Xheblati@ergestx·23 Oct 2024

Isn’t it interesting that where the Segway failed as personal transportation the electric scooter has succeeded?

Ergest Xheblati avatar
Ergest Xheblati@ergestx·19 Oct 2024

I’ve been trying to figure out what to focus my writing on in forever. I’ve gone back and forth between technology and business never quite choosing one or the other until today something clicked and I came up with this! It’s both and more. I’m calling it the data leadership triangle because it encapsulates three core themes of my writing and even though I haven’t spent much time talking about power, influence and organizational politics, it’s still an area of interest. I will expand on this in a future post but for now I want to get the idea out. This triangle represents the three core skills of a great data leader. 1. Understanding the business and building a metrics powered growth / operating model, which I believe is the highest value a data team can provide. 2. Understanding the data technology stack enough to make good choices for long term success. This means understanding the risks and costs of the data architecture 3. Understanding influence, power and politics which are crucial to success in any leadership role but which are never discussed openly.

Post attachment
Ergest Xheblati avatar
Ergest Xheblati@ergestx·17 Oct 2024

Sure you can use AI to generate code or a design for you, but if you know nothing about software engineering how can you tell it’s doing the right thing?