Home

	Submit Your Article
	Member Login
	Top Authors
	Recently Added Articles
	Most Popular Articles
	Submission Guidelines
	Categories
	RSS Feeds

For Everyone »

	Sitemap
	Add to Favorites
	Top Article Directories
	Top Web Directories

Directory »

	Link to us
	Directory

Business Intelligence in Taxation

© By: Kostis Panayotakis

It is proposed that a ‘tax monitoring data mart’, be designed based on the dimensional model approach. A proposed high–level logical data model is depicted in the picture, based on the assumption that a critical mass of data (geographic & time dimension) in a sufficient data quality exists, rendering the implementation feasible...

Return to Article

You have permission to publish this article electronically or in print, free of charge, as long as you leave the article title, author name, body and resource box in tact (means No changes) with the links made active and you agree to our posted publisher terms of service.

Use the tools below to copy the article in plain text form, or you can copy it as HTML, ready to copy and paste directly into a web page.

Word Count Appx. : 496
Total Views : 257

HTML Version	<h1>Business Intelligence in Taxation</h1> © By: <a href='http://fileblogs.com/index.php?page=author&author_name=Kostis+Panayotakis' target='_blank'>Kostis Panayotakis</a><br><br> <p>Government Finance Divisions manage the execution of the fiscal policy: <ul><li>management of the taxation and tax audit process</li><li>management of the budget execution process</li></ul> Within the taxation framework, each State aims to support its taxation policy: <ul><li>Support the efficient capture and processing of tax declarations</li><li>Assure the collection of tax revenue according to plans</li><li>Manage and reduce the risk of Citizen non-compliance: reduce tax evasion levels and fight financial crime</li><li>Support the analysis of alternative future tax policies and relevant decision making, e.g. consequences of a change on State revenue </li><li>Enhance the Citizen experience, during the tax compliance process (e.g. offer e-government services). </li></ul> It is proposed that a ‘tax monitoring data mart’, be designed based on the dimensional model approach. A proposed high–level logical data model is depicted in the picture (check resource below), based on the assumption that a critical mass of data (geographic & time dimension) in a sufficient data quality exists, rendering the implementation feasible. The proposed high-level data model depicted in the figure, is a star schema with a number of fact tables surrounded by a set of common (or conformed) dimensions. The fact tables are of the ‘accumulating snapshot’ type, meaning that they accumulate information throughout each individual taxation transaction lifecycle. Most taxation types have a yearly lifecycle (i.e. personal income tax). VAT involves more frequent transactions. This data modeling approach offers advantages, compared to the operational systems data models (usually normalized database schemas):· The model is quite simple and can be easily understood by business (non-IT) users · The model’s simplicity has also positive consequences to the performance of queries Based on this infrastructure which would monitor the taxation lifecycle of various taxes, the Government can produce information:· on a taxpayer’s holistic view (all transactions she / he made) and support the non-compliance risk scoring and general tax audit process · on tax collection time-series analysis· on the time it takes between reception of tax declarations & clearance· on the tax collection speed· on the Taxpayer demographics (i.e. average declared income per professional code, geographic distribution of income)· total tax collected by tax office, compared to tax office attributes</p> <p>The model is expandable when the following principle is applied: the star schema dimensions (time, tax office, taxpayer) are conformed allowing the application of queries via conformed dimensions across different fact tables (drill across queries). This approach is known as Datawarehouse Bus Architecture.</p> <p>Copyright 2006 - Kostis Panayotakis</p> <br> <p>The ‘tax monitoring data mart’ is depicted in the following link <a target="_new" href="http://www.pleroforea.com/tax_monitoring_process_data_mart.htm">http://www.pleroforea.com/tax_monitoring_process_data_mart.htm</a></p> <p>A 'tax audit case data mart' is depicted in the following link <a target="_new" href="http://www.pleroforea.com/tax_audit_case_data_mart.htm">http://www.pleroforea.com/tax_audit_case_data_mart.htm</a></p> <p>Relevant material on Business intelligence can be found at <a target="_new" href="http://www.pleroforea.com">http://www.pleroforea.com</a></p><br><br> Read more Articles on <a href='http://fileblogs.com/Management&category_23' target='_blank'>Management</a> at <a href='http://fileblogs.com' target='_blank'>FileBlogs.com</a>
Plain Text Version	Business Intelligence in Taxation © By: Kostis Panayotakis Government Finance Divisions manage the execution of the fiscal policy: management of the taxation and tax audit processmanagement of the budget execution process Within the taxation framework, each State aims to support its taxation policy: Support the efficient capture and processing of tax declarationsAssure the collection of tax revenue according to plansManage and reduce the risk of Citizen non-compliance: reduce tax evasion levels and fight financial crimeSupport the analysis of alternative future tax policies and relevant decision making, e.g. consequences of a change on State revenue Enhance the Citizen experience, during the tax compliance process (e.g. offer e-government services). It is proposed that a ‘tax monitoring data mart’, be designed based on the dimensional model approach. A proposed high–level logical data model is depicted in the picture (check resource below), based on the assumption that a critical mass of data (geographic & time dimension) in a sufficient data quality exists, rendering the implementation feasible. The proposed high-level data model depicted in the figure, is a star schema with a number of fact tables surrounded by a set of common (or conformed) dimensions. The fact tables are of the ‘accumulating snapshot’ type, meaning that they accumulate information throughout each individual taxation transaction lifecycle. Most taxation types have a yearly lifecycle (i.e. personal income tax). VAT involves more frequent transactions. This data modeling approach offers advantages, compared to the operational systems data models (usually normalized database schemas):· The model is quite simple and can be easily understood by business (non-IT) users · The model’s simplicity has also positive consequences to the performance of queries Based on this infrastructure which would monitor the taxation lifecycle of various taxes, the Government can produce information:· on a taxpayer’s holistic view (all transactions she / he made) and support the non-compliance risk scoring and general tax audit process · on tax collection time-series analysis· on the time it takes between reception of tax declarations & clearance· on the tax collection speed· on the Taxpayer demographics (i.e. average declared income per professional code, geographic distribution of income)· total tax collected by tax office, compared to tax office attributes The model is expandable when the following principle is applied: the star schema dimensions (time, tax office, taxpayer) are conformed allowing the application of queries via conformed dimensions across different fact tables (drill across queries). This approach is known as Datawarehouse Bus Architecture. Copyright 2006 - Kostis Panayotakis The ‘tax monitoring data mart’ is depicted in the following link http://www.pleroforea.com/tax_monitoring_process_data_mart.htm A 'tax audit case data mart' is depicted in the following link http://www.pleroforea.com/tax_audit_case_data_mart.htm Relevant material on Business intelligence can be found at http://www.pleroforea.com Read more Articles on Management at FileBlogs.com
Article URL

See All articles From Author

For Authors »

For Everyone »

Free Newsletter »

Member Login »

Directory »

Business Intelligence in Taxation