The output of hiring a Data Scientist for a company largely depends on the reason they were hired in the first place. There are different types of Data Scientists available today, classified typically based on deliverables. If you hired a Data Scientists scan through datasets, to extract insights for making informed decision-making then that is the output of that Data Scientist. If on the other hand, you hired a Data Scientist for training a model, by correctly organizing the datasets and feeding for training the model, then the output is producing fully functional models that generate accurate results on new datasets. So, the output varies, from company to company based on their requirements.
If you wish to get trained and certified in Data Science, check out the Data Science training course from Intellipaat. Also, watch the following YouTube video made by industry experts on Data Science courses.