Business Intelligence / Data Analyst
Job Ready Programme
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.
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 QueriesSQL Data Structures / Operations & Functions. |
Advanced T-SQL, Stored Procedures, FunctionLearn T-SQL, Stored Procedures, Built-in and user-defined function |
Reporting ServicesReports Requirement, Report Design, and Reporting Server Setup. Work on Report using Report Builder. |
MS Business IntelligenceData Warehouse Concept, Facts, and Dimension Design, MS Integration Services, MS Analysis Services. |
Power BIOverview 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.

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




