Power BI Dashboards
For this project I implemented 3 Power BI dashboards: GIS Headcounts, ITAM(IT Asset Management) and Operational Scorecard.
GIS Headcounts Dashboard
To keep track of employee movements for the Global Infrastructure Services team at TIAA, the Headcounts Dashboard includes the total amount of new hires, attritions, FTE employees and Contingent Workers.
Features Implemented:
- Drillthrough Integration
- Filters
.png)
For the drillthrough integration (refer to first image at the top for reference) if a user wanted to receive more details on a specific data item. They can right-click on a bar in th stacked bar chart a drillthrough option comes up, when selected the user will be moved to a table that has the specific details on the data chosen. The next feature, which are filters or slicers in Power BI terms, were implemented with a dropdown selection and when a option is clicked the visualization that holds data that are from the same datasource becomes filtered instantly.
Power App
Leaders need efficient and acccessible technology that can store and showcase metrics that reflect the teams they lead. That is why the Performance Management Portal created with Power Apps is implemented.
Python & Data
We are used to running the manual process of Data Validation with SQL queries. But with my experience with Python I manage to leverage the productivity with the data validation process. By using a JDBC Oracle driver connection to run SQL queries remotely and implementing an algorithm to store the results to an excel automatically. The process takes just one command line execute the process in seconds instead of long hours.
