O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PowerShell for Business Intelligence and Big Data Analytics LiveLessons

Video Description

Rough Cuts / Sneak Peek:

The Rough Cuts/Sneak Peek program provides early access to Pearson video products and is exclusively available to Safari subscribers. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing.

Table of Contents

  1. Introduction
  2. Lesson 1: An Introduction to Business Intelligence
    1. 1.1 What is Business Intelligence? 00:06:45
    2. 1.2 Microsoft Power BI as an example 00:04:39
    3. 1.3 Common uses for Power BI data 00:05:31
    4. 1.4 Why use PowerShell for BI and data analytics 00:04:06
  3. Lesson 2: Accessing Data Sources from PowerShell
    1. 2.1 Access Active Directory through PowerShell 00:10:00
    2. 2.2 Use PowerShell to extract objects and attributes 00:13:29
    3. 2.3 Parse event logs through PowerShell 00:11:02
    4. 2.4 Use PowerShell to read CSV files 00:05:35
    5. 2.5 Query SQL Server with PowerShell 00:12:49
    6. 2.6 Compile data from remote hosts 00:08:40
  4. Lesson 3: Create a GUI Interface
    1. 3.1 Understand PowerShell GUI fundamentals 00:13:00
    2. 3.2 Create GUI labels 00:15:09
    3. 3.3 Display text boxes 00:15:42
    4. 3.4 Create buttons 00:18:37
    5. 3.5 Build list boxes 00:11:05
    6. 3.6 Generate radio buttons 00:12:39
    7. 3.7 Create check boxes 00:14:35
  5. Lesson 4: The Basics of Data Charting
    1. 4.1 Install charting controls 00:03:48
    2. 4.2 Understand charting fundamentals 00:12:39
    3. 4.3 Learn common charting elements 00:25:05
    4. 4.4 Create common chart types 00:23:24
    5. 4.5 Work with multiple data series 00:14:58
  6. Lesson 5: Create Advanced Charts
    1. 5.1 Sort PowerShell's output 00:09:10
    2. 5.2 Create bubble charts 00:08:10
    3. 5.3 Build area charts 00:05:56
    4. 5.4 Produce pyramid charts 00:07:13
    5. 5.5 Create funnel charts 00:06:37
    6. 5.6 Make doughnut charts 00:07:01
  7. Lesson 6: Put the GUI to Work
    1. 6.1 Create a simple GUI application 00:19:47
    2. 6.2 Create an interactive chart 00:33:09
    3. 6.3 Build a simple business dashboard 00:30:43
  8. Lesson 7: Build a Financial Dashboard
    1. 7.1 Create a sample database 00:06:58
    2. 7.2 Create a top five customers report 00:27:22
    3. 7.3 Display projected accounts receivable 00:23:43
    4. 7.4 Report recent payments received 00:11:16
    5. 7.5 Show the top five overdue accounts 00:15:09
    6. 7.6 Build a customer summary tool 00:23:55
    7. 7.7 Assemble the financial dashboard 00:17:07
  9. Lesson 8: Build an IT Dashboard
    1. 8.1 Monitor host memory consumption 00:14:57
    2. 8.2 Track VM memory consumption 00:18:20
    3. 8.3 Report multi-host memory consumption 00:12:16
    4. 8.4 Display VM summary information 00:13:22
    5. 8.5 Create a live migration tool 00:15:16
    6. 8.6 Assemble the IT dashboard 00:16:41