October 4, 2014 at 4:46 pm
Im about the enter a production environment where my responsibilities will be to create an array of reports. I would really appreciate if someone could guide me with some real time applications or scenarios which may help me with my challenges that I am about to embark upon.
I have a fair bit knowledge of the business intelligence suite (SQL server, SSIS, SSRS) but Im having a hard time going about the integration of each software.
I would be utterly grateful if someone in this forum can guide me in the right path. 😀
October 7, 2014 at 12:03 pm
I believe we need to disabuse you of a notion you seem to have.
SSRS and SSIS are not meant to be real time applications, not in the way it's traditionally thought of. SSRS is for pre-built reports with user defined parameters at run time. It has a pre-built interface and plug in. Full bore applications CAN call SSRS from the servers if the designers decide to chase that, similar to using Crystal, but that's an uncommon approach in my experience.
So, SSRS gets a server stood up somewhere in the LAN/WAN, maybe a second one that's externally exposed with extra security and thought, and then you deploy .rdl files to it. That's it.
SSIS is for under the hood ETL. Your users shouldn't care a lick about what's happening there.
SSMS/SQL is just one of the database engines that both of those tools can connect to. However, since you need the license to this to run the SSIS/RS servers, you usually have one handy. That's the database engine. You drop off procedures there so SSRS and SSIS can connect against it.
In none of these items are your users going to be doing 'real time' work, except maybe the SSRS for some information. They certainly won't be editing information there or anything of that nature. The most real-time report I would typically expect to see is "Sales volume by person in last hour" or something like that.
What are you trying to get towards with this question? I've answered it pretty basically and you say you're familiar with these items, so it's possible I missed a nuance of your intent.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 8, 2014 at 10:17 pm
Thank you for your kind input.
Would you be able to explain a typical day for a BI developer?
October 8, 2014 at 11:08 pm
Nope, because that depends entirely on where you work. Do you have BA's and PM's? Are you working against a warehouse that's built by a data architect, or are you developing the initial ETLs? Are you hooking to cubes in SSAS and are your users experienced enough to use PowerPivot or are you hand-holding them?
BI is half business and half tech. Without knowing the business and the expectations, no one could tell you what your day will look like. You just need to make sure you understand the tools well enough (or at least what they could do so you know where to lead them/research) to be able to respond to their inquiries appropriately.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 9, 2014 at 12:51 am
mrkp (10/4/2014)
Im about the enter a production environment where my responsibilities will be to create an array of reports. I would really appreciate if someone could guide me with some real time applications or scenarios which may help me with my challenges that I am about to embark upon.
Possible challenges with reports:
* getting the right data
* trying to understand what users want in the report
* displaying the data accurately and in with a design that doesn't force you to gauge your eyes out (no pie charts for example)
* security (either to the data or access to the reports itself)
* SharePoint integration (hopefully no Kerberos set-up)
* slow reports
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply