Available

Register Interest

Analysing and Visualising Data with Power BI

Date

23/04/2024 (1 day)

Time

09:00 till 16:00

CPE Hours

6 hours

Competency

Professional

Location

The Hub, PwC Academy or Online

Price

€300

Category:

Course Description

Power BI for Excel is a powerful tool which allows you to consolidate and mine data from multiple sources, investigate trends, create dashboards and make sense of your business data with just a few clicks in the familiar environment of Excel. Now it is possible to process millions of rows of data in Excel enabling deeper business insight and shorter decision making cycles.

If you are looking to boost your business or advance your career, then Power BI Training is for you. No previous experience required as we show you everything from the start but if you know a little about Excel formulas, one-to-many relationships in Access, SQL queries, VLOOKUP, PowerPivot Reports, you have a head start.

Course Structure

The following topics will be tackled:

Using Power Query

  • Get data from various sources
  • Importing data in excel from various data sources (online, web search, spreadsheets, various database sources, Facebook, Microsoft exchange and others)

First Steps with PowerPivot

  • Working with Classic Excel PivotTables
  • Working with PivotTables in PowerPivot
  • Importing, Querying Data and Creating a Data Model
  • Creating PivotTables from multiple data sources

PowerPivot at Work

  • Using the PivotTable to Produce Reports
  • Formatting Numbers
  • Adding Calculated Columns
  • Adding Measures
  • Adding More Tables
  • Refreshing Data
  • Using Slicers
  • Extending the Data Model relationships using Excel, PowerPivot and DAX
  • Create row-level-security (RLS)

Power BI Service

  • Publish report to Power BI Service
  • Print to PDF
  • Export data to Excel
  • Show workspaces
  • Create Dashboards in Power BI Service
  • Set scheduled refresh
  • Manage Dataset permissions
  • Share reports
  • Assign RLS to user

Should Attend

The course is ideal for anyone who has a good knowledge of Excel and would like to learn Power BI.

Prerequisites

A very good knowledge of Excel, including a working knowledge of PivotTables.

Assessment

There is no final assessment. Students will be guided during the course.

Key-Features

At the end of the course, delegates will be able to use Power BI as a Self-Service BI tool. Users will learn Power Query for importing and transforming data from a multitude of data sources, building data models in Power Pivot and building Pivot Tables reading from multiple tables and finally creating interactive visualisations in Power BI Desktop or Power BI for o365.

We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our delegates and can be applied directly in the training.

Each delegate will be given a digital courseware manual to refer to, both during and after the course.

Attending delegates will be presented with a Certificate of Attendance upon completion of training.

Course Structure

The following topics will be tackled:

Using Power Query

  • Get data from various sources
  • Importing data in excel from various data sources (online, web search, spreadsheets, various database sources, Facebook, Microsoft exchange and others)

First Steps with PowerPivot

  • Working with Classic Excel PivotTables
  • Working with PivotTables in PowerPivot
  • Importing, Querying Data and Creating a Data Model
  • Creating PivotTables from multiple data sources

PowerPivot at Work

  • Using the PivotTable to Produce Reports
  • Formatting Numbers
  • Adding Calculated Columns
  • Adding Measures
  • Adding More Tables
  • Refreshing Data
  • Using Slicers
  • Extending the Data Model relationships using Excel, PowerPivot and DAX
  • Create row-level-security (RLS)

Power BI Service

  • Publish report to Power BI Service
  • Print to PDF
  • Export data to Excel
  • Show workspaces
  • Create Dashboards in Power BI Service
  • Set scheduled refresh
  • Manage Dataset permissions
  • Share reports
  • Assign RLS to user

Should Attend

The course is ideal for anyone who has a good knowledge of Excel and would like to learn Power BI.

Prerequisites

A very good knowledge of Excel, including a working knowledge of PivotTables.

Assessment

There is no final assessment. Students will be guided during the course.

Key-Features

At the end of the course, delegates will be able to use Power BI as a Self-Service BI tool. Users will learn Power Query for importing and transforming data from a multitude of data sources, building data models in Power Pivot and building Pivot Tables reading from multiple tables and finally creating interactive visualisations in Power BI Desktop or Power BI for o365.

We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our delegates and can be applied directly in the training.

Each delegate will be given a digital courseware manual to refer to, both during and after the course.

Attending delegates will be presented with a Certificate of Attendance upon completion of training.

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.