Data Analysis for Accountants: Power BI

by Paula Guilfoyle

This course introduces you to Power BI, Microsoft's powerful data analysis tool, and how it can benefit you in your finance role. Transform the way you handle and analyse data, and create a range of interactive data visualisations.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Use Power BI's "Power Query" to connect to and transform your data into a useable format
  • Gain a deeper understanding of DAX (the language used in Power Pivot Excel)
  • Build on your ability to analyse data and learn to spot trends and patterns
  • Tell the story of your data using Power BI's data visualisations

About the course

Power BI is a self-service business intelligence package from Microsoft that helps you analyse across data sets and really get behind the numbers. It builds on Excel concepts but enables even more powerful data manipulation. It's a tool that every accountant can benefit from.

This course gives you an introduction into Power BI and helps you to develop the skills you need to handle and organise your data beyond what's possible in Excel. You'll explore the features of Power BI, which allow you to connect to, transform, model data. Gain an understanding of the data visualisations available in power BI that enable you to tell a story with your data.

Microsoft Power BI is currently only available for Windows. This course may not be suitable for those using Apple Mac.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Getting started with Power BI
    • Power BI Desktop
    • Overview of Power BI
    • Connecting to and transforming data
    • Relationships
    • Visualising data
    • Carrying out calculations
  • Power Query
    • Power Query Editor
    • Connecting to an Excel workbook
    • Changing a query
    • Connecting to a folder
  • Data modelling with DAX
    • What is DAX?
    • Calculated columns
    • Measures
    • X expressions
    • Related tables
  • Data visualisation
    • Visualization canvas
    • Tooltips and hierarchies
    • Slicers and chart interactions
    • KPI visualisations
    • Choosing the right visualisation

Author

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours1,000+ unitshourshours1,000+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours1,000+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours1,000+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours1,000+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours1,000+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses