As our world becomes increasingly digital and more interconnected—from e-commerce, to electronic health records, to social media—businesses of any size are presented with a huge opportunity to leverage big data for enhanced insight into customers, operations, finances, and more. Still, according to a recent study conducted by Oracle, 93% of executives believe their organization is losing revenue as a result of not being able to fully leverage the data they collect.
To help professionals learn on-the-job skills needed to advance and help propel their businesses forward, New Horizons offers training solutions that can help meet the big data demands of your business. Below are our recommended training courses for job roles surrounding Analytics and Data Management.
Business Intelligence Developer (BI Developer)
The Business Intelligence Developer (BI Developer) is responsible for aggregating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for very large multidimensional databases. Additional responsibilities include: designing and planning BI solutions; debugging, monitoring, and troubleshooting BI solutions; creating and deploying reports; writing relational and multidimensional database queries; and configuring, deploying, and maintaining database servers.
- 10990 Analyzing Data with SQL Server Reporting Services
This five-day course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. It also discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
- 20767 Implementing a SQL Data Warehouse
This five-day course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with SQL Server 2016 and Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
- 20768 Developing SQL Data Models
This three-day course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
- 55123 Writing Reports with Report Builder and SSRS Level 1
In this two-day course, students will continue their learning on the foundations of report writing with SQL Server Report Builder and SSRS.
- 55128 Writing Reports with Report Builder and SSRS Level 2
In this two-day course, students will continue their learning on the foundations of report writing with SQL Server Report Builder and SSRS.
Data Analyst
A Data Analyst collects and stores data on sales numbers, market research, logistics, linguistics, or other behaviors. They bring technical expertise to ensure the quality and accuracy of that data, then process, design, and present it in ways to help organizations make better business decisions.
- 20778 Analyzing Data with Power BI
This three-course gives students a good understanding of data analysis with Power BI. The course also includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
- 20779 Analyzing Data with Excel
This three-day course gives 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.
Data Scientist
Data Scientists typically have a bachelor's degree in statistics, math, computer science, or economics and utilize their analytical, statistical, and programming skills to collect, analyze, and interpret large data sets to develop data-driven solutions. Data scientists have a wide range of technical competencies, including: statistics, coding languages, databases, machine learning, and reporting technologies.
- 20761 Querying Data with Transact SQL
This five-day course will 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.
- 20774 Perform Cloud Data Science with Azure Machine Learning
This five-day course will 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 Services.
- Python With Data Science
This two-day course covers theoretical and technical aspects of using Python in Applied Data Science projects and Data Logistics use cases.
Focus on R Programming
- Introduction to R Programming
This two-day course will help students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice.
- 20773 Analyzing Big Data with Microsoft R
The main purpose of this three-day 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. This course will also help prepare students for one of the exams required to earn the Microsoft Certified Solutions Associate (MCSA): Machine Learning certification.
Database Administrator (DBA)
A Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both back-end data structure and front-end accessibility for end-users.
- 20761 Querying Data with Transact SQL
This five-day course will 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.
- 20764 Administering a SQL Database Infrastructure
This five-day 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.
Database Developer
Database Developers are responsible for data gathering before development of a database. They design, develop, test, implement and maintain new and existing databases. Database developers create management methods and systems to access efficiently to information stored in databases.
- 20761 Querying Data with Transact SQL
This five-day course will 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.
- 20762 Developing SQL Databases
This five-day course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
Looking for Additional Courses? View All Related Learning Solutions
Note: The courses listed above are our recommendations for some of the most common roles within Analytics and Data Management; however, your organization may have slightly different titles and/or responsibilities. Please speak with one of our expert Account Representatives to discuss the specific learning requirements for you and your business.