AnalyticsCreator is a metadata-driven design application for data warehouse automation and data product engineering across the Microsoft data stack.
At its core is the AnalyticsCreator Governed Control Model, which keeps business meaning, data structures, transformation rules, dependencies and technical implementation connected in one controlled project model. Data teams design the required architecture in AnalyticsCreator, then generate native Microsoft assets from that design.
Generated assets can include SQL Server objects, SSIS packages, Azure Data Factory pipelines, Microsoft Fabric components, deployment artefacts and Power BI semantic models. AnalyticsCreator supports dimensional, 3NF and hybrid modelling approaches together with ingestion, transformations, delta loading, historisation, Slowly Changing Dimensions, snapshots and repeatable data-processing patterns.
Changes made in the model can be propagated across dependent project assets, while lineage, documentation and impact analysis remain connected to the underlying design. This helps teams reduce repetitive engineering work, standardise delivery and understand the effect of change before regenerating affected assets.
AnalyticsCreator generates native Microsoft technology rather than requiring a proprietary runtime. Organisations retain ownership of the resulting implementation and can integrate generated assets into existing Git, Azure DevOps and CI/CD processes.
Design Intelligence extends this governed project context into AI-assisted data engineering by giving authorised AI tools and agents structured access to metadata, lineage, dependencies and design rules.
Typical use cases include enterprise data warehouse development, Microsoft Fabric adoption, SQL Server and SSIS modernisation, governed Power BI delivery, SAP-to-Microsoft analytics architectures and repeatable data product engineering.
Learn more
CHARMS is a secure, online case management system used to manage all aspects of record keeping for foster care, adoption, children residential, supported accommodation, residential family centres, foster carer recruitment hubs, adult shared lives (adult foster care), supported employment and other care services.
SCN is a not-for-profit organisation, and always will be privately owned. It follows the principles of sociocracy so that all staff and customers are part of the CHARMS community and its development and progress. It means that everyone - employees, customers, suppliers and, most importantly, users of CHARMS - have a say in what CHARMS does and what it needs to do. We strive to ensure that care staff, educators, social workers, support staff and others who deliver care and education, can get on with the job knowing that CHARMS looks after their important, sensitive information.
Learn more
DreamFactory
DreamFactory Software is the fastest way to build secure, internal REST APIs.
Instantly generate APIs from any database with built-in enterprise security controls that operates on-premises, air-gapped, or in the cloud.
Develop 4x faster, save 70% on new projects, remove project management uncertainty, focus talent on truly critical issues, win more clients, and integrate with newer & legacy technologies instantly as needed.
DreamFactory is the easiest and fastest way to automatically generate, publish, manage, and secure REST APIs, convert SOAP to REST, and aggregate disparate data sources through a single API platform.
See why companies like Disney, Bosch, Netgear, T-Mobile, Intel, and many more are embracing DreamFactory's innovative platform to get a competitive edge.
Start a hosted trial or talk to our engineers to get access to an on-prem environment!
Learn more
