Training Materials!
Data Analytics Training
P-Card Files (Power Query)
P-Card Files: 2023 Monthly P-Card Transactions - July 2022
P-Card Files: 2023 Monthly P-Card Transactions - August 2022
P-Card Files: 2023 Monthly P-Card Transactions - September 2022
P-Card Files: 2023 Monthly P-Card Transactions - October 2022
P-Card Files: 2023 Monthly P-Card Transactions - November 2022
P-Card Files: 2023 Monthly P-Card Transactions - December 2022
P-Card Files: 2023 Monthly P-Card Transactions - January 2023
P-Card Files: 2023 Monthly P-Card Transactions - February 2023
P-Card Files: 2023 Monthly P-Card Transactions - March 2023
P-Card Files: 2023 Monthly P-Card Transactions - April 2023
P-Card Files: 2023 Monthly P-Card Transactions - May 2023
P-Card Files: 2023 Monthly P-Card Transactions - June 2023
PDF Examples (Power Query)
Allegheny County and City of Pittsburgh Market Value Analysis -- Multiple Tables & Merging Header Rows
Geocodes: Public Schools and Local Education Agencies -- Multiple Tables & Tables Spanning Multiple Pages
TX Dept of Motor Vehicles - Registered Vehicles by County -- Large Dataset & Multiple Tables
US Census - TIGER/Line Shapefiles -- Large Dataset & Multiple Tables & Tables Spanning Multiple Pages
Open Issues Data (PowerBI and Excel Dashboards)
Enchanted Enterprises - Open Issues and Action Plans (data)
Enchanted Enterprises - Open Issues and Action Plans Power BI Dashboard Example
Enchanted Enterprises - Power BI Gantt Chart Example
Enchanted Enterprises - Open Issues and Action Plans Excel Dashboard Example