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.

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.

Project+: This CompTIA training course helps you to prepare for CompTIA Project+ exam. The project management course introduces the project fundamental knowledge areas such as 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.

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 course helps individuals who are beginners to learn fundamentals of programming and build an understanding of topics like Core Programming, Object-Oriented Programming, General Software Development, Web Applications, Desktop Applications, and Databases.

Database Fundamentals: This instructor-led course not only gives an understanding of the topics like Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database etc., but also provides a baseline for an individual to be eligible for Exam DP-900: Microsoft Azure Data Fundamentals. Students can also choose to get Microsoft Certified in Azure Data Fundamentals after the completion of the course.

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.

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 provides a hands-on practical experience working with dashboards, models, and reports. Students have an opportunity to apply their new skills and knowledge to real world data.

Querying Data with Transact-SQL: This instructor-led course is designed to introduce students to Transact-SQL and introduce concepts appearing in Exam DP-300: Administering Microsoft Azure SQL Solutions. This information is valuable for students planning to get certification in Microsoft Azure Database Administrator Associate. The course gives 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. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

Developing SQL Databases: This instructor-led 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. It will also provide a baseline to individuals who are looking forward to appearing for Exam DP-300: Administering Microsoft Azure SQL Solutions or seek certification in Microsoft Azure Database Administrator Associate.

Administering a SQL Database Infrastructure: 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. Additionally, it will provide a baseline to individuals who wish to appear for Exam DP-300: Administering Microsoft Azure SQL Solutions or are planning to get certification in Microsoft Azure Database Administrator Associate.

Provisioning SQL Databases: This course provides knowledge to individuals who wish to administer and maintain SQL Server databases. This training is important for those who perform database administration and maintenance as their key area of responsibility, or work in environments where databases play a major role. This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. On completion, students can appear for Exam DP-300: Administering Microsoft Azure SQL Solutions or seek certification in Microsoft Azure Database Administrator Associate.

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. The primary audience for this course is database professionals who need to fulfill a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Additionally, it provides a baseline to appear for Exam DP-300: Administering Microsoft Azure SQL Solutions or for students planning certification in Microsoft Azure Database Administrator Associate.

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: This course gives students the ability to analyze and present data by using Azure Machine Learning and introduces the use of machine learning with big data tools such as HDInsight and R Service. Students gain knowledge and experience to appear for Exam DP-100: Designing and Implementing a Data Science Solution on Azure or for students planning certification in Microsoft Azure Data Scientist Associate.

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. The candidates enrolling for this course can improve on their skills and can pursue certification in Microsoft Power BI Data Analyst Associate. The course leads to Exam PL-300: Microsoft Power BI Data Analyst.

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.