ITECH7406- Business Intelligence and Data Warehousing
27 Pages4746 Words204 Views
Added on 2019-10-30
ITECH7406- Business Intelligence and Data Warehousing
Added on 2019-10-30
ShareRelated Documents
Running head: ITECH7406- Business Intelligence and Data WarehousingTECH7406- Business Intelligence and Data WarehousingName of the studentName of the university
1ITECH7406- BUSINESS INTELLIGENCE AND DATA WAREHOUSINGExecutive summaryThe following report has been designed and compiled for the understanding of thebusiness intelligence procedures and the working of the data warehousing. The reporthas been compiled with the help of an environmental issue related data set and adescriptive and predictive data analysis has been done on the data set. There is aninclusion of the justification of the dashboard that has been used for the compilation ofthe data set. To conclude the report there is an inclusion of recommendation for theCEO of the organization to follow which will help in them to increase their profit andchange their objectives in order to make their organization better in the marketcompetition.
2ITECH7406- BUSINESS INTELLIGENCE AND DATA WAREHOUSINGTable of ContentsIntroduction........................................................................................................................3Description of the data set used for the analysis.........................................................3Descriptive analysis..........................................................................................................4Predictive analysis..........................................................................................................10Justification of dashboard usage..................................................................................17Recommendation to the CEO.......................................................................................19Conclusion........................................................................................................................19References.......................................................................................................................21Bibliography.....................................................................................................................23
3ITECH7406- BUSINESS INTELLIGENCE AND DATA WAREHOUSINGIntroductionBusiness intelligence is the term, which includes the use of different applicationand infrastructures for the analysis of data for the improvement of decision making foran organization to improve the performance (Arnott, Lizama & Song, 2017) (Shollo &Galliers, 2016). The report has the discussion based on environmental issues aroundthe world. The report further discusses about the data set that has been used for theanalysis, the descriptive analysis of the data set created on the software, the predictiondone from the data set used, a brief justification of the dashboard that has been createdand the recommendation to the CEO of the organization (Basole, 2014).Description of the data set used for the analysisThe data set, which has been used for the analysis in this report, consists of 16locations and the subsequent carbon monoxide (CO), nitrous oxides (NOX), sulfuroxides (SOX), Volatile organic compound (VOC) and carbon dioxide (CO2) gasemissions. The locations which has been chosen for the analysis of the data are:1.Argentina2.Australia3.Brazil4.Canada5.China6.France7.Great Britain
4ITECH7406- BUSINESS INTELLIGENCE AND DATA WAREHOUSING8.Indonesia9.India10.Italy11.Japan12.Korea13.Mexico14.Russia15.Saudi Arabia16.Turkey17.United StatesThe original dataset which had been found was large. For the simplicity of thepredictive analysis of the data the data set was trimmed down to the respective dataset.The data has been collected for a period of 5 years from 2010 to 2014. This amount ofdata has been collected from various sources and analysis has been done. As per thenature of the data chosen for the analysis, the predictive research cannot be compiledwith the help of the SAP Predictive Analysis. The predictive analysis has been done onthe same data with the help of triple exponential smoothing. The prediction of the datahas been done for 3 future years. Descriptive analysisThis section describes the data set which has been selected for the analysis ofthe report. The following charts and description provide a brief insight about the data.
5ITECH7406- BUSINESS INTELLIGENCE AND DATA WAREHOUSINGFigure 1: CO, CO2, NOX, SOX and VOC gas emission for selected country byyearThe above chart shows a column chart where all the data that has been collectedfor the analysis has been plotted against the relevant years. The visual representationprovides the reader to understand the total sum of CO, CO2, NOX, SOX and VOCgasses that are emitted from the 17 countries of the world. From the visual it can beseen that the highest amount of gas which is emitted in the world is the CO gas. TheCO is followed by NOX and eventually, VOC, CO2 and at the end with the lowestamount of emission is SOX. The data which has been analyzed is from 2010 to 2014and the gradual decrease in the height of the columns shows that the countries havetried to reduce the amount of pollutant that has been produced by the respectivecountries. The sum of NOX gas emission over the years has also decreased. Apart fromthe value of CO2 all the rest of the gas emissions has decreased over the period of 5years. The effect of CO2 is more than the other gasses combined and due to the recentrise in the population of the world the amount of vehicles and the use of fuels has
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Intelligence And Data Warehousing Design and Compilationlg...
|23
|4672
|479
ITECH7406 Business Intelligence and Data Warehousinglg...
|26
|4697
|33
MIS781 Business Intelligence Reportlg...
|21
|5240
|75
Business Intelligence Reporting Solution or Dashboard?lg...
|25
|3799
|155
Business Intelligence and Data Warehousing for Earth's Environment Issueslg...
|21
|3855
|448
Environmental Issues and Business Intelligence Reportinglg...
|17
|2322
|480