Data Engineering
Automated vCISO security dashboards with Microsoft Graph
Replaced a manual PowerShell-to-Excel reporting process with Python and Microsoft Graph API ingestion into Azure SQL, feeding Power BI vCISO dashboards across multiple client tenants.
- Client
- 24by7 Security
- Industry
- Cybersecurity
- Status
- In production
The problem
Security reporting relied on PowerShell scripts, manual Excel loads and Power BI imports that were slow and hard to scale.
What we built
- Python Graph API collectors for tenant, users, security metrics, devices, roles and email insights
- Central Azure SQL database
- Power BI connected directly for scheduled monthly refresh
Challenges we solved
- Per-tenant Graph consent
- Licensing-dependent datasets
- OS lifecycle enrichment
Results
- Manual effort removed
- Scheduled monthly refresh across client tenants
Technology stack
- Python
- Microsoft Graph API
- Azure SQL
- Power BI
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Data Engineering