| Sumario: | 8+ Hours of Video Instruction Big data and business intelligence have been two of the major IT trends in the last five years. This video shows the viewer how they can capitalize on those trends by using tools that they already own. Description Business intelligence is the science of mining data and using it to derive business value. It typically requires complex tools such as Microsoft’s Power BI. The goal of this video series is to show how to perform custom business analytics and build business dashboards using nothing but PowerShell. This video series is entirely hands on. It explains key concepts while actually building PowerShell-based business intelligence dashboards and applications. Skill Level Intermediate - Advanced What You Will Learn How to use PowerShell as a data mining tool How to build a PowerShell GUI How to create charts using PowerShell How to build financial and IT dashboards How to build a number of interactive reports Who Should Take This Course IT professionals, system administrators, and developers Course Requirements Working knowledge of PowerShell Table of Contents Summaries: PowerShell for Business Intelligence and Big Data Analytics Lesson 1 is intended to be introductory in nature. This lesson explains what Business Intelligence is and how it is commonly used. This lesson also demonstrates Microsoft Power BI, Microsoft’s off the shelf Business Intelligence solution, before finishing off by making the case for using PowerShell as a business intelligence tool. Lesson 2 explains how to use PowerShell as a data mining tool. This lesson demonstrates how to use PowerShell to extract data from a number of different sources including the Active Directory, the Windows operating system, event logs, CSV files, SQL Server, and remote servers. Lesson 3 describes the process of building a GUI interface for PowerShell. It also provides instructions for adding various GUI controls including labels, text boxes, buttons, list boxes, radio buttons, and check boxes. Lesson 4 is an introduction to creating charts in PowerShell. It describes how to install the charting controls, and how to build a basic chart. From there, the lesson goes on to demonstrate the creation of a number of different types of common charts, before moving on to a discussion of charts that use multiple data series. Lesson 5 starts out by explaining how to sort PowerShell’s output, with an emphasis on ordered hash table data. From there, the lesson focuses on le...
|
|---|
