Calendar2019-01-07T23:38:06+00:00
Jan
22
Tue
2019
20778A: Analyzing Data with Power BI @ Fideicomiso de Ciencia, Tecnología e Innovación
Jan 22 – Jan 25 all-day
20778A: Analyzing Data with Power BI @ Fideicomiso de Ciencia, Tecnología e Innovación

 

Modality: Led-Training

Location: Puerto Rico Science, Technology & Research Trust Center


About this course

This three-day instructor-led course provides students with the knowledge and skills analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Audience Profile

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

At Course Completion

After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.

Prerequisites

This course requires that you meet the following prerequisites:

  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

 

Course Outline

Module 1: Power BI Desktop Data Transformations

This module describes how to import fata into Power BI.

Lessons

  • What is Power BI?
  • Power BI data
  • Transformations

Lab: Import Data to Power BI

  • Import data to Power BI desktop
  • Import data from CSV files
  • Import data from a less structured file

After completing this module, students will be able to:

  • Describe what Power BI is and what it does.
  • Describe the types of data.
  • Perform data transformations.

Module 2: Power BI Desktop Modeling

This module introduces Power BI desktop modeling.

Lessons

  • Optimizing data models
  • Calculations
  • Hierarchies

Lab: Manage Power BI data

Manage table relationships

  • Last year comparison
  • Year to date
  • Market share
  • Optimize the data model

After completing this module, students will be able to:

  • Optimize data models.
  • Perform calculations with Power BI data.
  • Describe and create hierarchies.

Module 3: Power BI Desktop Visualization

At the end of this module students will be able to create a Power BI desktop visualization.

Lessons

  • Visualizing your data
  • Working with multiple visualizations

Lab: Create reports with visualizations

  • Cross-tabular reports
  • Part-to-Whole reports
  • Relationship reports
  • Trend reports
  • Rank reports

After completing this module, students will be able to:

  • Visualize data using Power BI
  • Work with multiple visualizations.

Module 4: Power BI Service

This module describes how to implement the Power BI service.

Lessons

  • Working with the Power BI service
  • Configuring a dashboard
  • Viewing a Power BI Dashboard

Lab: Implementing the Power BI service

  • Upload a Power BI report
  • Share a Power BI dashboard
  • Configure data refresh

After completing this module, students will be able to:

  • Work with the Power BI service.
  • Configure a Power BI dashboard.
  • View a Power BI dashboard.

Module 5: Working with Excel

This module describes how to connect to Excel as a source of data.

Lessons

  • Importing data from excel
  • Analyzing data in Excel

Lab: Working with Excel

  • Uploading an Excel file with an Excel table
  • Uploading an Excel file with a data model

After completing this module, students will be able to:

  • Import data from excel.
  • Analyze data in Excel.
  • Table of Contents

Module 6: Organization Content Packs, Security, and groups

This module describes how to collaborate with Power BI data.

Lessons

  • Collaboration
  • Content packs

Lab: Working with Organization Content Packs

  • Create a content pack
  • Edit a content pack
  • Share a content pack

After completing this module, students will be able to:

  • Share data for collaborative purposes.
  • Create, edit, and share content packs.

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

  • Cloud data
  • Connecting to analysis services

Lab: Direct Connectivity

  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

After completing this module, students will be able to:

  • Access data in SQL Azure.
  • Connect to SQL Server Analysis Services.

Module 8: Developer API

This module describes the developer API within Power BI.

Lessons

  • The developer API
  • Custom visuals

Lab: using the developer API

  • Using custom visuals

After completing this module, students will be able to:

  • Describe the developer API.
  • Use the developer API to create custom visuals.

Module 9: Power BI mobile app

This module describes the Power BI mobile app.

Lessons

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app.
  • Download and use the Power BI mobile app.
  • Describe Power BI embedded and when
    you would want to use it.

Total Hours: 24

Jan
28
Mon
2019
AZ-100: Microsoft Azure Infrastructure and Deployment @ Fideicomiso de Ciencia, Tecnología e Innovación
Jan 28 – Feb 1 all-day
AZ-100: Microsoft Azure Infrastructure and Deployment @ Fideicomiso de Ciencia, Tecnología e Innovación
Material Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificated Of Achievement
  4. 15% OFF on Exam & Practice Test

 

About this course

This five-day set of courses is aligned to the Azure Exam: Azure Administrator, Deployment and contains the courseware that helps prepare students for Exam AZ-100. Passing this exam is required to earn the Azure Administrator, Deployment certification.

Audience profile

Candidates for this exam are Azure Administrators who manage cloud services that span storage, security, networking, and compute cloud capabilities. Candidates have a deep understanding of each service across the full IT lifecycle and take requests for infrastructure services, applications, and environments. They make recommendations on services to use for optimal performance and scale, as well as provision, size, monitor, and adjust resources as appropriate.

At course completion

After completing this course, students will be able to:

• Manage Azure subscriptions
• Analyze resource utilization and consumption
• Manage resource groups
• Create and configure storage accounts
• Import and export data to Azure
• Configure Azure files
• Implement Azure backup
• Create and configure a VM for Windows and Linux
• Automate deployment of VMs
• Manage Azure VM
• Manage VM backups
• Create connectivity between virtual networks
• Implement and manage virtual networking
• Configure name resolution
• Create and configure a Network Security Group (NSG)
• Manage Azure Active Directory (AD)
• Manage Azure AD objects (users, groups, and devices)
• Implement and manage hybrid identities

Course Outline

Subject
Day 1
Manage Subscriptions and Resources (AZ-100T01)
Module 1: Managing Azure Subscriptions
Module 2: Access Management for Cloud Resources
Module 3: Monitoring and Diagnostics
Module 4: Log Analytics
Module 5: Azure Resource Manager
Day 2
Implementing and Managing Storage (AZ-100T02)
Module 1: Overview of Azure Storage
Module 2: Storage Services
Module 3: Securing and Managing Storage
Module 4: Storing and Accessing Data
Module 5: Monitoring Storage
Day 3
Deploying and Managing Virtual Machines (AZ-100T03)
Module 1: Overview of Azure Machines
Module 2: Creating Virtual Machines
Module 3: Deploying Virtual Machine Images
Module 4: Configuring Virtual Machines
Module 5: Configuring Availability and Extensibility
Module 6: Managing and Monitoring Virtual Machines
Day 4
Configuring and Managing Virtual Networks (AZ-100T04)
Module 1: Azure Virtual Networks
Module 2: Azure DNS
Module 3: Securing Virtual Network Resources
Module 4: Connecting Virtual Networks
Day 5
Manage Identities (AZ-100T05)
Module 1: Managing Azure Active Directory
Module 2: Managing Azure Active Directory Objects
Module 3: Implementing and Managing Hybrid Identities
Prerequisites
Proficiency in using PowerShell, the Command Line Interface, Azure Portal, ARM templates, operating systems, virtualization, cloud infrastructure, storage structures, and networking.
Contact hours 40
Feb
4
Mon
2019
AZ-101: Microsoft Azure Integration and Security @ Fideicomiso de Ciencia, Tecnología e Innovación
Feb 4 – Feb 7 all-day
AZ-101: Microsoft Azure Integration and Security @ Fideicomiso de Ciencia, Tecnología e Innovación
Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificated Of Achievement
  4. 15% OFF on Exam & Practice Test

About this course

This four-day set of courses is aligned with the Azure Exam: Microsoft Azure Integration and Security and contains the courseware that helps prepare students for Exam AZ-101. Passing this exam is required to earn the Azure Administrator, Deployment certification.

Audience profile

This course is for Azure Administrators. Azure Administrators manage the cloud services that span storage, networking, and compute cloud capabilities, with a deep understanding of each service across the full IT lifecycle. They take end-user requests for new cloud applications and make recommendations on services to use for optimal performance and scale, as well as provision, size, monitor and adjust as appropriate. This role requires communicating and coordinating with vendors. Azure Administrators use the Azure Portal and as they become more proficient they use PowerShell and the Command Line Interface.

At course completion

After completing this course, students will be able to:

• Use Azure Migrate to discover and assess on-premises virtual machine migration to Azure.
• Use Azure Site Recovery to migrate Hyper-V infrastructures to Azure.
• Review migration strategies for VMWare and System Center VMM virtual machines.
• Implement use cases and configuration options for Azure App Services and App Service Environments.
• Manage and secure web apps with backup, restore, snapshot, and cloning.
• Optimize your web app performance with Scale Up, Scale Out, Autoscale, and Grow out strategies.
• Deploy serverless computing features like Azure Functions, Event Grid, and Service Bus.
• Implement and configure Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway.
• Implement and configure Site-to-Site VPN connections and ExpressRoute.
• Implement and configure Network Watcher and troubleshooting common network issues.
• Use Azure RBAC to grant a granular level of access based on an administrator’s assigned tasks.
• Use Azure Multi-Factor Authentication to configure a strong authentication for users at sign-in.
• User Azure AD Privileged Identity Management to configure access rights based on just-in-time administration

