Business Intelligence / Data Analyst
Job Ready Programme

Programme set by Software Development Companies

The Business Intelligence / Data Analyst Job Ready Programme provides real-world insights into working in the IT industry. You will experience what itโ€™s really like to work in the industry. You will learn key industry terms and communication techniques while building valuable personal industry connections.

We are here to assist with guidance in your personal job hunt, including assistance with CV preparation and interview techniques. Upon successful completion of the programme and internship you receive a reference letter to endorse your commercial project development experience while with us.

Flowchart

What You Will Learn & How It Works

Practical Skills Commercial Experience Build Connections Receive Reference
Help participants in a small group to gain software development knowledge used in the commercial world. The best way to learn is by doing it for real and you will experience so much more in real world project. You will sit down with IT CEO, Director, Manager, Testers, Senior Developers, and Career Direction. We will give you a reference for the commercial project you are working which is drawn from your internship tracking data.


This course is designed for:

> People wanting to change career to IT.
> Graduate job seeker looking for their first job opportunity in Data Analysis.

> Final-year student, international student or recent graduate from university.
> IT professional who wants to make the switch to BI/Data Analytics.
> An immigrant who previously worked in software development.

  • NO teachers! But developers. We run sessions by software developers from work space.
  • NO books and theories! We focus on in-demand skills currently used in the commercial world.
  • NO assignments or marks! We focus on research and resolving commercial problems.

BI Overview, SQL Queries

SQL Data Structures / Operations & Functions.

Advanced T-SQL, Stored Procedures, Function

Learn T-SQL, Stored Procedures, Built-in and user-defined function

Reporting Services

Reports Requirement, Report Design, and Reporting Server Setup.ย 

Work on Report using Report Builder.

MS Business Intelligence

Data Warehouse Concept, Facts, and Dimension Design, MS Integration Services, MS Analysis Services.

Power BI

Overview of Power BI in the commercial world, different services of Power BI, visualize data using Power BI.

Internship with MVP Studio

Programme participants will work within MVP Studio, a global software company for their internship where they will work on a commercial scale project/s to enhance their practical, business-oriented development skills.

The projects are chosen to specifically match the skills that employers are currently looking for. Participants will be mentored throughout the project. Projects typically involve a selection of the following technology:

  • MS SQL Server
  • MS Power BI
  • Report Builder

Description Duration Details

Step 1:ย  Job Ready Programme

2 sessions + 1 tutorial per week
2 hours per session in the evenings online via Zoom.ย  Each session is recorded so that participants can review the session (available for 3 months).

Step 2:ย  Internship with MVP Studio (3+ months)

Working on a Commercial Scale Project(s)
Guided by Senior developers, PM, BA or QA

*Prerequisite: Option 1.ย  Using the skills learnt, participants get involved in commercial scale projects. They are guided by senior developers or testers from commercial development teams. Past projects have utilised the latest and coolest technologies which are in-demand within the market.

Request Our Info Pack

SQL Server Business Intelligence

  • SQL Server Integration Services – SSIS
  • SQL Server Reporting Services – SSRS
  • SQL Server Analysis Services – SSAS
  • BI jobs are in demand.

T-SQL Querying, Programming and Tuning

  • SQL Queries.
  • SQL Data Structures.
  • SQL Operations and Functions.
  • Design Patterns and Optimization.

Why Power BI

  • Excel is Primary Tool for Self-Service BI.
  • Cloud-Based Self-Service BI.
  • Mobile Support.
  • Great tool for data visualisation.

Report Builder

  • Build reports for relational database & data cube.
  • Build tabular, Matrix reports.
  • Grouping and Expression.
  • SSRS reporting developer is in high demand.

50+ Stories of BI / Data Analyst Career Starters