Instructor-led (classroom)
Intermediate
2 days
English
This course is designed for the end users and analysts that are interested in exploring the new self-service business intelligence tools in Excel and SharePoint Server 2013.
Before attending this course, students must have:
This course is intended for all business professionals including IT professional, developers, managers, project leads, project managers, and team leads, but we do not expect coding skills, just thinking skills!
A 360-degree learning approach that you can adapt to your learning style
Engage and learn more with these live and highly-interactive classes alongside your peers
24/7 Teaching Assistance Keep engaged with integrated teaching
Projects provide you with sample work to show prospective employers.
Real-world projects relevant to what you’re learning throughout the program
A support team focused on helping you succeed alongside a peer community
After completing this course, students will be able to:
Course Overview
Lessons
After completing this module, students will be able to:
Microsoft Business Intelligence Vision
Lessons
Lab : Microsoft Business Intelligence Vision
After completing this module, students will be able to:
Enterprise Business Intelligence and PowerPivot
Lab : Excel 2013 PowerPivot
After completing this module, students will be able to:
Power View
In this module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will have you ready to visualize your data in a variety of ways.
Lessons
Lab : Power View
After completing this module, students will be able to:
Power Query
This module explains how to use Power Query effectively.
Lessons
Lab : Power Query
After completing this module, students will be able to:
Power Map
This module explores Power Map, a new 3D visualization add-in for mapping, exploring, and interacting with geographical and temporal data, enabling users to discover and share new insights.
Lessons
Lab : Power Map
After completing this module, students will be able to:
Summary Lab Exercises
This module includes concept reinforcement scenarios to encourage students to use what they’ve learned throughout this course. Scenario solutions are provided.
Lessons
Lab : Summary Lab Solutions
After completing this course, students will be able to:
√ Perform a local media-based installation of Windows Server 2012.
√ Select appropriate storage technologies and configure storage on a Windows Server.
√ Describe fundamental network components and terminology so you can select an appropriate network component.
√ Implement a network by selecting network hardware components and technologies and determine the appropriate network hardware and wiring components for a given situation.
Installing and Configuring Windows Server 2012
This module explains how the Windows Server 2012 editions, installation options, optimal service and device configuration and general post-installation configuration all contribute to the functionality and effectiveness of your Windows Server implementation.
Lessons
Lab: Installing and Configuring Windows Server 2012
After completing this module, student will be able to:
Implementing Storage in Windows Server
This module will introduce you to different storage technologies and discuss how to implement the storage solutions in Windows Server. There is also a discussion on how to create a resilient strategy for your storage, helping to avoid unplanned downtime and loss of data.
Lessons
Lab: Implementing Storage in Windows Server
After completing this module, students will be able to:
Understanding Network Infrastructure
In this module, students will learn how to describe fundamental network component and terminology thus enabling the student to select an appropriate network component in a particular scenario.
Lessons
Lab: Selecting Network Infrastructure Components
After completing this module, students will be able to:
Connecting Network Components
This module explores the functionality of low-level networking components, including switches and routers. In addition, the module provides guidance on how best to connect these and other components together to provide additional network functionality.
Lessons
Lab: Connecting Network Components
After completing this module, students will be able to:
Implementing TCP/IP
This module describes the requirements of a protocol stack and then focuses on the Transmission Control Protocol/Internet Protocol (TCP/IP) protocol stack.
Lessons
Lab: Implementing TCP/IP
After completing this module, students will be able to:
Implementing Windows Server Roles
This module explains the functional requirements of a server computer and how to select and deploy appropriate server roles to support these functional requirements.
Lessons
Lab: Implementing Server Roles
Lab : Implementing Server Roles
After completing this module, students will be able to:
Implementing Active Directory
This module explains that, as a directory service, how AD DS stores information about objects on a network and makes this information available to users and network administrators.
Lessons
Lab: Implementing AD DS
After completing this module, students will be able to:
Implementing IT Security Layers
This module explains how, in addition to file and share permissions, you can also use data encryption to restrict data access.
Lessons
Lab: Implementing IT Security Layers
After completing this module, students will be able to:
Implementing Security in Windows Server
This module reviews the tools and concepts available for implementing security within a Microsoft Windows infrastructure.
Lessons
Lab: Implementing Windows Security
After completing this module, students will be able to:
Implementing Network Security
This module explains possible threats when you connect your computers to a network, how to identify them, and how implement appropriate Windows network security features to help to eliminate them.
Lessons
Lab: Implementing Network Security
After completing this module, students will be able to:
Implementing Security Software
This module explains how an information technology (IT) administrator can account for and mitigate the risks of malicious code, unauthorized use, and data theft.
Lessons
Lab: Implementing Security Software
After completing this module, students will be able to:
Monitoring Server Performance
This module discusses the importance of monitoring the performance of servers, and how you monitor servers to ensure that they run efficiently and use available server capacity. It also explains performance monitoring tools to identify components that require additional tuning and troubleshooting, so that you can improve the efficiency of your servers.
Lessons
Lab: Monitoring Server Performance
After completing this module, students will be able to:
Maintaining Windows Server
This module explains the importance of system updates, how to troubleshoot the Windows Server boot process, and how to implement high availability and recovery technologies to improve system availability.
Lessons
Lab: Maintaining Windows Server
After completing this module, students will be able to:
Networking Fundamentals
Security Fundamentals
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure
