#FrogBlog

Purple Frog Data🐸

@purplefrogsys.bsky.social

2 days ago

A promotional graphic with a purple background titled “Wait, does ChatGPT actually think it’s 2024?” in large white text. Below, orange text reads “Frog Blog | Annabel Hemingbrough.” A paragraph explains why generative AI tools can appear outdated due to training data limitations and the need for retrieval‑augmented generation. The lower portion shows a laptop screen displaying the ChatGPT interface. At the bottom is an orange “Frog Blog” button and a tagline: “Using Data Analytics and Business Intelligence to transform your business.”

Ever asked #ChatGPT something recent and it answers like it is still 2024? 🤖

That is because of knowledge cutoffs.

In her #FrogBlog, Annabel explains why #AI models rely on older training data and how tools like RAG fetch current information.

👇️ Read more:
www.purplefrogsystems.com/2026/03/wait...

Purple Frog Data🐸

@purplefrogsys.bsky.social

3 days ago

The Difference Between Using AI and Integrating It - Purple Frog Systems Enter, The Conflation Problem There is a growing issue in the AI space. Many talks marketed as “AI strategy” are, in reality, basic training sessions on prompt writing, ChatGPT usage, or Copilot for…

Using #AI tools is not the same as integrating AI🚫🤖

Prompt training and #Copilot workshops build digital literacy. They do not replace data engineering, modelling, governance, or measurable ROI.

Lewis explains the difference in his #FrogBlog.

Purple Frog Data🐸

@purplefrogsys.bsky.social

4 days ago

A purple graphic promoting a Microsoft Fabric Warehouse guide. The title reads “Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide.” Below it, an orange subtitle says “Power BI Developer | James Snow.” On the left is a circular photo of a person. To the right, white text explains the purpose of setting a Microsoft Fabric Warehouse to case‑insensitive at the workspace level to avoid query errors caused by capitalization differences such as “CustomerID” versus “customerid,” and notes that configuring this early ensures more consistent development and avoids issues with joins, queries, and reporting in Power BI.

A small #MicrosoftFabric setting can save hours of troubleshooting⚙️

In this #FrogBlog, James shows why configuring a case insensitive Warehouse improves query reliability and development consistency. Set it right BEFORE building your data platform.

🔗 www.purplefrogsystems.com/2026/02/micr...

Purple Frog Data🐸

@purplefrogsys.bsky.social

6 months ago

Blank rows breaking your #PowerBI visuals?

Callum shares a DAX trick to fill gaps with the last known value in his latest #FrogBlog. This is ideal for tracking daily metrics like membership counts.

Problem solved.

🔗 www.purplefrogsystems.com/2025/09/fill...

Microsoft Data Platform Group Birmingham

@msdatagroupbrum.bsky.social

6 months ago

Blog Archives - Purple Frog Systems Most databases need a server. DuckDB doesn’t. It’s a zero‑config, in‑process OLAP database you can run directly using Python. It’s fast, SQL‑friendly, and speaks Parquet like a native language — no…

Looking for some great reads? We love the Purple Frog Systems #FrogBlog, packed with great insights on all things data and tech! 🐸

A fantastic resource for the community. #DataCommunity

➡️ Check it out:

Purple Frog Data🐸

@purplefrogsys.bsky.social

6 months ago

You’ve used ROW_NUMBER()—but have you ever restarted it mid-window?
Jeet shows how to do exactly that with a clean CTE-based approach.

📚 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...

#SQL #SQLServer #Coding #FrogBlog

Purple Frog Data🐸

@purplefrogsys.bsky.social

6 months ago

Think ROW_NUMBER() can’t be dynamic? Think again.

Jeet resets it across renewal chains using CTEs and partitioning magic.

✨ Read the #FrogBlog by Jeet!🐸

www.purplefrogsystems.com/2025/07/rese...

#SQL #DataEngineering

Purple Frog Data🐸

@purplefrogsys.bsky.social

7 months ago

Want to track customer renewals in SQL and reset row numbers by group?🤔

Jeet’s blog breaks it down beautifully using CTEs and partition logic📚

🧩 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...

#SQL #Analytics #FrogBlog

Purple Frog Data🐸

@purplefrogsys.bsky.social

7 months ago

ROW_NUMBER() is powerful — but resetting it based on logic?
That’s next-level📈

Jeet explains how to group and renumber subscriptions step by step📝

🧪 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...
#SQL #FrogBlog #Analytics

Purple Frog Data🐸

@purplefrogsys.bsky.social

7 months ago

Why did the Python developer get stuck in a loop? 🔁
They forgot how to slice a list properly.

Jon's new post will fix that, and more.

🐸 www.purplefrogsystems.com/2025/07/pyth... #Python #Coding #FrogBlog

Purple Frog Data🐸

@purplefrogsys.bsky.social

7 months ago

🐍 Learning Python? Lists are one of the first (and most important) data structures to master.

Our consultant Jon just dropped a blog post covering everything you need to know 👉

🔗 www.purplefrogsystems.com/2025/07/pyth... #Python #Code #FrogBlog

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

Variable Libraries In Microsoft Fabric, In Preview! - Purple Frog Systems How variable libraries in Microsoft Fabric can enhance your CI/CD processes by ensuring consistency & efficiency in your teams process

Maximise efficiency in Microsoft Fabric!📈

James' new #FrogBlog post explains #VariableLibraries and how they can seriously improve your workflow. Don't miss it!📚️

📰Read the full blog:

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

