Education
CHALLENGE
Our client in the education sector had been tracking absences by school in SharePoint Online. The list has several lookup fields for other related information. The information needs to be reported upon and charts created to show performance against targets.
SOLUTION
After close consultation with the client we implemented ThorApps Online Services, making use of the BI Service we were able to create an automated multi-page report with charts detailing performance against target.
RESULT
The client was able to get automated reports to ensure that absence was effectively tracked and reported to ensure that targets were met or exceeded.
Health
CHALLENGE
Our client working in the health sector, Sandra was responsible for approving timesheets each week, but had the unenviable task of having to chase up staff who needed constant reminding to submit their documentation. She wanted to find a way she could avoid having to personally phone each one of them individually.
SOLUTION
When we met with Sandra, it didn’t take long to see just how time consuming this process had become. We used the BI Service subscription features and created the “hasslebot”, the hassle you have when you’re not having to hassle.
RESULT
A clever report now runs behind the scenes without Sandra having to lift a finger. This then runs an email every Monday morning at 10am to ONLY the staff that have not submitted their timesheet. Not only did this take only 15 minutes to setup, the best part is that 95% of the company’s timesheets are now being submitted on time.
Utilities
CHALLENGE
Sam is a project manager working in utilities, using Project Online. He runs daily project status meetings and had to manually collate information from project schedules and lists in project workspace sites. This was taking Sam an inordinate amount of time, and even with all that effort, he could only ever see day old information.
SOLUTION
We created Sam a single status report for each project that was updated to the minute, so he could focus on problem areas. Using BI Service and Project Sync Service, we created a PoP report (Project on a Page). His Issue, Risk and Change Request information became available immediately and Project Schedule information a few minutes after publishing a project.
RESULT
Sam got his sanity back and was so happy with the solution, we then put the report into a web part on the project sites, so all team members could see the “to the minute” status anytime. This has also resulted in much shorter status meetings with everyone updating the report before it’s presented in the meeting.
Government
CHALLENGE
Our client in government spent years building vital business reports in SSRS for SharePoint Integrated-Mode, but wanted to migrate to SharePoint Online. With SharePoint Online not providing SSRS, they were at a total crossroads as they could not afford to operate without the business intelligence generated from their reporting.
SOLUTION
Working closely with the client to understand the essential reports driving their business, we began to build a BI Service solution that would ensure business continuity, provide improved efficiency and provide limited development time.
RESULT
As well as seamlessly migrating all existing reports to Online Services and creating a secure connection to their SQL server onsite, our client was able to experience business as usual in record time.
Utilities
CHALLENGE
Working in finance, as well as helping to resolve issues, Michael also sends his customers an issue status report every week. This detailed report is collated in Excel individually for each customer and emailed individually to them. The reporting process had become unmanageable, taking up nearly just as much time as getting issues resolved.
SOLUTION
Michael’s issue is not uncommon and was the perfect candidate for our support ticketing system, which uses a SQL database to store the issue and customer contact data, then generate reports. So we created an SSRS report for BI Service and a data driven subscription.
RESULT
This flexible reporting solution means Michael’s customer issue status reports are now completely automated. This has saved him numerous hours of tedious work each week and enabled him to get back to helping his customers.
Mining
CHALLENGE
Enable our client in the mining industry to easily print their Power BI dashboard and score card data, especially when there is more than one page of information.
SOLUTION
By employing BI Service by ThorApps the client was able to generate paginated reports via the free Visual Studio community edition. They were then more easily able to present reports as both a dashboard in SharePoint online and print the paginated reports (to PDF or Printer).
RESULT
No more battling with Power BI printouts! Using the BI Service app now means anyone can not only page through their report pages, but also export their report to PDF for printing.
