Microsoft Power BI + Microsoft PivotTables

Sale

$138.00 $19.00

Clear section

Self-service Business Intelligence has never been so easy.

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.

Why Microsoft Power BI?

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.

Why PivotTables?

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.

What you get with this duo:

  • 70 modules of training.
  • Multiple videos, practice exercises and test questions to aid your learning.
  • Tailored learning. If you have some knowledge, you can use the filter to show only what you most need to learn.

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

Sample content:

More about us:

  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.

If you are not 100% happy with your EwB duo, you have 30 days to exchange or refund.

About the author:

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

 

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of producing public and on-site IT training content at different skill levels, to groups of varying sizes. His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of the UK and international clients.