Business Intelligence Developer/Analyst

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.

Subjects

    • 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

Career

  • Database Administrator
  • Business Analyst
  • Business Intelligence Developer
  • Database Analyst
  • Business Report  Developer
  • ETL Specialist
  • Database Report Developer
  • SQL Developer
  • Microsoft BI Architect