Analytics Anecdotes

A collection of 24 posts

Analytics Anecdotes

Mini Project: RAG Pipeline Using LangChain on Databricks

By this point, I had read too much in theory about Retrieval-Augmented Generation (RAG) - what it is, how it works, and why it's useful. I understood the general processes it follows, including chunking, embedding, and vectorisation and then querying data with a large language model (LLM). And

Analytics Anecdotes

Design Patterns in Agentic AI

In my last blog, I introduced the different components of Agentic AI. These components help answer the “what”. * What enables an agent to take independent action, and * What allows it to remember and learn from past interactions? But there’s a crucial follow-up question we haven’t tackled yet. How

Analytics Anecdotes

Breaking Down Agentic AI and Its Core Components

Recently, I participated in a company-wide Hackathon at JLL focused on solving real business challenges using Agentic AI. With just over a week to develop our ideas into working proof of concepts, it was an intense yet incredibly energising experience. Out of more than 1,600 colleagues and 200+ projects

Analytics Anecdotes

The Secret to Getting Better Answers from Language Models

My mom is my best friend. She lives in India and works as a school teacher, but she always takes a keen interest in my blogs. Today, she asked me how my Agentic AI blog was coming along. I couldn’t help but laugh a little - it was so

Analytics Anecdotes

Mini Project: Data Cleaning App using ChatGPT API and Streamlit

Discover how I built an AI-powered data cleaning app using the ChatGPT API to automate CSV file cleaning. Learn about its features, challenges, benefits, and future improvements to make it production-ready.

Analytics Anecdotes

ChatGPT API - How to Get Started?

We all love using ChatGPT. But have you ever wondered how cool it would be to build something of your own using the same technology? Well, that’s exactly what we’re going to do! ChatGPT uses models like GPT-4, GPT-4o Mini, and GPT-3.5, and ChatGPT API enables us

Analytics Anecdotes

Databricks Certified Data Analyst Associate - How to Pass?

Introduction Hello, and a very warm welcome to my website! If you're new here, I’m a Business Intelligence Specialist working in real estate in London. My day-to-day involves a lot of data wrangling, creating and delivering insights, and managing a variety of stakeholders. My data toolkit includes

Analytics Anecdotes

The Role of BI in Real Estate

Real Estate Data: Where It Begins Let's say you are the CEO of a global corporate giant. There are 100 properties your company owns across the globe. Of these, 80% are office spaces, while the rest include industrial warehouses, lands and other property types. Some of these properties

Analytics Anecdotes

LinkedIn Profile Makeover with Notebook LM

Another day, another AI productivity tool. Today we are going to deep dive into Notebook LM, an AI-powered tool that can help you revamp your LinkedIn profile and make it more appealing to recruiters But before we jump into the details, let’s explore what Notebook LM is all about.

Analytics Anecdotes

Level up your storytelling with Napkin AI

Are you someone who creates presentations on a day-to-day basis, or a student working on a project, or a content creator writing blogs, or a teacher preparing study materials - This tool can help you present your stories in a much more visual manner. What is Napkin AI? It is

Analytics Anecdotes

Tinywow - AI Productivity Tool

With so many productivity tools available today, finding one that’s both versatile and easy to use can feel like a challenge. So, I decided to explore some of the most popular options and share my thoughts. In this blog, we'll explore the productivity tool called - Tinywow.

Analytics Anecdotes

CoxComb Chart - How do you read and make it?

Understanding what is a CoxComb Chart A Coxcomb chart, also known as a polar area chart or rose diagram, is a type of data visualization that combines aspects of a pie chart and a bar chart. In a Coxcomb chart, each category is represented by a segment (like a slice

Analytics Anecdotes

How to clean and organize your BI environment?

Imagine this: You’re looking at a report that shows your company has 80 products under its purview. Then you glance at another dashboard, and it says 72. Which one would you trust? Probably neither. You’d end up doing what most stakeholders do—send off an ad-hoc request for

Analytics Anecdotes

Depression Across the World

Depression is a mental disorder that leads to persistent feelings of sadness and a lack of interest. It can make daily activities feel overwhelming, and sometimes you might feel that life isn't worth living. You may also experience trouble sleeping, excessive low self-worth, or changes in appetite. These

Analytics Anecdotes

Augmented Analytics: Part 2

In part 1, we explored what Augmented Analytics is, the tools that provide it, and how companies are adopting it. We saw that Augmented Analytics is rapidly transforming the traditional analytics lifecycle, automating various aspects and bringing analytics closer to business users. But do you think it will replace analysts

Analytics Anecdotes

Augmented Analytics: Part 1

As a data analytics enthusiast, I like to stay updated on the top trends in data analytics and where the future of analytics is heading. One of the most exciting and recent developments in this field is augmented analytics. This revolutionary approach leverages artificial intelligence (AI) and machine learning (ML)

Analytics Anecdotes

Alteryx Advanced Certification: Preparation and Tips

If you want to get started in Alteryx and pass the core exam, you can read about it here: https://www.medhakhurana.com/get-started-with-alteryx-for-free/ Now, if you are someone who is core certified, and looking to get Alteryx advanced certified, then this is the blog for you. I recently took

Analytics Anecdotes

Find the street crime in your area: Macros and APIs in Alteryx

Living in London, a city that's a dream destination for many, is an incredible experience. Its beauty and charm are undeniable, but like any big city, it has its challenges, one of which is the crime rate. Whether you're considering a move to/within London or

Analytics Anecdotes

From Hypothesis to Conclusions: A Deep Dive into T-Tests for Data-Driven Analysis

In our journey as analysts, our goal is to harness the power of data to bring intelligence to the decision-making table. We're not just number-crunchers; we're storytellers who strive to use data that can guide our stakeholders to make informed decisions based on evidence rather than

Analytics Anecdotes

The Statistical Frontier of the Global AI Race Through Hypothesis Testing

In today's hyper-connected world, the race for AI dominance is heating up like never before. In this relentless pursuit of AI supremacy, all the nations are making waves with groundbreaking research, bold initiatives, and ambitious investments, challenging the traditional notion of AI dominance. So I ask you today,

Analytics Anecdotes

Optimize Your Alteryx Experience: Leveraging Automated Alerts for Workflow Failures

Welcome to the edition 'Optimize Your Alteryx Experience', crafted for professionals like you who rely on Alteryx in their day-to-day work. Throughout this series, I'll serve as your trusted guide, unveiling tips and tricks tailored to enhance your proficiency with Alteryx. In today's tutorial,

Analytics Anecdotes

Optimize Your Alteryx Experience: Harnessing the Power of Workflow Templates

Welcome to the edition 'Optimize Your Alteryx Experience', crafted for professionals like you who rely on Alteryx in their day-to-day work. Throughout this series, I'll serve as your trusted guide, unveiling tips and tricks tailored to enhance your proficiency with Alteryx. In today's tutorial,

Analytics Anecdotes

Unleash Your Data Wizard: Mastering Alteryx for FREE

Hey there, fellow data enthusiast! 👋 If you're anything like me, the thirst for knowledge and the drive to stay ahead in today's dynamic market are the flames that keep your passion burning bright. Alteryx is an amazing skill to have on your profile if you are

Analytics Anecdotes

First Glance at Data

Have you ever found yourself face-to-face with a sea of data and wondered, "Well, umm what next?" 😮 Does the urge to dive into the analysis immediately strike, or perhaps assumptions start forming like shadows in the dark? If you find yourself nodding, you're in for a