\documentclass[11pt,twoside]{article}\makeatletter

\IfFileExists{xcolor.sty}%
  {\RequirePackage{xcolor}}%
  {\RequirePackage{color}}
\usepackage{colortbl}
\usepackage{wrapfig}
\usepackage{ifxetex}
\ifxetex
  \usepackage{fontspec}
  \usepackage{xunicode}
  \catcode`⃥=\active \def⃥{\textbackslash}
  \catcode`❴=\active \def❴{\{}
  \catcode`❵=\active \def❵{\}}
  \def\textJapanese{\fontspec{Noto Sans CJK JP}}
  \def\textChinese{\fontspec{Noto Sans CJK SC}}
  \def\textKorean{\fontspec{Noto Sans CJK KR}}
  \setmonofont{DejaVu Sans Mono}
  
\else
  \IfFileExists{utf8x.def}%
   {\usepackage[utf8x]{inputenc}
      \PrerenderUnicode{–}
    }%
   {\usepackage[utf8]{inputenc}}
  \usepackage[english]{babel}
  \usepackage[T1]{fontenc}
  \usepackage{float}
  \usepackage[]{ucs}
  \uc@dclc{8421}{default}{\textbackslash }
  \uc@dclc{10100}{default}{\{}
  \uc@dclc{10101}{default}{\}}
  \uc@dclc{8491}{default}{\AA{}}
  \uc@dclc{8239}{default}{\,}
  \uc@dclc{20154}{default}{ }
  \uc@dclc{10148}{default}{>}
  \def\textschwa{\rotatebox{-90}{e}}
  \def\textJapanese{}
  \def\textChinese{}
  \IfFileExists{tipa.sty}{\usepackage{tipa}}{}
\fi
\def\exampleFont{\ttfamily\small}
\DeclareTextSymbol{\textpi}{OML}{25}
\usepackage{relsize}
\RequirePackage{array}
\def\@testpach{\@chclass
 \ifnum \@lastchclass=6 \@ne \@chnum \@ne \else
  \ifnum \@lastchclass=7 5 \else
   \ifnum \@lastchclass=8 \tw@ \else
    \ifnum \@lastchclass=9 \thr@@
   \else \z@
   \ifnum \@lastchclass = 10 \else
   \edef\@nextchar{\expandafter\string\@nextchar}%
   \@chnum
   \if \@nextchar c\z@ \else
    \if \@nextchar l\@ne \else
     \if \@nextchar r\tw@ \else
   \z@ \@chclass
   \if\@nextchar |\@ne \else
    \if \@nextchar !6 \else
     \if \@nextchar @7 \else
      \if \@nextchar (8 \else
       \if \@nextchar )9 \else
  10
  \@chnum
  \if \@nextchar m\thr@@\else
   \if \@nextchar p4 \else
    \if \@nextchar b5 \else
   \z@ \@chclass \z@ \@preamerr \z@ \fi \fi \fi \fi
   \fi \fi  \fi  \fi  \fi  \fi  \fi \fi \fi \fi \fi \fi}
\gdef\arraybackslash{\let\\=\@arraycr}
\def\@textsubscript#1{{\m@th\ensuremath{_{\mbox{\fontsize\sf@size\z@#1}}}}}
\def\Panel#1#2#3#4{\multicolumn{#3}{){\columncolor{#2}}#4}{#1}}
\def\abbr{}
\def\corr{}
\def\expan{}
\def\gap{}
\def\orig{}
\def\reg{}
\def\ref{}
\def\sic{}
\def\persName{}\def\name{}
\def\placeName{}
\def\orgName{}
\def\textcal#1{{\fontspec{Lucida Calligraphy}#1}}
\def\textgothic#1{{\fontspec{Lucida Blackletter}#1}}
\def\textlarge#1{{\large #1}}
\def\textoverbar#1{\ensuremath{\overline{#1}}}
\def\textquoted#1{‘#1’}
\def\textsmall#1{{\small #1}}
\def\textsubscript#1{\@textsubscript{\selectfont#1}}
\def\textxi{\ensuremath{\xi}}
\def\titlem{\itshape}
\newenvironment{biblfree}{}{\ifvmode\par\fi }
\newenvironment{bibl}{}{}
\newenvironment{byline}{\vskip6pt\itshape\fontsize{16pt}{18pt}\selectfont}{\par }
\newenvironment{citbibl}{}{\ifvmode\par\fi }
\newenvironment{docAuthor}{\ifvmode\vskip4pt\fontsize{16pt}{18pt}\selectfont\fi\itshape}{\ifvmode\par\fi }
\newenvironment{docDate}{}{\ifvmode\par\fi }
\newenvironment{docImprint}{\vskip 6pt}{\ifvmode\par\fi }
\newenvironment{docTitle}{\vskip6pt\bfseries\fontsize{22pt}{25pt}\selectfont}{\par }
\newenvironment{msHead}{\vskip 6pt}{\par}
\newenvironment{msItem}{\vskip 6pt}{\par}
\newenvironment{rubric}{}{}
\newenvironment{titlePart}{}{\par }

\newcolumntype{L}[1]{){\raggedright\arraybackslash}p{#1}}
\newcolumntype{C}[1]{){\centering\arraybackslash}p{#1}}
\newcolumntype{R}[1]{){\raggedleft\arraybackslash}p{#1}}
\newcolumntype{P}[1]{){\arraybackslash}p{#1}}
\newcolumntype{B}[1]{){\arraybackslash}b{#1}}
\newcolumntype{M}[1]{){\arraybackslash}m{#1}}
\definecolor{label}{gray}{0.75}
\def\unusedattribute#1{\sout{\textcolor{label}{#1}}}
\DeclareRobustCommand*{\xref}{\hyper@normalise\xref@}
\def\xref@#1#2{\hyper@linkurl{#2}{#1}}
\begingroup
\catcode`\_=\active
\gdef_#1{\ensuremath{\sb{\mathrm{#1}}}}
\endgroup
\mathcode`\_=\string"8000
\catcode`\_=12\relax

\usepackage[a4paper,twoside,lmargin=1in,rmargin=1in,tmargin=1in,bmargin=1in,marginparwidth=0.75in]{geometry}
\usepackage{framed}

\definecolor{shadecolor}{gray}{0.95}
\usepackage{longtable}
\usepackage[normalem]{ulem}
\usepackage{fancyvrb}
\usepackage{fancyhdr}
\usepackage{graphicx}
\usepackage{marginnote}

\renewcommand{\@cite}[1]{#1}


\renewcommand*{\marginfont}{\itshape\footnotesize}

\def\Gin@extensions{.pdf,.png,.jpg,.mps,.tif}

  \pagestyle{fancy}

\usepackage[pdftitle={Analysis and Design of Visualization of Educational Institution Database using Power BI Tool},
 pdfauthor={}]{hyperref}
\hyperbaseurl{}

	 \paperwidth210mm
	 \paperheight297mm
              
\def\@pnumwidth{1.55em}
\def\@tocrmarg {2.55em}
\def\@dotsep{4.5}
\setcounter{tocdepth}{3}
\clubpenalty=8000
\emergencystretch 3em
\hbadness=4000
\hyphenpenalty=400
\pretolerance=750
\tolerance=2000
\vbadness=4000
\widowpenalty=10000

\renewcommand\section{\@startsection {section}{1}{\z@}%
     {-1.75ex \@plus -0.5ex \@minus -.2ex}%
     {0.5ex \@plus .2ex}%
     {\reset@font\Large\bfseries}}
\renewcommand\subsection{\@startsection{subsection}{2}{\z@}%
     {-1.75ex\@plus -0.5ex \@minus- .2ex}%
     {0.5ex \@plus .2ex}%
     {\reset@font\Large}}
\renewcommand\subsubsection{\@startsection{subsubsection}{3}{\z@}%
     {-1.5ex\@plus -0.35ex \@minus -.2ex}%
     {0.5ex \@plus .2ex}%
     {\reset@font\large}}
\renewcommand\paragraph{\@startsection{paragraph}{4}{\z@}%
     {-1ex \@plus-0.35ex \@minus -0.2ex}%
     {0.5ex \@plus .2ex}%
     {\reset@font\normalsize}}
\renewcommand\subparagraph{\@startsection{subparagraph}{5}{\parindent}%
     {1.5ex \@plus1ex \@minus .2ex}%
     {-1em}%
     {\reset@font\normalsize\bfseries}}


\def\l@section#1#2{\addpenalty{\@secpenalty} \addvspace{1.0em plus 1pt}
 \@tempdima 1.5em \begingroup
 \parindent \z@ \rightskip \@pnumwidth 
 \parfillskip -\@pnumwidth 
 \bfseries \leavevmode #1\hfil \hbox to\@pnumwidth{\hss #2}\par
 \endgroup}
\def\l@subsection{\@dottedtocline{2}{1.5em}{2.3em}}
\def\l@subsubsection{\@dottedtocline{3}{3.8em}{3.2em}}
\def\l@paragraph{\@dottedtocline{4}{7.0em}{4.1em}}
\def\l@subparagraph{\@dottedtocline{5}{10em}{5em}}
\@ifundefined{c@section}{\newcounter{section}}{}
\@ifundefined{c@chapter}{\newcounter{chapter}}{}
\newif\if@mainmatter 
\@mainmattertrue
\def\chaptername{Chapter}
\def\frontmatter{%
  \pagenumbering{roman}
  \def\thechapter{\@roman\c@chapter}
  \def\theHchapter{\roman{chapter}}
  \def\thesection{\@roman\c@section}
  \def\theHsection{\roman{section}}
  \def\@chapapp{}%
}
\def\mainmatter{%
  \cleardoublepage
  \def\thechapter{\@arabic\c@chapter}
  \setcounter{chapter}{0}
  \setcounter{section}{0}
  \pagenumbering{arabic}
  \setcounter{secnumdepth}{6}
  \def\@chapapp{\chaptername}%
  \def\theHchapter{\arabic{chapter}}
  \def\thesection{\@arabic\c@section}
  \def\theHsection{\arabic{section}}
}
\def\backmatter{%
  \cleardoublepage
  \setcounter{chapter}{0}
  \setcounter{section}{0}
  \setcounter{secnumdepth}{2}
  \def\@chapapp{\appendixname}%
  \def\thechapter{\@Alph\c@chapter}
  \def\theHchapter{\Alph{chapter}}
  \appendix
}
\newenvironment{bibitemlist}[1]{%
   \list{\@biblabel{\@arabic\c@enumiv}}%
       {\settowidth\labelwidth{\@biblabel{#1}}%
        \leftmargin\labelwidth
        \advance\leftmargin\labelsep
        \@openbib@code
        \usecounter{enumiv}%
        \let\p@enumiv\@empty
        \renewcommand\theenumiv{\@arabic\c@enumiv}%
	}%
  \sloppy
  \clubpenalty4000
  \@clubpenalty \clubpenalty
  \widowpenalty4000%
  \sfcode`\.\@m}%
  {\def\@noitemerr
    {\@latex@warning{Empty `bibitemlist' environment}}%
    \endlist}

\def\tableofcontents{\section*{\contentsname}\@starttoc{toc}}
\parskip0pt
\parindent1em
\def\Panel#1#2#3#4{\multicolumn{#3}{){\columncolor{#2}}#4}{#1}}
\newenvironment{reflist}{%
  \begin{raggedright}\begin{list}{}
  {%
   \setlength{\topsep}{0pt}%
   \setlength{\rightmargin}{0.25in}%
   \setlength{\itemsep}{0pt}%
   \setlength{\itemindent}{0pt}%
   \setlength{\parskip}{0pt}%
   \setlength{\parsep}{2pt}%
   \def\makelabel##1{\itshape ##1}}%
  }
  {\end{list}\end{raggedright}}
\newenvironment{sansreflist}{%
  \begin{raggedright}\begin{list}{}
  {%
   \setlength{\topsep}{0pt}%
   \setlength{\rightmargin}{0.25in}%
   \setlength{\itemindent}{0pt}%
   \setlength{\parskip}{0pt}%
   \setlength{\itemsep}{0pt}%
   \setlength{\parsep}{2pt}%
   \def\makelabel##1{\upshape ##1}}%
  }
  {\end{list}\end{raggedright}}
\newenvironment{specHead}[2]%
 {\vspace{20pt}\hrule\vspace{10pt}%
  \phantomsection\label{#1}\markright{#2}%

  \pdfbookmark[2]{#2}{#1}%
  \hspace{-0.75in}{\bfseries\fontsize{16pt}{18pt}\selectfont#2}%
  }{}
      \def\TheFullDate{2018-01-15 (revised: 15 January 2018)}
\def\TheID{\makeatother }
\def\TheDate{2018-01-15}
\title{Analysis and Design of Visualization of Educational Institution Database using Power BI Tool}
\author{}\makeatletter 
\makeatletter
\newcommand*{\cleartoleftpage}{%
  \clearpage
    \if@twoside
    \ifodd\c@page
      \hbox{}\newpage
      \if@twocolumn
        \hbox{}\newpage
      \fi
    \fi
  \fi
}
\makeatother
\makeatletter
\thispagestyle{empty}
\markright{\@title}\markboth{\@title}{\@author}
\renewcommand\small{\@setfontsize\small{9pt}{11pt}\abovedisplayskip 8.5\p@ plus3\p@ minus4\p@
\belowdisplayskip \abovedisplayskip
\abovedisplayshortskip \z@ plus2\p@
\belowdisplayshortskip 4\p@ plus2\p@ minus2\p@
\def\@listi{\leftmargin\leftmargini
               \topsep 2\p@ plus1\p@ minus1\p@
               \parsep 2\p@ plus\p@ minus\p@
               \itemsep 1pt}
}
\makeatother
\fvset{frame=single,numberblanklines=false,xleftmargin=5mm,xrightmargin=5mm}
\fancyhf{} 
\setlength{\headheight}{14pt}
\fancyhead[LE]{\bfseries\leftmark} 
\fancyhead[RO]{\bfseries\rightmark} 
\fancyfoot[RO]{}
\fancyfoot[CO]{\thepage}
\fancyfoot[LO]{\TheID}
\fancyfoot[LE]{}
\fancyfoot[CE]{\thepage}
\fancyfoot[RE]{\TheID}
\hypersetup{citebordercolor=0.75 0.75 0.75,linkbordercolor=0.75 0.75 0.75,urlbordercolor=0.75 0.75 0.75,bookmarksnumbered=true}
\fancypagestyle{plain}{\fancyhead{}\renewcommand{\headrulewidth}{0pt}}

\date{}
\usepackage{authblk}

\providecommand{\keywords}[1]
{
\footnotesize
  \textbf{\textit{Index terms---}} #1
}

\usepackage{graphicx,xcolor}
\definecolor{GJBlue}{HTML}{273B81}
\definecolor{GJLightBlue}{HTML}{0A9DD9}
\definecolor{GJMediumGrey}{HTML}{6D6E70}
\definecolor{GJLightGrey}{HTML}{929497} 

\renewenvironment{abstract}{%
   \setlength{\parindent}{0pt}\raggedright
   \textcolor{GJMediumGrey}{\rule{\textwidth}{2pt}}
   \vskip16pt
   \textcolor{GJBlue}{\large\bfseries\abstractname\space}
}{%   
   \vskip8pt
   \textcolor{GJMediumGrey}{\rule{\textwidth}{2pt}}
   \vskip16pt
}

\usepackage[absolute,overlay]{textpos}

\makeatother 
      \usepackage{lineno}
      \linenumbers
      
\begin{document}

             \author[1]{Mandava Geetha  Bhargava}

             \author[2]{Kuppa Tara Phani Surya  Kiran}

             \author[3]{Duvvada Rajeswara  Rao}

             \affil[1]{  KL University}

\renewcommand\Authands{ and }

\date{\small \em Received: 14 December 2017 Accepted: 5 January 2018 Published: 15 January 2018}

\maketitle


\begin{abstract}
        


Visualization of data set is a process of making understand the significance of data through visual context and part of data analytics where it?s executed after the data correction. Nowadays visualization is more useful in business intelligence and Analytics in every field, There are different techniques for visualizing the datasets, it may be in dynamic or interactive nature, and datasets can be visualized in different types of visuals insights, This paper deals with the interactive visualization of educational institution database using Microsoft Power BI Tool with different modules and this paper focuses on process model, operations of Microsoft Power BI, types of data sources available in Tool and its different related types of visual insights or context.

\end{abstract}


\keywords{analytics, visualization, business intelligence, insights.}

\begin{textblock*}{18cm}(1cm,1cm) % {block width} (coords) 
\textcolor{GJBlue}{\LARGE Global Journals \LaTeX\ JournalKaleidoscope\texttrademark}
\end{textblock*}

\begin{textblock*}{18cm}(1.4cm,1.5cm) % {block width} (coords) 
\textcolor{GJBlue}{\footnotesize \\ Artificial Intelligence formulated this projection for compatibility purposes from the original article published at Global Journals. However, this technology is currently in beta. \emph{Therefore, kindly ignore odd layouts, missed formulae, text, tables, or figures.}}
\end{textblock*}


\let\tabcellsep& 	 	 		 
\section[{Introduction}]{Introduction}\par
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. 
\section[{1) Microsoft Visuals}]{1) Microsoft Visuals}\par
These are the official visuals from Microsoft, and some were built-in visuals in power BI installation package.\par
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. 
\section[{2) Custom Visuals}]{2) Custom Visuals}\par
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.\par
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.\par
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  
\section[{Literature Reviews}]{Literature Reviews}\par
Marija Blagojevic et al. \hyperref[b0]{[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.\par
Daniel J.Power \hyperref[b1]{[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.\par
Zhijun Ren \hyperref[b2]{[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. \hyperref[b3]{[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. \hyperref[b4]{[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. \hyperref[b5]{[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. 
\section[{VI.}]{VI.} 
\section[{Methodology}]{Methodology}\par
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 
\section[{Global Journal of Computer Science and Technology}]{Global Journal of Computer Science and Technology}\par
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. 
\section[{VII.}]{VII.} 
\section[{Results and Discussion}]{Results and Discussion}\par
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.   \begin{figure}[htbp]
\noindent\textbf{1}\includegraphics[]{image-2.png}
\caption{\label{fig_0}Fig. 1 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{}\includegraphics[]{image-3.png}
\caption{\label{fig_1}a)}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{2}\includegraphics[]{image-4.png}
\caption{\label{fig_2}Fig. 2 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{345}\includegraphics[]{image-5.png}
\caption{\label{fig_3}Fig. 3 :Fig. 4 :Fig. 5 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{68}\includegraphics[]{image-6.png}
\caption{\label{fig_4}Fig 6 :Fig. 8 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{79}\includegraphics[]{image-7.png}
\caption{\label{fig_5}Fig. 7 :Fig. 9 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{1} \par 
\begin{longtable}{}
\end{longtable} \par
 
\caption{\label{tab_0}Table 1 :}\end{figure}
 \begin{figure}[htbp]
\noindent\textbf{} \par 
\begin{longtable}{P{0.02885348112227225\textwidth}P{0.36655697956356076\textwidth}P{0.016487703498441288\textwidth}P{0.013543470730862487\textwidth}P{0.41955316937997916\textwidth}P{0.0050051957048839624\textwidth}}
\tabcellsep \tabcellsep \tabcellsep \tabcellsep P ape =P at /5*100\\
\tabcellsep \tabcellsep \tabcellsep \tabcellsep Create new Column P t1pe\\
\tabcellsep Data Format\tabcellsep \tabcellsep Data Sources\tabcellsep P t1pe =P t1 /20*100 Create new Column P t2pe\\
\tabcellsep Files\tabcellsep \multicolumn{2}{l}{Excel, Text/CSV, XML, JSON, Folder, Share Point Folder}\tabcellsep P t2 pe=P t2 /20*100 Create new Column P qpe\\
\tabcellsep \multicolumn{3}{l}{Pseudo Code Algorithm 3:}\tabcellsep P qpe =P q /5*100\\
C ( ) Volume XVIII Issue IV Version I 4 Year 2018\tabcellsep \multicolumn{3}{l}{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 '}\tabcellsep 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\tabcellsep 3 Year 2018 ( ) C\\
Global Journal of Computer Science and Technology\tabcellsep \multicolumn{3}{l}{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}\tabcellsep 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 '\\
\tabcellsep \multicolumn{3}{l}{Else If P ap <65, Detention}\tabcellsep Initialise P id ,P na ,P up ,P Qf ,P br ,P st ,P cn ,P lp\\
\tabcellsep \multicolumn{3}{l}{Else If P ap >75\&\&P ap <=100, Promotion}\tabcellsep Processing of P ii by means of string operations\\
\tabcellsep Else Condonation Else Error\tabcellsep If\tabcellsep P ap >=65\&\&P t >=16\&\&P ap <75,\tabcellsep Visualize the above-considered variables using different Visuals Publish the Report to power bi services notations\\
\tabcellsep \multicolumn{2}{l}{Create new column P ape}\tabcellsep \tabcellsep P id = Variable name of id number\\
\tabcellsep \tabcellsep \tabcellsep \tabcellsep © 2018 Global Journals\end{longtable} \par
  {\small\itshape [Note: functionality]} 
\caption{\label{tab_1}}\end{figure}
 			\footnote{© 2018 Global Journals} 		 		\backmatter  			  				\begin{bibitemlist}{1}
\bibitem[Power et al. (2017)]{b10}\label{b10} 	 		\textit{},  		 			Microsoft Power 		,  		 			B I Organization 		,  		 			Microsoft Power 		,  		 			B I Website 		.  		 \url{https://powerbi.microsoft.com/en-us/what-is-power-bi}  		September 2017.  	 
\bibitem[Zhu et al.]{b9}\label{b9} 	 		\textit{A framework based approach to utility big data analytics},  		 			Jun Zhu 		,  		 			Eric Zhuang 		,  		 			Jian Fu 		,  		 			John Baranowski 		,  		 			Andrew Ford 		,  		 			James Shen 		.  		31 p. .  	 
\bibitem[Walshaw ()]{b12}\label{b12} 	 		‘A multilevel algorithm for forcedirected graph drawing’.  		 			C Walshaw 		.  	 	 		\textit{Proceedings of Graph Drawing},  				 (Graph DrawingBerlin Heidelberg)  		2000. Springer. p. .  	 
\bibitem[Blagojevic and Micic ()]{b0}\label{b0} 	 		‘A web-based Intelligent report e-learning system using data mining technique’.  		 			Marija Blagojevic 		,  		 			Zivadin Micic 		.  	 	 		\textit{Computers and Electrical Engineering}  		2013. Elsevier. 39 p. .  	 
\bibitem[Nieto et al. ()]{b5}\label{b5} 	 		‘Academic Decision Making model for higher education institutions using learning analytics’.  		 			Yuri Vanesa Nieto 		,  		 			Vicente Garcia Diaz 		,  		 			Carlos Enrique Montenegro 		.  	 	 		\textit{th International Symposium on computational and Business Intelligence},  				2016. p. .  	 
\bibitem[Villegas-Ch and Lujan-Mora ()]{b6}\label{b6} 	 		\textit{Analysis of data mining techniques applied to LMS for personalized education},  		 			W Villegas-Ch 		,  		 			S Lujan-Mora 		.  		2017.  	 
\bibitem[Ren ()]{b2}\label{b2} 	 		‘Delivering a Comprehensive BI solution with Microsoft Business Intelligence Stack’.  		 			Zhijun Ren 		.  	 	 		\textit{International Conference on Challenges in Environmental Science and Computer Engineering}  		2010. 183 p. .  	 
\bibitem[Jianu et al. ()]{b11}\label{b11} 	 		‘How to display group information on node-link diagrams: an evaluation’.  		 			R Jianu 		,  		 			A Rusu 		,  		 			Y Hu 		,  		 			D Taggart 		.  	 	 		\textit{IEEE Transactions on Visualization \& Computer Graphics}  		2014. 20  (11)  p. .  	 
\bibitem[Jayakody and Allagalla]{b7}\label{b7} 	 		‘Identification of varying standard of student based on Moodle Pattern Identification Business Intelligence Tool’.  		 			J R K C Jayakody 		,  		 			W H P Allagalla 		.  	 	 		\textit{Proceedings of the International Symposium on ICT for sustainable development},  				 (the International Symposium on ICT for sustainable development)  		p. .  	 
\bibitem[Syed Mohd Ali et al. ()]{b8}\label{b8} 	 		 			Noopur Syed Mohd Ali 		,  		 			Gupta 		,  		 			Krishna Gopala 		,  		 			Rakesh Nayak 		,  		 			Kumar Lenka 		.  		\textit{Big data Visualization: Tools and Challenges, Contemporary Computing and Informatics (IC31)},  				2016. p. .  	 
\bibitem[Nguyen et al. (2015)]{b13}\label{b13} 	 		\textit{Time Sets: Timeline visualization with set relations. Information Visualization},  		 			P H Nguyen 		,  		 			K Xu 		,  		 			R Walker 		,  		 			B W Wong 		.  		 \xref{http://dx.doi.org/=10.1177/1473871615605347}{=10.1177/1473871615605347}.  		2015. Oct 2015.  	 
\bibitem[Power ()]{b1}\label{b1} 	 		‘Understanding Data-Driven Decision Support Systems’.  		 			Daniel J Power 		.  	 	 		\textit{Information Systems management}  		2008. 25  (2)  p. .  	 
\bibitem[Hoda Wilkerson and Laina ()]{b4}\label{b4} 	 		\textit{Youth Reasoning with Interactive Data Visualizations: A preliminary study},  		 			Michelle Hoda Wilkerson 		,  		 			Vasiliki Laina 		.  		2017. p. .  	 
\bibitem[Zheng et al. ()]{b3}\label{b3} 	 		 			Guangzhi Zheng 		,  		 			Chi Zhang 		,  		 			Lei Li 		.  		\textit{Bringing Business Intelligence to HealthCare Informatics Curriculum: A Preliminary Investigation, SIGCSE '14 Proceedings of the 45 th ACM technical symposium on computer science education},  				2014. p. .  	 
\end{bibitemlist}
 			 		 	 
\end{document}
