"Information is the oil of the 21st century, and analytics is the combustion engine." – Peter Sondergaard
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 and designed a LAN based Whatsapp like app. Works like whatsapp, looks and felt like whatsapp but data does not leave your organization. Instead of…
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 provide the advanced lookup capabilities of INDEX MATCH, including the crucial ability to search columns to the left of your lookup value with better performance, within…
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 to merge together. First all Excel files are identified in thate directory excluding the master itself. It then populates a list box with these file…
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 was a critical task that happened every night after business close. The raw data, detailing the daily efforts of our field officials, arrived in various…
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 abroad, for household income in their home country. For a developing nation like Pakistan, these financial inflows are not merely a supplemental income source but…
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 Stock Exchange (ISE). This consolidation aimed to create a unified, more efficient, and robust capital market. The journey began with the establishment of the Karachi…
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 of borrowing than a simple average because it takes into account the fact that larger loans have a greater impact on the overall interest income…
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 adopted, where the value of a currency is determined by market forces of supply and demand. In this context, the concept of “Bank Floating Average…
The Haro River flows through Khyber Pakhtunkhwa and parts of Punjab in Pakistan. It begins in the southern Dunga Gali range, splitting into two branches. The river travels through Abbottabad District, where its main valley resides. It then enters Rawalpindi District and continues through Attock District. Four major tributaries feed the Haro River: the Lora…
Played this game when it first came out. Did not like and did not finish. If you like games like GTA chances are good you find it hard liking this game. Too many dialogues, dark busy world etc. However gave it a second chance and found out it had multiple endings. To play all endings…