- Lab
- Core Tech
Work with Data in Windows PowerShell
In this lab, you'll practice working with various data formats in Windows PowerShell. You'll gain hands-on experience manipulating CSVs, JSON, XML, and other structured data. When you're finished, you'll have developed skills in data cleaning, conversion between different formats, creating interactive HTML reports, and interacting with REST APIs to send and retrieve data.
Path Info
Table of Contents
-
Challenge
Get Started in the Lab Environment
Here are the initial instructions and explanation of the lab environment. Read this while your environment is busy creating itself from nothing. Yes, this violates physics; we know. How fun!
-
Challenge
Import and Clean CSV Data
In this hands-on lab, you'll use PowerShell to clean and prepare complex CSV data for migration to a new CRM system. You'll learn to handle encoding issues, identify non-standard characters, and manage null values to ensure seamless data integration.
-
Challenge
Import and Export CliXML Data
Dive into PowerShell's data manipulation capabilities! Learn to handle complex data structures, use CliXML for serialization and deserialization, and ensure data integrity across sessions and systems.
-
Challenge
Convert PS Objects to JSON
Explore complex employee data structures, convert PowerShell objects to JSON for API integration, and transform JSON back to objects for analysis. Master data manipulation essential for modern IT professionals.
-
Challenge
Convert XML to Objects
Master converting PowerShell objects to XML strings and XML to objects. Essential for working with REST APIs, you'll transform employee data for payroll submission and convert API responses for reporting.
-
Challenge
Build an HTML Report
Transform CSV data into captivating web reports using PowerShell! Learn to convert objects to HTML, enhance reports with titles, headers, and CSS styling, and to add interactive charts for data visualization.
-
Challenge
Redirect Objects to a File
Master PowerShell's Out-File cmdlet by generating comprehensive server reports. Capture running processes, append system details, and avoid overwriting data. Gain essential skills for system documentation and analysis.
-
Challenge
Create Files with Set and Add-Content
Master PowerShell's Set-Content and Add-Content cmdlets to create and append data to files. Learn to import, manipulate, and combine data from multiple sources, automating report generation and streamlining data management.
-
Challenge
Query REST APIs with Invoke-RestMethod
Master PowerShell's web interaction capabilities. Learn to send and update data via APIs, handle errors, extract information from web pages, and create reusable functions for seamless integration with web services.
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.