Power BI Topic 2: Powerful Queries with Power BI
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 queries, measurements, calculations, formatting and charts.
Participants should have attended the Power BI Level 1 - Introduction to Power BI webinar prior to attending this one.
Course Outline:
Course Introduction
Recap on Introduction to Power BI
Creating Measures and Quick Measures
Setting Up Calculations and Measurements
Creating Visualizations
Modifying Colour Formatting
Setting the Sort Order
Inserting Scatter Charts, Bubble Charts and Play Axis
Using Tooltips
Adding Slicers and Synchronising Slicers
Cross-Filtering and Highlighting
Setting Up Visual, Page and Report Level Filters
Using Drill Down and Drill Up
Understanding Hierarchies in Tables
Adding Reference Lines and Constant Lines to Charts
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
