If you’ve always wanted to add data analysis skills to your CV but were intimidated by the need to learn programming languages such as Python or C++, this course is for you. Learn to prepare, blend, and analyse datasets using common software solutions – Excel, Power BI, and Tableau – to uncover valuable insights and drive business decision making. No coding required!
COURSE LENGTH:
COURSE STRUCTURE:
- Everyday Data Analysis
- Data Fundamentals
- Excel Fundamentals
- Excel Statistical Analysis
- Excel Workshop
- Power BI: Getting Started
- Power BI: Intermediate
- Power BI: Case Study
- Introduction to Tableau
- Creating Dashboards in Tableau
- Tableau: Case Study
- Data Communication
STUDY OPTIONS:
Part Time
1 x 3 hour live online evening class per week over 12 weeks
SUMMARY:
Data has become a vital factor in problem solving and decision making. Most professional roles require you to either present or understand data analysis. This practical and experiential course will take you through the essentials of data analysis, so you understand how to think about data and use data within your organisation without having to write a single line of code.
Excel, Power BI, and Tableau are some of the most widely used solutions in business. This course will show you how to use these tools to collate, clean, sort, blend, and analyse your datasets, then present your findings in the most effective manner (charts, graphs, dashboards, and other visualisations). These transversal skills will be applicable in all kinds of roles and at every level in an organisation.
Designed to be interactive and hands-on, this course is ideal for professionals who don’t wish to learn coding but recognise the importance of data in their organisation. It will help you understand the challenges and opportunities that data analysis presents in industry and equip you to become a better communicator of data.
SYSTEM REQUIREMENTS 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.
CAREER OPPORTUNITIES:
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. The business intelligence and analytics solutions you’ll discover on this course are widely used by companies like Amazon, Experian, and Unilever to explore, display, and securely exchange data. This UCD Professional Academy Diploma will demonstrate your ability to create reports and dashboards with ease and confidence. This course is also the ideal introduction for students considering a career track such as Data Analyst, Data Scientist, Data Engineer, or Machine Learning Scientist.
ASSESSMENT AND CERTIFICATION
This course is assessed through an Excel project (worth 40% of your assessment) completed half-way through the course and a final project (using either Power BI or Tableau) 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.
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’ll also be able to add the certification to your LinkedIn profile to demonstrate your achievement to your network as well as recruiters and potential employers searching for individuals with your skills and experience.
This course is not on the National Framework of Qualifications.
LEARNER PROFILE:
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 emphasis 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!
