Power BI, Python & AI for Finance

Click to enlarge

Data Transformation in Python — At Scale

One export of 6.18 million dirty rows, cleaned in Python and reconciled to a total you can defend. For Power Query users who have never written Python. Amounts stored as text, three date formats in one column, the same transaction arriving twice with two different values, and twelve monthly branch files that disagree with the export — three of which do not even have the same columns. By the end you will have a cleaned table of 5,880,056 rows and the four numbers that prove it is right.