Business Intelligence and Data Analytics      Call Us | 01628 54 00 56

Business Intelligence Developer

Your Role
As a Business Intelligence Developer will be responsible for converting business requirements into actionable statements of work, developing solutions to extract data from a variety of sources, creating logical and physical data stores and implementing data cleansing activities in ETL, and to help to define business rules to support data quality. You will also be responsible for building and maintaining data platforms. You will use your knowledge of databases and ETL processes to facilitate data integration both within the business and from external sources. You will apply analytical problem solving approach to investigate, troubleshoot and fix data/program errors.

Salary Expectation - from £40,000

What You Learn

  • Understand relational database structure and objects, e.g. Tables, Indexes, Constraints, Triggers, Views, etc.
  • Learn to query databases and manipulate data using the SQL language
  • Write procedural codes such as Stored Procedures, User-defined Functions and Triggers using T-SQL
  • Design and build business specific Data Marts using Dimension Modeling methodology
  • Build and maintain enterprise data warehouse and routine ETL business processes with SSIS
  • Design and build hierarchical multi-dimensional OLAP data models using SSAS
  • Design and build hierarchical data models as well as dynamic reports and dashboards with SSRS

Course Modules

1. SQL + Database Fundamentals  3 days £695
2. T-SQL Programming  2 days £595
3. SQL Server Integration Services (SSIS) + Dimension Modeling  3 days £795
4. SQL Server Analysis Services (SSAS Multidimensional) + MDX  3 days £795
5. SQL Server Reporting Services (SSRS)  3 days £795
6. BI Solution Design & Administration  2 days     Free
   Total £3,675
   Total (+VAT)   £4,410

 

Training
Each module run for, typically, 3 consecutive days, all day 9am - 5:30pm (Monday - Saturday).
All learning materials such as notebooks, text books and learning software will be provided.

Duration
5 months, taking one module a month.

Prerequisite
Higher education qualification in most sciences, maths, engineering, computing, accounting, economics, or related subjects.

Payment
We offer flexible payment by installments typically over 3 - 6 months depending on course duration and total amount due.