Hi all
I am very new to Power BI and I have been asked to put together a way of reporting that the company can use to solve a variety of problems. I have power BI available to me and with the AD integration, I think it will be the perfect tool. I have already put together some dashboards but i am stuck on the approach for the remaining ones.
Here is exactly what I am trying to achieve for my project. I have to do an audit of the old objects in AD by location and generate a dashboard the owners can interact with. I have a little bit of knowledge on doing this but I need some guidance.
The field DistinguishedName contains the OU that indicates the location in one table. Please note that there is hundreds of thousands of entries in these tables.
<tbody>
</tbody>
I want to create a query (by merge I think) on this table that does a lookup on the DistinguishedName matches the OU=LON entry and then match each row to another table that has the following.
<tbody>
</tbody>
Tables that I need to create from this are:
<tbody>
</tbody>
With another table that counts the entries:
<tbody>
</tbody>
And a final table that looks at the LastLogonDate that is older than 1st Jan 2013.
<tbody>
</tbody>
That is all of the problems I have to solve to create my entire project. From these scenarios I can then do all of my other requests I have
Really excited to learn PowerBI, I have done so much trawling through forums and can't seem to find the right approach., but I'm also a complete noob and Trial and error isn't going as well as expected.
Thank you so much for any help of guidence you can provide.
DJJ2
I am very new to Power BI and I have been asked to put together a way of reporting that the company can use to solve a variety of problems. I have power BI available to me and with the AD integration, I think it will be the perfect tool. I have already put together some dashboards but i am stuck on the approach for the remaining ones.
Here is exactly what I am trying to achieve for my project. I have to do an audit of the old objects in AD by location and generate a dashboard the owners can interact with. I have a little bit of knowledge on doing this but I need some guidance.
The field DistinguishedName contains the OU that indicates the location in one table. Please note that there is hundreds of thousands of entries in these tables.
<tbody> </tbody> | ||||||
<tbody>
</tbody>
I want to create a query (by merge I think) on this table that does a lookup on the DistinguishedName matches the OU=LON entry and then match each row to another table that has the following.
| Region | Country | City | Code |
| EMEA | UK | London | LON |
<tbody>
</tbody>
Tables that I need to create from this are:
| Servername | Location | Country | Region |
| LONSERVER1 | London | UK | EMEA |
<tbody>
</tbody>
With another table that counts the entries:
| Server Count | |
| EMEA | 50 |
| Uk | 20 |
| London | 3 |
<tbody>
</tbody>
And a final table that looks at the LastLogonDate that is older than 1st Jan 2013.
| Name | LastLogonDate |
| Server2 | 17/09/2001 |
<tbody>
</tbody>
That is all of the problems I have to solve to create my entire project. From these scenarios I can then do all of my other requests I have
Really excited to learn PowerBI, I have done so much trawling through forums and can't seem to find the right approach., but I'm also a complete noob and Trial and error isn't going as well as expected.Thank you so much for any help of guidence you can provide.
DJJ2
