Your Role
As a Business Intelligence Analyst you will be charged with administering, developing and supporting enterprise transaction (OLTP) databases, the enterprise data warehouse and surrounding application. You will develop, maintain and ensure smooth delivery of operational and management reports. 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 £35,000
What You Will 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 Data Marts using Dimension Modeling methodology
- Build and maintain enterprise data warehouse and routine ETL business processes with SSIS
- Design and build hierarchical data models as well as dynamic reports and dashboards with SSRS
Course Modules
| 1. SQL Querying + 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 Reporting Services (SSRS) | 3 days | £795 |
| 5. BI Solution Design & Administration | 2 days | Free |
| Total | £2,880 | |
| Total (+VAT) | £3,456 |
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
4 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 amount due.