Centre for Continuing Education

Power BI and Excel Course

Data Analysis and Analytics. Uncover insights and transform your organisation.

This comprehensive course is designed for users who have reached the advanced level of Excel and want to start their journey in the data analysis field. It will complete your skills and prepare you to more effectively embrace new trends in the data analysis world.

Aims

This course aims to develop your ability to deal with different external data sources. It will provide instruction on how to perform data cleaning and how to create professional reports.

Outcomes

Upon successful completion of this course, participants should be able to:

  1. Differentiate between different kinds of data sources.
  2. Clean the datasets and prepare them for professional presentation purposes.
  3. Examine the various calculations and functions to create formulas and measures.
  4. Develop clear KPIs.
  5. Create professional Power Pivot reports using a Data model.
  6. Create stunning and dynamic dashboards in Power BI.

Content

Part 1

Excel Data Analysis

  • Getting Data – Excel
  • Data Modelling
  • Get & Transform
  • Using Power Query in Excel
  • Creating a New Query from a File
  • Creating a New Query from the Web
  • Understanding the Query Editor
  • Displaying the Query Editor
  • Managing Data Columns
  • Reducing Data Rows
  • Adding a Data Column
  • Transforming Data
  • Editing Query Steps
  • Merging Queries
  • Merged Queries

Power Pivot

  • Power Pivot and the Data Model
  • Enabling Power Pivot
  • Creating a Data Model Pivot Table
  • Creating a Calculated Field
  • Creating a Calculated Column
  • Formatting Data Model Fields

Dashboards

  • Building Smart Dashboards
  • Slicers and Spark Lines

Part 2

Power BI

  • Get data into Power BI
  • Building Data Model
  • Query Editor UI
  • Transform Data
  • Append and Merge Queries
  • Relationships and Cross Filtering
  • Measures and Calculated Columns
  • Filter Context
  • DAX
  • Time Intelligence
  • Quick Measures

Visualisation

Q & A

Intended Audience

This course is suitable for:

  • Data Analysts
  • DB Administrators
  • Project Managers
  • Anyone working in a finance role
  • Marketers.

Prerequisites

It is assumed participants have basic knowledge of database structures and relationships, as well as very good command in Excel.

Delivery Style

This workshop is delivered as presenter-taught computer-based training in a computer lab. It will involve blended learning whereby key concepts will be explained by the tutor and participants will have the opportunity to practice exercises on their individual work stations.

Materials

Participants will be provided with a hard-copy workbook and lab files.

Features

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion