That was Then... This is Now

According to the Project Management Institute, generative AI tools may be used in the development process for certain repetitive tasks such as creating documentation or diagrams. This semester in my MGT 330 Project Management class I decided to offer ChatGPT as an alternative to the more tradidional means we have used for several of the weekly assignments and Milestones. Here is one example where we used ChatGPT to create an "Entity-Relationship" diagram. For this Milestone, we entered a prompt similar to the one below then additional information pertaining to the case. I chose to use PowerPoint to draw the actual diagram using the Entities and Relationships suggested: “draw an entity relationship diagram for customer places order” Sure! Here's a description of how the Entity Relationship Diagram (ERD) for "Customer places an Order" could look: Entities: Customer Attributes: CustomerID (Primary Key) Name Email Phone Numbe...

Power Query is found within both Excel and Power BI, helping users to transform and clean up their data before they analyze it. With Power Query, you can easily connect to data sources like Excel worksheets, external databases, websites, and even Cloud services. Once connected, you can import data and perform a wide range of data transformations. Data Cleaning: Clean up messy or redundant data. Power Query can help clean up by removing duplicates, correcting errors, and standardizing formats. Data Transformation: Power Query lets you pivot, unpivot, merge, and append tables to get your data ready for analysis. Columns: Add calculated columns or split existing columns. Similar to the way we do it in Excel, Power Query makes it easy to perform various operations. Data Merging: Power Query can merge data from separate tables or files into a single large dataset for analysis. Power Query records all the steps you take to transform your data so if your data changes, you can refresh your qu...