DCU Home | Our Courses | Loop | Registry | Library | Search DCU

Module Specifications..

Current Academic Year 2023 - 2024

Please note that this information is subject to change.

Module Title Business Analytics 1
Module Code MT120
School DCUBS
Module Co-ordinatorSemester 1: Gerry Conyngham
Semester 2: Gerry Conyngham
Autumn: Gerry Conyngham
Module TeachersDes McLaughlin
Gerry Conyngham
Cliona McParland
NFQ level 8 Credit Rating 5
Pre-requisite None
Co-requisite None
Compatibles None
Incompatibles None
Repeat the module

The module aims to develop the relevant skills and knowledge to effectively use basic IT tools to manage and manipulate data and provide a basic IT data management ‘literacy’ that is now an essential feature of work in modern organisations. Online tools are used to provide students extensive training in MS EXCEL, an Introduction to Data Visualisation and Viulaisation Software (Power BI and Tableau) and support in developing their MS WORD, POWERPOINT and other IT skills that are needed to collect, critically assess, manipulate data to provide useful information for management. Students are also introduced to data types, data collection, data management and basic data analysis and given an introduction to Data Analytics and the growth of data and data driven functions in organisations.

Learning Outcomes

1. Will be able to describe the fundamental concepts of Data Literacy and Analytics, the key steps in the analytics process, and the applications and implications of data analytics.
2. Distinguish between different data types, choose the appropriate techniques for gathering reliable and valid primary data and identify and extract data from reliable secondary data sources.
3. Apply the basic principles of effectively communicating data visually using software applications, including MS EXCEL, POWER BI and TABLEAU.
4. Use the appropriate descriptive statistics techniques to effectively summarise a wide variety of data types.
5. Be proficient in the use of MS EXCEL spreadsheet software.

Workload Full-time hours per semester
Type Hours Description
Online activity50Online Training in MS EXCEL and Fundamentals of Data Analytics
Assignment Completion10Ms EXCEL Assignment
Assignment Completion25Weekly Exercises
Independent Study15No Description
Workshop12Workshops in MS Excel
Total Workload: 124

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

Introduction to Data Analytics
- What is Data Analytics - Evolution - Role in the Organisation

Information Systems/Fundamentals of Software
Introduction to Information Systems in organisations and how they are used to enable operations and strategy

Skills and Tools to Organise
- Setup (download applications & setup accounts), Organise - Accessing online learning support tools, LOOP, Zotero, Library, ISS, etc. - Manage professional social media profile – LinkedIn profile etc. - Introduction to Kubicle (Online Learning Platform) - Report and Presentation (MS WORD and MS POWERPOINT) - Spreadsheets (Introduction to MS EXCEL) - Google Apps (Google Docs, Google Sheets, Google Forms)

Introduction To Data Visualisation
- What is Data Visualisation and Why is it important? - Introductions to Data Visualisation in MS EXCEL, Communicating using Visualisations - Choosing correct tools - Introduction to TABLEAU and POWER BI

Sources of Data / Cleaning Data
Primary Data: Questionnaires (Using Google sheets and Qualtrics), Focus Groups, Interviews, Observation Secondary Data Sources, “Big Data” 5 Vs of Big Data, Data Types: Structured / Unstructured, Measurement Error, Cleaning Data

Business Statistics 1: Descriptive Statistics
Describing Data - Frequency Tables - Descriptive Statistics - Crosstabs - Data Visualisation (Patterns in Data)

MS EXCEL - Data Manipulation and Formatting
Adding, Editing and Deleting Cells, Essential Shortcuts in MS EXCEL, Inserting Rows and Columns, Adjusting Rows and Columns, Formatting Cells, Grouping and Hiding Cells, Sorting and Filtering Cells

MS EXCEL - Formula and Functions
Basic Arithmetic Functions, Conditional Arithmetic, Max, Min and Average Functions, Logical Operators, Naming and Anchoring Cells, Array Formulas, Conditional Arithmetic, Generating Random Numbers, Formula Auditing, Fill Commands, Information Functions, Rounding Numbers,

MS EXCEL - Text, Time and Dates
Combine Strings of Text, Search for Strings in Datasets, Covert Dates from Text into Values, Analyse Data by Day of Week, Combine Dates and Times, Add annd Subtract Times, Analyse Data within Time Intervals

