Cart
Login
Find Training
Microsoft Job Roles
Azure
Dynamics
M365
Power-Platform
Microsoft Office
Agile
Applications Infrastructure
Cloud
Data & Analytics
Programming
DevOps
ITIL
Professional Development
Security
Virtualization
CompTIA
PMI
Scrum
Cisco
VMWare
EC-Council
Adobe
Citrix
RedHat
AWS
Tableau
IBM
Microsoft Technical
Topics
Agile
Application & Infrastructure
Cloud
Data & Analytics
Design Multimedia
Programming
DevOps
ITIL/ IT Service Management
Leadership & Professional Development
Modern Workplace
Networking
Project Management
Security
Virtualization
Brands
Microsoft Technical
Microsoft Office
Microsoft Job Role
CompTIA
ITIL
PMI
Scrum
Cisco
VMWare
EC-Council
Adobe
Citrix
RedHat
Agile
AWS
Tableau
DevOps
IBM
Search All Brands
Resources
Learning Methods
Army Credentialing
Learn Now Live
Webinars
Blog
Contact
About Us
A Letter from Our Founder
Facebook Icon
Linkedin Icon
Search Button
Button
Search by Topic
Adobe
Acrobat
Captivate
Dreamweaver
Illustrator
InDesign
Photoshop
Service Management
Business Analysis
COBIT
ITIL
®
ITSM (IT Service Management)
Lean Six Sigma
QuickBooks
Tableau
Cisco
Cloud
Collaboration
Data Center
Enterprise
Security
Unified Contact Center
Wireless
Citrix
XenApp
XenDesktop
XenServer
NetScaler
CompTIA
A+
CASP+
Cloud+
Cloud Essentials+
CySA+
IT Fundamentals+
Linux+
Network+
PenTest+
Project+
Security+
Server+
Microsoft Technical
Azure
Dynamics & Power Apps
Exchange
Microsoft 365
Office 365
Power BI
PowerShell
SharePoint
Teams
SQL Server
System Center
Visual Studio
Windows 10
Windows Server
Office
Access
Excel
Office 365
OneNote
Outlook
PowerPoint
Project
SharePoint
Teams
Visio
Word
Power Apps
Professional
Workplace Fundamentals
Leadership & Professional Development
Brands
Amazon (AWS)
Checkpoint
Cloudera
DevOps
Crystal Reports
F5 Networks
Google
IBM
IT Management
Linux
Oracle
Red Hat
Salesforce
Tableau
VEEAM
Project Mgt
Agile
CAPM
®
Fundamentals
MS Project
PMP
®
PRINCE2
®
Project+
Risk Management
Scrum
Security
EC-Council
ISACA
(ISC)²
Internet of Things
NIST - NCSF
VMware
Horizon
NSX
vRealize
vSAN
vSphere
Search Courses
Search
Course Search Results for:
data analytics
Microsoft Excel
Data Analysis using Excel 2016 – Level 1
Report Builders will learn everything they need to create highly effective PivotTable and PivotChart reports using data sources that are created using Excel. Topics covered include an overview of the PowerPivot add-in, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, creating simple custom data calculations, effectively applying new visualization techniques using Power View, creating geospatial Power Map tours, using data transformations to prepare for data modeling, and creating simple custom data calculations. Students will also learn how to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query.
Course Details & Class Schedule
Microsoft Excel
Data Model Design using Excel 2016 - Level 2
This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers.
Course Details & Class Schedule
Crystal Reports
Crystal Reports 2016 - Part 1
In this course, students will create a basic report by connecting to a database and modifying the report's presentation.
Course Details & Class Schedule
Crystal Reports
Crystal Reports 2016 - Part 2
In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.
Course Details & Class Schedule
Microsoft SQL Server
10985 Introduction to SQL Databases
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
Course Details & Class Schedule
Microsoft SQL Server
10987 Performance Tuning and Optimizing SQL Databases
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Course Details & Class Schedule
Microsoft SQL Server
10990 Analyzing Data with SQL Server Reporting Services
This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
Course Details & Class Schedule
Microsoft SQL Server
10998 Updating Your Skills to SQL Server 2017
This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
Course Details & Class Schedule
Microsoft SQL Server
20461 Querying Microsoft SQL Server
This 5-day instructor led 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. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for 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.. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Course Details & Class Schedule
Microsoft SQL Server
20462 Administering Microsoft® SQL Server® Databases
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Course Details & Class Schedule
Microsoft SQL Server
20463 Implementing a Data Warehouse with Microsoft® SQL Server®
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Course Details & Class Schedule
Microsoft SQL Server
20466 Implementing Data Models and Reports with Microsoft SQL Server
The focus of this five-day instructor-led 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. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Course Details & Class Schedule
Microsoft SQL Server
20761 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. Days 4 & 5 teach the remaining skills required to take exam 70-761.
Course Details & Class Schedule
Microsoft SQL Server
20762 Developing SQL Databases
This five-day instructor-led 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.
Course Details & Class Schedule
Microsoft SQL Server
20764 Administering a SQL Database Infrastructure
This five-day 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.
Course Details & Class Schedule
Microsoft SQL Server
20765 Provisioning SQL Databases
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
Course Details & Class Schedule
Microsoft SQL Server
20767 Implementing a SQL Data Warehouse
This five-day instructor-led 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.
Course Details & Class Schedule
Microsoft SQL Server
20768 Developing SQL Data Models
This three-day instructor-led 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.
Course Details & Class Schedule
Microsoft SQL Server
55123 Writing Reports with Report Builder and SSRS Level 1
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.
Course Details & Class Schedule
Microsoft SQL Server
55128 Writing Reports with Report Builder and SSRS Level 2
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.
Course Details & Class Schedule
Microsoft Excel
10994 Data Analysis Fundamentals using Excel
The main purpose of the 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.
Course Details & Class Schedule
Microsoft Power BI
20778 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.
Course Details & Class Schedule
Microsoft Excel
20779 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.
Course Details & Class Schedule
Microsoft PowerShell
55069 PowerShell for SQL Server Administrators
This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks.
Course Details & Class Schedule
Microsoft Power BI
55232 Writing Analytical Queries for Business Intelligence
This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.
Course Details & Class Schedule
Microsoft Azure
DA-100T00: Analyzing Data with Power BI
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Course Details & Class Schedule
Database Design - A Modern Approach
This course introduces you to a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential, and prevents the extra work of fixing data maintenance problems later on. The concepts are not specific to a particular software application and can be applied to any relational database management system.
Course Details & Class Schedule
Microsoft Azure
DP-070T00 Migrate Open Source Data Workloads to Azure
This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
Course Details & Class Schedule
Microsoft Azure
DP-100T01 Designing and Implementing a Data Science Solution on Azure
Gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure's premier data science service, Azure Machine Learning service, to automate the data science pipeline. This course is focused on Azure and does not teach the student how to do data science. It is assumed students already know that.
Course Details & Class Schedule
Microsoft Azure
DP-200T01 Implementing an Azure Data Solution
In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data. The students will also explore how to implement data security including authentication, authorization, data policies and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, they will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing and streaming data solutions.
Course Details & Class Schedule
Microsoft Azure
DP-201T01 Designing an Azure Data Solution
In this course, students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, No-SQL or Data Warehouse data. Students will also learn how to design process architectures using a range of technologies for both streaming and batch data. Students will also explore how to design data security including data access, data policies and standards. They will also design Azure data solutions which includes the optimization, availability and disaster recovery of big data, batch processing and streaming data solutions.
Course Details & Class Schedule
Microsoft Azure
DP-300T00 Administering Relational Databases on Microsoft Azure
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Course Details & Class Schedule
Microsoft Azure
DP-900T00 Microsoft Azure Data Fundamentals
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
Course Details & Class Schedule
QuickBooks
Get Going with QuickBooks
This course is an introduction to QuickBooks. Students will be introduced to the basic features and functionality in QuickBooks and will learn how to use QuickBooks to effectively track and manage their company’s financial data and determine the health of the business. QuickBooks users will quickly learn the new features and functionality of QuickBooks 2015, 2016 or 2018.
Course Details & Class Schedule
QuickBooks
Keep Going with QuickBooks
From reporting to automating tasks, working with more advanced features and accounts, this course moves beyond the basics and enables students to work with more advanced features in QuickBooks.
Course Details & Class Schedule
Oracle
Oracle 12c Administration I
In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems.
Course Details & Class Schedule
Oracle
Oracle 12c SQL Fundamentals
This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
Course Details & Class Schedule
SQL
SQL Querying Fundamentals – Part 1
In this course, students will compose SQL queries to retrieve desired information from a database.
Course Details & Class Schedule
SQL
SQL Querying Fundamentals – Part 2
In this 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.
Course Details & Class Schedule
Tableau
Tableau Desktop - Part 1
The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. This course will introduce you to Tableau, which was built to connect to a wide range of data sources and allow users to quickly create visualizations of connected data to gain insights, show trends, and create reports. You will learn Tableau's data connection capabilities and visualization features which go far beyond those that can be found in spreadsheets, allowing you to create compelling and interactive worksheets, dashboards, and stories, that bring your data to life and allow you to take thoughtful action.
Course Details & Class Schedule
Tableau
Tableau Desktop - Part 2
The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau® software is designed for this purpose. Tableau was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives and clients.
Course Details & Class Schedule