Review of Enron: IT Review of Enron: IT Model Validation and Model Validation and

Spreadsheet ErrorSpreadsheet ErrorBy i2consulting:By i2consulting:

Anthony Rimel, CEOAnthony Rimel, CEODavid Paterson, CFODavid Paterson, CFOLindsay Aamot, CIOLindsay Aamot, CIO

OutlineOutline

Presentation ReviewPresentation Review Our thoughtsOur thoughts Survey ResultsSurvey Results

Readings ReviewReadings Review Our thoughtsOur thoughts Survey ResultsSurvey Results

Our DecisionOur Decision

Reading List ProsReading List Pros

• Readings 1 & 2 informativeReadings 1 & 2 informative• Sources were laid out well – formattingSources were laid out well – formatting• Reading #5 was fantasticReading #5 was fantastic• OSU articleOSU article

• ““The reading list page was very well formatted and was The reading list page was very well formatted and was very easy to understand. It was cool to see a different very easy to understand. It was cool to see a different department at OSU in the "news" about this topic.”department at OSU in the "news" about this topic.”

• ““The article about databases versus spreadsheets. It tied in The article about databases versus spreadsheets. It tied in nicely to what we have learned in class before”nicely to what we have learned in class before”

Reading List ConsReading List Cons

• Reading #4 was confusing. Reading #4 was confusing. • Should start with a definition articleShould start with a definition article• How does Audit fit in?How does Audit fit in?

• ““I’m not sure if it was just me, but the link to the reading I’m not sure if it was just me, but the link to the reading list didn’t work for me until today when I came back and list didn’t work for me until today when I came back and checked. I was a little rushed to finish reading it.”checked. I was a little rushed to finish reading it.”

• ““The readings were dull I would like more examples.” The readings were dull I would like more examples.” • ““A couple readings were a little bit confusing.”A couple readings were a little bit confusing.”

Reading List Survey ResultsReading List Survey ResultsReading List Survey Results

0.00

0.50

1.00

1.50

2.00

2.50

Formated well Described well better than the text? Tech. Quality?

Presentation ReviewPresentation Review

0.00

0.50

1.00

1.50

2.00

2.50

3.00

Informative Relevant Supported Reading Power Point Discussion

What classmates thoughtWhat classmates thought ““This was a really thorough presentation. This was a really thorough presentation.

You knew the information you were You knew the information you were presenting. Gave good recommendations presenting. Gave good recommendations for the consuming group. The Video tied in for the consuming group. The Video tied in well”well”

““I think the power point was less organized. I think the power point was less organized. They should have a concept map and get They should have a concept map and get involved the audience more”involved the audience more”

““The presentation was presented in an The presentation was presented in an interesting order. I liked the link in interesting order. I liked the link in relevance of jobs to the class”relevance of jobs to the class”

““Possibly could have given some applicable Possibly could have given some applicable examples from real life companies”examples from real life companies”

Our ReviewOur Review

Missing key requirementsMissing key requirements A lot of text on the slidesA lot of text on the slides No connection with the reading listNo connection with the reading list Did not fully answer our questionsDid not fully answer our questions We would have preferred more We would have preferred more

description and understand of the description and understand of the recommendationsrecommendations– Job opportunities were a fillerJob opportunities were a filler

Our DecisionOur Decision

To seek additional informationTo seek additional information

Our unanswered questions:Our unanswered questions: The problems with our current systemThe problems with our current system The ways that a new system (a The ways that a new system (a

database) might help us overcome these database) might help us overcome these problemsproblems

Differences between relational databases Differences between relational databases and multidimensional databasesand multidimensional databases

How multidimensional databases workHow multidimensional databases work

Where we go from here…Where we go from here…

Hire a new consultant team?Hire a new consultant team?

Stick with our current (albeit broken) Stick with our current (albeit broken) model because we don’t know enough model because we don’t know enough to move forward.to move forward.

We were curious about the spreadsheet We were curious about the spreadsheet validating software Audit, but couldn’t validating software Audit, but couldn’t find it online and don’t have access to find it online and don’t have access to your slides to check your links.your slides to check your links.