Transcript Ledelsesinformasjonsystem

Ledelsesinformasjonsystem
Notar
Ledelsesinformasjonsystem – Notar
Oppdragsgiver:
Ledelsesinformasjonsystem – Notar
Virksomhetsområder
Notar Eiendom
Codex Advokat
Conto
Creno Inkasso
 Næringseiendom
• Arbeidsrett
• Selskapsrett
 Fritidseiendom
• Fast eiendom
 Utvikling/salg av
• Forsikringsrett
 Inkasso
nye boligprosjekter
• Erstatningsrett
 Rettslig inkasso
 Utleie av privat
• Skatterett
 Boligeiendom
og næringseiendom
• Styrearbeid
• Avtalerett
• Kontraktsrett
• Markedsrett
• Immaterialrett
Boligfinansiering
 Kreditt-opplysninger
 Boligforsikringer
 Kredittovervåking
 Purreservice
 Inkasso-overvåking
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.
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
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.
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.
Ledelsesinformasjonsystem – Notar
How was the problem solved:
Agresso
Preparing data
LIS
Analysis Services
MApp
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
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