9 of 9 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 … reliability. Provide knowledge transfer and user training before project completion 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 ...

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 ...

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 ...

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 ...

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 ...

laws. Licence: Valid UK driving licence. Desirable: Experience in the Care Sector, NHS, or Charity Sector . Data Tools: Hands-on experience with Power Query , SQL (extraction/reporting), and Data Modelling . Exposure to Power BI, DAX, Microsoft Fabric, or ETL/ ...

maintain high service standards across the logistics network. * Your responsibilities include developing and maintaining KPI dashboards, reports, and performance templates using Excel and Power BI, enabling transparency and data-driven decisions. * After analysing operational data, you prepare business cases, cost analyses, and improvement initiatives that support both operational … related field. * Experience: You have gained practical experience in transport and logistics. * You bring strong analytical capabilities, advanced Excel skills (including Power Query and Pivot Tables), and solid experience with Power BI for reporting and data modelling. * Experience in system implementation, key user roles ...

priorities. Work independently using existing technical skills including: - Advanced Excel knowledge to build tools to collect, store, model, analyse and present data - Power Query to extract and transform data from different sources - Writing SQL queries for data extraction and report building - Data modelling to bring sources … together for reporting Build on previous personal experiences, learn and apply new skills quickly around: - Power BI for analysis and presentation of data - DAX data modelling - Built-in reporting tools to extract data from business systems - Data engineering to automate the flow of data for reporting (ADF, Fabric ...

driven decision-making across the business by developing insightful reporting, dashboards, and analytical tools.This role is ideally suited to a candidate with strong Power BI expertise and a good understanding of finance processes, who can bridge the gap between data, finance, and business performance. The successful candidate will … transform complex datasets into clear, actionable insights that support operational and strategic decision-making.Key ResponsibilitiesDesign, build, and maintain interactive dashboards and reports in Power BI for finance and business stakeholders.Partner with FP&A, finance, and operational teams to understand reporting requirements and translate them into effective BI solutions.Analyse ...