Anovate

Innovate. Analyze. Elevate | Making data work for you

[Anovate @anovate]

Great insights start with great dashboards. 📊
@anovate builds the ones your team actually uses.

[Agam @itsagam]

i would love interacting with people in tech, design, art and politics. a balanced discussion. trying to broaden my horizon. let’s see if @X can make that happen

[Agam @itsagam]

💡SQL challenge: Rank the Scores

👉Highest→Lowest.
👉Ties get the same rank and there are no gaps after ties.
👉Return the table ordered by score desc.

Ready to solve?
🔗 Schema + Solution included.
https://t.co/xJxddGenCz

[Agam @itsagam]

💡 SQL Challenge: Second Highest Salary

Table: employee (id, salary)

👉 Find the 2nd highest distinct salary.
👉 If it doesn’t exist → return NULL.

Try it out & share your solution!

🔗 Schema + Solution included.
https://t.co/iPvxGTKiDI

#SQL #DataAnalytics #SQLChallenge

[Agam @itsagam]

🚀 SQL Challenge: Combine Two Tables

You have:
👤 Person (personId, firstName, lastName)
🏠 Address (addressId, personId, city, state)

Task → Return each person’s first & last name + city & state.
If no address exists → return NULL.

Schema + Example included.
🔗https://t.co/eOoLR0B5Xr

[Agam @itsagam]

Scaling is exciting, but it often comes with some familiar speed bumps:

🧩 Data scattered across teams
⏳ Reports taking too long
🏃🏻 Constantly chasing updates
🚨 Getting blindsided by anomalies
📊 Hours lost wrangling spreadsheets

At @anovate, we help teams cut through that noise.
We run a 10-day, NO-COST proof of concept to show what’s possible - a live KPI dashboard with real-time alerts built on your existing stack.
The goal is simple: make the value visible before you commit to anything.

Curious? I’d be happy to share a one-pager, a sample dashboard, or just jump on a 15-minute scope call. Let’s explore how to make your data actually work for you.

Here's a quick peek
https://t.co/TfI8r3X8x3

[Agam @itsagam]

@PLBompard Business Intelligence Services for Emerging Businesses

https://t.co/tr5TAjIHGs

[Agam @itsagam]

dbt Logging: Make Your Data Builds Observable

dbt logging captures events, messages, and metadata during runs/tests, helping diagnose failures, measure performance, and trace lineage across models.

[Agam @itsagam]

Currently reading "How to Lie with Statistics" by Darrell Huff, a classic on how numbers can be twisted to mislead, manipulate, or deceive.
Essential and fun reading for anyone who wants to spot dodgy data, misleading graphs, and “statisticulation” in the news and beyond. Stay skeptical!

[Agam @itsagam]

Ever wonder how data models power your favourite dashboards, ML pipelines, and reports?
Meet dbt exposures! ✨

Exposures close the gap between your backend SQL and business-facing analytics, adding transparency, accountability, and traceability to your modern data stack.

[Agam @itsagam]

Master your data workflows with dbt hooks! 🛠️

✨ dbt hooks let you run custom SQL at key points, before or after models build, or even at the start/end of your run. Use hooks for automating audits, setting permissions, triggering cleanups, and more.

[Agam @itsagam]

Most SQL projects have one big problem:
🧠 No one knows wtf is going on.

🔻What feeds this table?
🔻What does this column mean?
🔻Is this still being used?

That’s where dbt docs comes in clutch.

[Agam @itsagam]

people often play fast and loose with "average". it wouldn't be amiss to state that it's often used to manipulate general opinion.
often by cherry-picking the type of average that flatters their narrative, they manufacture a perception that doesn’t reflect reality.

[Agam @itsagam]

dbt macros let you define logic once and use it everywhere, whether you're transforming data or writing custom tests.

dbt comes with several built-in macros for your use in model definition and tests!

[Agam @itsagam]

We ran a poll asking data folks about their go-to tool in 2025 - and the results are in!

Let’s take a look: 👇

[Agam @itsagam]

When you're learning something completely new, what's your go-to method?

Everyone learns differently.
Curious to know yours 👇

[Agam @itsagam]

If you're building data pipelines, but not writing tests in dbt, you're flying blind.

🧵 Let's talk about dbt tests, your first line of defense for clean, reliable data.

[Astronomer @astronomerio]

Thank you for your interest in Astronomer.

[Agam @itsagam]

Need slowly changing dimensions (SCDs) in your warehouse? Even if it doesn't get tracked in production.

Use dbt snapshots to track row-level changes over time.

[Agam @itsagam]

In dbt, a model is just a .sql file that selects data.
It’s that simple. ✅

But that simplicity hides powerful structure and control that makes your data stack maintainable and scalable.

[Agam @itsagam]

🎯 Data People: What’s your real go-to tool in 2025?

Vote below. 👇
But more importantly, tell me why in the comments.