Power BI Modelling, Visualisation and Publishing
- Learn to use Power BI (Business Intelligence) Desktop to create queries, data connections, and reports that can easily be shared with others.
- Through Power BI Desktop learn to integrate proven Microsoft technologies such as the Query engine, data modelling, and visualisations.
- Discover how to harness Power BI Service to share these connections, models and reports in accessible ways for users to view and interact with on all kinds of devices.
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,986 people .
- Over 14,078 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
This two day course is ideal for those looking to grasp the complete Power BI workflow, from sourcing data, modelling the data to creating and sharing data visualisations.
Training Course Content
Introducing the Power BI Ecosystem
Desktop, Service and MobileInstalling and setting up Power BI
Setting up a MS Power BI account
Getting started with Power BI Desktop
Visualisation and Fields PanesCreate visualisations with Report View
Sort and format data with Data View
Power BI Desktop and Data sources
How to import from various data sourcesConnectivity with MS Office apps - Excel, Access
Using other data sources such as databases and CSV Files
Power BI Desktop to create Data Models
Getting to grips with the Data ModelUsing the Relationship View
Many-to-one relationships
Filter propagation
Power BI Desktop for Visualisation Workshop
Adding visualisations to Report CanvasManaging visualisation relationships
Drill Down and Drill through techniques
Use of Hierarchies
Importing and using custom visualisations
Power BI Desktop and Introduction to DAX
Custom calculation and the Data ModelCalculated Columns and Measures
Evaluation Context
CountRows and DistinctCount Functions
SUMX and CALCULATE
Time Intelligence functions
Power BI Desktop and Queries
Data import and the role of QueriesETL: Extract, Transform and Load
Data transformations
Using Applied Steps
Query Parameters
Power BI Service Publishing
Report publishing to PowerBI.comDashboards
Quick Insights
Data searching with QandA
Power BI Service and Importing Cloud-based Data
OneDriveAzure SQL Websites and Databases
Power BI Service and Excel PowerPivot
Creating a PowerPivot Data ModelImport data from PowerPivot to Power BI Service
Using PowerPivot data to create visualisations in Power BI Service
Sharing Data with Power BI
Share interactive Power BI dashboardsShare through Power BI, PowerPoint, the web and other mediums
Content Packs
Role Level Security
Refreshing Data
Refreshing data manuallyScheduled Refresh
Personal Gateway
Enterprise Gateway
Power BI on Mobile Devices
Meeting different mobile clients' requirementsWindows 10, Ipad, Android and Tablet
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads