Back to Top
Here's how we've helped some of our clients over the last few years.Piotr Szatkowski
Operations Director
Great work supported by great people.

Microsoft for Energy Sector

How can an electricity distributor effectively manage power limitation exceedances?

The Polish Government introduced legal regulations (so-called power supply limitations) to govern electricity consumption and ensure continuity of energy supply. High volume users of electricity are obliged to reduce consumption according to limitation plans, while electricity distributors are required to register any incident where power limitations are exceeded.

Though the process is easy to describe, it’s actually fairly complicated in practice and produces a vast amount of data (Big Data).

At the invitation of Tauron Dystrybucja S.A., the country’s largest electricity distributor (45,000 GWh, 57940 km2 of covered area, 11 branches, 5.3 million customers), Microsoft Poland took on the challenge, and invited Objectivity – a partner experienced in analysis and processing of large data sets (Big Data) and building tailored solutions based on cloud-based services – to co-operate on a solution.

The only limit is our imagination

So far, we’ve shown how new technologies can help simplify the management of power limitations. Leveraging technologies such as Machine Learning, applied to existing historical data, the system would be able to automatically design limitation plans, taking into account the history of energy consumption for individual customers over time. This represents an important innovation, as it would enable each customer’s limitation plan to be based on their capability to reduce power consumption.

We’ve also identified potential to make delivery of limitation plans and reports on power limitation exceedances to customers less labour intensive.

Our aim was to offer an easy and intuitive way of presenting and reporting complex data – data that is inherently difficult to visualise. Thanks to our cooperation with an energy market expert, we gained valuable insight on how to interpret data, and on which data and indicators are important to the end user. This close collaboration enabled us to deliver the entire scope of the pilot project within three weeks. The resulting solution provides a compelling demonstration of the value offered by a set of important new technologies and, above all, satisfies the business need.

Michał Puterman
IT Operations and Development
Guild Master at Objectivity

Hosting the system in the cloud, and making it available to customers via the web, would offer each customer the ability to view and track their own energy consumption. This would be particularly valuable during periods where energy consumption is more tightly constrained by the Polish Government. In addition, the system would not only automatically create power limitation plans, but also deliver them to the customer, together with the relevant guidelines.

Implementing an IoT (Internet of Things) solution, means that we can monitor power limitation exceedances on an ongoing basis and react when they occur. We are certain that new technologies used in this way would greatly assist electricity distributors in their mission to ensure energy security.

Due to our cooperation with Objectivity, we could present Tauron Dystrybucja S.A. opportunities and business benefits resulting from the use of new technologies such as IoT or Big Data, as well as new data visualization techniques such as PowerBI. Fast, professional and a matter-of-fact analysis allowed us to identify areas, in which the applied technology would have the greatest impact on improving the business processes. An undeniable strength of Objectivity is a team of experienced developers and architects, who know how to convert business requirements into a real product, developing a technical solution based on many years of experience in many industries

Jarosław Zarychta
Business Development Executive at Microsoft Polska

Potential given by new technologies

  • Automation reduces labour intensity and increases quality.
  • Correlation of different data sources gives enhanced visibility.
  • Integration with existing systems reduces cost of implementation.
  • The solution offers scalability according to need.

Key achievements

  • Rapid identification of power limitation exceedances for individual customers.
  • Easy visualisation of limitation plans.
  • Intuitive, dynamic data analysis and reporting.

Core Technologies

  • Microsoft SSRS 2016 for data aggregation and presentation of static reports.
  • Microsoft PowerBI for dynamic data presentation with the possibility of deep data exploration.
  • Microsoft Azure SQL database (a cloud hosted database, which offers performance and scalability without interruptions to service provision).
Download PDF