1 / 10

Ledelsesinformasjonsystem

Develop a system for Notar AS to automate report generation from separate databases. Update reports daily for timely information on finances, operations, and property management.

barias
Download Presentation

Ledelsesinformasjonsystem

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ledelsesinformasjonsystem Notar

  2. Ledelsesinformasjonsystem – Notar Oppdragsgiver:

  3. Ledelsesinformasjonsystem – Notar Virksomhetsområder Notar Eiendom Codex Advokat Conto Creno Inkasso • Arbeidsrett • Selskapsrett • Fast eiendom • Forsikringsrett • Erstatningsrett • Skatterett • Styrearbeid • Avtalerett • Kontraktsrett • Markedsrett • Immaterialrett • Boligeiendom • Næringseiendom • Fritidseiendom • Utvikling/salg av nye boligprosjekter • Utleie av privat og næringseiendom • Boligfinansiering • Boligforsikringer • Kreditt-opplysninger • Kredittovervåking • Purreservice • Inkasso • Rettslig inkasso • Inkasso-overvåking

  4. Ledelsesinformasjonsystem – Notar Problem to solve: Notar AS needed a tool that would make it possible to get information out of two separate databases and present them to the user. The new tool should be able to generate the reports, that today are made manually, automatically. Today very much time is used in updating those reports and therefore the information is only update once a week or once a month depending on the report. With the new tool it should be possible to get the data on updated report every day.

  5. Ledelsesinformasjonsystem – Notar Reports to generate: • Resultatrapport • Oversikt over franchiseavgift • Låneoversikt eksterne lån • Inntektsføringsrapport • Konsolidert regnskapsrapport • Balanserapport • Mellomværende oversikt • Likviditetsrapport • Kontantstrømrapport - +/- 30 dager • Aktivitetsrapport • Ukerapport Eiendom • Ti på topp rapport • Servicerapport • Kontrollrapport • Avvik – og utleggsrapport

  6. Ledelsesinformasjonsystem – Notar • Why did I choose this project: • I work in the IT division of Notar AS so it would be natural to choose a project there. • I wanted to work with something different in my ”Hovedprosjekt” than what I do every day. • Datawarehousing seemed to be a very interesting subject and it was a good chance to learn something about it.

  7. Ledelsesinformasjonsystem – Notar How was the problem solved: The problem was solved using Microsoft SQL Server 2000 Analysis Services, Microsoft SQL Server 2000 and Excel for presenting the reports. A cube was generated for each of the reports that the new system should present. The user interface is Excel using Pivot tables and Pivot charts and the cubes as data sources.

  8. Ledelsesinformasjonsystem – Notar How was the problem solved:

  9. Ledelsesinformasjonsystem – Notar • Results: • Most of the reports are finished • Procedures for updating the data in the reports is finished • The layout of the reports is ready • Reports that are ready and tested are in production

  10. Ledelsesinformasjonsystem – Notar • Next on the project: • Develop two the reports that are not finished • Check that the information in the new reports is correct • Put the system in production • Update the documentation

More Related