connectors and protocols, Power BI Desktop is the component in Architecture where the data is analyzed and transformed through some procedure using tools and made to report on the web by means of several visuals, tools and publish feature. There are two types of visuals in power BI. 1) Microsoft Visuals, 2) Custom Visuals.
These are the official visuals from Microsoft, and some were built-in visuals in power BI installation package.
They are secured in nature and following are the official Visuals of Microsoft such as Stacked bar chart, line chart, Waterfall chart, Area Chart, Clustered Bar chart, Slicer, table, and Matrix?etc.
These visuals contexts are developed by the third party or the end users such as developers and these are shared among the users through the portal like office store and git Hub. They are unsecured in nature and following are the Custom visuals provided by third party and Microsoft officials such as dot plot, route map, flow map, journey chart, and scroller?etc. e) Visualize: In this step, the analyzed and processed data is visualized through means of visuals such as Microsoft Power BI Visuals and Custom Visuals like plots, graphs, slicer, KPI...Etc. After this process, the report is published to power BI services.
f) Editing: In this step, the published report on to web is finalized after rectifying errors for any changes such as if any filters or visuals need to solve and after completion of the editing process, the report is made to publish on the web.
g) Web: As said above step, it is a state where the report is converted into the dashboard, and it can be share-able via URLs, websites. Etc. Details of Data Sources
Marija Blagojevic et al. [1] studied on web-based intelligent report of e-learning system by using the technique of data mining and it deals about PDCA method such as (Plan, Do Check, Act) for improving the web-based intelligent reports of eLearning system by means of data mining techniques and concluded that their proposed system has an improvement since it predicts behavior patterns thus leading to the increase in count of participants and in there study ,it proved that their proposed system has improvements in terms of report system in the field of LMS (learning management system) or e-learning . Moreover, the development and implementation of new modules.
Daniel J.Power [2]studied the data-driven decision support system and it deals with data-driven decision support system and its advantages at Business Intelligence and concluded that mainframe-based decision support systems would need to be updated or replaced by web-based or web-enabled systems the accessibility reach for data-driven decision support systems are open source software's, new hardware's, web technologies, etc.
Zhijun Ren [3] studied the delivering of a comprehensive Business Intelligence solution using Microsoft Business Intelligence stack and it deals about features and advantages of business intelligence stack of Microsoft and concluded that by integrating several technologies such as database, connectors, SharePoint servers, and business intelligence tools will lead to Faster delivery of comprehensive business intelligence solution within an enterprise Guangzhi Zheng et al. [4] studied on business intelligence to healthcare informatics Curriculum and their paper deals with the preliminary analysis of integration of Business Intelligence with Healthcare Information Technology and concluded that Business Intelligence had been a neglected part in many healthcare information technology programs yet both the industry and academia have realized the importance of Business Intelligence Michelle Hoda Wilkerson et al. [5]done work on youth reasoning with interactive data visualization and it deals with the youth understanding of data by interactive data visualization, they concluded that supporting learners in the coordination of any resources they choose to leverage is more likely helpful than supporting a particular approach or sequence of resource use Yuri Vanessa Nieto et al. [6]done a work on academic decision-making model for higher education institutions with the help of learning analytics .it deals with modeling and construction of software architecture for creating and categorizing indicators and they concluded that proposed software architecture has benefit of providing integration of learning analytics indicators and supports decision making in universities.
In Power BI, the different types of data are fetched by means of getting data function from different data sources and the different data sources are Files, Database, Azure, Online Services and other, the detailed description of data sources as shown in details of data sources After selecting the Data sources, we have to get the data by means of queries (if the data source is other than files) or selecting files from folders. The data will be loaded in the Power BI tool and before making the report in the power BI tool, the uploaded data should be Analysed and Corrected for error freed data through edit queries function in data part of Power BI tool and we can have relations between different datasets by means of relationships part, As the option is seen at the left side of the power BI tool, if we required any conditional columns or to add new data in datasets by means of edit queries function we can proceed it and next step is to make report by means of clicking on report option and white empty sheet appears on the screen where we create our own report. The analyzed and corrected data is visualized by means of different Visuals such as Custom Visuals and Power BI Visuals such as stacked bar chart, stacked column chart and by means of Publish option the report is published on the Power BI Services. We have to log in to power bi services, if required we can do any editing operations otherwise the report is made into the dashboard by means of publish on the web
Volume XVIII Issue IV Version I As shown in the Pseudo code Algorithms 1,2, and 3 for different modules, Firstly the tool Programme is started and required data such as P i , P ii , P iii in Algorithms 1,2 and 3 are captured into the tool from different data sources via getting data function and dataset is viewed if any corrections to be done for selected data and then data is initialized with multiple columns such as P at , P t1 , P t2 , P ha , P q , P ch , P ca , P Api , P am ,P id , P na , P up , P Qf , P br , P st , P cn , P lp as shown in Pseudo-Code 1,2,and 3 respectively where different datasets contain a different number of columns. If required Uploaded dataset is processed by means of string operations, otherwise by means of queries conditional columns are created in datasets using edit queries as shown in pseudo code 1 and 2 with mathematical and conditional operations and then the dataset is Visualized through Microsoft Power Bi Visuals, by visualization of datasets report process is completed and then it is published to power BI Services by means of Publish function in the tool. After Publishing the report into the services of Power BI, the report is made into the dashboard by means of clicking publish on to web function in the file tab and then generated link can be shareable to anyone, it can be share to individuals of organization by means of Uniform Resource Locator (URL) directly or indirectly by means of SharePoint, Website,..Etc., as shown in the Results and discussion section.
After publishing the dashboard to the power BI services it appears as shown in below figure and we can have some editing operations if any filters or visuals are not properly accessible then they can be rectified here before publishing on to the web. Not only above discussed modules, we can have dashboards of different modules of every educational institution, it may be related to staffs, Infrastructure and other Amenities of institutions...Etc. following are the results of dashboards of discussed modules of educational Institutions.
P ape =P at /5*100 | |||||
Create new Column P t1pe | |||||
Data Format | Data Sources | P t1pe =P t1 /20*100 Create new Column P t2pe | |||
Files | Excel, Text/CSV, XML, JSON, Folder, Share Point Folder | P t2 pe=P t2 /20*100 Create new Column P qpe | |||
Pseudo Code Algorithm 3: | P qpe =P q /5*100 | ||||
C ( ) Volume XVIII Issue IV Version I 4 Year 2018 | Database Azure Online Services Other Pseudo Code Algorithms: SQL SERVER, ACCESS, ORACLE, IBM DB2, IBM INFORMIX, IBM NETEZZA, MySQL, Postgre, Sysbase, Teradata, SAP, Google Bigquery, etc. Azure SQL database, Azure SQL Data Warehouse, Azure Blob Storage, Azure Table Storage, Azure HD Insight(HDFS), etc. Power Bi service, Share point online list, Dynamics 365, Microsoft Exchange Online, Salesforce, Google Analytics, Facebook, Github, etc. Web, SharePoint list, OData Feed, Active Directory, Microsoft Exchange, Hadoop File(HDFS), R Script, ODBC, OLE DB, etc. Pseudo Code Algorithm 1: Start Create new column P ap P ap =P ca /P ch *100; Create new column P am P am = If P ap ==100, 5 Else If P ap >=95, View 'P i ' Get 'P i ' Start Get 'P iii ' View 'P iii ' | notations P i = Dataset of Students Internal marks from different data sources P at = Variable name of Assignment Test marks P t1 = Variable name of Test 1 marks P t2 = Variable name of Test 2 marks P ha = Variable name of Home Assignment marks P q = Variable name of Quiz exam P ca = Variable name of Classes Attended P ch = Variable name of classes held Publish the Report to power bi services Create new Column P hape P hape =P ha /5*100 Visualize the above-considered variables using different Visuals | 3 Year 2018 ( ) C | ||
Global Journal of Computer Science and Technology | Else If P ap >=90, Else If P ap >=85, Else If P ap >=80, Else If P ap >=75, Create new column P ttm Else 0 P ttm =If P t1 <P t2 , ((P t2 *0.75) + (P t1 *0.25)) Else ((P t2 *0.25) + (P t1 *0.75)) Create new column Pt, P t =P at +P ha +P q +P am +P ttm Create new column P fs P fs =If P t >=16, Promotion Else If P t <16, Detention | P ape =Variable name of assignment test performance P am =Variable name of Attendance marks P ap = Variable name of attendance percentage P t = Variable name of the total percentage P ttm =Variable name of test total marks P fs =Variable name of Final Status X t1pe = Variable name of Test 1 Performance P t2pe = Variable name of Test 2 Performance P qp = Variable name of quiz performance P hap = Variable name of Home Assignment Performance Pseudo Code Algorithm 2: Start Get 'P ii ' View 'P ii ' | |||
Else If P ap <65, Detention | Initialise P id ,P na ,P up ,P Qf ,P br ,P st ,P cn ,P lp | ||||
Else If P ap >75&&P ap <=100, Promotion | Processing of P ii by means of string operations | ||||
Else Condonation Else Error | If | P ap >=65&&P t >=16&&P ap <75, | Visualize the above-considered variables using different Visuals Publish the Report to power bi services notations | ||
Create new column P ape | P id = Variable name of id number | ||||
© 2018 Global Journals |
A multilevel algorithm for forcedirected graph drawing. Proceedings of Graph Drawing, (Graph DrawingBerlin Heidelberg
Understanding Data-Driven Decision Support Systems. Information Systems management 2008. 25 (2) p. .
Identification of varying standard of student based on Moodle Pattern Identification Business Intelligence Tool. Proceedings of the International Symposium on ICT for sustainable development, (the International Symposium on ICT for sustainable development) p. .
A web-based Intelligent report e-learning system using data mining technique. Computers and Electrical Engineering 2013. Elsevier. 39 p. .
How to display group information on node-link diagrams: an evaluation. IEEE Transactions on Visualization & Computer Graphics 2014. 20 (11) p. .
Academic Decision Making model for higher education institutions using learning analytics. th International Symposium on computational and Business Intelligence, 2016. p. .
Delivering a Comprehensive BI solution with Microsoft Business Intelligence Stack. International Conference on Challenges in Environmental Science and Computer Engineering 2010. 183 p. .