Application of the cloud-based sevice of business intelligence in the information infrastructure of the higher education institution
95 49
Keywords:
effective ways of university management, scientific and educational activity, information-analytical system, Power BIAbstract
In this article, an approach to solving the problem of strategic management of a university using an information-analytical system is proposed. The purpose of this article is to describe the roles and ways users interact with the information and analysis system. Methodological basis of the research was made by the technologies of data mining, table and graphic methods of information visualization and also business intelligence tools. As a tool for solving practical problems, the Power BI service is used that allows creating interactive panels and reports on the most important metrics. The practical importance of the materials presented in this article is the definition of the main information flows, the role of the quality management system and the place of the analytical service in the management organization of the university. Methods of storing and transferring data using cloud technologies and data cubes are described. The place of the information-analytical system in the unified corporate information system of the university is determined. The examples of the implementation of the information-analytical system of Al-Farabi KazNU on Power BI cloud platform are presented.
References
[1] Alekseyeva T.V., Ameridi YU.V., Luzhetskiy M.G., "Informatsionno-analiticheskiye sistemy. [Information-analytical systems. Moscow: - Moscow Financial-Industrial Academy] (Moskovskaya finansovo-promyshlennaya akademiya, 2005) accessed May 19 2017, http://www.e-biblio.ru/book/bib/01_informatika/IAS/Book.html
[2] Barilenko V.I. i dr. Analiz khozyaystvennoy deyatel’nosti: ucheb. Posobiye [Analysis of economic activity: training. Allowance] (Izdatel’stvo "Omega-L 2009), 414
[3] Chto takoye Power BI? [What is Power BI?], accessed May 12 2017, https://powerbi.microsoft.com/ru-ru/what-is-power- bi/
[4] Cooper Alan The Inmates are Running the Asylum: Why High-tech Products Drive Us Crazy and How to Restore the Sanity Paperback (2nd Edition, Kindle Edition, 2004), 328
[5] Daly Marshall The Modern Approach to Business Intelligence Ellie Fields – Vice President, Product Marketing, accessed May 16 2017, http://www.accountingpdfbooks.com/the-modern-approach-to-business-intelligence-ellie-fields- vice-president-product-marketing-marshall-daly-product-marketing/
[6] Desmeijter Browne Brecht, Rodrigo Frealdo Dumont, Armin Kamal, John Leahy, Scott Masson, Ksenija Rusak, Shinsuke Yamamoto, Martin Keen, "IBM Cognos Business Intelligence V10.1 Handbook, (International Technical Support Organization ibm.com, 2010) 549
[7] Eckerson W., Hackathorn R., McGivern M., Twogood C., Watson G., "BI Experts’ perspective: Data Warehousing Appliances."Business Intelligence Journal. Vol. 14 Issue 1(2009): 40-48.
[8] Elizabeth Hull, Ken Jackson, Jeremy Dick. Requirements Engineering, (SpringerVerlag London Limited, 2011) 229
[9] Ethan M. Rasiel, Paul N. Friga, "The McKinsey Mind Understanding and Implementing the Problem-Solving Tools and Management Techniques of the World’s Top Strategic Consulting Firm (McGraw-Hill, 2009) 224.
[10] Goel S. "Using Microsoft Business Intelligence Dashboards and Reports in the Federal Government. A White Paper on Leveraging Existing Investments in Microsoft Technology for Analytics and Reporting (Dev Technology Group, June 2013) 11
[11] Karl E. "Wiegers Software Requirements Second Edition Practical techniques for gathering and managering requirements throughout the development cycle, Two-time winner of the Software Development Productivity Award (Microsoft Press, 2014) 736
[12] Khimonin Y.U. "Sbor i analiz trebovaniy k programmnomu produktu (Versiya 1.03)"[Collection and analysis of requirements for the software product (Version 1.03)]. https://pmi.ru/profes/Software_Requirements_Khimonin.pdf.
[13] Kobern A., Sovremennyye metody opisaniya funktsional’nykh trebovaniy k sistemam, [Modern methods of describing functional requirements for systems] (Izdatel’stvo "Lori 2002) 263
[14] Kornipayev I. Trebovaniya dlya programmnogo obespecheniya: rekomendatsii po sboru i dokumentirovaniyu [Requirements for software: recommendations for collection and documentation], (Izdatel’stvo "Kniga po Trebovaniyu 2013) 118
[15] Laffenguell D., Weidrig D. "Agile Software Requirements: Lean Requirements Practices for Teams, Programs, and the Enterprise"(Agile Software Development Series) Scaling "Software Agility Best Practices for Large Enterprises"(AAddison- Wesley, 2016) 418
[16] Larson Brian, Delivering Business intelligence with Microsoft SQL Server 2008 (MC Graw Hill, 2009) 741
[17] Mamykova ZH.D., Mutanov G.M., Bobrov L.K. "Elektronnyy kampus v sotsial’no oriyentirovannoy modeli Smart- obshchestva"[Campus in a Socially-Oriented Model of the Smart Society], Idei i idealy: nauchnyy zhurnal. - Novosibirsk: Izdatel’stvo "NGUEU"Tom 2.- No 2(16), (2013). 64-70.
[18] Minto Barbara. The Pyramid principle logic in writing and thinking (Ausgabe - 18, November 2008) 272
[19] Moss Larissa T. "Business Intelligence Roadmap: The Complete Project Lifecycle for DecisionSupport"(Addison-Wesley Professional, 2003) 576
[20] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (promezhutochnyy)"[Scientific and methodological basis for the development and implementation of information and communication technologies in the educational system: report on research (interim)] (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D. No0212RK01116/GR 0112RK01488. Almaty, 2012. 164)
[21] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (promezhutochnyy)"[Scientific and methodological bases for the development and implementation of information and communication technologies in the educational system: report on research (intermediate)] (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D.- No0213RK02558/GR 0112RK01488. Almaty, 2013. 276)
[22] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (zaklyuchitel’nyy)"[Scientific and methodological basis for the development and implementation of information and communication technologies in the educational system: report on research (final)], (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D. No 0214RK01254/GR 0112RK01488. Almaty, 2014. 158)
[23] Osterwalder Alexander, Pigneur Yves Business Model Generation, A Handbook for Visionaries, Game Changers, and Challengers, (Written by John Wiley & Sons, 2011) 288
[24] Paklin N. B., Oreshkov V.I. Biznes analitika: ot dannykh k znaniyam: Uchebnoye posobiye [Business analysis: from data to knowledge: Textbook]. (2 izd., ispr. SPb.: Piter, 2013) 704
[25] Pererva A., Ivanova V. Put’ analitika. Prakticheskoye rukovodstvo IT-spetsialista [The Way of the Analyst. Practical guidance of the IT specialist]. (Piter, 2012) 304
[26] Ralston Barry. PowerPivot for Business Intelligence Using Excel and Sharepoint Business Intelligence Solutions for the Desktop (Apress, 2011) 277
[27] Ranjan J., "Business intelligence: concepts, components, techniques and benefits Journal of Theoretical and Applied Information Technology. Vol 9. No 1., 2005): 60 - 70.
[28] Robert Alvin, "Content Marketing Insights for IT Marketers Copyright B2B Marketers Start Here. NetLine Corporation. All rights reserved, Accessed May 20 2017. http://www.netline.com/netline002n/?d= hrcontentguide17&k= 170303nlwhrgd.
[29] Schmitz Dominik. Managing Dynamic Requirements Knowledge An Agent-Based Approach, Tag der mundlichen (Prufung: 20. Dezember, 2010) 346
[30] The project analytics framework Oracle Business Intelligence by Sid Goel (KPI Partners, 2012) 12
[2] Barilenko V.I. i dr. Analiz khozyaystvennoy deyatel’nosti: ucheb. Posobiye [Analysis of economic activity: training. Allowance] (Izdatel’stvo "Omega-L 2009), 414
[3] Chto takoye Power BI? [What is Power BI?], accessed May 12 2017, https://powerbi.microsoft.com/ru-ru/what-is-power- bi/
[4] Cooper Alan The Inmates are Running the Asylum: Why High-tech Products Drive Us Crazy and How to Restore the Sanity Paperback (2nd Edition, Kindle Edition, 2004), 328
[5] Daly Marshall The Modern Approach to Business Intelligence Ellie Fields – Vice President, Product Marketing, accessed May 16 2017, http://www.accountingpdfbooks.com/the-modern-approach-to-business-intelligence-ellie-fields- vice-president-product-marketing-marshall-daly-product-marketing/
[6] Desmeijter Browne Brecht, Rodrigo Frealdo Dumont, Armin Kamal, John Leahy, Scott Masson, Ksenija Rusak, Shinsuke Yamamoto, Martin Keen, "IBM Cognos Business Intelligence V10.1 Handbook, (International Technical Support Organization ibm.com, 2010) 549
[7] Eckerson W., Hackathorn R., McGivern M., Twogood C., Watson G., "BI Experts’ perspective: Data Warehousing Appliances."Business Intelligence Journal. Vol. 14 Issue 1(2009): 40-48.
[8] Elizabeth Hull, Ken Jackson, Jeremy Dick. Requirements Engineering, (SpringerVerlag London Limited, 2011) 229
[9] Ethan M. Rasiel, Paul N. Friga, "The McKinsey Mind Understanding and Implementing the Problem-Solving Tools and Management Techniques of the World’s Top Strategic Consulting Firm (McGraw-Hill, 2009) 224.
[10] Goel S. "Using Microsoft Business Intelligence Dashboards and Reports in the Federal Government. A White Paper on Leveraging Existing Investments in Microsoft Technology for Analytics and Reporting (Dev Technology Group, June 2013) 11
[11] Karl E. "Wiegers Software Requirements Second Edition Practical techniques for gathering and managering requirements throughout the development cycle, Two-time winner of the Software Development Productivity Award (Microsoft Press, 2014) 736
[12] Khimonin Y.U. "Sbor i analiz trebovaniy k programmnomu produktu (Versiya 1.03)"[Collection and analysis of requirements for the software product (Version 1.03)]. https://pmi.ru/profes/Software_Requirements_Khimonin.pdf.
[13] Kobern A., Sovremennyye metody opisaniya funktsional’nykh trebovaniy k sistemam, [Modern methods of describing functional requirements for systems] (Izdatel’stvo "Lori 2002) 263
[14] Kornipayev I. Trebovaniya dlya programmnogo obespecheniya: rekomendatsii po sboru i dokumentirovaniyu [Requirements for software: recommendations for collection and documentation], (Izdatel’stvo "Kniga po Trebovaniyu 2013) 118
[15] Laffenguell D., Weidrig D. "Agile Software Requirements: Lean Requirements Practices for Teams, Programs, and the Enterprise"(Agile Software Development Series) Scaling "Software Agility Best Practices for Large Enterprises"(AAddison- Wesley, 2016) 418
[16] Larson Brian, Delivering Business intelligence with Microsoft SQL Server 2008 (MC Graw Hill, 2009) 741
[17] Mamykova ZH.D., Mutanov G.M., Bobrov L.K. "Elektronnyy kampus v sotsial’no oriyentirovannoy modeli Smart- obshchestva"[Campus in a Socially-Oriented Model of the Smart Society], Idei i idealy: nauchnyy zhurnal. - Novosibirsk: Izdatel’stvo "NGUEU"Tom 2.- No 2(16), (2013). 64-70.
[18] Minto Barbara. The Pyramid principle logic in writing and thinking (Ausgabe - 18, November 2008) 272
[19] Moss Larissa T. "Business Intelligence Roadmap: The Complete Project Lifecycle for DecisionSupport"(Addison-Wesley Professional, 2003) 576
[20] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (promezhutochnyy)"[Scientific and methodological basis for the development and implementation of information and communication technologies in the educational system: report on research (interim)] (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D. No0212RK01116/GR 0112RK01488. Almaty, 2012. 164)
[21] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (promezhutochnyy)"[Scientific and methodological bases for the development and implementation of information and communication technologies in the educational system: report on research (intermediate)] (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D.- No0213RK02558/GR 0112RK01488. Almaty, 2013. 276)
[22] Mutanov G.M., "Nauchno-metodologicheskiye osnovy razrabotki i vnedreniya informatsionno-kommunikatsionnykh tekhnologiy v obrazovatel’nuyu sistemu: otchet o NIR (zaklyuchitel’nyy)"[Scientific and methodological basis for the development and implementation of information and communication technologies in the educational system: report on research (final)], (NII MM KazNU im. al’-Farabi: ruk. Mutanov G.M.; ispoln.: Mamykova ZH.D. No 0214RK01254/GR 0112RK01488. Almaty, 2014. 158)
[23] Osterwalder Alexander, Pigneur Yves Business Model Generation, A Handbook for Visionaries, Game Changers, and Challengers, (Written by John Wiley & Sons, 2011) 288
[24] Paklin N. B., Oreshkov V.I. Biznes analitika: ot dannykh k znaniyam: Uchebnoye posobiye [Business analysis: from data to knowledge: Textbook]. (2 izd., ispr. SPb.: Piter, 2013) 704
[25] Pererva A., Ivanova V. Put’ analitika. Prakticheskoye rukovodstvo IT-spetsialista [The Way of the Analyst. Practical guidance of the IT specialist]. (Piter, 2012) 304
[26] Ralston Barry. PowerPivot for Business Intelligence Using Excel and Sharepoint Business Intelligence Solutions for the Desktop (Apress, 2011) 277
[27] Ranjan J., "Business intelligence: concepts, components, techniques and benefits Journal of Theoretical and Applied Information Technology. Vol 9. No 1., 2005): 60 - 70.
[28] Robert Alvin, "Content Marketing Insights for IT Marketers Copyright B2B Marketers Start Here. NetLine Corporation. All rights reserved, Accessed May 20 2017. http://www.netline.com/netline002n/?d= hrcontentguide17&k= 170303nlwhrgd.
[29] Schmitz Dominik. Managing Dynamic Requirements Knowledge An Agent-Based Approach, Tag der mundlichen (Prufung: 20. Dezember, 2010) 346
[30] The project analytics framework Oracle Business Intelligence by Sid Goel (KPI Partners, 2012) 12
Downloads
How to Cite
Mutanov, G. M., Mamykova, J. D., Nadirbaeva, G. M., Kopnova, O. L., Zhaydarova, A. M., & Kistaubaev, E. B. (2018). Application of the cloud-based sevice of business intelligence in the information infrastructure of the higher education institution. Journal of Mathematics, Mechanics and Computer Science, 94(2), 46–58. Retrieved from https://bm.kaznu.kz/index.php/kaznu/article/view/445
Issue
Section
Computer Science
