X
GO

Data Science Training from New Horizons

Data science is a method for gathering insights from structured and unstructured data using approaches, ranging from statistical analysis to machine learning. For most organizations, data science is used to transform data into value that come in the form increased revenue, reduced costs, product development, trend analysis, and more.

Data science techniques include data mining, big data analysis, data extraction and data retrieval. Additionally, data science concepts and processes are derived from data engineering, statistics, programming, social engineering, data warehousing, machine learning and natural language processing.

The Increasing Demand for Data Scientists

Successful Data Scientists are able to identify relevant questions, collect data from a variety of data sources, organize the information, translate results into solutions, and effectively communicate their findings. These skills are required in almost all industries, causing skilled data scientists to be increasingly valuable to companies.

In recent times, Data Scientists are present in almost all organizations. These professionals are well-rounded, data-driven individuals with high-level technical skills who are capable of building complex quantitative algorithms to organize and synthesize large amounts of information used to answer questions and drive strategy in their organization.

Every organization will likely have a different take on job tasks. Some treat their Data Scientists as Data Analysts or combine their duties with Data Engineers; others need top-level analytics experts skilled in intense machine learning and data visualizations.


Available Data Science Courses from New Horizons

  • 10988 Managing SQL Business Intelligence Operations
    This three-day course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

  • 20466 Implementing Data Models and Reports with SQL Server
    This five-day course focuses 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.

  • 20778 Analyzing Data with Power BI
    This three-day course will 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.
  • 10994 Data Analysis Fundamentals using Excel
    The main purpose of this two-day course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

  • 20778 Analyzing Data with Power BI
    This three-day course will 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.

  • 20779 Analyzing Data with Excel
    The main purpose of this three-day 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.
  • 20778 Analyzing Data with Power BI
    This three-day course will 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.

  • 20779 Analyzing Data with Excel
    The main purpose of this three-day 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.

  • Tableau Advanced
    This two-day course enables participants to create complex visualizations and to combine them into interactive dashboards to share with others using Tableau Desktop 10.5.

  • Tableau Fundamentals
    This two-day course enables participants to navigate and use effectively the Tableau user interface to connect to various data sources to create simple visualizations to share with others.
  • 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.

  • 20774 Perform Cloud Data Science with Azure Machine Learning
    The main purpose of this five-day 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 Services.
  • Introduction to R Programming
    This two-day course helps 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.

  • 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.
  • 20461 Querying Microsoft SQL Server
    This five-day course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

  • 20761 Querying Data with Transact SQL
    The main purpose of this five-day course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines

  • SQL Querying Fundamentals
    In this one-day course, students will compose SQL queries to retrieve desired information from a database.

  • SQL Querying Advanced
    In this one day course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.

Associated Microsoft Certifications

Microsoft Certified Solutions Associate (MCSA): BI Reporting

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

Courses and Exams for the MCSA: BI Reporting:

Course:  20778 Analyzing Data with Power BI
Exam: 70-778: Analyzing and Visualizing Data with Power BI
 
Course: 20779 Analyzing Data with Excel
Exam: 70-779: Analyzing and Visualizing Data with Microsoft Excel

Microsoft Certified Solutions Associate (MCSA): Machine Learning

Earning an MCSA: Machine Learning demonstrates knowledge relevant to Machine Learning, Data Scientists and Data Analysts positions, particularly those who process and analyze large data sets using R and use Azure cloud services to build and deploy intelligent solutions. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

An MCSA: Machine Learning certification demonstrates the knowledge to use machine learning to process and analyze big data using Microsoft Azure, R Server, and SQL R. Typical job roles for certification holders include data scientist and business intelligence analyst. See required exams and associated courses below:

Course: 20773: Analyzing Big Data with Microsoft R
Exam: 70-773: Analyzing Big Data with Microsoft R
Course: 20774: Perform Cloud Data Science with Azure Machine Learning
Exam: 70-774: Perform Cloud Data Science with Azure Machine Learning

Microsoft Certified Solutions Expert (MCSE): Database Management & Analytics

Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data—both on-premises and in cloud environments. Earning an MCSE: Data Management and Analytics certification qualifies you for such positions as database analyst, database designer, and business intelligence analyst.


Once you obtain an associated Microsoft Certified Solutions Associate (MSCA), pass any ONE of the following elective exams to earn an MCSE: Database Management & Analytics:

  • 70-464: Developing Microsoft SQL Server Databases
  • 70-465: Designing Database Solutions for Microsoft SQL Server
  • 70-466: Implementing Data Models and Reports with Microsoft SQL Server
  • 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
  • 70-473: Designing and Implementing Cloud Data Platform Solutions
  • 70-475: Designing and Implementing Big Data Analytics Solutions
  • 70-762: Developing SQL Databases
  • 70-767: Implementing a Data Warehouse using SQL
  • 70-768: Developing SQL Data Models
  • 70-773: Analyzing Big Data with Microsoft R
  • 70-774: Perform Cloud Data Science with Azure Machine Learning
  • 70-775: Perform Data Engineering on Microsoft Azure HDInsight

Note that Microsoft will change the required elective exams every calendar year.

Questions About Training?