Table of Contents Overview While working on a complex Excel workbook that has several worksheets with lot of formulas, logic, pivot tables, …, it can become a challenge to make changes without breaking something or the other. For that reason, I would like to share the below code examples in VBA that can be used […]
How to use VBA code to find reference(s) in multi worksheet Excel workbook Read More »
TABLE OF CONTENTS INTRODUCTION Sometimes you have a requirement to export large volumes of static reports to users who may or may not have Power BI licenses. One way of accomplishing this is through email subscriptions. The issue being that a large population (say, 50+ users) would each need their own subscription managed per report!
Python: Dynamic Power BI PDFs with REST API Read More »
TABLE OF CONTENTS OVERVIEW Source control is a powerful tool for development teams; from version control, qualifying deliverables (i.e., peer-review check-in), and the ability for multiple developers to work on the same project simultaneously, the benefits of incorporating this tool into your workflow can’t be overstated. Microsoft has launched two amazing features for Power BI
Source Control for Power BI (Azure DevOps, GIT) Read More »
Table of Contents Overview Breadcrumbs are a powerful element adding context to your reports. Effectively, when a user applies filters, breadcrumbs establish context for quick reference. You can see an example below or by going to this article: Financial Modeling in Power BI (Filter Page and Breadcrumbs), Analytical Ants. Pattern Overview The output of this
DAX: A Breadcrumb Pattern Read More »
Table of Contents Overview In Power BI, there are many ways of working with data via DAX. One option is to materialize tables in memory for dynamic computations. An example is creating a virtual time series for dynamic present value analysis; an example can be found here: Discounting Cash Flows in Power BI – DCF
DAX: Option for viewing Virtually Materialized Tables in Power BI (Fabric) Read More »
Table of Contents Overview The Discounted Cash Flow model is a business valuation model that quantifies enterprise value by discounting all future cashflows to a singular present value. Does that sound like Gobbledygook? Don’t worry, we will break this down in more detail later. For now, know that we will be replicating this paradigm of
Discounted Cash Flows in Power BI (part 1) Read More »
Table of Contents Overview If you haven’t done so already, please make sure to review part one and two of this series: Effectively, we are building financial statements and reports based on raw transactional general ledger (GL) data. In this article, we will be procuring the following financial statements and metrics: Indifferent of the organization
Financial Modeling in Power BI (Part 3) Read More »
Table of Contents Overview If you haven’t done so already, please review part one in this series covering accounting, finance, and business intelligence data modeling basics (Financial Modeling in Business Intelligence, Analytical Ants). A summarized brief: Accounting is a double-entry method for record keeping, and those records are aggregated into financial reports for analysis and
Financial Modeling in Excel (Part 2) Read More »
Table of Contents: Accounting | Financial Overview Intro Accounting and finance effectively are one in the same. As the old joke goes, ‘one holds the elephant’s trunk and another it’s tail; thinking they are touching different animals, they’re surprised when it’s revealed they are touching the same creature.’ Wait… that ‘joke’ may highlight exactly why
Financial Modeling in Business Intelligence (Part 1) Read More »
Excited to launch the ‘Contoso Machine Learning Generator’ 🥳🥳🥳 Effectively, this tool offers data professionals a script to easily procure models to demo their abilities. Initially designed for Data Scientists, all data data-genres can benefit! – Data Engineers can load data into bronze data lake layers and use the script for ELT processing into silver
Announcement: Launching Contoso Machine Learning Generator Read More »
