Page 1 of 4 123 ... LastLast
Results 1 to 15 of 57
  1. #1
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Unanswered: Whatever the database Excel is THE reporting app.

    I work as Online Excel Developer and I develop analyzing and reporting applications downstream from all kinds of database or specialized applications from SQL to Oracle, SAP, etc.

    To do the job (transforming data into information) I use the SUMPRODUCT function in 75% of the applications that I develop.

    This function ignored by many is the function that makes Excel the best reporting tool. It allows the user to transform any database extract into a report. With it you can sum a column (amounts) based on ANY number of criteria located in other columns (account, city, product,...). It is simple to use yet one of the most powerful function in Excel for Accountants, Financial Analysts and Data Analysts.

    There is an example on my website at:
    http://www.excel-vba.com/e-formula-sumproduct.htm
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What a joke.

    Classic case of "To a man with a hammer, every problem is a nail".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What is an "OnLine EXCEL Developer"?

    Yo, blind dude...got something against Self promotion?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    He's just trying to hawk some Excel templates at the bottom of his web page.

    "Online Excel Developer"??? http://www.dbforums.com/showthread.php?t=975527

    I can't believe this guy actually talks managers into using Excel as an Enterprise Reporting platform.

    Learn SQL so you can play with the Big Boys, buddy.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's 60% of Free?

    LOL

    Hey, and where do you think you are? Jersey....

    Since when do Ohioians have 'tude?

    Tell the truth...you're a Jersey transplant....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Oh, we got 'tude, dude. After a long day of sloppin' the hogs, mowin' hay, and shoppin' at Wal-Mart, we mid-westerners can get downright cranky.

    I reckon!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    Oh, we got 'tude, dude. After a long day of sloppin' the hogs, mowin' hay, and shoppin' at Wal-Mart, we mid-westerners can get downright cranky.

    I reckon!
    Better than sloppin' the hay and mowin' the hogs, you betcha!

    -PatP

  8. #8
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Hi blindman

    You see the reality is that the "Big boys" are overloaded and don't know much about data. They know about databases. Smart executives have realized that users (the ones who know the data) must be empowered to use what you people store in databases. To this effect, Excel is the best tool. I bet I could design a reporting application (simple or complex) for one third of the price that you would cost. I respect the knowledge of you "big boys" but the general insatisfaction I hear about at the users' level is that the "big boys" don't recognize the expertise of the users who had business running long before they arrived. You don't have this tendency to share the power and you end up overworked and designing applications that don't work.

    If you need help do not hesitate to call the "small boy" who has been working with business data for 30 years now.
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm just curious...why wouldn't they just link Access to a backend database...

    And if you've been in the b'ness for 30, then you know what a data model and data dictionary are, no?

    And I'm curious what the templates look like...can you attach one?

    Yo blind dude, remember the guy who said a dba shouldn't have access to the box?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Lawsy! I don't know nothin' 'bout no data! All's I kin do is makin' the tables an backin' up da files!

    30 years experience and you are an expert with Excel? What did you do with the other 29 years?

    I'm sorry I came down so hard on you, but the idea of using Excel as an Enterprise reporting tool is just loony. Yeah, develop it in an hour....and spend 500 hours maintaining it across the enterprise every year. I guess I shouldn't complain, because philosphys like that just make more work for me when the manager comes to our firm and says "We need a real solution, because these spreadsheets are just not manageable any more."
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    dude with the 'tude

    Excuse while I get off the floor and back on to my barstool...ummm offcie chair....

    EDIT: Oh, and btw, that's what keeps me going...
    Last edited by Brett Kaiser; 06-23-04 at 18:02.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Hi blindman

    The spreadsheets you are taking about have been developed by people who don't know Excel that is why they don't work. They are indeed usually developed by IT people who think you become an expert in Excel in less than a year. You are very condescendant toward users and anybody who doesn't know your very specialised and limited language.

    On top of having spent a few years really understanding Excel and VBA I have a masters in management and a Masters in statistics.

    And during this third career like dutring the two others I try to be useful rather than SHOW that I am intelligent.

    You may be very intelligent but beware when some people call you GOD, there is a bunch following with a cross.

    Signing off until next Monday
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  13. #13
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Hi Brett

    I probably know what these are (data model and data dictionary) but I am not familar with the language.

    The people I work for already have their meta language (accounting, finance, engineering...) and thay just want data. So I talk to the dba who creates a query and send me a file that I then import into an Excel workbook and the formulas take care of the rest.

    I will be back on Monday. Send me a personnal email and I will send you an example.
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  14. #14
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I thought you kicked out

    Yeah, we know...The data model is basically the database...it usually starts as a logical model. Which means we have to interview everyone in the business before we build one...

    Part of the interviewing process is capturing definitions of Entities and attributes

    Yeah it's metadata...data about data...

    Not that I like it much, but you should see M$ Reporting Services....

    Pretty impressive...

    And I Imagine that's also what cubes are for
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, I'm pretty respectfull of people who are experts in an area in which I am not familiar. Requirements gathering and application design is not such an area.
    I am "condescendant" of people who make statements like "Whatever the database Excel is THE reporting app" and talk businesses who don't know any better into slap-dash short-sighted solutions. You may think you are being usefull proposing the cheap solution, but I've had to pick up the pieces of such projects too many times.

    And I have a Masters in Management too, and I've written SQL code for calculating linear regression and exponential smoothing models among other statistical algorithms.

    And I don't call myself GOD. My forums title is "Data Janitor", because I always keep in mind that serving the needs of the users is the ultimate goal, and that technology is just a means to an end. You are the one harping on your experience while hawking a one-size-fits-all solution.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •