Services: Automation

By: Camdeboo Connections  06-Dec-2011
Keywords: Sql Server

Automation makes life easier for BI administrators. It's the "oil" that keeps the BI processes running smoothly week in and week out.

Using scripting, a "master" job controls everything from start to finish. This includes preparatory processing; the running of the SQL or tool-based ETL datamart processes (e.g. initiating SQL Server SSIS packages); handling of error situations and automatic retries.

Automation: refreshes multi-dimensional cubes; publishes and distributes data extracts and reports; consolidates log files; sends notifications or alerts to key users; does house-keeping of files and databases.

Do your staff prepare reports in Excel format ? You probably import data, do some copy/paste, change some reference values, check and fix broken formulae, and distribute ?

Did it start off being quick and easy ? But now the job has grown, become more valuable, complex and fragile?

Automation frees staff from boring error-prone work, reduces the risk of things breaking while they're away, and gets information out sooner. For a smaller company, smart automation can get functionality big companies get from high-tech BI solutions.

Keywords: Sql Server

Contact Camdeboo Connections


Print this page

Other products and services from Camdeboo Connections


Camdeboo: Services

Automate to streamline and schedule after-hours publishing or distribution of report sets, or to remove the administrative load of processing and distributing cubes. It requires a thorough understanding of performance measurement, best-practice design methodology, business analysis, software tools, database and scripting.


Services: BI and Data warehousing

Where the operational data can be extracted without effort into a cube-friendly format, smart BI modelling tools will enable full cube building and report publishing without the need for any extra data transformation. Camdeboo consultants will build for you anything from a rapid prototype or a proof-of-concept BI system, to a fully-fledged system addressing the needs of senior management, analysts and information "consumers".


Services: Workshops

Because we focus on your business and your data, students instantly relate to the instructor's demonstrations and to the many practical exercises they're expected to complete. Suited to both new users and already-trained users needing a refresher, this workshop is ideal for analysts, frequent report authors, power users and frequent cube browsers.