Category: Python

Part 4: From Architecture to Operations — Making Excel Financial Models Production‑Ready

February 1, 2026

In Part 3: Future-State Architecture, Modernizing Excel Financial Modeling of the Excel modernization series, the focus moved from when to modernize to what a modern financial modeling environment should look like. The article introduced a future‑state reference architecture that treats Excel as part of a governed, scalable analytics system—not a standalone spreadsheet. It showed where … More Part 4: From Architecture to Operations — Making Excel Financial Models Production‑Ready

Part 2: When Excel Needs to Grow Up — The Hybrid Excel + Python / Power BI Framework

January 22, 2026

In Excel Optimization for Financial Modeling a Modernization Guide – Part 1: Fix Excel, we focused on optimizing Excel: making models faster, smaller, and more stable.But optimization alone doesn’t answer the bigger question many teams face next: When is Excel still enough — and when is it time to modernize? This post explores the hybrid … More Part 2: When Excel Needs to Grow Up — The Hybrid Excel + Python / Power BI Framework

Part 1: Fix Excel – Optimization for Financial Modeling a Modernization Guide

January 21, 2026

As financial models grow larger and more critical, performance, stability, and governance become just as important as analytical accuracy. This series provides a complete blueprint for optimizing and modernizing Excel‑based financial modeling. It begins with high‑impact Excel optimization techniques—such as Power Query transformations, Data Model loading, formula simplification, static value conversion, workbook hygiene, and .xlsb … More Part 1: Fix Excel – Optimization for Financial Modeling a Modernization Guide

Intelligent Applications in Azure SQL Server

August 9, 2024

Ready to elevate your data management game? Today, we’re diving into the fascinating world of Retrieval Augmented Generation (RAG) and how it can transform your Azure SQL Server experience. Whether you’re a seasoned SQL expert or just starting out, RAG offers a plethora of benefits that will make your data management faster, smoother, and more … More Intelligent Applications in Azure SQL Server

Azure Based COVID19 PPE Hospital Forecasting Using Azure Server-less Architecture

May 1, 2020

Introduction This project was born from Rush’s Medical Center development of the same project which was implemented using Jupyter Notebook & hosting it on a virtual machine using Voila. Rush’s Medical Center calculates forecasting based on 3 models: Exponential Regression Logistic Regression Polynomial Regression Deploy to Azure To deploy this solution to Azure click here to access … More Azure Based COVID19 PPE Hospital Forecasting Using Azure Server-less Architecture