Jan 114 min readExcel's Hidden Power: The Camera Tool!Create live, updateable images of data ranges or charts within Excel, turning static data into dynamic visual elements.
Apr 20, 20237 min readPower Query, Power Pivot, Power BI. Confused?We clarify the distinct, but sometimes inter-related features of these powerful Microsoft analytic 'Power' tools.
Dec 2, 20221 min readPower BI Sample Job Interview Q&AKnow your DAX from your DBA, or your metadata from your multi-dimensional? Prepare for your job interview with our sample Power BI Q&A.
Oct 24, 20222 min readData Analytics are Catching-OnAustralian businesses leveraging customer & staff data can raise their revenue by about 10 per cent, according to Deloitte's 2022 research.
Jun 9, 20222 min readExcel's New XLOOKUP FunctionExcel's XLOOKUP function allows you to look up a value in a range of cells and return a corresponding value from a different range of cells.
