Sam Thompson Email & Phone Number

My expertise is in the use of the Microsoft suite of BI tools. I do this at an expert level. My role involves both performing the tasks of an analyst and as a subject matter expert, trainer and mentor within the team and cross functionally. I act as the conduit for complex information flows between technical and non technical teams. I make the complex appear simple. Core to this job is my analysis role. This includes: Creation of an end to end capacity constraints model of the company allowing complex and varied scenarios to be analysed and acted upon. ETL of local and IAAS Data manipulation and analysis, Development and deployment of reporting. solutions in Excel and Power BI (dashboard and ad hoc reporting) over disparate local and foreign sources. Authoring queries in SQL, DAX, MDX and MI provide ad hoc and cyclical reporting to single users through to governance and statutory bodies.Built reporting suites for C level use and specialist teams. These reports are a represent a single data source with multiple views catering to the user group needs. I have developed a suite of real time reporting for the companies sustainability project. As a subject matter expert I: Provide technical CPD training hours to NZICA members in the use and development of Excel and PowerBI. Am a one stop shop for answers on how to do stuff or do stuff better in Excel/PowerBI. Author a fortnightly tips and tricks email.I am the subject matter expert in: Livestock data, Excel use and development, Excel services, PowerBI, Power Query, Power Pivot

Dunedin

A series of lectures and facilitation of workshops on the application of PowerBI & Excel in the workplace. The themes covered included best practice, financial modeling, forecasting, big data and professional expectations

Dunedin

Procurement analysis Demand forecastingFinancial modellingVolume budgeting and variance reporting

Dunedin

Internal AuditMonthly management accounting and reportingFinancial modelling

London, United Kingdom

Local authority internal and external audit assignmentsFinancial modellingForensic investigation and accounting from discovery to prosecution

Business advisoryAudit internal and externalFinancial modeling Tax compliance