Module Details

Module Code: MGMT8032
Title: Business Analysis & Reporting
Long Title: Business Analysis & Reporting
NFQ Level: Advanced
Valid From: Semester 1 - 2016/17 ( September 2016 )
Duration: 1 Semester
Credits: 5
Field of Study: 4820 - Information Systems
Module Delivered in: 1 programme(s)
Module Description: This module will provide students with the knowledge of how to apply skills, technologies and applications to disparate data sets with a goal of highlighting useful information, suggesting conclusions and supporting business decision making. It will also provide a thorough understanding of how to analyse, report and communicate business performance information.
 
Learning Outcomes
On successful completion of this module the learner will be able to:
# Learning Outcome Description
LO1 Evaluate the important role of data in supporting business decision making.
LO2 Identify, select and apply key performance metrics.
LO3 Apply software tools to import data from different sources.
LO4 Prepare data for analysis and create mashups between data sources.
LO5 Produce a business performance dashboard to report on key performance metrics.
Dependencies
Module Recommendations

This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named MTU module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
No incompatible modules listed
Co-requisite Modules
11896 MGMT8031 Financial & Shared Services
Requirements

This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.
No requirements listed
 
Indicative Content
Data and Decision Making.
Business Value of data and improved decision making. Big Data and analytics.
Performance Measurement
Selecting the right KPI's, KPI's as decision making tools, using the balanced scorecard.
Performance Dashboards
Dashboard design and planning, dashboard structure, design principles, functionality, choosing the right charts. Preparing data using Power Query. Use visualizations tools such as PowerView, PowerBI, Tableau.
Data Analysis
Import data from external sources , use tools to prepare the data for analysis, set up relationships between sets of data, explore functions to create aggregate calculations and measures.
Building Interactive Reports
Interactive controls, automating and distributing excel dashboards.
Module Content & Assessment
Assessment Breakdown%
Coursework100.00%

Assessments

Coursework
Assessment Type Practical/Skills Evaluation % of Total Mark 50
Timing Week 8 Learning Outcomes 1,2,3,4
Assessment Description
Lab based assessment
Assessment Type Project % of Total Mark 50
Timing Sem End Learning Outcomes 1,2,3,4,5
Assessment Description
Import data from multiple sources and analyse to same to produce business reports. Cross Modular Project with MGMT8031.
No End of Module Formal Examination
Reassessment Requirement
Coursework Only
This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.

The University reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lab Contact Computer Lab Practical Every Week 3.00 3
Independent & Directed Learning (Non-contact) Non Contact Self directed student learning Every Week 4.00 4
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 3.00
Workload: Part Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Independent & Directed Learning (Non-contact) Non Contact Self directed student learning Every Week 5.00 5
Lab Contact Computer Lab Practical Every Week 2.00 2
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 2.00
 
Module Resources
Recommended Book Resources
  • Bill Jelen. (2013), Pivot Table Data Crunching Excel 2013, [ISBN: 978-0-7897-48].
Supplementary Book Resources
  • Michael Alexander. (2013), Excel Dashboards & Reports, [ISBN: 978-1-118-490].
  • Bernard Maar. (2014), Key Performance Indicators (KPI): The 75 Measures Every Manager Needs to Know, [ISBN: 978-027375011].
  • Dan Clarke. (2014), Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map, [ISBN: 978-143026445].
  • Ron Person. (2013), Balanced Scorecards & Operational Dashboards with Microsoft Excel, [ISBN: 978-111851965].
  • Kenneth & Jane Laudon. (2015), Management information systems, Upper Saddle River, NJ; Pearson Education, [ISBN: 1292094001].
This module does not have any article/paper resources
Other Resources
 
Module Delivered in
Programme Code Programme Semester Delivery
CR_BBADM_8 Bachelor of Business (Honours) in Business Administration 2 Mandatory