Building a business intelligence dashboard for a Lebanese company
DOI:
https://doi.org/10.5585/iptec.v11i1.24603Palavras-chave:
Business Intelligence, Dashboards, Data, ETL, Modelling.Resumo
This project developed a business intelligence process for a Lebanese company to enhance their financial management. The process involved creating a data model based on the company's needs and data availability, integrating their data into a physical database using Python and PostgreSQL, and generating dashboards with Power BI to visualize and analyse their revenue numbers. The project outcomes will help the company gain insights into their business performance, optimize their revenue and profit, and identify data entry issues that may affect their results. The project also provides a foundation for further data integration and analysis.
Downloads
Referências
Bray T (2011) The role of business intelligence dashboards in financial management. Credit Control 32 (5/6): 29–33
Breslin J G (2019) Developing an organizational data strategy. J Bus Manag 24(1): 35-42 https://doi.org/10.3390/app11073186
Cukier K (2013) Data, data everywhere: A special report on managing information. The Economist 25 https://doi.org/10.4324/9781315856469
Davenport T H, and Harris J G (2007) Competing on analytics: The new science of winning. Harvard Business Press, https://doi.org/10.5860/choice.44-6322
Fernández A (2020) El papel del Big Data en el reporting y la toma de decisiones. Contabilidad y Direccion 31, 21–36
Gandomi A, and Haider M (2015) Beyond the hype: Big data concepts, methods, and analytics. Inter J Info Manag 35(2), 137–144 https://doi:10.1016/j.ijinfomgt.2014.10.007
Gao J, and Ren G (2020) Social media data analytics: An overview. IEEE Transac Compu Social Systems 7(6): 1621–1633
García-Sánchez F, Pérez-González D, and Pavón-Mariño P (2018) A survey of data modeling techniques for big data. Info Systems 73: 1–19
Hernández-Orallo J, Ramírez-Quintana M J, and Flach P A (2020) Explainable AI: Interpreting, explaining and visualizing deep learning. Springer https://doi.org/10.1007/978-3-030-28954-6
Kim S H, and LeeJ N (2012) The impact of organizational context and information technology on employee knowledge-sharing capabilities. Public Admin Rev 72(4), 527–536 https://doi:10.1111/j.1540-6210.2006.00595.x
Lenzerini M (2002) Data integration: A theoretical perspective. Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems 233–246 https://doi:10.1145/543613.543644
Li X, Huang J, Wang L, and Lu X (2018) Big data analytics in supply chain management: A comprehensive overview and future directions. Computers Indus Engineer 116: 299–316 https://doi.org/10.3390/bdcc6010017
Manyika J, Chui M, Brown B, Bughin J, Dobbs R, Roxburgh C, and Byers A H (2011) Big data: The next frontier for innovation, competition, and productivity. McKinsey Global Instit: 1–156
Popescu S (2012) Business intelligence solutions - A way of general improvement of efficiency and effectiveness. Rev Inter Compar Manag / Revista de Manag Comparat Inter 13(1): 88–95
Wieder B, Ossimitz M-L, and Chamoni P (2012) The impact of business intelligence tools on performance: A user satisfaction paradox? Inter J Econ Sciences and Applied Res 5(3): 7–32
Wu X, Zhu X, Wu G Q, and Ding W (2021) Data mining with big data. IEEE Trans Know Data Engineer 33(5): 1855–¬1878 https://doi.org/10.1109/TKDE.2013.109
Younus A, and Qureshi M A (2021) Data analytics for business decision making: A comparative study of regression techniques. In Proceedings of the 4th International Conference on Future Networks and Distributed Systems (pp 229–241)
Downloads
Publicado
Como Citar
Edição
Secção
Licença
Direitos de Autor (c) 2023 Revista Inovação, Projetos e Tecnologias
![Creative Commons License](http://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png)
Este trabalho encontra-se publicado com a Licença Internacional Creative Commons Atribuição-NãoComercial-CompartilhaIgual 4.0.