Shahid Latif – "Information is the oil of the 21st century, and analytics is the combustion engine."

What is Risk?

Risk is the possibility of an unfavorable event occurring. Mathematically and conceptually, it is driven by two distinct variables: probability (the likelihood or uncertainty of the event) and impact (the…

shahidlatif July 14, 2026

Projects

Open-Agent: A Free .Net Based AI Agent

https://youtu.be/4-A297RgEbw Open-Agent is a free .net based AI agent that runs on your computer and connects to your local ollama server and its models. Simply select a model, enter a…

shahidlatif June 25, 2026

Projects

LANCom – A LAN Based Communication System

I designed a website for my office (I am heading Business Analytics in ZTBL) where I present analytics/reports/dashboardsKPIs etc. and it is accassible over LAN. So, I got an idea…

shahidlatif May 22, 2026

Projects

Introducing VLOOKUP_IM: Powerful Lookups with VLOOKUP Simplicity

https://youtu.be/DM4kvnkMNmU If VLOOKUP's unidirectional and underperforming search has held you back, and INDEX MATCH's multi-argument structure seems daunting, VLOOKUP_IM is your solution. This custom Excel VBA function is engineered to…

shahidlatif July 18, 2025

Projects

Universal Excel File Merger System

The VBA file is designed to merge data from multiple Excel workbooks into a single "master" workbook. The file is placed in a folder among other files that you intend…

shahidlatif June 20, 2025

Projects

Automating ETL, Reporting, and Communication Operations Using Python and Google Cloud

When I started as Head Business Analytics and MIS, my first major challenge was to compile and report the daily performance of all our field offices to higher management. This…

shahidlatif June 19, 2025

Analytics

The Lifeline of an Economy: The Indispensable Role of Foreign Remittances in Pakistan

Foreign remittances, often referred to as "workers' remittances" or "migrant transfers," represent the non-commercial transfer of money by foreign workers, members of a diaspora community, or citizens with familial ties…

shahidlatif May 25, 2025

Analytics

The Pulse of the Economy: Pakistan Stock Exchange

The Pakistan Stock Exchange (PSX) is the sole stock exchange in Pakistan, formed in 2016 through the merger of the Karachi Stock Exchange (KSE), Lahore Stock Exchange (LSE), and Islamabad…

shahidlatif May 25, 2025

Analytics

Analysis of Weighted Average Lending and Deposit Rates in Pakistan

Weighted Average Lending Rate is the average interest rate that banks charge on loans, weighted by the size of the loans. It provides a more accurate picture of the cost…

shahidlatif January 16, 2025

Analytics

Understanding the Bank Floating Average Exchange Rates

In today's interconnected global economy, exchange rates play a crucial role in international trade, investment, and finance. Among the various exchange rate regimes, the floating exchange rate system is widely…

shahidlatif December 20, 2024