One of the most interesting things about Power BI is that it covers a wide range of areas. Therefore, it can help a wide range of different users to analyse and understand their businesses easily. For instance system administrators can use Power BI to analyse their Microsoft Windows Active Directory. As a matter of fact, Power BI and Active Directory can work together very nicely so that a system administrator can create high level reports and dashboards.
In this , we’ll create a report of the following charts:
- Total number of computers by Operating System/Service Pack
- Total number of computers by year and Operating System
- Total number of computers
- Print pages per minute by printer
- Total number of printers by year and driver name
As a system administrator you can create heaps of other useful reports.
Get Data
- On Power BI Desktop click “Get Data” then click “More”
- Click “Other”, click “Active Directory” then click “Connect”
- Enter a Domain name then click OK
- As you can see there are 374 tables you can select to create heaps of reports. In this post I use “Computer” and “PrintQueue”
Continue reading “Power BI and Active Directory for System Administrators”