BNAD 597A – Research, goals and expectations CLIENT: Arizona department of educationTeam: Aviral Choudhary, Pranav Bhandary, Kunbo Zhao, JayPatel, Manoj PrahaladaraoSection1: Research 1. Client background: Arizona department of education(ADE) is astate agency which oversees public education in the state of Arizona. ADEsupports about 15 county-level education agencies which covers more than 200public school districts. Its headquarters is located at downtown, Phoenix.State superintendent of public instructionis incahrge of ADE and the current superintendent is Diane Douglas. Lisa Byleris the deputy associate superintendent.
She has more than 15 years of experience in a fast-paced executiveenvironment as an experienced budget and procurement manager. 2. AZDash and OnlineReporting Guide: Internet Portalcalled “AZDash” will host all our dashboards and will be populated with datafrom a longitudinal operational data store (AgencyODS) from the ArizonaDepartment of Education (ADE) information system. AZDash consolidates andpresents student performance data using interactive dashboards, saving teacherstime. AZ merit have a online report guide.
Online Reporting System (ORS) haveall guidelines that needs to be followed. These guidelines include field names,accepted values, definitions and description, user roles and permissions,layout restrictions, norms followed by AZ merit. By this document, I understoodthe restrictions and format followed by AZ merit for reporting which will inturn help us to develop dashboards complaint to the online report guidelines 3. Project research: In thisproject, we would develop series of dashboards both using power BI and tableauto serve stakeholders in State of Arizona K-12 education system.
To understandthe requirements, we can break down the project research into three components i. Current Scenario and Scope: The current AZ Dash portal has over 30educator dashboards and over 100 individual visualization components and iscustom developed using Microsoft .Net framework. The goal of the project is to leveragebest of breed visualization software tominimize the cost to develop and maintain dashboards. In this initial phase ofthis project aims at developing a single dashboard that will display summarizedstudents results and identify trends in the results. Results obtained are of AZmerit, a computer based test measures critical thinking skills for college andcareer readiness ii. Data tell stories:The first step for any data analysis using visualization is to identify thesource of data.
In this project, source of data will be SQL server database. SQLserver database latest version is installed and its connection with theproposed visualization tools is tested. Appendix/ data dictionary is analyzed.
Our aim for this project is tell stories using data visualizations. This willbe accomplished by developing various types of visualization to appreciate andidentify trends in data. 3 suggested visualizations, i.e. histograms, stackedcharts and barrel chart will be used primarily. iii. Tools and itsadvantages: Tableau and power BI will be used for developing dashboards in thisproject.
Along with delivering dashboards and reports, it would be ourresponsibility to highlight pros and cons of each tool a. Visualizations: Bothsolutions provide visualizations. With Power BI you choose thevisualization first, then drag the data into it. In Tableau, you select thedata and switch between visualizations on the fly. It’s easier to jumpbetween visualizations in Tableau when compared to power BI b.
Data and trends discovery:Power BI is best suited for investigating setsof data when businesses outgrow Excel. However, some users feel Power BI may besluggish when working with extremely large data sets. Tableau has an advantagein this area due to its extensive features. c. Pricing: PowerBI Pro: $9.99/user/month. User receives 10 GB ofstorage.
A free version of powerBI is also available which provides just 1GB ofstorage Tableau: University edition is free withlimited features and storage for a year. Tableau professional is $70/user/month and tableau server is $35/user per month with a 10 user minimum. d. Cons:No product is perfect, below are the mostreported shortcomings:PowerBI: Customers have reported Power BI doesnot have the ability to publish reports with all associated data. This meanssome data or information can be bottled out. Because Power BI is still indevelopment, some customers have reported issues with existing sharing features. Tableau: Some customers have reported Tableauhas a steep learning curve for executives. Also, products are expensivefor smaller businesses.
With all this said, every tool behavesdifferently in different environment. Hence it would be our responsibility tohelp Arizona department of education to highlight pros and cons of both toolsduring every phase of this project.4. California Department of EducationAcademic Performance Index (API) Report:Californiadepartment of education measured the academic performance and growth of schoolson a variety of academic measures using Academic performance index. On March15, 2017, the State Board of Education (SBE) and the California Department ofEducation (CDE) launched a new accountability system to replace the AcademicPerformance Index (API) to better measure our State’s educational goals.
California’s new accountability system is available at the new California dashboardweb page. By analyzing this dashboard page, I was able gain insights on newtechniques and features adopted by California education department. One of thekey finding was five by five placement report guideline used. I was able toable to appreciate the use of colors to infer results.
Five-by-five coloredtable produced 25 results using five colors. Also, the Career Indicatorused multiple measures to provide a performance level based on the number ofstudents who are likely to be successful after high school References:http://www.azed.gov/https://en.wikipedia.org/wiki/Arizona_Department_of_Educationhttps://www.
gov/ta/ac/ap/Personal Goals for BNAD 597A During the course of this consulting project, I wish to accomplishfollowing goals. Technical goals: I would also want to gain experience on how to · Optimizerequirement gathering· Translatebusiness requirements into technical user stories· Developa solution from scratch· Employagile and scrum methodology· Attainproficiency in both visualization tools, i.e. Tableau, Power BI· Understanddata dictionary of existing database· Establishconnectivity between database and visualization tools· Tellstories from data· Compareboth visualization toolsProfessional development goals:· TEAMWORK: To apply the things learned during business communication class on how toeffectively work in a team· Todevelop and enhance critical thinking· Tocollaborate and establish a bond between our team mates· Tobe pro active· Tobe organized· Towork towards the project milestone by accomplishing individual goals· Tounderstand my role and respect roles of other teammates