£790.00 – £1,990.00
This Power BI training course aims to familiarize subscribers to Power BI and Power BI Pro with the key features and operations of the Power BI service, as well as with the use of Power BI Desktop to prepare reports.
In this basic Power BI training course, you will learn all the essentials features of Microsoft’s competitively-priced, cloud-based business analytics BI platform. This Introductory Power BI training course aims to familiarize subscribers to Power BI and Power BI Pro with the key features and operations of the Power BI service, as well as with the use of Power BI Desktop to prepare reports.
The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports and datasets
Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack
Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server
Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command
Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction
Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions
Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers
Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports
Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content in app workspaces; Assigning groups to app workspaces; Publishing apps; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page
Optimising visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports
Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions
Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data
We run this scheduled Power BI training course regularly as a public, instructor-led online course. Our online classes are small, with a maximum of eight delegates and each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught.
All of our scheduled public courses are now run online. When we resume the running of our in-person scheduled training courses, they will take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248
If you have several staff members that need to complete this training, we can arrange a private instructor-led online training course tailored to the requirements of your organisation. Each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught remotely. This means that your staff can attend a course either in the office or from home.
7-8 Dec 2020 (Tutor-Led Online), 11-12 Jan 2021(Tutor-led, Online), 8-9 Feb 2021(Tutor-led, Online), 15-16 Mar 2021(Tutor-led, Online), 19-20 Apr 2021(Tutor-led, Online), 10-11 May 2021(Tutor-led, Online), 21-22 Jun 2021(Tutor-led, Online), 26-27 Jul 2021(Tutor-led, Online), 23-24 Aug 2021(Tutor-led, Online), 13-14 Sep 2021(Tutor-led, Online), 11-12 Oct 2021(Tutor-led, Online), 8-9 Nov 2021(Tutor-led, Online), 6-7 Dec 2021(Tutor-led, Online), Private Tutor-Led Training