PinnedAutomating Business Intelligence on the CheapUsing Azure, One Drive and PowerBI Pro to get a simple, low cost and auto-updating dashboard up and running Introduction Based on empirical evidence it would appear most SMEs in Asia could do more to build a coherent, comprehensive data strategy. More work can also be done towards implementing adequate Business…Bi6 min read
PinnedPrivate Equity Valuation — A Quantitative ApproachPrivate Equity Valuation — A Quantitative Approach Private Equity (PE) valuation traditionally rests on the three pillars of Peerset multiple analysis, Cashflow analysis and forecasts (usually using the Discounted Cashflow Valuation model), and Some form of asset valuation or coverage ratio analysis. While these are fairly robust and have done reasonably well over the years, each of…Private Equity9 min read
Feb 25Early Warning Systems — Role of Data Strategy & BIA key issue I’ve faced in my PE career is firms not reporting issues in time. Either they themselves couldn’t anticipate this or they chose not to highlight the fact to us. …Business Intelligence5 min read
Sep 12, 2021Automating PowerBI with AzureTemplate to Automate PowerBI using Azure SQL and csv Files (yes I know bullet numbering is messed up — for some reason medium wont allow me to fix this) Tushar Sinha September 12, 2021 Version: 1.0 Overview This document outlines key steps to automate a PowerBI data chain using Azure SQL…Power Bi6 min read
Apr 17, 2021AgglomerativeClustering with Cluster CentersRecently I was working on a project that required me to compare Kmeans clustering to AgglomerativeClustering (using the sklearn package). I wanted to plot the clusters in 2d space and use the yellowbrick elbow visualiser to find the right number of clusters. For those who don’t know yellowbrick, it is…Clustering2 min read
