-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
barry Jul 27, 2011 11:16 AM (in response to bchamberlain)Bill, have you seen this as well? https://community.jivesoftware.com/docs/DOC-4778 I think this might have more details.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Jul 27, 2011 11:22 AM (in response to barry)Yep -- I have seen this one too. It helps, but not to the level I am looking.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Jul 11, 2012 4:16 AM (in response to bchamberlain)Hello Bill
I've been through the current the v4.5 Application Db documentation and also found myself needing more information.
I wondered if you received the data dictionary asked of Jive last year.
We are seeking one for the 4.5.6 schema and entity relationship map too.
Thanks
Marcell
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Jul 11, 2012 5:28 AM (in response to mitchelm)Hi Marcell --
We did not ever receive the entity relationship diagram. Through trial and error, we figured it out during our Pilot. When we went to production, we purchased the analytics module which is okay for something, but you really need to understand Business Objects and have a decent understanding of the data. You've probably seen numerous posts in the Community regarding the BO tool and a lot of people struggle with it.
As an alternative, we are finishing up a framework that sits on top of the Jive analytics database. Once you download the data (4.5 or 5.x), the framework will provide a decent set of analytics that a client can use. It is something we are going to market to clients relatively soon and I think it is fairly compelling as it fits in between the Community Manager Reports (which are good, but limited) and the BO tool (which is complex and slow).
Once we get things cleaned up a bit more, you want me to ping you with more information?
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
ted.hoptonJul 11, 2012 5:51 AM (in response to bchamberlain)
Hey, Bill, I don't know if Jive will sanction it or not, but I would think you'd get a nice turnout for a webinar in which you demo the tool and let us all ask questions, too.
Ryan Rutan can we get a ruling on this? There's significant demand among Jive customers for the kind of tool Bill is going to offer. Can we coordinate to meet this need in the Jive Community, or do we have to take it to another platform to arrange this? (It's going to happen whether Jive sanctions it or not, so I'd think you'd want to be helpful in meeting our needs.)
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
ryanrutan Jul 11, 2012 6:02 AM (in response to ted.hopton)As long as it will help our customers, I see no reason why you can't coordinate this event via the Jive Community.
I'll ask around and see if there is anything we have on the horizon that we can share that can complement this discussion? Would that be of interest?
Let me know and thanks for looking me in
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
ted.hoptonJul 11, 2012 6:14 AM (in response to ryanrutan)
Thanks, Ryan. I think the focus of this event would be Bill's offering. If someone from Jive, say Karl Rumelhart were present and wanted to provide perspective on how Jive plans to evolve it's own reporting and analytics offerings, that could add value, too.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
ryanrutan Jul 11, 2012 6:22 AM (in response to ted.hopton)Read my mind
Already got a line out to Karl to see if he would have any relevant information to share with such a presentation. Definitely keep me looped in on the timing of this event, and will try to do my best to help with promoting it in appropriate places. =)
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Jul 11, 2012 7:50 AM (in response to ryanrutan)A few updates for everyone.
We've looped in a few Jive people in the Midwest (e.g. quentin.skinner) on what we are doing and I have some time with Karl Rumelhart next week to chat about what we are doing. I also saw this Jive Analytics and Reporting Solutions document which I think can be a good summary document.
Where we are:
- Our framework v10 is built, but I need to QA it a bit more before a webinar.
- We've been cleaning up some data for demo purposes that can clearly illustrate the benefits.
- The framework we've built sits nicely between the CMR and the BO Analytics tool. The compelling thing (for me at least!) is the ease of exploring the activity in your Jive Community across groups, people, blogs, activities, and information in your user profile.
- My thinking is we should be ready to show this to people by the last week of July.
I will keep everyone posted!
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
RyanSe Jul 30, 2012 8:15 AM (in response to bchamberlain)Hey Bill,
Its the last week of July, how are things going
We're in a very similar spot as you are with regard to data. I have spent a lot of time working with both the analytics and the production databases for reporting so I am interested to see what you have done.
Ryan
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Jul 31, 2012 6:18 AM (in response to RyanSe)Hi Ryan --
We are doing a demo for the Jive team on Thursday (August 2nd) and we are getting ready to market this to clients. Let me know if you'd like to chat on what we've built.
Bill
-
-
-
-
-
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Jul 11, 2012 6:01 AM (in response to bchamberlain)Absolutely Bill, do ping me.
I realize you could be anywhere from weeks to a year or so before you're up and running.
I wait with bated anticipation.
Marcell
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Aug 31, 2012 11:41 AM (in response to mitchelm)Marcell Mitchell our QlikView framework is ready to go and we have started to demo it for Jive customers. If you are interested in a demo or more information, just let me know.
Bill
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Sep 5, 2012 7:33 AM (in response to bchamberlain)Hello Bill,
Yes, I would be interested in a demo.
Let me know what's the format for the demo? If possible we would like a demo to me plus 2.
Thanks
Marcell.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Sep 5, 2012 8:10 AM (in response to mitchelm)Hi Marcel - Happy to demo our QlikView framework for you. You are in the UK, correct? I am in Chicago, so a morning here probably will work best. I could do a demo September 11, 12, or 14 at 7:30 or 8 am CDT if any of those times work for you.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Sep 6, 2012 9:24 AM (in response to bchamberlain)Hi Bill,
Would like to tentatively book Sept 14 at 7.30am CDT. Awaiting confirmation from interested colleagues and will inform you early next week.
Thank you.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Sep 6, 2012 8:12 PM (in response to mitchelm)Sounds good – 7:30 am CDT is on my calendar. Let me know!
Bill
From: Marcell Mitchell communities-no-reply@jivesoftware.com
Sent: Thursday, September 06, 2012 11:25 AM
To: Bill Chamberlain
Subject: New message: "Has anyone pulled
together detailed documentation on the Analytics Data Warehouse?"
Jive Community <https://community.jivesoftware.com/index.jspa>Has anyone
pulled together detailed documentation on the Analytics Data Warehouse?
created by Marcell
Mitchell<https://community.jivesoftware.com/people/mitchelm>in
Internal Community Managers - View the full
discussion<https://community.jivesoftware.com/message/1219628#1219628>
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Sep 10, 2012 10:37 AM (in response to mitchelm)Sorry Bill this week proves difficult.
If we may try again, next Monday 12th or Friday 21st appear possible, or Monday, Tuesday or Friday of the following week.-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Sep 10, 2012 9:01 PM (in response to mitchelm)I assume you mean Monday the 17th…..which won’t work for me. In terms of
the 21st, what is the latest you could start?
Otherwise, Sep 24, 25, and 28 in the morning look pretty good. (and are
probably the best option)
From: Marcell Mitchell communities-no-reply@jivesoftware.com
Sent: Monday, September 10, 2012 12:38 PM
To: Bill Chamberlain
Subject: New message: "Has anyone pulled
together detailed documentation on the Analytics Data Warehouse?"
Jive Community <https://community.jivesoftware.com/index.jspa>Has anyone
pulled together detailed documentation on the Analytics Data Warehouse?
created by Marcell
Mitchell<https://community.jivesoftware.com/people/mitchelm>in
Internal Community Managers - View the full
discussion<https://community.jivesoftware.com/message/1223842#1223842>
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
mitchelm Sep 11, 2012 3:10 AM (in response to bchamberlain)Bill, Tue 25th Sept works for us. Would you like to message me outside this post to firm up on the details. Many thanks Bill.
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
bchamberlain Sep 11, 2012 6:34 PM (in response to mitchelm)We are all set! You should receive a calendar invite.
-
-
-
-
-
-
-
-
-
-
-
-
-
Re: Has anyone pulled together detailed documentation on the Analytics Data Warehouse?
austen.rustrum Jul 27, 2011 11:19 AM (in response to bchamberlain)Bill,
FYI -- my development manager, Ryan King, will be getting back to you with an answer today on the questions you sent across previously through email.
Thanks,
Austen