MS EXCEL - Lookup and Database Functions
Finding records with Vlookup, Naming Arrays, Lookups with INDEX and MATCH, Nested IF, Dropdown List, Ranking Data Records, Lookup Multiple Criteria, Database functions, Updating Formula with New Data,

MS EXCEL - Pivot Tables
Building Pivot Tables, Formatting Pivot Tables, Pivot Table Subtotals, Sorting Pivot Table, Data, Applying Filters, Pivot Table Slicers, Build Charts from Pivot Tables, Using Pivot Table Data in Formulae.

MS EXCEL - Basic Statistics using MS EXCEL
Mean, Median and Mode, Creating Databins, Variance and Standard Deviation, Finding Trends in Data, Correlation,

MS EXCEL - Creating Charts in MS EXCEL
Formatting Charts, Adding Labels and Chart Titles, Legends and Data Tables, Actual vs Target Charts, Export Charts to MS WORD or POWERPOINT

Assessment Breakdown
Continuous Assessment100% Examination Weight0%
Course Work Breakdown
TypeDescription% of totalAssessment Date
In Class TestMS EXCEL Proficiency Exam50%As required
ParticipationCompletion of Online Courses and Digital Exercises on Loop on schedule* Students must complete the 4 Mandatory Online Courses to Pass Module Overall.15%Every Week
Digital ProjectOngoing Digital exercises: Loop quizzes, Technical exercises, online tests,.....15%Every Second Week
Digital ProjectDescriptive Statistics assignment using MS EXCEL20%n/a
Reassessment Requirement Type
Resit arrangements are explained by the following categories;
1 = A resit is available for all components of the module
2 = No resit is available for 100% continuous assessment module
3 = No resit is available for the continuous assessment component
This module is category 1
Indicative Reading List

    Other Resources

    59367, Online Training, Kubicle, 0, Online Analytics Training for Business, 59368, Book, Frye, Curtis., 2016, Microsoft Excel, Redmond, Washington, USA:, Microsoft Press, 59369, Ebook, Michael Alexander, Richard Kusleika, 2019, Excel 2016 Formulas, John Wiley & Sons, 59370, Website, 0, Microsoft Online Support, https://support.office.com/, 59371, Ebook, Justin Bateh and Bert G. Wachsmuth, 2016, Using Statistics for Better Business Decisions, Business Expert Press, 59372, EBook, Cole Nussbaumer Knaflic, 2015, Storytelling with Data : A Data Visualization Guide for Business Professionals,, John Wiley & Sons, 59373, Book, Tufte, Edward R., 2001, The Visual Display of Quantitative Information. 2nd edition., Graphics Press USA, 59374, EBook, EMC Education Services, 2015, Data science & big data analytics: discovering, analyzing, visualizing and presenting data, Indianapolis, Indiana, John Wiley, https://ebookcentral-proquest-com.dcu.idm.oclc.org/lib/DCU/detail.action?docID=1908952, 59375, Book, Bocij, Paul, Andrew Greasley, and Simon Hickie, 2014, Business Information Systems, 5th Edn: Technology, Development and Management for the E-Business, Harlow, England ;, Pearson, 59376, Ebook, Mark N. K. Saunders, Adrian Thornhill and Philip Lewis, 2017, Research Methods for Business Students, Pearson Education Limited, 59377, Ebook, Jaggia S, Kelly A., Lertwachara K. and Chen L., 2020, Business Analytics: Communicating with Numbers, McGraw Hill,
    Programme or List of Programmes
    AFBA in Accounting and Finance
    AMPSBSc in Aviation Management
    BSBachelor of Business Studies
    BSSAOStudy Abroad (DCU Business School)
    DBIBSc in Digital Business and Innovation
    EBCBA in Global Business (Canada)
    EBFBA in Global Business (France)
    EBGBA in Global Business (Germany)
    EBSBA in Global Business (Spain)
    EBTBA in Global Business (USA)
    INTBBachelor Business Studies International
    MINTBSc Marketing, Innovation & Technology

    My DCU | Loop | Disclaimer | Privacy Statement