Analytical Ants

Blog Posts

Categories

Click on a category to filter blog posts. Multiple selections allowed.

Automation (1)Azure (1)DAX (2)Data Analysis (5)Data Engineering (3)Excel (2)Power BI (7)Power Query (2)Python (2)VBA (1)

	Category
Time Series Decomposition and Autocorrelation Function in Power BI with Python	Power BIPythonData Analysis	1/8/2025
How to use VBA code to find reference(s) in multi worksheet Excel workbook	VBAExcelData Engineering	6/10/2024
Python: Dynamic Power BI PDFs with REST API	PythonPower BIAutomation	5/21/2024
Source Control for Power BI (Azure DevOps, GIT)	Power BIAzure	2/29/2024
DAX: A Breadcrumb Pattern	DAXPower BIData Analysis	11/25/2023
DAX: Option for viewing Virtually Materialized Tables in Power BI (Fabric)	DAXPower BIData Engineering	11/14/2023
Discounted Cash Flows in Power BI (part 1)	Power BIData Analysis	11/14/2023
Financial Modeling in Power BI (Part 3)	Power BIPower QueryData Engineering	10/27/2023
Financial Modeling in Excel (Part 2)	ExcelPower QueryData Analysis	10/18/2023
Financial Modeling in Business Intelligence (Part 1)	Data Analysis	10/16/2023

We're Social!

Email us or follow us on LinkedIn, GitHub, or X.