This example is from the Beginning SSRS by Kathi Kallenberger. Supporting files are available with a free download from the www.Joes2Pros.com web site.
This will be a 5 day blog post in getting started with SSRS. Today will show the importance of SSRS in the business.
Why is SSRS asked for in so many job openings?
If you talk to an SSRS expert it’s very
clear to them exactly why companies really need this invention and how
it saves time and adds business value. You don’t have to be an SSRS
expert to know its value or to start using it. For example you don’t
have to be an airline pilot to know the usefulness of modern
transportation. Even the people who don’t know how to run SSRS but need
the reports can tell you why that is needed. This blog post will go into
why SSRS is an important invention by showing how it improves the usage
of information in your company.
Before SSRS there has always been a need
for a company to benefit from the use of its own information. Excel
spreadsheets have been a popular way to do this for a long time. With
SSRS you can still use this solution and gain many other options too.
A friend of mine told me a story about
doing database work in the 90s for a major company and how he wished
SSRS was available back then. The Vice President of the marketing
channel would often come to him just before an important meeting with
the board of directors. He often needed to show how certain product
sales were performing over time. All this information was in the
database so it was my friend’s job to get the information out and
organized into a medium the VP could use. This medium was usually Excel. The VP often had meetings all over the world where he showcased this Excel report.
The solution to get the VP to him anywhere he was in the world was an Excel file attached to an e-mail. This worked pretty well but with some drawbacks. One time my friend sent the wrong file in the e-mail.
A few minutes later my friend realized his mistake and sent another
frantic e-mail to VP. This one was saying to ignore the last e-mail and
use this newer one. Would the VP see the correct e-mail in time?
If SSRS had been available, my friend could have created a solution that let
the VP run the report any time he wished. The report could have been
published to the company intranet where the VP could run it from any of
the offices he happened to be traveling to
that month. There is a fair amount of work up front to develop and
publish the report, but once that work is completed, the report can be
reused as many times as needed. My friend could even be on vacation for
the first day of the monthly and the VP can get his real-time report.
Not only could the report show the most
recent data, the VP could choose to view reports of previous months with
just a few clicks. The deployed SSRS is user friendly, and can also be
configured to protect reports from being run by the wrong people.
Tomorrow’s Post
Tomorrow’s blog post will show how to know if you already have SSRS installed.
If you want to learn SSRS in easy to simple words – I strongly recommend you to get Beginning SSRS book from Joes 2 Pros.
No comments:
Post a Comment