Our 3-day Power BI course is aimed at IT professionals who will be responsible for optimizing data and creating Power BI reports. Students will become familiar with the key features and operations of the Power BI service, as well as with the use of Power BI Desktop to prepare reports. Delegates on this Power BI course will learn how to connect to local data sources and online services; customize and transform data sources to suit their own requirements; model data by creating relationships, calculated columns and measures; create reports using a wide variety of visualizations; publish reports to the Power BI service; distribute reports and dashboards both internally and to a wider audience; and schedule automatic refreshes of their datasets.
This Power BI course can be delivered anywhere in the UK and costs £1,775, plus VAT. Call us now on 0800-998 9248 for more information.
G Com Solutions also offer a 5 day intensive Power BI Training Course which includes coverage of advanced features.
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
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 Packs; Assigning groups to content packs; 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
Benefits of parameters and templates; Creating parameters; Parameter value types; Parameterizing data sources; parameterizing filters; Creating a template; Using a template
Converting a query to a function; Understanding function syntax; Invoking a function
Calendar tables; Power BI Auto Date/Time feature; The TOTALYTD function; Specifying end of fiscal year; Calculating running totals; the SAMEPERIODLASTYEAR function; the PARALLELPERIOD function; Using the DATEADD function for maximum flexibility
Creating a what-if parameter; Specifying limits; Referencing the parameter measure; Incorporating parameter values in your model
Analyze in Excel; Installing Power BI Publisher for Excel; Creating pivot table reports from Power BI data sources; The importance of data types; Error – The field that you are moving cannot be placed in that PivotTable area; Pinning Excel content to a Power BI dashboard
Overview of custom visuals; Chiclet Slicer; Timeline; Advanced Time Slicer; Hierarchy Slicer; Synoptic Panel; Waffle Chart; Percentile Chart; Box and Whisker; Histogram; Bullet Chart; KPI Indicator; GlobeMap; Table Heatmap; WordCloud
Planning narratives; Self-running narratives; Interactive narratives; Using the Bookmarks and Selection panes; Using the Pulse chart visual; Using the Scroller visual; Using Narratives for Power BI; Using video clips in your visuals