Modern Excel

By Microsoft


Power Query & Power Pivot Expertise 



Procurement Analytics

with Power Query & Power Pivot

Two power tools you can use to transform the way you work with procurement data in your teams, departments or your entire organisation.

Power Query is a business intelligence tool allowing you to import your data from a variety of sources so you can reshape the data as needed. Then you can save this query once and recall updated data with a simple refresh.

Power Pivot allows you to import data from multiple data sources into a single Excel workbook. Then you can colate data relationships to create PivotTables and PivotCharts within Power BI to more easily analize the data.

 JNT Consulting understands how to make these powerful tools work for your organisation. If you are envisioning scenarios where you can achieve significant improvement combining the use of these tools to improve efficiency, we are ready to help you take the next step.

Fully automate your Excel based periodic reports. Excel NOW can save you hundreds of hours of manual and repetitive tasks AND, now Excel can handle hundreds of million of more limits.

See How Power Query Can Help You