Analytics, Big Data and Business Intelligence

Program Overview

LEA.DT: Analytics, Big Data and Business Intelligence

About this Program

The rapid technological advances of recent years require new expertise and skills. To be able to establish themselves in a competitive ecosystem, companies can now base their business strategies on big data and technologies derived from artificial intelligence research (Blockchain, Complex Systems, Scale Automation, etc.). Upon completion of their training, students will be able to set up networked and automated databases, operate data warehouses, perform fine analyses and produce detailed reports. Trebas Institute Quebec Inc.’s LEA.DT: Analytics, Big Data and Business Intelligence program will give you the tools and knowledge you need to help create value for the company you work with. Become highly proficient in analytics, business intelligence (BI) and big data. Study using industry-standard software programs and online platforms, within a curriculum that is constantly updated to give you an edge in the job market.

Program Details

• Location: Montreal
• Intakes: January and September
• Duration: 24 Months (91 Weeks) Number of weeks does not include breaks and holidays.
• Delivery: Full-time – Hybrid (in class, online)
• Language: French and English
• Class Time: Daytime
• Credential: Diploma
• Tuition Fees: For our competitive tuition amount after scholarship, please visit our "Scholarships & Grants" page.

Key Facts

• Program in French - January / September
• Program in English - January / September
• ACS (Attestation of College Studies)

Program Overview

Term 1

In this term, you will complete workplace research, tasks and responsibilities related to the role of a database analyst. You will learn how to analyze and solve simple problems using basic algorithms, determine error correction strategies, and use debugging tools. You will also learn how to use mathematics applied to solving computer problems. To do this, you will learn to recognize and process the representations of numbers, to represent geometric figures in two dimensions through equations, to model logical reasoning, and to process quantitative data. You will also learn how to analyze data models, data management system specifications, and formulate specific queries. Finally, you will learn how to prepare and organize computers, peripherals, and components for different operating systems to ensure their efficiency in performing the tasks required for analysis and database management.

• Introduction to the Computer Work Function – 45 hours
• Programming and Problem-Solving Languages – 75 hours
• Mathematics Applied to Computer Science – 60 hours
• Introduction to Database Operation – 75 hours
• Software and Hardware Environment – 60 hours

Term 2

In this term, you will learn to use spreadsheets and office tools to produce reports and represent data in tables and graphs. You will also learn how to program and use databases to their full potential, as well as learn how to analyze, model, and produce algorithms to program instructions and responses to solve a problem. Finally, you will learn how to prepare automation tools that allow information to be synchronized from one source to another.

• Reporting: Tables and Graphs – 75 hours
• Data Warehouses – 75 hours
• Object-Oriented Programming – 105 hours
• Middleware Technology: Extracto-Loaders – 90 hours

Term 3

During this term, you will learn to interpret data in order to formulate prognostics and hypotheses related to future trends and the effects of behaviors and events. You will also learn how to analyze baseline data (products, customers, accountants, etc.) to produce reports to prevent and predict change for the company. You will also learn how to carry out information security prevention activities such as risk analysis and the application of recognized measures (access rights strategies, safeguarding, use of cryptography utilities, authentications, etc.). Finally, you will learn how to write, test, and execute automation scripts for different operating systems for recurring network management tasks.

• Predictive Modeling Process for Big Data – 75 hours
• Non-Transactional Master Data Analysis – 90 hours
• Cybersecurity and Blockchain – 105 hours
• Automation and artificial intelligence – 60 hours

Term 4

In this term you will learn how to produce charts, graphs, and diagrams to visualize data collected using specialized tools and office suites, and facilitate business decision-making. You will also learn how to plan the logic of data exchanges between apps, browsers or connected objects, how to use databases, how to program a test application, how to provide quality control, how to deploy the solution or service while keeping a clear and useful log or tracking documentation. Finally, you will learn the attitudes and skills needed to facilitate your integration into the IT job market, how to introduce yourself, and how to develop your own network.

• Charts, Maps and Dashboards – 75 hours
• Computerized Data Exchange – 75 hours
• Predictive Analytics and Business Intelligence – 105 hours
• Computer Job Integration – 60 hours

Term 5

In this final term, you will learn how to establish professional relationships with clients and users through your attitudes and behaviors, work with and integrate into an interdisciplinary team, and understand your ethical and legal responsibilities as a professional analyst. You will have the opportunity, through a 330-hour internship, to apply the learning you acquired during your program.

• Internship in Analytics, Mega Data and Business Intelligence – 330 hours

Skills and Competencies

Throughout this program, you will develop some of the following skills and competencies:

• Process information related to work environment in the computer field.
• Install and manage computers.
• Use programming languages.
• Solve IT problems with mathematics.
• Use Office software.
• Use the principles of programming orientation.
• Operate a database management system.
• Security prevention operations on information security.
• Interact in a professional context.
• Evaluate software and hardware components.
• Automate computer network management tasks.
• Develop data exchange services.

Career Outlook

Our graduates will be able to pursue successful careers in the following roles:

• Database administrator
• Data dictionary administrator
• Data administrator
• Database analyst
• Data analyst / computer and systems
• Data repository analyst
• Data mining analyst
• Information resources analyst
• Electronic data processing system analyst
• Electronic data processing analyst
• Database designer
• Data explorer
• Database manager – computer systems
• Data manager
• Computer specialist
• Database management supervisor / computer systems