Data Analytics and Business Intelligence

KNOWLEDGE & SKILLS GAINED

PROGRAM OUTLINE

Student Success Strategy: Introduces to techniques, skills and concepts to achieve personal, academic and professional success.

English I: Introduces to college level English reading and writing skills to develop grammar, vocabulary and paragraph development.

Microsoft Word, Excel, PowerPoint: Introduces to the skills, training and assessment of computing concepts and techniques to gain proficiency in word processing, spread sheet functions and impact of computing on the present day society.

Business Values and Ethics: Introduces the categories and framework of philosophical ethics in selected professions and the role of the government and issues of corporate governance.

Business Communication: Introduces to the fundamental principles of effective business communication in global environment, stressing on the skills necessary for developing, planning, organizing, outlining and editing various business documents.   

Microsoft Excel: Introduces to improve the competency in customizing the Excel interface.

Microsoft Access: Introduces to skills in designing applications, using tools and controls.

Microsoft Outlook: Introduces to the basic and intermediate features of Outlook to manage messages for efficient communication and to organize appointments and duties.

PMP Fundamentals: Applies the nine project management knowledge areas – project integration, scope, time, cost, quality, human resources, communications, risk and procurement management, across the project management lifecycle of initiation, planning, executing, controlling and closing.

Organizational Change Management: Looks at logical reasons why organizations must change, and why people and companies are resistant to change. Prepares students to institute change and develops skills needed to communicate change for a smoother transition.  Provides tools necessary to effectively manage change in a dynamic technology environment.

Cross Culture Management: Examines the challenges and opportunities of managing cultural diversity in organizations with emphasis on the transnational enterprise. Introduces phenomena of globalization, culture and organizational culture, and cultural synergy. Teaches strategies for hedging cultural; gaps.

Leadership: Looks at dynamics of leadership, initiation and management in the face of changing environment serving the organization. Looks at nature and characteristics of transactional leadership; relationships of power, authority and responsibility to leadership effectiveness including conflict management.

Introduction to Programming: This instructor-led course is intended for students who want to learn how to write Python code that logically solves a given problem.  Students will learn how to write, debug, maintain and document Python code. Students also learn how programming relates to Data Analytics and BI.

Software Development Fundamentals: This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core Programming, Object-Oriented Programming, General Software Development, Web Applications, Desktop Applications, and Databases.

Database Fundamentals: This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.   The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies.

Implementing Data Models and Reports: The focus of this course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

Business Intelligence Solutions: This course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.  This course is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

Cloud Data Platform Solutions: This course is intended for data professionals who want to design and implement database solutions in SQL Server and on Microsoft Azure.  Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting options will also be demonstrated.

Big Data Analytics Solutions: This course teaches how to design big data batch processing and interactive solutions, as well as how to design big data real-time processing solutions.  Students also learn to operationalize end-to-end cloud analytics solutions.  

Querying Data with Transact-SQL: This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Developing SQL Databases: This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database. 

Administering a SQL Database Infrastructure: This instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. This course is valuable for individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Provisioning SQL Databases: This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Implementing a SQL Data Warehouse: This course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.   

Developing SQL Data Models: The focus of this instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.

Analyzing Big Data with Microsoft R: The main purpose of the course is to give students the ability to use Microsoft R Server to create and run an analysis on a large dataset, and show how to utilize it in Big Data environments, such as a Hadoop or Spark cluster, or a SQL Server database.

Cloud Data Science with Azure Machine Learning: The main purpose of the course is to give students the ability to analyze and present data by using Azure Machine Learning, and to provide an introduction to the use of machine learning with big data tools such as HDInsight and R Service.

Microsoft Azure HDInsight: The main purpose of the course is to give students the ability plan and implement big data workflows on HDInsight.  The primary audience for this course is data engineers, data architects, data scientists, and data developers who plan to implement big data engineering workflows on HDInsight.

Analyzing Data with Power BI: The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Analyzing Data with Excel: The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Capstone Project for BI: This capstone project provides a hands-on learning experience for students to work independently on a specialized topic from data analytics and business intelligence. This is to prepare the student to articulate their relevant know-how and skills with the help of a business presentation.  The student will write a written report on the project and will also make an oral presentation, including answering questions from the audience.

Professional Skills: Prepares students with every aspect of their transition into their new career by identifying and teaching essential business and interpersonal skills.  Students receive in class lectures, as well as a private one-on-one appointment with a Career Services specialist to perfect their resume package and interviewing skills.

WHY THIS PROGRAM?

This is a growing and exciting field! Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models. Information systems analysts and consultants analyze systems requirements, develop and implement information systems development plans, policies and procedures, and provide advice on a wide range of information systems issues.

ASSOCIATED NATIONAL OCCUPATION CLASSIFICATION (NOC) CODES

Database analysts are employed in information technology consulting firms and in information technology units throughout the private and public sectors. Information systems analysts are employed in information technology consulting firms and in information technology units throughout the private and public sectors, or they may be self-employed.

After achieving a diploma in Data Analytics and Business Intelligence, you are eligible for positions falling under the following NOC Codes

Database Analysts and Data Administrators  -  2172

Information Systems Analysts and Consultants  -  2171

Common Job Titles which you can apply for include – data administrator, data custodian, data dictionary administrator, data warehouse analyst, database administrator (DBA), database analyst, database architect, technical architect – database, computer systems analyst, informatics consultant, informatics security analyst, information systems business analyst, information systems quality assurance analyst, IT (information technology) consultant, management information systems (MIS) analyst, systems auditor, systems consultant, and systems security analyst.

JOB FUNCTIONS

People working in Data Analytics and Business Intelligence perform some or all of the following duties:

• Collect and document user requirements.
• Design and develop database architecture for information systems projects.
• Design, construct, modify, integrate, implement and test data models and database management systems.
• Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools.
• Operate database management systems to analyze data and perform data mining analysis.
• May lead, co-ordinate or supervise other workers in this group.
• Develop and implement data administration policy, standards and models.
• Research and document data requirements, data collection and administration policy, data access rules and security.
• Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data.
• Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data.
• Write scripts related to stored procedures and triggers.
• May lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.
• Information systems business analysts and consultants confer with clients to identify and document requirements, conduct business and technical studies, design, develop, integrate and implement information systems business solutions, and provide advice on information systems strategy, policy, management, security and service delivery.
• Systems security analysts confer with clients to identify and document requirements, assess physical and technical security risks to data, software and hardware, and develop policies, procedures and contingency plans to minimize the effects of security breaches.
• Information systems quality assurance analysts develop and implement policies and procedures throughout the software development life cycle to maximize the efficiency, effectiveness and overall quality of software products and information systems.
• Systems auditors conduct independent third-party reviews to assess quality assurance practices, software products and information systems.

JOB REQUIREMENTS

Employers are generally looking for candidates that have a Diploma or Degree, excellent interpersonal and communication skills, as well as being technically proficient in Microsoft products. Some computer programming experience is usually required.

EMPLOYMENT AREAS & PROSPECTS

Completing the Diploma in Data Analytics and Business Intelligence exposes students to various fields for hire, predominately for information systems, data management, business intelligence, and data analysis in various IT industries. The technology sector in Canada is growing at an expansive rate which is allowing for new opportunities to arise this field.

The IT industry is projected to grow and create new jobs as the number of companies expanding their IT departments, are growing.