ChatGPT Data Wrangler, Things in Mirror are Closer than they Appear
You’re traveling through another dimension — a dimension not only of sight and sound but of mind. A journey into a wondrous land whose boundaries are that of imagination. That’s a signpost up ahead: your next stop: the Twilight Zone! You unlock this door with the key of imagination.
- (NB: This is a prediction about data management and analytics before OpenAI allowed the creation of your own GPT’s.)
Hey ChatGPT! .. you are a master of API creation and testing. Here are links and passwords to 27 of our in-house and cloud-hosted datasets. Please write API’s to each of these so you can interrogate their contents individually, according to best practices found here:
- https://document360.com/blog/api-design-best-practices
- https://stackoverflow.blog/2020/03/02/best-practices-for-rest-api-design
- https://learn.microsoft.com/en-us/azure/architecture/best-practices/api-design
- https://blog.hubspot.com/website/api-development
You are also a database schema documentation expert. Here are links and passwords to 27 of our in-house and cloud-hosted datasets. Please document all of these according to the best practices found at:
- https://documentation.softwareag.com/adabas/ada744mfr/adamf/pdf/dbatasks/dbadbdoc.pdf
- https://www.fivetran.com/blog/database-schema-best-practices
- https://techwriter.me/best-practices-guide/documenting-databases.aspx
Once that step is complete, create a dynamic data dictionary that maps all of them together and generate a monitoring system to keep that dictionary up to date according to learnings from
- https://library.si.edu/sites/default/files/tutorial/pdf/datadictionaries20180226.pdf
- https://medium.com/@leapingllamas/data-dictionary-a-how-to-and-best-practices-a09a685dcd61
- https://libguides.lmu.edu/c.php?g=509009&p=3976820
As an expert of data quality and observability, apply the techniques found at these links in order to create an automated data quality checking and cleansing process
- https://monkeylearn.com/blog/data-cleaning-techniques/
- https://www.tableau.com/learn/articles/what-is-data-cleaning
- https://technologyadvice.com/blog/information-technology/data-cleaning/
- https://dev.to/pragyanatvade/10-best-practices-for-ensuring-proper-monitoring-and-observability-1f0m
- https://www.montecarlodata.com/blog-what-is-data-observability
Next, generate a super-schema of our combined 27 datasets.
Compare the features and benefits of AWS, Azure, and Google Cloud. Select the platform that has the best balance of scalability, cost, flexibility, speed, ease of use, compute services, etc., using these recourses as guides:
- https://www.bmc.com/blogs/aws-vs-azure-vs-google-cloud-platforms/
- https://www.coursera.org/articles/aws-vs-azure-vs-google-cloud
- https://www.digitalocean.com/resources/article/comparing-aws-azure-gcp
Based on your research, select the winning platform and negotiate with each for services and price based on the size of combining all 27 of our datasets and on your expertise as a world-class negotiator, using learnings from:
- https://www.pon.harvard.edu/daily/batna/10-hardball-tactics-in-negotiation/
- https://www.vistage.com/research-center/business-growth-strategy/six-successful-strategies-for-negotiation/
- https://online.hbs.edu/blog/post/negotiation-skills
- Never Split the Difference by Chris Voss
Using your API’s, create an automated process for extracting and transforming the data from our 27 datasets in order to load them into the winning platform.
You are a wizard at analytics. Reach out to each department head in the company via the communication channel each likes best and ask them a series of questions that will get to the heart of the problems they are trying to solve and the goals they are trying to achieve. Engage each individual in conversation as a trusted advisor, providing suggestions and recommendations based on statistical analysis and your best understanding of the personal motivations, incentive packages, corporate culture, and political constraints of each individual. Offer tactical assistance wherever you can to prove, test, and automate processes. Think outside the box to help each individual achieve their goals.
Send me an email once an hour to report your progress and include your perception of department heads’ willingness and ability to work with you, open mindedness, and areas where you might offer additional training. Let me know which individuals are working above or below their capacity and your recommendations for responsibility allocation and individual career paths.
Be kind, considerate and supportive to all humans.
Have a nice day.
Jim