Team17 – Using Power BI to Improve Reporting & Business Decision Making

Team17

A multi-award-winning video game development company reached out to Espria to discuss improving their reporting structure and how to effectively utilise their data. Team17 found that while bursting with creativity and inventive thinking, they were lacking reporting infrastructure and data analytics. The organisation held a large amount of data but did not have the technology, nor the expertise make effective use of it.

Espria offer a full range of Power BI support and data intelligence services to maximise productivity and fully utilise an organisation’s valuable data assets.

The Solution

Following a migration to an AWS MySQL database, Team17 wanted to analyse their data. Lacking a means to analyse this data, they were unable to decide on approach and next steps in order to adapt to changes in the market, so they called upon Espria to develop a new Power BI data reporting infrastructure.

During Phase 1 of the project, a Power BI gateway was created to allow the data from the MySQL database to securely surface in the Power BI Online Service. This would enable managers and employees to view the up-to-date report anywhere, within their O365 environment. The connection to the database was tested and a test plan created, outlining the steps taken to ensure there were no issues with the tables within Power BI.

Espria then designed and created the new reports and infrastructure which would fulfil the business requirements. Once the final report format was agreed, Espria conducted OAT and UAT with key stakeholders to ensure the reporting worked effectively and provided accurate information to the business.

Business Benefits

From understanding how the effects of lockdown impacted their growth, to viewing game performance over different geographical locations and gaming platforms, Team17 are now able to drill deeper into their data, to spot trends and to understand these trends and plan their budget and forecasting based on facts rather than assumptions.

This new report allowed management to explore their sales performance data, patterns across different sales platforms, periods and more. In addition to the Sales report developed by Espria, they were able to access a clean, easy-to-understand dataset, enabling employees without business analytical skills to build their own reports and further adapt how they view their data.

Courtesy of Espria and the Power BI solution, Team17 now have a 360-degree view of their organisation with a greater understanding of what is happening in every area of the business. Every member of staff can access and create their own reports due to the simple, easy-to-use technology, with ongoing support from Espria.

Reveal areas that need proactive, defensive or collaborative resource

One of our experts will review your current data risk, examine current governance and security controls.

Rectangle111

What’s in this article

    We’re experts in building sustainable IT infrastructure that can scale to your businesses needs.

    You may be interested in

    What Happens to Your Printer Cartridges After You Use Them?

    Is Your Printer Recycling Actually Making a Difference? Most businesses know they should recycle their printer consumables. Fewer know what actually happens to a cartridge once it leaves the office, or whether their current supplier is doing anything meaningful with it at all. A smarter approach to printer consumables Under a properly managed print service, consumables are handled with a clear process rather than left to chance: One less thing for Office Managers to manage For an Office Manager, this also removes a recurring low-value task: nobody needs to track toner stock levels, notice a…

    Read the article

    Taking Control of Print Costs Without Micromanaging Staff

    The Hidden Cost of Office Printing Print costs have a habit of creeping up quietly: a few extra colour pages here, an unnecessary duplicate print there, a job sent to the wrong printer and reprinted. On their own, none of these feel significant. Across a whole office, over a year, they add up to a real and often invisible cost. See where your print spend is going PaperCut gives an Office Manager visibility and control over this without needing to police individual print jobs. In practice, this looks like: Reduce waste without restricting staff The…

    Read the article

    Five Printer Security Risks Most Small Offices Never Think About

    5 Print Security Risks Hiding in Your Office Following on from our earlier piece on printers as network endpoints, it is worth being specific about what actually goes wrong. These are the five risks we see most often when we assess a print fleet for the first time. The five print security risks to look out for 1. Default or shared admin passwords. Many devices are still running the password they arrived with, often known publicly for that model. 2. Unsecured print queues. Documents sitting in a print queue, or printed and left uncollected in…

    Read the article

    Key Takeaways from Microsoft Frontier Tour

    From AI Experimentation to Real Business Outcomes: Our Takeaways from Microsoft Frontier Tour London

    This week, Pete Graham, Microsoft Business Manager at Espria, attended Microsoft Frontier Tour London alongside members of the wider Espria team to hear directly from Microsoft leaders, partners and customers about the future of artificial intelligence. Having attended Microsoft’s AI Tour last year, Pete was interested to see how the conversation had evolved over the past 12 months. What became clear throughout the day was that the discussion around AI has matured significantly. A year ago, many organisations were still asking what AI could do. Today, the focus is increasingly on how to adopt it…

    Read the article

    PHP Vulnerabilities

    Critical PHP vulnerabilities: do you know who owns the fix? 

    When websites and applications sit with different teams and suppliers, the first challenge is knowing who needs to act. Critical vulnerabilities have been disclosed affecting PHP, a technology widely used across websites, web applications and other software products.  The technical advice is clear: identify affected systems and apply the available updates. But for many organisations, the first challenge is understanding where PHP is being used, who manages those systems and who is responsible for taking action.  To help you identify potential exposure, we have created a PHP Security Checker to determine whether your systems have…

    Read the article

    Beyond the Filing Cabinet: What Document Management Actually Saves You

    Document Management for Small Offices with DocuWare For many small offices, document management still means a filing cabinet, a shared drive with inconsistent folder names, and a lot of time spent searching for the one contract or invoice somebody needs right now. DocuWare replaces that with a structured, searchable system that sits behind your everyday paperwork. What does DocuWare mean in practice? Giving Office Managers time back For an Office Manager who is often the person holding the whole administrative process together, this is time back. Fewer interruptions to find a document for a colleague,…

    Read the article