I sincerely believe if you have the right database design before you develop your application then analyzing your data will be a piece of cake.
Feel free if you want to get in touch discuss anything related to BI and SQL.
Blog: http://www.msiman.ga
Email: m m s i ma ng a @ g m a i l . c o m