We provide professional data solutions to businesses across the UK and Europe. Built on a long history of business intelligence and database development expertise, we have worked on projects ranging from building web-based social media analytics to reporting development & support, data warehouse design, database architecture consulting and industrial manufacturing plant data gathering and analysis. Our team bring experience from the IT, software development, services, sales, and manufacturing/research industries gained with multi-national companies like Atos, Intersnack, Aptean, Boots, Lockheed-Martin, United Technologies, and BNP Paribas (among many others).
The name Sthenica is pronounced "sth-en-i-ca" and derives from a word meaning abounding in energy or strength; active or strong.
Our work with Access Intelligence was to create an integrated data warehouse and dashboard for a cloud-based political monitoring tool. We used SQL Server & SSIS 2012 to build the warehouse and extract data from the applications database (running on RavenDB) and the Kendo UI HTML5 framework to build the dashboard.
Working again with Kendo UI to visualise sentiment analysis data gathered from Twitter, Facebook and various blog sources, our dashboard was built on top of a Sthenica designed data warehouse on SQL Server 2008R2. As with all our data visualisation projects, our in house graphic design expertise was used to ensure the end product integrated with the applications brand colours and feel.
Due North needed a performance review of the database for their upcoming cloud-based procurement application. Our work involved a complete review of the database schema, and profiling of the database to identify concern areas and identify LinQ queries with tuning opportunities.
We worked with East Surrey College providing interrim SSRS and SSIS reporting and ETL development services to their existing MIS department. Reporting requirements ranged from budget reports, to student enrolment notices and attendance reports (among others) generated from their EBS and Proachieve systems on Oracle 9i and SQL Server 2005.
We have worked with the charity Build it International on some design projects. Build it International is an international development charity working in areas of Africa where there is a chronic need for affordable housing, schools and clinics.