Wednesday, September 30, 2020

BI/DW Best Practice #16 - Start small, release in batches

Try to release reports batch by batch in smaller portions. Users and production supports will get crazy if you release too much and too fast. We should give enough time for the users to change their working procedures with the new reports and environment. Otherwise, users may stick to their old procedures instead of switching to the new system.

User training is also important for switching smooth. It would be nice that we can assign a power user in each department. He/she may also act as the trainer within his/her department.

Please pay more attention to the process of Business User Adoption. It is challenging.

No comments:

Post a Comment

Extract: Performance Tips

Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...