Christmas Sale: Save up to €500 on select courses. Ends soon!
Christmas Sale: Save up to €500 on select courses. Ends soon!
Choose Your Start Date
Browse our upcoming live online classes. Download your brochure to learn more.
Secure your place by paying in full or availing of our payment plan. For Part-time, on demand and on campus courses, pay in three equal interest-free instalments. For full-time Bootcamps enrol with a 50% deposit and the rest at the course start date. T&C's apply.
Why UCD Professional Academy?
- Valuable, trusted certification
- Industry expert lecturers
- Flexible learning options
Data Analysis Without Coding Course Modules
This practical and experiential course will give you a solid foundation in data analysis. It assumes no previous experience with the three solutions used – Excel, Power BI, and Tableau – and you will not have to learn or use code to source, clean, filter, or transform your datasets. Instead, you will focus on everyday data analysis skills that could be applied across a wide range of business situations, with a focus on the data process and understanding how data can be used to drive decision making and problem solving. There will be real-world case studies to explore and plenty of break-out sessions for peer-supported exchange, learning, and application in small groups.
1. Everyday Data Analysis
Learn about the fundamental role of data in decision-making, problem-solving, and innovation across industries. See how data can be transformed into valuable insights through analytics, and how these insights can be used to improve business performance and drive strategic decisions.
- The value of data in society
- Data types
- Sources of data
2. Data Fundamentals
Understand the different types and sources of data and the various formats it comes in. Learn about the data preparation process, which includes cleaning, filtering, and transforming data to ensure it is accurate and consistent. Discover data exploration techniques such as data profiling, statistical analysis, and data visualisation.
- Data workflow
- Data collection
- Data preparation
- Data pipelines
- Data analysis
3. Excel Fundamentals
Learn how to use various Excel functions to manipulate and analyse data efficiently. Understand how to clean data in Excel to eliminate errors and inconsistencies, as well as how to sort and filter data to focus on specific data subsets.
- Importance of data types
- Excel functions and formatting
- Cleaning data in Excel
- Sorting and filtering data
- Pivot Tables
4. Excel Statistical Analysis
Learn how to apply statistical functions to different data sets to draw meaningful conclusions. Look at data visualisation techniques by creating charts, graphs, and other visual aids to represent data effectively. Understand how to obtain insights and make data-driven decisions based on the analysis of the data.
- Statistical functions
- Data visualisation
- Case study
- Insights and decision-making
5. Excel Workshop
Having explored the fundamental concepts of data analysis, you will move into more practical applications of these skills and prepare for the first assignment.
- Excel workshop
- Setting up Tableau
- Setting up Power BI
6. Power BI: Getting Started
Explore the capabilities of Microsoft’s Power BI - its interface, functions, Power Query Editor (which is where you clean the data), and its ability to visualise data.
- Power BI capabilities
- The Power BI interface
- Transforming data using Power Query Editor
- Simple reports and visualisation
7. Power BI: Intermediate
Move onto more advanced concepts such as calculated columns and measures. Use these calculations to build more complex visualisations that contain deeper insights.
- Creating calculated columns and measures
- Working with relationships between tables
- Building more advanced visualisations
8. Power BI: Case Study
Use the skills and knowledge from previous units to build a comprehensive dashboard from start to finish. This will be a team effort that is guided by the lecturer.
- Power BI case study
- Building end-to-end dashboards
9. Introduction To Tableau
Explore the capabilities, interface, and functions of Tableau.
- Tableau and data visualisation
- The Tableau interface and components
- Data cleaning
- Creating basic visualisations
10. Creating Dashboards In Tableau
Learn how to manipulate data in Tableau. Explore multiple sources of data to identify patterns and create rich visualisations that reveal deep insights.
- Calculations and filtering in Tableau
- Combining data from multiple sources
- Blending data in Tableau
- Advanced chart types in Tableau
11. Tableau: Case Study
Use the skills and knowledge from previous units to build a comprehensive dashboard from start to finish. This will be a team effort that is guided by the lecturer.
- Tableau case study
- Building end-to-end dashboards
12. Data Communication
In the final lesson, explore how to use data as a tool for positive change by learning how to report insights in the most effective way.
- Storytelling with data
- Best practices for visualisation
- Activity: build an “effective” report
What our Alumni Say
Access to thousands of journals, articles and papers. Free of charge.
Students taking part in this course will now have access to the EBSCO Online Library, free of charge, for the full duration of the course. Here you can browse thousands of relevant journals, articles and other reliable academic and commercial texts like the Harvard Business Review, Bloomberg Businessweek and Forbes Magazine, to supplement your learning and assignments.
Download BrochureWe've trained the employees of
){kind=logo}
){kind=logo}
)
)
){kind=logo}
){kind=logo}
){kind=logo}
){kind=logo}
){kind=logo}
Relevant skills for your team, results for you.
Whether you’re interested in making your training budget work harder with volume discounts across our standard portfolio, or have bespoke training needs to be addressed, we’ll help you level up. Our team of upskilling experts are ready to take the pain out of meeting your training targets.
Talk to our expertsFrequently Asked Questions
Is this course right for me?
This course is ideal for professionals who need to start incorporating data analysis into their daily work but do not have the time or desire to learn programming languages such as Python or R. The goal is to introduce the fundamental concepts of data analysis and then show you how to gather and visualise data using some well-known tools. If you are interested in learning about the process of data collection and interpretation - with a practical focus on how data is used and how we can gain valuable insights from it - this course is for you!
Please note: learners must have a computer, broadband connection, and audio capable of running Zoom sessions. The course will require learners to install Microsoft Power BI and Tableau, or have access to the software. Learners must ensure that they have permissions to install software on their computers. Please note that Power BI is only compatible with Windows 10 and 11. It is the learner's responsibility to ensure they have access to a Windows 10+ PC to use Power BI. Mac users who cannot run Windows on their Macs can still complete the assessment without Power BI using Tableau.
How will this course help with my career?
Almost every professional role now includes an element of data analysis. Data insights can improve outcomes in any department and across every sector or industry, making data analysis a highly sought-after skill. This UCD Professional Academy Diploma will demonstrate your ability to create reports and dashboards with ease and confidence. The business intelligence and analytics solutions you'll discover on this course are widely used by firms like Amazon, Experian, and Unilever to explore, display, and securely exchange data.
What is the online learning experience like?
Our online experience is designed to be just as interactive, supportive, and inspiring as the UCD Professional Academy campus experience.
Online courses can be accessed from any computer or laptop with an internet connection.
Live lectures are delivered using Zoom. During these lectures, your teachers will use technology interactively to ensure an engaging learning experience. When appropriate, students will be encouraged to activate their microphones so that they can ask questions and communicate with other students.
What is the student experience like?
Student care is a high priority at UCD Professional Academy, which is why our Student Services team is on hand to support you throughout your time with us. They will respond to any queries you have, help you with any technical issues, and facilitate your learning experience at every point. All students are given access to our Student Portal, where you can see your timetable, access all your study materials, and manage your account.
How is this course assessed?
This course is assessed through an Excel project (worth 40% of your assessment) completed half-way through the course and a final project at the end of the course (worth 60% of your assessment). Both assignments involve analysing data to reveal and visualise useful insights, with an accompanying report explaining how your project was planned and executed. You can use a dataset of your own choosing (for example, one that is representative of your role or simply a topic you are interested in) or pick from pre-prepared datasets.
What are the benefits of a Professional Academy Diploma?
UCD Professional Academy Diplomas and Certificates are designed to give your career an advantage. Developed in conjunction with industry thought leaders our courses teach practical, applied skills to support you to achieve your career and business goals. Professional Academy Diplomas are suitable for career minded learners wishing to advance their professional skills and prospects rather than their academic credentials.
The Professional Academy is an independent wholly owned part of UCD designed to address the need for skills development in the workforce. Courses tend to be short, designed and delivered by industry practitioners, and are not part of nor do they lead to a traditional University award such as a degree or a masters. They are widely accepted by employers and many students are sponsored to study by their organisation.
For full details of UCD Professional Academy’s Certifications & Governance please visit https://www.ucd.ie/professionalacademy/governance/
How do I get my Professional Academy Diploma?
Your UCD Professional Academy Diploma will be issued electronically on a secure platform, with a link that you can share with employers and others wishing to verify your credentials. You can also add this certificate to your LinkedIn profile.
What payment options are available?
You can secure your spot on most of our Live Online, On-Campus, or On-Demand courses with a low 30% deposit. The remaining balance can be paid in two equal instalments (30 and 60 days later).
For full-time Bootcamp courses, you can secure your spot with a 50% deposit, with the remaining balance due prior to the start of your course.
Please note that standard terms and conditions apply, which you can review here: https://www.ucd.ie/professionalacademy/terms-and-conditions/