Social media has become a vital part of the business strategy to communicate with their customers with the use of creative promotions by message and contents. Current businesses adopt social media analytics field to improve their promotional performance. However, businesses are struggling with adopting, implementing, and institutionalizing methodologies and techniques for an effective social media analytics approach. The purpose of this study is to outline and elaborate a way to integrate business intelligence, business analytics, and visualization, with the end results is drawn insights for business who uses Instagram social media as their intermediary to promote their business. To present the proposed framework's practical validity, a local Instagram business account is used as a case study.