£750.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.
Power BI Pro is Microsoft’s competitively-priced, cloud-based business analytics service. 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.
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
Our scheduled training courses take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248
When booking on-site training, use the pricing zone map below to determine the daily rate based on the location of your organization: zone A, £795, per day; zone B, £895, per day; zone C, £995, per day.
|Choose a Date||
22-23 Jul 2019 – London, 19-20 Aug 2019 – London, 23-24 Sep 2019 – London, 11-12 Nov 2019 – London, 9-10 Dec 2019 – London, 13-14 Jan 2020 – London, 10-11 Feb 2020 – London, 16-17 Mar 2020 – London, 11-12 May 2020 – London, On-site training – Zone A, On-site training – Zone B, On-site training – Zone C