The challenge
The association needed one place to see business opportunities that were published by many agencies and partners, refreshed automatically and more often than before. Members, stakeholders and partners each had to see only what their permissions allowed.
What we did
Delivered by Logic Intelligence®, the team behind every Data Arcade package.
- Gathered requirements with the association's subject-matter experts and stakeholders.
- Built scheduled ingestion pipelines that collect, cleanse and normalize opportunities from agencies and partners.
- Added an approval workflow for opportunities that staff upload by hand where a source does not publish them.
- Designed role-based access, row-level security and a data dictionary with lineage.
The solution
An opportunity aggregation platform. Azure Data Factory pipelines ingest and cleanse the source data into curated Azure SQL tables for opportunities, agencies, registry and certification data. Power Automate handles refresh orchestration, approvals of manual uploads, exception routing and notifications. Power BI semantic models and reports are embedded securely in the association's website, with access mapped to Azure AD groups and row-level security.
Built with
- Azure Data Factory
- Azure SQL Database
- Azure Storage
- SharePoint
- Power Automate
- Power BI
- Azure DevOps
- Row-level security
Outcomes
What the client has now.
- One source of truth for opportunities, shown to each user according to their permissions.
- Faster opportunity discovery through automated aggregation and governed refreshes.
- Higher trust in the numbers, with quality checks, documented definitions and lineage.
- Less manual effort, with scheduled ingestion and workflows for exceptions, approvals and notifications.
Buy this as a package
The same kind of work, as a fixed-scope package with a published price range.