Microsoft Power BI

Power BI Topic 4: Data Modelling and Exporting Data

Duration: 90 Minutes

Target Audience:

Aimed at experienced Microsoft Excel users who wish to use the Power BI interface to create their own reports and dashboards.

Course Objectives:

Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This session will introduce participants to the modelling capabilities in Power BI, you can connect to multiple data sources, then combine them in ways that create a unique model of data that suits your needs.

Participants should have attended the Power BI Level 1: Introduction to Power BI, Power BI Level 2: Building Reports, Power BI Level 3: Data Transformation and Power Query webinars prior to attending this session.

Course Outline:

Course Introduction

The Power BI Data Model

Data Structure for Q&A

Creating Calculated Columns

Shaping Data

Combining Data

Introduction to Data Modelling

Setting Up and Managing Relationships

Understanding Cardinality and Cross-Filtering

Changing the Default Summarisation

Changing the Default Sort By and Sort Order

Exporting Data from a Visualization to Excel

Publishing Reports for Mobile Apps.

Optimising for Mobile Viewing

Exporting Reports to PowerPoint

Discussion and Question Time

 

Please contact us today if you have any questions about our Microsoft Courses. We offer both classroom and virtual training options. Contact us at +353 1 279 0020 or Email us at sales@olas.ie

Follow us on Facebook and LinkedIn for more updates

Microsoft POWER BI Introduction