Excel Power Business Intelligence Tools

BPP Professional Education
Course summary
6 hours
634 GBP excl. VAT
London, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses
Professional Training

Course description

Excel Power Business Intelligence Tools

This one day course covers the newly introduced range of Excel Power BI tools (Power Business Intelligence). Learn how to use all of these latest features introduced in Excel which will help in business processing, data analysis, financial reporting, and with day-to-day decision making. Become confident with what Microsoft are now including as standard, and with what is now starting to become a benchmark in advanced Excel skills.This course is very hands-on with Excel, and offers all the advice and software practice utilising these advanced tools which include building queries to extract, transform, and load data, and also to create elegant data models with PowerPivot. This involves analysing multiple data sets, working with cross-sectional data, merging different sets to create one data model, and using a key range of brand new formulas in Excel.The course also covers an introduction into the world of DAX formulas (Data Analysis Expressions), designed to work with relational data and perform dynamic aggregation.All of the latest Excel power BI tools in one course.

COVID-19 Update

This provider offers an online version of their classroom courses

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Suitability - Who should attend?

The course material includes advanced features of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is recommended that they already have attended Data Analysis with Excel – Advanced , or have the equivalent level of knowledge.At a minimum, it is assumed that participants will know how to do some of the following:Navigate confidently in ExcelAn understanding of the benefits in nesting functionsWork with inherited spreadsheets from othersEnjoy using Excel for analysis and similar business processes, using tools such as PivotTables

Training Course Content

Best practice in producing quality reports; picking up sample data and creating a reportIntroduction to PowerPivotHow PowerPivot differs from a PivotTableFiltering rows/columnsData and diagram viewCombining data sourcesPowerPivot data modelsCreate a PowerPivot data modelExtract meaningful insight from a data modelDynamic filters with slicers and timelinesCreating and editing data relationshipsGet data / power import from external sourcesWhat is Power Query and when to use itQuery editor overviewQuerying a databaseManaging data sources and queriesColumn, row and calculated transform actionsFurther Power Query featuresOutput to a PowerPivot data modelAutomate reoccurring tasksThe ‘M’ languagePower MapSetup and overview of Power MapLocalising data & geographic plots across the globeTypes of mapMore advanced tools in Power MapMake a killer map in under 5 minutesTouringIntro to sharing stories and videosIntroduction to DAX (BI) functionsWhat is DAX?How to create effective DAX formulasFunctions: SUM; CALCULATE; RELATED; AGGREGATE; and moreRankingPutting it all togetherCreate a report with real-world data: PowerPivot, Power Query, Power MapCreate calculated fields and calculated columnsExtract and transform dataBonus topicsDAX cheat sheetCalculated items and KPIsFully integrated Power Report to take away for own useFurther exploration and advice into queries and database connectivityHomework topics for further studyNote that the course content is compatible with the following versions of Excel: Excel 2013 Professional Plus, Excel 2016 Professional Plus, Office 365 ProPlus.

Get Inspired! Watch the Video

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel Power Business Intelligence Tools.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Excel Power Business Intelligence Tools course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here