Your Role
As a Business Intelligence Reporting Analyst you will develop and maintain enterprise reporting solutions for a wide range of business needs. You will be responsible for delivering strategic, operationally focused performance reporting, KPIs, and dashboard solutions for a variety of business processes. You will use your understanding of SQL query writing to make data selection and build data models using third party tools, you will also investigate, troubleshoot and fix data errors.
Salary Expectation - from £30,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
- Provide quick and informative data analysis and reports using Excel 2013
- Build data models and deliver KPIs and metrics reports for specific business functions using PowerPivot and Pivot Charts
- Design and build hierarchical data models as well as dynamic reports and dashboards with SSRS
- Deploying and Configuring reports on SharePoint
- Create storyboards and scorecards
Course Modules
| 1. SQL Querying + Database Fundamentals | 3 days | £695 |
| 2. Excel Reporting + PowerPivot Data Modeling | 3 days | £695 |
| 3. SQL Server Reporting Services (SSRS) + SharePoint | 3 days | £795 |
| 4. Enterprise Reports Administration + Automation | 2 days | Free |
| Total | £2,185 | |
| Total (+VAT) | £2,622 |
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
3 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.