Local Land Services NSW automates workflows to improve business reporting efficiency – Microsoft Australia News Center

When it comes to business planning and reporting, organizations need to be able to show what they have achieved and clearly articulate their strategic direction. Achieving this requires immediate access to reliable data and the ability to drill down into metrics to provide richer insights.

This is particularly crucial for organizations such as Local Land Services (LLS), an executive agency of the NSW State Government. The regions-focused NSW government agency helps farmers, landowners and the wider community make better decisions about the land they manage. It also helps rural and regional communities become more profitable and sustainable.

LLS operates in 11 regions across NSW, which means it has 11 different strategic plans which feed into a statewide strategic plan. And the agency’s 1,073 employees are spread across 110 cities.

According to Emily Kearns Business Partner Strategy and Performance at LLS, the agency used several disparate systems to manage corporate reporting and planning. This resulted in inconsistent and unreliable data, and took a long time to collect.

“There are a lot of moving parts in our framework, achieving central oversight and being able to see how we are delivering our strategic plans has always been difficult,” she explains.

“If we were ever audited or needed to deliver something to the Treasury, there were a lot of spreadsheets, there was a lot of paper and there were a lot of files that we had to go through to find out what we were. deliver and how we could prove it.

Improved data integrity and reduced effort

LLS engaged Microsoft partner Sentient Dynamics to design and build an enterprise evidence and reporting tool (BERT) that guides LLS staff through the planning and reporting process, and helps align national strategies and regions of the agency.

The first version of BERT was built for the agency’s North West region, which assists farmers and landowners in several areas such as weed and invasive species control and monitoring of traveling livestock reserves. .

Scott Wallace, Microsoft Power Platform consultant for Sentient Dynamics, explains that the solution resides within Microsoft Teams and uses Microsoft Dataverse and Microsoft Power Apps to capture business blueprints. BERT also leverages Microsoft Power Automate for workflow automation and notifications, and Microsoft Power BI to visualize data, generate reports, and enable data-driven decisions.

The reporting tool (BERT), powered by Microsoft technologies such as Microsoft Teams and Power BI, has helped farmers in areas such as weed and invasive species control. (Source: Jed Owen)

“We have notifications and approvals in Microsoft Teams triggered through Power Automate Flows. And then we integrated Microsoft SharePoint, which is where all the evidence files are stored,” he explains.

James Diekman, Principal Consultant at Sentient Dynamics, adds, “One of the reasons the solution was originally built in Dataverse and Teams, and using as many Microsoft tools as possible, is that LLS already had a existing investment in Microsoft. [technology] and knew these tools. So we were able to engage and come up with a solution fairly quickly. »

Sentient Dynamics built the solution in just three months and implemented it for the agency’s Northwest regional division in July 2021.

Dale Kirby, team leader for agriculture at LLS in the North West region, says BERT has saved about 45 days per year collecting data and about 10 days per month generating reports.

“It alleviates all the multiple reporting channels that we gather data for,” he says. “We could have one annual report per calendar year, then another annual report per fiscal year, and that would change the data. So we would go back to collecting data based on spreadsheets and then slicing that data to provide accurate reports for each of those different cadences.

Gregory M. Roy