Please note javascript is required for full website functionality.
MVP

Powerful Data Modelling

If you have Microsoft Excel 2010 or later, you may not realise it but you have access to self-service Power Business Intelligence (Power BI) tools. Alongside MS Query, Excel has a suite of data interrogation tools that can put many expensive management information systems to shame.

SumProduct can help you unlock the power of ready-made analysis at your fingertips, developing financial models and dashboard summaries that analyse data from a multitude of sources which were previously never linked together. Simple to use and easy to customise, SumProduct can assist with your data modelling analysis in a way Excel was never able previously.

Useful tools include:

Power Query

  • Microsoft Power Query for Excel is an Excel COM add-in that simplifies data discovery, access and linking
  • Suddenly, you no longer need to be an IT expert to draw data from a myriad of sources and combine to understand trends and correlations
  • Users may extract and transform data as they see fit without affecting the integrity of the underlying sources


Power Pivot

  • Developed for Excel 2010 and enhanced for 2013, Power Pivot is a data analysis tool that delivers more computational power than Excel alone may utilise
  • Power Pivot is often known as “PivotTables on steroids” as you can link data from different sources using straightforward formulae and user-friendly links
  • Provides deeper business insight in a fraction of the time using familiar Excel tools
  • Users may transform data into vital information and load into Excel with ease for simple manipulation for business decision-making

Power Map

  • Power Map is a great new Excel feature for exploring map and time-based data
  • It can be used to summarise data obtained from Power Query and filtered via Power Pivot
  • Allows filtering and the creation of custom maps

Power View

  • Provides interactive dashboard summaries for all your reporting requirements and may incorporate maps, PivotTables and PivotCharts
  • Updates instantly as underlying data is refreshed
  • Data may be drilled down upon with ease

Make your business more intelligent. Contact us for how Power BI may be implemented in your business today.

Newsletter