Claritix Insights

How Finance Teams can Analyse Big Data in Excel PivotTables using Power Query big data excel power pivot power query

When we think of “big data,” Excel likely isn’t the first tool that comes to mind. It’s often seen as suited to smaller-scale analysis - and with good reason. Excel worksheets max out at just over a m...

Continue Reading...
The 5 Stages to Creating Power BI Financial Reporting power bi power query

If you’re an accounting or finance professional looking to save time and deliver more insightful, reliable monthly reporting, Power BI can transform the way you work. This article walks you through th...

Continue Reading...
Automate Data Cleaning in Financial Reporting with Power Query automation power query

If you're in accounting or finance, there's a good chance you've found yourself, when reporting, stuck in a data cleaning Groundhog Day - repeating the same steps on the same types of data sets, month...

Continue Reading...