Business Analyses for Business Intelligence

PROGRAM OVERVIEW

This program will use the Relational Database Management System and SAP BI toolset to give you the skills you need to develop, administer and analyze corporate data. You will learn industry-standard data management best practices and techniques.

Business analysis involves understanding market trends and helping decision-makers find ways to realize strategic operational and tactical goals as they relate to culture, capital, costs, customers, compliance, competition, and competence.

PROGRAM DESCRIPTION

Qualification: Certificate
Duration: 12 Weeks
Delivery: Blended
Video: 12 Hours
Practicum: No

CAREER PATHS

BUSINESS INTELLIGENCE DEVELOPER

Business intelligence developers are responsible for devising solutions to business problems, drawing on the data at hand so that it can be presented to executives in order to make informed decisions.

BUSINESS INTELLIGENCE ANALYST

Business intelligence analysts determine how best to understand the business data available, introducing new strategies for analyzing data and explaining unexpected outcomes in the data. These professionals are also responsible for collaborating with IT professionals to create software for working with big data.

DATA SPECIALIST

A certified data specialist works in conjunction with marketing and sales professionals to create a clear vision of the market landscape. Analyzing data, a data specialist must be able to organize and analyze large data sets efficiently in order to present conclusions about the business.

DATA VISUALIZATION ANALYST

The data visualization analysts are a part statistician and part storyteller. Converting data sets into narratives and transforming numbers into images, these professionals create clarity for executive decision-makers with regard to the information at hand.

BUSINESS STRATEGIST

Setting goals for their employers, business strategists also keep their organizations on pace toward those goals. They design and implement methods and systems that enable the organization to grow, creating plans that their organizations can follow to meet short-term goals that then lead to longer-term ones.

ADMISSIONS REQUIREMENTS

Education
Post-Secondary Degree or Undergraduate Degree:

  • Verified By Transcript
  • Preferably in Business, Information Technology

English Proficiency
International English Language Testing System IELTS score of 5

  • Canadian Language Benchmark C.L.B. level 5
  • Listening 5
  • Speaking 5
  • Reading 5
  • Writing 5

Interview: Program applicants require an interview.

Others

  • Technical Aptitude Toward
  • Business Applications
  • Computer Programming Experience
  • Relational Databases Experience
  • Operating Systems Skills (Windows)

If you do not meet the admissions requirements and are interested in our program, please do not hesitate to get in touch with us anyway as we understand every situation is different and we will find ways to accommodate you.

PROGRAM CURRICULUM

PROFESSIONALS SKILLS

● Interview techniques
● Communication skills
● Conflict resolution
● Assertiveness at work
● Time Management
● Presentation Skills
● Effective report writing
● Improving personal success

HOURS: 20

SQL/RDBMS

● Table joins, queries
● Data types
● SQL best practice
● Functions and procedures
● DDL, DML, DCL
● Statements, schema, syntax
● Normalization

HOURS: 20

EXCEL VBA

● Excel – Basics
● Arithmetic, Text and Date functions
● Lookup functions
● WHATIF analysis
● Pivot tables and pivot charts
● Conditional formatting
● Array functions
● Aggregation functions
● VBA Excel object model
● VBA subroutines and functions

HOURS: 20

BUSINESS ANALYSIS

● Introduction to Business Analysis
● Modelling techniques
● Requirements engineering
● Investigation techniques
● Business case development
● Risk management
● Stakeholder management
● Financial Industry Awareness

HOURS: 80

BUSINESS INTELLIGENCE

● Data normalization & dimensional data modelling ● Extract, transform, load (ETL)
● Requirements engineering
● User experience design
● Waterfall
● Iterative
● Agile
● SAP Introduction
● SAP Business Intelligence
● Tableau

HOURS: 80

IT FINANCE

● Introduction to financial services
● Financial assets and markets
● Equities
● Bonds
● Derivatives
● Investment funds
● Other financial retail products
● Trade lifecycle
● Risk

HOURS: 20

Enroll Now



I understand that by submitting this form, I consent to be contacted by email, phone, text message or any other form of communication by ERP College. My consent can be withdrawn at any time.

Follow us on

Student Resources

X