Summer Sets: Microsoft Power BI + Microsoft PivotTables

Excel With Business

Course

Online

Save 83%
£ 19 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    14h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Learn to analyse and present data quickly and easily using PivotTables whilst using Microsoft Power BI to create compelling visualisations and reports which provide profound insights into your data.

With this duo, we will take you step-by-step from the basics through to dominating your data.

Microsoft Power BI offers users true Self-Service Business Intelligence. Power BI enables business users to interact with corporate information and to extract the reports and intel they need to make data-based business decisions.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

Excel can feel daunting – in particular, the infamous PivotTable™ function, which is widely spoken about and little understood. In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.

But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 5 years

Subjects

  • Query editor
  • Reporting
  • Relationships
  • Calculated
  • Columns
  • Data Modelling
  • DAX expressions
  • Dashboards
  • Potential clients
  • Business partners
  • Desktop
  • Mobile Apps
  • Data sources

Course programme

What you will learn in these courses:

Microsoft PowerBI:

  • How to use the Query Editor to transform and morph data into the right format for your reporting purposes.
  • How to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.
  • How to share dashboards and reports, with colleagues, business partners and potential clients.
  • How to use Power BI’s sophisticated security features to control the exact content your audience can view.
  • How to use Power BI Desktop, Service and Mobile Apps
  • How to connect with a variety of data sources

Microsoft PivotTables:

  • The primary uses of pivot tables
  • How to identify the best and worst datasets
  • To filter, sort and group PivotTable™ data to maximise its usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting

See related categories

Summer Sets: Microsoft Power BI + Microsoft PivotTables

£ 19 VAT inc.

The best Excel courses

See all

See all