May 22, 2013 at 11:16 am
I have a group of Business Analysts that I will soon be working closely with to further their report building capabilities. They've recently been brought back under the IT wing and will be working directly under me (the sole DBA). One of their primary goals will be learning basic SQL query writing in order to develop more advanced reports for the applications they each specialize in. Currently none of them have very much experience doing this, outside of very basic SELECT and JOIN queries for some existing reports. The good news is that they already have a good understand of their respective database structures and will never need any advanced SQL knowledge -- they just need to know how to write queries that can produce the requested reports. And they will, obviously, never have more than read access to their own database (or a reporting version of it).
I've currently prepared some basic material to start teaching them with -- JOINs, comparison operators, aggregates, and some other useful knowledge for report queries. While I was looking to see what good Business Analyst specific report tools there might be I came across dbForge's Query Builder [/url]tool. I haven't used or really even noticed any tools that are for visually creating SQL queries, at least not to this extent, prior to finding this. But, so far, after tinkering around with the trial version I think it might be an interesting addition to their learning path. With some obvious restrictions I'll put in place prior to deploying, I feel like tools like this could give them a head start on learning some of the basic aspects in a more intuitive, visual manner. I would obviously be there to oversee and assist with the more advanced matters.
Does anyone else have any similar experiences or insight? Any thoughts on something like this or even better suggestions? I am in no way looking for an overall solution or quick-fix, just other opinions to consider. In the end I am just looking at all my options for developing their query/report writing abilities as efficiently as possible, without creating any major issues, while also balancing my own limited time. 🙂
Thanks in advance,
May 22, 2013 at 11:18 am
I apologize, but I wasn't 100% where this should be posted -- I should have mentioned this above. But, I posted this here due to it's implications on the Administration side of being a DBA. If there's a better forum for it, please let me know and I'll gladly relocate this.
Thanks,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply