Additional information
| Province | Ontario |
|---|---|
| Colleges | Stanford International College of Business & Technology |
| Program Categories | IT |
| Program Duration | 52 Weeks |
| Class Type | Virtual |
| Funding | OSAP, Second Career, Line Of Credit |
Business Intelligence Developer/Analyst
Roll over image to zoom in
The program provides full coverage of Microsoft Business Intelligence Technology Stack and engineering fundamentals including SDLC, Project implementation Methodologies such as Waterfall,Incremental/Agile methodologies, and programmin
Schedule
Full-time
Category
Technology
Accreditation
Diploma
Articulations
Duration
52 Weeks
Hours
1040
Campuses Offered
Scarborough
416-383-1608
In today?s business world companies require information on which to base their business decisions.??The Business Intelligence Developer/Analyst provides this information by collecting data from multiple sources to develop reports used to?analyse?information. The program provides full coverage of Microsoft Business Intelligence?Technology Stack and engineering fundamentals including SDLC, Project implementation Methodologies such as Waterfall, Incremental/Agile methodologies, and programming languages, C#/Java with OOA/OOP design patterns and principles as well as an understanding of others database solutions including Oracle Database and related ETL tools.
Upon completion of the program the student will be able to develop Business Intelligence presentations such as reporting, business KPI, Dashboard and Visualization with Microsoft BI technical stacks; install and manage Microsoft SQL Server; implement Data Modelling for Databases; design and model??OLTP and OLAP Data Process Model; develop complex SQL Query and Stored Procedure based on Microsoft SQL Server; process non-structure data with Hadoop and HDFS technology; debug and troubleshoot system problems and issues and resolve issues and write technical proposals, technical requirements and solution designs.
Course Features
Schedule
0
Quizzes
0
Category
3 hours
Accreditation
All level
Articulations
English
Students
0
Assessments
Yes
Program Overview
Computer & Networking Fundamentals
Introduction to Linux
C# & .Net Fundamentals
Java Programming
Software Engineering Principles
Software Testing and Quality Assurance
SQL Server & Development
Business Intelligence Development with SQL Server
Big Data Foundation and Programming
Employment Search
Admission Requirements
An Ontario Secondary School Diploma or equivalent, or
Students are 18 years of age or older and pass the program entrance examination.
Please see Admissions for detailed information.
The Business Intelligence Developer is responsible for aggregating data from multiple sources in an efficient data warehouse and for designing enterprise-level solutions for very large multidimensional databases. *Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models.
*Employment opportunities may be found?in information technology consulting firms and in information technology units throughout the private and public sectors. Graduates of the program may apply for may apply for positions as a:
Possible Careers NOC: 2172
Database Administrator
Business Analyst
Business Intelligence Developer
Database Analyst
Business Report Developer
ETL Specialist
Database Report Developer
SQL Developer
Microsoft BI Architect
