Excel pivot tables

Soldato
Joined
7 Mar 2011
Posts
6,859
Location
Oldham, Lancashire
Any Excel gurus in here? There is a job I do daily, and I cant help but think I am doing it in the most inneficient way possible :(

I am given a spreadsheet with a lot of information. Basically everything done at my site in the last 24 horus. I then use this to create a whole bunch of tables and charts to make it easier for people to read.

The problem is, the only way I can think of doing it is to filter down to what I want for that chart, then copy it over to a new sheet in the book, then create the pivot table from that.

Depending on how busy we have been, and/or any issues we have I can end up with dozens of sheets, all with what I am guessing is redundant data. I have 3 shifts, 4 sections, each section with 4 sections of their own. Honesty it's a mess.

It's purely for my own sanity. I get the data pulled from the server before I get in to work, and before I go home I give the upper managers their fancy charts and graphs. Only I see the inbetween, but its getting annoying. There has to be an easier way!
 
Sounds like you are manually performing an ETL process each day and building "reports". Has your business considered data mart/ data warehouse and reporting off that?

An example of a tool that could be useful is SQL Server Integration Services that could be used for ETL. You could then use a reporting like Reporting Services to report on the data.
 
We are smack in the middle of an IT overhaul. I have no idea what they are planning for next year. It's al supposed to be done by March.

Right now the data is being pulled from all over the place by some random IT guy's script. Merging 2 legacy systems (from a business merger) has been half done then abandoned in favor of a whole new system, will be better in the long run.

Until then, I am stuck with Excel. It's actually working in my favor though, I have learned more from playing with the data than I ever did in school/ITQ2 and all the management think what I am doing is far harder than I am actually finding it. That may come in very usefull as I have an interview for promotion tomorrow ;)
 
Back
Top Bottom