ویندوز پاورشل (به انگلیسی: Windows PowerShell) یک موتور خودکار قابل ارتقا است از طرف مایکروسافت که شامل یک پوسته خط فرمان و همراه یک زبان اسکریپت‌نویسی است. ویندوز پاورشل با بهره‌گیری و همراه چهارچوب دات‌نت ارایه شده‌است و چهارچوبی برای اتوماسیون کردن وظایف است پاور شل به مدیران امکان مدیریت سیستم در هر دو حالت محلی و از راه دور را می‌دهد.
LiveLessons PowerShell for Business Intelligence and Big Data Analytics
HDRips | MP4/AVC, ~252 kb/s | 1280×720 | Duration: 10:07:25 | English: AAC, 128 kb/s (2 ch)
by Brien Posey
Publisher: Sams
Release Date: February 2017
ISBN: 9780134691527
Topics:Analytics
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
Introduction
Lesson 1: An Introduction to Business Intelligence
1.1 What is Business Intelligence? 00:06:45
1.2 Microsoft Power BI as an example 00:04:39
1.3 Common uses for Power BI data 00:05:31
1.4 Why use PowerShell for BI and data analytics 00:04:06
Lesson 2: Accessing Data Sources from PowerShell
2.1 Access Active Directory through PowerShell 00:10:00
2.2 Use PowerShell to extract objects and attributes 00:13:29
2.3 Parse event logs through PowerShell 00:11:02
2.4 Use PowerShell to read CSV files 00:05:35
2.5 Query SQL Server with PowerShell 00:12:49
2.6 Compile data from remote hosts 00:08:40
Lesson 3: Create a GUI Interface
3.1 Understand PowerShell GUI fundamentals 00:13:00
3.2 Create GUI labels 00:15:09
3.3 Display text boxes 00:15:42
3.4 Create buttons 00:18:37
3.5 Build list boxes 00:11:05
3.6 Generate radio buttons 00:12:39
3.7 Create check boxes 00:14:35
Lesson 4: The Basics of Data Charting
4.1 Install charting controls 00:03:48
4.2 Understand charting fundamentals 00:12:39
4.3 Learn common charting elements 00:25:05
4.4 Create common chart types 00:23:24
4.5 Work with multiple data series 00:14:58
Lesson 5: Create Advanced Charts
5.1 Sort PowerShell’s output 00:09:10
5.2 Create bubble charts 00:08:10
5.3 Build area charts 00:05:56
5.4 Produce pyramid charts 00:07:13
5.5 Create funnel charts 00:06:37
5.6 Make doughnut charts 00:07:01
Lesson 6: Put the GUI to Work
6.1 Create a simple GUI application 00:19:47
6.2 Create an interactive chart 00:33:09
6.3 Build a simple business dashboard 00:30:43
Lesson 7: Build a Financial Dashboard
7.1 Create a sample database 00:06:58
7.2 Create a top five customers report 00:27:22
7.3 Display projected accounts receivable 00:23:43
7.4 Report recent payments received 00:11:16
7.5 Show the top five overdue accounts 00:15:09
7.6 Build a customer summary tool 00:23:55
7.7 Assemble the financial dashboard 00:17:07
Lesson 8: Build an IT Dashboard
8.1 Monitor host memory consumption 00:14:57
8.2 Track VM memory consumption 00:18:20
8.3 Report multi-host memory consumption 00:12:16
8.4 Display VM summary information 00:13:22
8.5 Create a live migration tool 00:15:16
8.6 Assemble the IT dashboard 00:16:41