Course Outline

Subject
Day 1
Migrate Servers to Azure
Module 1: Azure Migrate
Module 2: Azure Site Recovery
Module 3: Disaster Recovery
Module 4: Migrating Data
Lab: Implement Azure Site Recovery Between Azure Regions
Day 2
Implement and Manage Application Services
Module 1: Introducing the Azure App Service Platform
Module 2: Managing and Securing Web Apps
Module 3: Scaling and Performance
Module 4: Deploying Serverless Computing Solutions
Lab: Implement and Manage Application Services
Day 3
Implement Advanced Virtual Networking
Module 1: Distributing Network Traffic
Module 2: Site Connectivity
Module 3: Monitoring and Troubleshooting Network Connectivity
Lab: Implement Advanced Virtual Networking
Day 4
Secure Identities
Module 1: Introduction to Identity Protection in Azure
Module 2: Using Multi-Factor Authentication for Secure Access
Module 3: Azure AD Privileged Identity Management
Lab: Secure Identities
Prerequisites
Successful Azure Administrators start this role with experience on operating systems, virtualization, cloud infrastructure, storage structures, and networking.
Contact hours 32
Feb
8
Fri
2019
MS-101 Microsoft 365 Mobility and Security @ Fideicomiso de Ciencia, Tecnología e Innovación
Feb 8 – Feb 13 all-day
MS-101 Microsoft 365 Mobility and Security @ Fideicomiso de Ciencia, Tecnología e Innovación
Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificated Of Achievement
  4. 15% OFF on Exam & Practice Test

About this course

This four-day set of courses is aligned to learn about Microsoft 365 Security Management, including how to manage your security metrics, how to enable Azure AD Identity Protection, how to configure your Microsoft 365 security services, and user Microsoft 365 Threat Intelligence. Also, Microsoft 365 Compliance Management, including data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations. This course introduces you to the world of Microsoft 365 device management – from establishing Microsoft Intune, to enrolling devices to Intune, to monitoring the devices, to controlling what users can do from the enrolled devices by using conditional access policies.

Audience profile

Audience Profile
This course is designed for persons who are aspiring to the Microsoft 365 Enterprise Admin role and have completed one of the Microsoft 365 workload administrator certification paths.

At course completion

After completing this course, students will be able to:

  • Implement security solutions in Microsoft 365
  • Implement Microsoft Secure Score
  • Implement Exchange Online Protection
  • Implement Advanced Threat Protection
  • Manage Safe Attachments and Safe Links
  • Implement Microsoft 365 Threat Intelligence
  • Use the Microsoft 365 Security Dashboard
  • Configure Advanced Threat Analytics
  • Implement cloud application security
  • Search for content in the Security and Compliance Center
  • Audit log investigations
  • Manage advanced eDiscovery
  • Plan for Co-management
  • Prepare your Windows 10 devices for Co-management
  • Plan your Windows 10 subscription activation strategy
  • Implement Windows 10 Analytics
  • Deploy Mobile Device Management
  • Manage devices with Mobile Device Management
  • Manage device compliance

Course Outline

Subject
Day 1
Microsoft 365 Security Management
Module 1: Designing your Microsoft 365 Tenant
Module 2: Configuring your Microsoft 365 Tenant
Module 3: Managing your Microsoft 365 Tenant
Module 4: Hands-On Lab
Lab: Managing Microsoft 365 Security
Day 2 
Microsoft 365 Compliance Management
Module 1: Introduction to Data Governance in Microsoft 365
Module 2: Archiving and Retention in Microsoft 365
Module 3: Implementing Data Governance in Microsoft 365 Intelligence
Module 4: Managing Data Governance in Microsoft 365
Module 5: Managing Search and Investigations
Module 6: Hands-On Lab
Lab: Setting Up your Lab Environment
Lab: Archiving and Retention in Microsoft 365
Lab : Implementing Data Governance
Lab : Verify Your Data Governance Policies
Day 3
Microsoft 365 Device Management
Module 1: Planning for Device Management
Module 2: Planning Your Windows 10 Deployment Strategy
Module 3: Implementing Mobile Device Management
Lab: Implement Advanced Virtual Networking
Day 4
Secure Identities
Module 1: Introduction to Identity Protection in Azure
Module 2: Using Multi-Factor Authentication for Secure Access
Module 3: Azure AD Privileged Identity Management
Module 4: Hands-On Lab
Lab: Working with Microsoft Store for Business
Lab : Managing Devices by using Intune
Contact hours 32