3 of 3 Contract Power Query Jobs in the East Midlands

Other project and commercial documentation Build formulas, data relationships, lookups, validation rules, dashboards, and reporting tools. Implement automation using advanced Excel functionality, including: Power Query Power Pivot VBA Macros (where appropriate) Dynamic Arrays Advanced Formulas and Data Linking Simplify and standardise document generation processes … generate and populate multiple documents from a single source of data. Proficiency with: Complex formulas XLOOKUP INDEX/MATCH Dynamic Arrays Pivot Tables Power Query Data Validation Conditional Formatting Experience building commercial and project management templates. Strong analytical and problem-solving skills. Ability to work independently ...

connected. Develop automated solutions to replace manual processes. Support the automation of PFEP (Plan For Every Part) processes. Use Python, SQL and Power Query to manipulate and analyse data. Develop and maintain Power BI dashboards and reporting solutions. Use Excel extensively for data analysis … organisation. Strong experience working with large and complex datasets. Advanced Microsoft Excel skills are essential. Practical coding experience using Python and SQL. Strong Power Query experience. Experience creating dashboards and data visualisations using Power BI. Experience working with SAP or other ERP/ ...

Requirements Strong Power BI build skills: DAX, Power Query (M), data modelling (star schema) Experience reporting from Dynamics 365/Dataverse (tables, relationships, option sets, including custom tables) Delivered reporting for Customer Service/Contact Centre : cases, queues, SLAs, agent performance, call statistics. Data … clear KPIs, definitions, and usable dashboards Nice to Haves Knowledge of Omnichannel/contact centre metrics (e.g., FCR, AHT, backlog/aging) Broader Power Platform exposure (Power Apps/Automate) and how it impacts data/reporting ALM/DevOps for Power BI (pipelines ...