Choosing demo data is a very tricky question and there are many options. The main three boil down to general demo data, industry/special demo data and data from customers. Your choice will depend on the purpose of the demo and your precise situation.
Industry or special demo data can work if you have a perfect match between your customer’s expectations and purpose. However, data from customers can be tricky. You never know what you will get. Personally, I never ask for customer data. In my view, it must be a requirement from the customer, and you will also need one or more use cases that define what to do with the data. Be aware that getting customer data will almost certainly also mean extra data preparation time is needed.
Personally, I always prefer to use my demo data. Why? The content is very straightforward, and I know that it focuses on sales and is customer-related. I know this data very well and I can cover almost any demo situation with it. There is also a huge advantage to knowing your data: it gives you a lot of flexibility. You can switch direction at any time during your demo, and showcase things that were not originally planned—and as we have said before, this can often save you from demo disaster.
The bottom line is that best practice is to use diverse data that can cover many areas. Most importantly, it must be understandable to your audience.
For situations where you are receiving empty tables (DDL) from the customer, the following macro may help - it will look at the table attributes and create random data to fill it up. Primary key constraints are honoured!
https://core.sasjs.io/mp__makedata_8sas.html
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.