Data skills: Further Practice and Case Studies

Date

Ongoing

Time

On-demand

CPE Hours

16 hours

Competency

Professional

Location

eLearn

Price

€499

Course Description

Digitisation, technology and automation are considered key drivers for the future of work and data-driven decision making is critical for business success. Do you feel the need or want to become more tech-savvy to leverage and exploit data to its full potential? To identify risks and opportunities in and to surface value from your data and communicate results effectively? This e-learn introduces data-driven decision making, automation, analytics and innovation. Relevant terms, concepts and feature real life case studies are explained which aim to inspire technology enabled innovation. It has been developed by data scientists and business experts for business experts seeking to increase their data literacy and competency to remain relevant in today’s and the future work environment.

Course Structure

Learners work through a problem scenario with hands-on training and exercises in data analytic tools such as Power Query, Alteryx or Knime) and surface valuable insights with analytic and visualization software such as Tableau, Qlick and/or Power BI.

eLearn Structure

Chapter 1

  • Program context & navigating the training
  • Newsroom: New world, new skills
  • D&A success story: Recruiting Dashboard
  •  Data Analytics: basic terms and concepts
  • The data pyramid: from data to actionable insights and data driven decision making
  • Data preparation and data visualization basics
  • D&A success story: Transfer Pricing
  • Introduction to market leading BI tools
  • Introduction to case study

Chapter 2

  • D&A success story: Bookkeeping Analyzer
  • Data classification and information security
  • Data basics: Tidy data and data types
  • Quiz
  • Case study recap
  • Hands on: Data preparation training and co-create (I)
  • Data Analytics: approaches and techniques
  • Hands on: Visualization training and co-create (I)
  • Data Analytics challenge
  • Quiz

Chapter 3

  •  D&A success story: Audit & VAT
  • Data basics: data formats, pivoting and connecting data sets
  • Quiz
  • Case study recap
  • Hands on: Data preparation training and co-create (II)
  • Hands on: Visualization training and co-create (II)
  • Data Analytics challenge
  • Quiz
  • D&A success story: Payment Efficiency Insights (Internal Audit)

Should Attend

Participants who have a good understanding of data analysis and visualisation and would like to extend their theoretical knowledge with further practice using different data analysis tools and challenging themselves with practice scenarios which will
take them from a foundation to a more practitioner type of user.The program has been developed for business experts seeking to increase their data literacy and competency in data wrangling, cleansing, visualization and dashboarding.

Prerequisites

A certificate in Analysing and Visualising Data with Power BI. To complete the training, you require access to minimum of one or more data preparation and a minimum of one or more visualization software tool(s) in order to complete the training.

Below are the software tools required to complete the training. Free trial licenses are available.

  • Alteryx Designer
  • Knime Analytics Platform
  • Power Query (as add-in to Power BI Desktop and to Excel 2016 and newer versions)
  • Tableau Desktop
  • Power BI Desktop

Assessment

A final quiz that will test your knowledge.

Key-Features

Online self-paced, available 24/7

Course Structure

Learners work through a problem scenario with hands-on training and exercises in data analytic tools such as Power Query, Alteryx or Knime) and surface valuable insights with analytic and visualization software such as Tableau, Qlick and/or Power BI.

eLearn Structure

Chapter 1

  • Program context & navigating the training
  • Newsroom: New world, new skills
  • D&A success story: Recruiting Dashboard
  •  Data Analytics: basic terms and concepts
  • The data pyramid: from data to actionable insights and data driven decision making
  • Data preparation and data visualization basics
  • D&A success story: Transfer Pricing
  • Introduction to market leading BI tools
  • Introduction to case study

Chapter 2

  • D&A success story: Bookkeeping Analyzer
  • Data classification and information security
  • Data basics: Tidy data and data types
  • Quiz
  • Case study recap
  • Hands on: Data preparation training and co-create (I)
  • Data Analytics: approaches and techniques
  • Hands on: Visualization training and co-create (I)
  • Data Analytics challenge
  • Quiz

Chapter 3

  •  D&A success story: Audit & VAT
  • Data basics: data formats, pivoting and connecting data sets
  • Quiz
  • Case study recap
  • Hands on: Data preparation training and co-create (II)
  • Hands on: Visualization training and co-create (II)
  • Data Analytics challenge
  • Quiz
  • D&A success story: Payment Efficiency Insights (Internal Audit)

Should Attend

Participants who have a good understanding of data analysis and visualisation and would like to extend their theoretical knowledge with further practice using different data analysis tools and challenging themselves with practice scenarios which will
take them from a foundation to a more practitioner type of user.The program has been developed for business experts seeking to increase their data literacy and competency in data wrangling, cleansing, visualization and dashboarding.

Prerequisites

A certificate in Analysing and Visualising Data with Power BI. To complete the training, you require access to minimum of one or more data preparation and a minimum of one or more visualization software tool(s) in order to complete the training.

Below are the software tools required to complete the training. Free trial licenses are available.

  • Alteryx Designer
  • Knime Analytics Platform
  • Power Query (as add-in to Power BI Desktop and to Excel 2016 and newer versions)
  • Tableau Desktop
  • Power BI Desktop

Assessment

A final quiz that will test your knowledge.

Key-Features

Online self-paced, available 24/7

Register Your Interest:

    I would like to receive more information about PwC’s Academy training.

    Funding Schemes Available

    Funding for Individuals

    Find out how you could get up to 70% of your course fees back.

    Funding for Corporates

    Discover our funding options for businesses and find out how you and your employees could benefit.