I read about Qlikview but i am unsure whether being a service provider how reasonable it would be to use qlikview and provide reporting and anlysis again to client industries using qlikview? That dosent make much sense, what i understood about qlikview is its useful for end companies like manufacturing industries so on whcih would use qlikview in their system for reprting or analyzing the company performance and so on, But providing a service to the industries i dont see how we would be able to implement qlikview to generate reports only to ask the client to install qlikview tools to access those reports or analyze. I mean we arent really needed anymore other than to perform and generate the test data, the main idea here is to make our services flexible and attractive i hope you get the idea?
But using SSRS, SSAS we would able to generate adhoc reports and SSAS allows the remote users to analyze the reports along various dimensions in a sharepoint website portal that we could build.
I would really appreciate some advice from all the reporting, analysis experts
We provide electronics engineering services to several defense and aerospace industries that manufacture defense and aerospace components.
We perform several detailed tests on those products to determine the efficiency and safety of the products. At the end of each test a large collection of data is organized into data files for analysis and storage.
Example: For a single test we generate nearly 5 excel reports, along with relevant test data and documentation which will be submitted in the form of printed material which can be used by management, design engineers.
I have to say that this is quite restrictive in nature as the printed material only provides a static view one dimensional view to the user.
Currently I am entrusted with improving the company services to its clients and finding new sources of income. I have been involved with the ETL development of Warehousing in several industries and i also have some prior awareness of the benefits of reporting services although i didn`t get the benefit of working directly with them.
Being aware of the advantages of reporting and analysis services. We would be able to provide the clients with the ability to
1)access and download the reports any time from anywhere.
2)Wide range of report formats like Web Reports, Excel Sheets, and ?
3)The user could be able to analyze a particular report from multiple dimensions like
X-Pressure vs Y- Time OR X-Strain vs Y - Expansion.
So the business user who isn`t aware of the technical details could drag and change dimensions to compare different things.
4)Compare and analyze several test reports against one another.
Any more advantages please feel free to provide as it would be very much helpful in obtaining a good solution.
5)We obtain all data feeds in the form of flat files, maybe some time in future it might change but currently only flat files.
The amount of data generated for each test would be around 50 mb.
I am thinking of building a Data Mart to host all the historical test data which when the reporting, analysis service for clients is setup would enable the designers, management to compare online without the need to search, go through past printed materials.
7)New data would be inserted around 10 times in a month.
500mb - monthly, 6gb yearly, currently thinking of holding only around 4 years past data - 24GB or more.
Doesnt have to be exactly an elaborate OLAP setup currently. I am assuming an underlying database would suffice given the amount of data.
8)Currently cost wise the company isnt looking to engage any high cost reporting, analysis tools like Cognos or BO.
9)Once a database is setup to hold the data, using SSRS once say 50 reports, will i have the option
a)That the client who would be sitting several miles away is able to access the reports through some sort of link, username, password.
b)I want only 10 reports to be accessible by one user, will it be possible i.e. setting roles and groups for users of reports.
10)Also analysis services i am not familiar with this so say one client has a report X Pressure vs Y-Time and now he wants to view it in another dimension, will it be possible?
I am assuming all of this of course and would greatly appreciate if anyone can correct me. Also i would greatly appreciate if somebody can take the time to elaborate their view.