Tired of writing the same code snippets over and over in #MicrosoftFabric?🥱

James' latest #FrogBlog has the answer: Variable Libraries!⬇️
Discover how to centralise and reuse variables for cleaner, more efficient solutions.

🐸 Dive in: www.purplefrogsystems.com/2025/06/maxi...

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

In his latest #FrogBlog, Lewis shares his first-hand experience navigating the #AI buzz at @SQLBits, the standout sessions, and what it all means for the future of data.

📖 Read: "SQLBits 2025: The Year You Couldn’t Escape AI"

👉 www.purplefrogsystems.com/2025/07/sqlb...

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

Croaking about our latest #FrogBlog! 🐸

Lewis' Frog Blog just dropped "10 Ways #SmallBusinesses Can Use #AI Today." If you're a #SmallBusiness looking to integrate #AI, this is a must-read!

Practical tips to get you started now👇
www.purplefrogsystems.com/2025/06/10-w...

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

Data Factory pipeline failure with a "null" error message - Purple Frog Systems Have you ever had this error when running a pipeline in ADF or Synapse? I have now seen this more than once and it can be frustrating to debug the issue. After trying a few different setups in…

Debugging ADF/Synapse pipelines?
If you see a "null" error, check for:

✅ An Until inside an If Condition
✅ A nested ForEach
✅ A parameter name with “-”

#MIcrosoftFabric provides clearer errors
🐸Learn more on the #FrogBlog:

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

New #FrogBlog alert! 🚨 James dives into the power of Variable Libraries in Microsoft Fabric. If you want to cut down on redundant code and boost productivity, this is a must-read.

Go check it out! 👇 #MicrosoftFabric
🔗 Link: www.purplefrogsystems.com/2025/06/maxi...

Purple Frog Data🐸

@purplefrogsys.bsky.social

8 months ago

Struggling with repetitive code in #MicrosoftFabric?🐸

James' #FrogBlog post reveals how Variable Libraries can revolutionise efficiency! Learn to maximise reusability and streamline development.

Read it here⬇️
www.purplefrogsystems.com/2025/06/maxi... #DataEngineering

Purple Frog Data🐸

@purplefrogsys.bsky.social

9 months ago

Save time in #PowerBI!⏱️
⏭️Skip the Publish button.

💾Save to OneDrive or SharePoint, and updates sync automatically.

Joe shares how in his latest #FrogBlog on the topic!
www.purplefrogsystems.com/2025/03/stop...

Purple Frog Data🐸

@purplefrogsys.bsky.social

10 months ago

Stop Pressing Publish in Power BI - OneDrive or Sharepoint can do that for you - Purple Frog Systems If you’re still using the Publish button in Power BI Desktop, there’s a better and more efficient way to manage your reports while saving time.

Still clicking "Publish" in #PowerBI?🖱️
There's a better way, and Joe's showing you how⬇️

#OneDrive and #SharePoint can handle updates for you. No manual publishing is needed.

🐸Learn more from the #FrogBlog:

Purple Frog Data🐸

@purplefrogsys.bsky.social

10 months ago

Have you thought about migrating to #MicrosoftFabric?🔄

In this #FrogBlog, Laura-Jayne is running through why you should migrate to #Microsoft #Fabric!

Take a read 👉️ www.purplefrogsystems.com/2025/03/tran...

Purple Frog Data🐸

@purplefrogsys.bsky.social

11 months ago

Work smarter in Power BI...📈

Automate report updates with #OneDrive & #SharePoint.
💯No more publishing, no more hassle.

🐸Learn how in Joe's latest #FrogBlog:
t.co/mVzZMZzKHm

Purple Frog Data🐸

@purplefrogsys.bsky.social

11 months ago

Pipeline fails with "null" error" in ADF/Synapse?😰

Jeet uncovers why & how #MicrosoftFabric helps fix it!
Don’t waste hours debugging.

🐸Read more here on the #FrogBlog: www.purplefrogsystems.com/2025/03/data...

Purple Frog Data🐸

@purplefrogsys.bsky.social

11 months ago

Still clicking "Publish" in Power BI?🖱️

There's a better way💯

#OneDrive and #SharePoint can handle updates for you. No manual publishing is needed.

🐸Learn more from Joe's #FrogBlog:

💜 www.purplefrogsystems.com/2025/03/stop...

Purple Frog Data🐸

@purplefrogsys.bsky.social

11 months ago

Debugging ADF/Synapse pipelines?
If you see a "null" error, check for:

✅ An Until inside an If Condition
✅ A nested ForEach
✅ A parameter name with “-”

#MIcrosoftFabric provides clearer errors
🐸Learn more on the #FrogBlog: www.purplefrogsystems.com/2025/03/data...

Purple Frog Data🐸

@purplefrogsys.bsky.social

1 year ago

🤯 The wait is over!

Dynamic execution of Fabric pipelines is finally here! 🎉

Nick dives into the new Invoke Pipeline (Preview) activity and how it changes the game in his latest #FrogBlog.

Read more:
🔗 https://buff.ly/4goPj4h
#Azure #Fabric #MicrosoftFabric #DataEngineering

Purple Frog Data🐸

@purplefrogsys.bsky.social

1 year ago

Great talk by @holliewhittles.bsky.social today on marketing with the British Business Bank and Marches Growth Hub!👏

You can even read all about over on our #FrogBlog!
🐸 www.purplefrogsystems.com/2025/01/new-...

#Marketing #Audience #TargetAudience