Olap Technology In The Analysis Of Financial Indicators

With the construction of informational systematized in diversified industries, loads of data is produced and reserved during the process of corporation's operation。The corporations did not use these materials sufficiently and made data loose fragment。Nowadays, corporations have higher expectation from data analysis。In such competitive market, decision maker's strategy has direct influence toward corporation's performance and competitive competence。The information produced from operation process can present financial position performance。The decision maker may receive the explicit output from synthesis analysis。The electrical industry in China is the researching objective in this dissertation。The electrical industry has key effect of supporting states'public development, it has accumulated loads of data by managing the development of information system。The status of industrial development can be reflected by reviewing and analysing financial statements。This dissertation uses financial statements from top-ranked corporations electrical industry for data fundamentals, analyses the demand and conducts feasibility studies, constructs financial indexes data storage, applies SQL Server 2005 to convert data, builds up data base model and multidimensional datasets, applies OLAP technical analysing covariance of financial indexes among electrical companies, outputs result。Detailed analysing to primary operating revenue and profit indexes suggested the targeted four electrical corporations of having steady growth in full aspect。The dissertation analysed cost structures and suggested the way of proper costing, and obtained the covariance and correlation output among variable financial indexes by adopting the method of comparative analysis。For instance, the covariance between current liability and current asset suggested that the corporation maintained good cash flow accumulation in response to solvency and liquidity in good standing。The covariance among long-term investment, shareholders'interest, primary operation revenue and current asset suggested realized long-term investment would secure the growth of shareholders'interest。Liquid Assets is an important factor of corporation's income growing steadily。And the analysis did not suggest the strong covariance between share price and corporation's earnings。The efficient results from OLAP analysis will be presented in the form of statements。...