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.
Qualification: Diploma
Duration: 50 Weeks
Delivery: Blended
Video: 12 Hours
Practicum: No
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 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.
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.
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.
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.
Education
Post-Secondary Degree or Undergraduate Degree:
English Proficiency
International English Language Testing System IELTS score of 5
Interview: Program applicants require an interview.
Others
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.
● Interview techniques
● Communication skills
● Conflict resolution
● Assertiveness at work
● Time Management
● Presentation Skills
● Effective report writing
● Improving personal success
HOURS: 20
● Table joins, queries
● Data types
● SQL best practice
● Functions and procedures
● DDL, DML, DCL
● Statements, schema, syntax
● Normalization
HOURS: 20
● 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
● Introduction to Business Analysis
● Modelling techniques
● Requirements engineering
● Investigation techniques
● Business case development
● Risk management
● Stakeholder management
● Financial Industry Awareness
HOURS: 80
● 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
● Introduction to financial services
● Financial assets and markets
● Equities
● Bonds
● Derivatives
● Investment funds
● Other financial retail products
● Trade lifecycle
● Risk
HOURS: 20
