My Tableau Journey: Visualizing Banking Data I started this blogathon series as the one without an IT background, curious about data and how it drives decisions in real world banking operations. My learning journey has been step-by-step and now it culminates in exploring Tableau for data visualization This final blog brings my skills together, focusing on visualizing the teller cash inflow, cash outflow and showing insights in a clear interactive way. The goal is not complex,

Image from stock.adobe.com In the previous blogs of this series, I explored how data analysis fits into real business scenarios. Now, it’s time to take the next step in this journey, working with larger more complex datasets, the kind that banks deal with every day. One of the challenges they face constantly is figuring out the loan outstanding for customers who have multiple loans. Think about it! customers rarely just have one loan. Many of them juggle a home loan, a person

Using Excel to Analyze Daily Banking Operations – A Real Time Case Study As we discussed in the previous blog, Excel is one of the most beginner-friendly tools  in Data Analytics. It allows you to experiment with ideas, explore data, and understand patterns without feeling overwhelmed by complex tools or coding. Because of this simplicity and flexibility, I chose Excel as the primary tool  for this project. It gave me the freedom to apply what I was learning and turned real-w

From NON - IT to Data Analytics... Could This Be Your Story Too? Photo by Deng Xiang  on Unsplash Have you ever sat at your desk and thought, “I’m doing my job well… but is this really what I want to do long term?” If yes, trust me you’re not alone. I was working in the financial sector , handling daily operations, transactions, and reports. Everything was stable. Everything was familiar. But somewhere along the way, I started noticing something interesting, every decision wa

Drawing from six years of banking experience, I built an Excel-based cash management dashboard to track inflow, outflow, and teller performance showcasing the real impact of analytics in banking.

In PostgreSQL, both Common Table Expressions (CTEs) and views offer powerful ways to simplify and organize complex queries. While they...

Introduction: PostgreSQL's window functions are a powerful feature that allows for complex data analysis and reporting directly within...

Data Enthusiast — Are you in crossroads ? Are you currently diving deep into the world of data, perhaps mastering SQL queries or...

"You've just spent hours perfecting that Tableau dashboard, it looks amazing on your Windows machine. You share it with a colleague on a...