About the Project
LAUSD is committed to implementing a new self-service approach to ad hoc reporting for MiSiS, MyData, and Welligent users. This approach empowers central office, local district, and school administrators to easily access, create, and share reports to support data-driven initiatives. The new approach requires replacing the existing ad hoc reporting capability, MiSiS Explorer, with a more robust ad hoc reporting tool – Oracle Business Intelligence Foundation Suite – which enables end users to create personalized reports with minimal or no IT involvement.
Frequently Asked Questions
Q. Why is LAUSD switching to the new Ad Hoc Reporting tool?
A. LAUSD is making the switch to provide a self-service approach to producing reports and data extracts that LAUSD school, local district, and central office staff can use in data-driven initiatives. There are limitations in MiSiS Explorer, which the new ad hoc reporting tool will address, such as limited historical data, lack of dashboard capability, and inability to extract data for multiple schools, to name a few. MiSiS Ad Hoc Reporting and Dashboards also provides more data to choose from than the old MiSiS Explorer and SIS systems, providing greater flexibility in creating reports.Q. What are the benefits of this project?
A. Implementing the new ad hoc reporting tool will improve the experience of generating reports using data found in MiSiS. Some of the major benefits include:
Q. What is ad hoc reporting?
- Flexibility – Provides more flexibility in MiSiS ad hoc reporting, now allowing users to create reports at the local district and LAUSD levels if they have access to that data.
- Self-Service Approach – Eliminates the need to request new reports to be created by IT – users can create and personalize their own reports.
- Dashboards – Provides dashboards to various types of users (administrators, central office staff, school officials, etc.) consisting of the information those users need to have to succeed.
- Historical Data – Provides the ability to produce reports on historical student data, so users can look at information on a student’s previous enrollment and course history.
- Up-to-Date Data – Data will be updated nightly; some data, such as attendance and scheduling, will be available in real-time.
A. Ad hoc reporting is a method of creating reports in which users can select the data and format of a report to fit their needs. This method of reporting does not require a developer to take the time to build a report. In MiSiS Ad Hoc Reporting, the user selects the data for a report from a subject area and then formats the report in a way that best presents the information.Q. How does the tool work?
A. MiSiS Ad Hoc Reporting and Dashboards consists of two major capabilities: dashboards and ad hoc reporting.
MiSiS Ad Hoc Reporting and Dashboards is updated with software fixes and/or enhancements every third Tuesday night. Browse the notes below to learn about all updates released since November 2016.
August 17, 2017Posted by MiSiS Ad Hoc Reporting and Dashboards at 8/17/2017
Updated Norm Enrollment Dashboard – This dashboard has been updated to enhance the user experience and improve data transparency. The dashboard displays classification enrollment counts, adjustment counts, norm enrollment counts, and warning counts from the first day of school through Norm Day. To access, go to the Budget Services and Financial Planning Division website https://achieve.lausd.net/Page/431 or the School Fiscal Services Division website https://achieve.lausd.net/Page/794 and click Norm Enrollment and Staffing Dashboards. Click the link below to download the job aid. The job aid has also been added to the Dashboards Job Aid page at https://achieve.lausd.net/Page/11829.
New Norm Staffing Dashboard – This new dashboard helps schools monitor their staffing levels. The dashboard uses adjusted norm enrollment counts from the Norm Enrollment Dashboard to calculate teacher, administrator, counselor, and clerical allocations from the first day of school through Norm Day. To access, go to the Human Resources website https://achieve.lausd.net/hr and click Norm Enrollment and Staffing Dashboards. Click the link below to download the job aid. The job aid has also been added to the Dashboards Job Aid page at https://achieve.lausd.net/Page/11829.
August 16, 2017Posted by MiSiS Ad Hoc Reporting and Dashboards at 8/16/2017
New More Than a Meal Dashboard – A new dashboard is available for tracking Meal Application and Household Income Form submissions that provides a daily snapshot of the District, Local District, and schools’ progress toward meeting related targets. To access, go to https://MTAM.LAUSD.net and click the link to the MTAM Dashboard. Below the link, click the buttons for Pricing Schools or Provision 2/CEP Schools to download the job aid corresponding to your school type. The job aids have also been added to the Dashboards Job Aid page at https://achieve.lausd.net/Page/11829.
August 2, 2017Posted by MiSiS Ad Hoc Reporting and Dashboards at 8/2/2017
Update to Grad Progress Dashboard to Display Students with Waivers – Grad Progress Dashboard has been updated to display current data, which now includes summer school courses and AB167/216/1806 Waivers. Current 2016-2017 data will display through August 14, 2017. 2017-2018 data will display beginning August 15, 2017.
New Local District Monitoring Report: No Attendance But Not Marked No Show (Will begin to display data the day after the new school year starts) – This report is now available, providing a list of students who have no attendance recorded for the previous day of school, but have not been marked as a “No Show.” To access, go to Dashboards in the navigational menu > Local District Reports > click the No Attendance But Not Marked No Show tab.
New Local District Monitoring Report: No Show (Will begin to display data the day after the new school year starts) – This report is now available, providing a list of students who have been marked as a “No Show” for the previous day of school. To access, go to Dashboards in the navigational menu > Local District Reports > click the No Show tab.
New CMS PIN Column – This column is now available to produce reports including student CMS (Cafeteria Management System) PIN Numbers. It can be found in the Student Detail Subject Area > Programs folder > Meal Code subfolder > CMS PIN. The updated subject area guide is available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.
New English Learner Columns – New English Learner columns are available in the Student Detail Subject Area. The columns added include EL Years, ELD Level, LEP Profile Code, and LTEL Flag. They can be accessed by navigating to the Programs folder > English Learner subfolder. The updated subject area guide is available on the MiSiS Ad Hoc Reporting job aids webpage http://achieve.lausd.net/Page/11833.
Update to Master Scheduling Commit Status Report – This report has been updated to refresh with new data every day until August 14, 2017.
Update to Attendance Rates – All Attendance Rate columns in the application have been updated to exclude Summer School Attendance Rates.