Module: Business Analytics 1

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-ordinator	Semester 1: Gerry Conyngham Semester 2: Gerry Conyngham Autumn: Gerry Conyngham
Module Teachers	Des McLaughlin Gerry Conyngham Cliona McParland
NFQ level	8	Credit Rating	5
Pre-requisite	None
Co-requisite	None
Compatibles	None
Incompatibles	None

Repeat the module

Description

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.

*Type*	*Hours*	*Description*
Workload	Full-time hours per semester
Lecture	12	Lectures
Online activity	50	Online Training in MS EXCEL and Fundamentals of Data Analytics
Assignment Completion	10	Ms EXCEL Assignment
Assignment Completion	25	Weekly Exercises
Independent Study	15	No Description
Workshop	12	Workshops 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 Assessment	100%	Examination Weight	0%

Type	Description	% of total	Assessment Date
Course Work Breakdown
In Class Test	MS EXCEL Proficiency Exam	50%	As required
Participation	Completion 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 Project	Ongoing Digital exercises: Loop quizzes, Technical exercises, online tests,.....	15%	Every Second Week
Digital Project	Descriptive Statistics assignment using MS EXCEL	20%	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

AF	BA in Accounting and Finance
AMPS	BSc in Aviation Management
BS	Bachelor of Business Studies
BSSAO	Study Abroad (DCU Business School)
DBI	BSc in Digital Business and Innovation
EBC	BA in Global Business (Canada)
EBF	BA in Global Business (France)
EBG	BA in Global Business (Germany)
EBS	BA in Global Business (Spain)
EBT	BA in Global Business (USA)
INTB	Bachelor Business Studies International
MINT	BSc Marketing, Innovation & Technology

Archives: