Business Intelligence Developer/Analyst
|
|
New: Online delivery of this program is now available.
*Approved as a vocational program under the Ontario Career Colleges Act, 2005
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 a Superintendent approved qualifying test
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
|
