Turn any database into governed, self-service analytics, without giving end users SQL.
System administrators connect BizBlocks to one or many MSSQL or MySQL databases. Connections are managed centrally and every query runs against a defined connection, so access to raw data stays with administrators while end users only ever see the reports you publish.
Reports are authored in a visual query editor. Behind the scenes a query interpreter composes safe, parameterized SQL from your report definition and the filters a user selects at run time. Write the query once and it adapts to any schema.
SELECT StoreName, SUM(NetSales) AS NetSales
FROM dbo.Sales
WHERE BusinessDate BETWEEN @start AND @end
GROUP BY StoreName
ORDER BY NetSales DESCFilters like @start and @end become run-time controls. Users change them; they never touch SQL.
Add unlimited filters to any report. End users pivot, sort and filter within the permissions you grant, then save personal views and charts. Views roll up into dashboards and scorecards.
Compose report views into one or many dashboards per user or team. Dashboards can stream real-time updates over SignalR, giving each role an always-current, all-in-one view of the metrics they care about.
Any report or list of reports can be scheduled for delivery by email or FTP as PDF or Excel on a recurring basis, with alert notifications and outbound domain restrictions to keep private data internal.
Scheduling is powered by the same background jobs engine that runs imports and syncs.