Author Topic: Data Normalization and Stackoverflow  (Read 298 times)

choppedwood

  • Trusted Member
  • Guru
  • ******
  • Posts: 205
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #30 on: November 15, 2011, 11:44:47 pm »
A well thought out system can provide a lot of information and be easy to access. Management from years back would be wowed but today, not so much plus you need charts, graphs, etc and all in color.

Funny that you mention that.  When the son took over from the father one of my biggest misses was "but, it's all there, everything you need to know, and it's fast, and easy" while he wanted a pretty dashboard.  Drove me crazy but then he never even saw what we'd done.

Richardk

  • Global Moderator
  • Wise Sage
  • *****
  • Posts: 3820
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #31 on: November 16, 2011, 12:09:01 am »
Yup, it's the old "been there, done that".

When the PC generation started to gain control, anything without a GUI, nice graphics, color and so on would cause their heads to explode.  :o

Walter Mitty

  • Trusted Member
  • Wise Sage
  • ******
  • Posts: 1025
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #32 on: November 16, 2011, 07:36:35 am »
I don't want to make this a generatonal thing.  One of the best bosses I ever worked for told me this about numbers in business presentations,  "I like graphs".  And after attending several of his business meetings, I could understand why.  A graph tells a story that a table of numbers does not.  Now, as to what software generates the graphs and whether that software is GUI driven or not, that's another discussion.

One of my best short term projects involved designing and populating a star schema data mart for OLAP purposes.  The data was extracted from the operational system, that lived behind a web site.  The star schema in turn was automatically transformed into a data cube by some Cognos software.  The Cognos software, in turn, provided the analysts with an interactive graphic capability with graphs and drill down such that they could answer all their questions without even learning SQL.  It's cute. 

Not that more primitive methods can't yield equally substantive results.  Just that the cake tastes better with the icing on it.


Richardk

  • Global Moderator
  • Wise Sage
  • *****
  • Posts: 3820
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #33 on: November 16, 2011, 09:56:04 am »
Don't get me wrong, charts and graphs are nice but in the early days, integration wasn't so great and many clients didn't have the right tools.

As you mention Walter, today you can move data around and get all sorts of analysis and display options.

Walter Mitty

  • Trusted Member
  • Wise Sage
  • ******
  • Posts: 1025
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #34 on: November 16, 2011, 10:59:38 am »
Datatrieve had a moderately good chart builder in it as well as an outstandingly good report generator.  If you could read the file with datatrieve, you could make a chart. I'd bet my bottom dollar that IBM had something just as spiffy in the same time frame.  Circa 1983.   If the  early days were later than that,  maybe that's because they came around again.

Richardk

  • Global Moderator
  • Wise Sage
  • *****
  • Posts: 3820
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #35 on: November 16, 2011, 12:18:14 pm »
It wasn't a lack of tools in the market, only at the client. Champagne projects with beer budgets.

Walter Mitty

  • Trusted Member
  • Wise Sage
  • ******
  • Posts: 1025
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #36 on: November 16, 2011, 12:34:28 pm »
OK.  I was misled by "in the early days".


Richardk

  • Global Moderator
  • Wise Sage
  • *****
  • Posts: 3820
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #37 on: November 16, 2011, 01:12:35 pm »
OK.  I was misled by "in the early days".

Not totally. Terminals were still more common than PC's. In some places about 20:1. So it was a limited resource and no money for big iron or server based products.

Origisaurus

  • Wise Sage
  • Wise Sage
  • *****
  • Posts: 1678
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #38 on: November 16, 2011, 06:06:32 pm »
One of the best bosses I ever worked for told me this about numbers in business presentations,  "I like graphs".  And after attending several of his business meetings, I could understand why.  A graph tells a story that a table of numbers does not.

Yes. It's damned hard, even for the practiced eye, to see a trend in a table of numbers.  And trends are what competent managers need.  If it's up, OK, leave it alone.  If it's down, it's an opportunity for improvement and another boost to my bonus.

You can crunch the heck out of the numbers, but to produce meaningful information, you need insight into what is meaningful to the enterprise at the particular moment.  The Reverend Leroy's Church of What's Happ'nin' Now!

Production numbers are no help when the enterprise needs sales.

In the wayback, I had a gig at a Tier-One automotive supplier.  A senior analyst told me a story about the manager who demanded a 3-inch stack of fanfold detailing the previous day's operations.  The manager looked up a few numbers from the stack, wrote them on a yellow pad along with some results from his desktop calculator.  Gave the numbers to the plant manager.  The analyst said "We can program those calculations".  The manager replied, "Don't you dare.  Don't you dare break my rice bowl!  The plant manager needs me to give him those numbers!"
Avatar is from the cover of the November 2007 National Geographic.  Fair use is assumed.

Richardk

  • Global Moderator
  • Wise Sage
  • *****
  • Posts: 3820
    • View Profile
Re: Data Normalization and Stackoverflow
« Reply #39 on: November 16, 2011, 07:39:39 pm »
The manager replied, "Don't you dare.  Don't you dare break my rice bowl!  The plant manager needs me to give him those numbers!"

I'm sure that the emphasis was on ME.


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf