Enable Technology offers a specialist Business Intelligence and Data Analysis training consultancy service. We support organisations integrate and use the following technologies.
- Microsoft SQL Server
- SQL (Structured Query Language)
- Excel and PivotTables
- VBA (Visual Basic for Applications)
- SSAS (SQL Server Analysis Services)
- SSRS (SQL Server Reporting Services)
- SSIS (SQL Server Integration Services)
- SAP Crystal Reports
- Transact SQL - PL/SQL
- ASP.NET Web Services
Enable Technology helps organisations analyse large data sets by providing bespoke onsite training and support on each of the following processes.
- ETL (Extraction, Transformation and Loading) of flat data files into relational databases or OLAP (Online Analysis Cubes).
- Designing and building normalized databases using the Microsoft SQL Server, Oracle and MySQL database platforms.
- Querying relational data sources using SQL ( Structured Query Language). Summarizing, grouping and aggregating data.
- Building Views, Stored Procedures and User Defined Functions using Transact SQL and PL/SQL.
- Producing dynamic parametised reports using SQL Server Reporting Services (SSRS) and the SAP Crystal Reports suite.
- Deploying the resultant Crystal Reports and Reporting Services reports to secure intranet locations.
- Designing and building OLAP cubes using SSAS (Microsoft SQL Server Analysis Services).
- Data mining large data sets using Microsoft Data Mining algorithms and DMX (Data Mining Extensions) queries.
- Analyzing data in Excel using VBA Macros. Configuring Excel as a client tool for relational database queries and data mining techniques.
If you would like further information about any of the above services, please fee free
to contact us either
by email or telephone Enable Technology on
(01902) 837406.
|
