• Virtual
  • December 3, 2021 - December 7, 2021
  • 9:00 AM to12:30 PM (Everyday)

Contact event manager

Thank you Kindly

Microsoft Power BI – 2 Days (Virtual)

VIRTUAL (AEST)

Fri, 03 December, 2021 to Tue, 07 December, 2021
December 3, 2021

000000

Microsoft Power BI – 2 Days (Virtual)

VIRTUAL (AEST)

Fri, 03 December, 2021 to Tue, 07 December, 2021
December 3, 2021

PRINT

FULLY BOOKED

Duration:  3 hours each day for 2 days (3/12 9.00am to 12.30pm & 7/12 9.00am to 12:30pm)

Microsoft Power BI is a suite of business intelligence (BI) services for performing sophisticated data analysis and creating interactive reports and dashboards. The Power BI suite comprises several products and services, primarily: Power BI Desktop and the Power BI Service. This course will focus on Power BI Desktop, a free tool that we will use to pull datasets from a variety of sources, model and analyse that data and then visually present our analysis in an interactive report. Attendees will require the Power BI Desktop application (available for Windows only).

Learn how to integrate planning, communications, tasks and activities, and how to apply the Working Smart method that can give you an extra hour, every day.

GETTING STARTED WITH POWER BI
• What is Power BI
• Overview of Power BI Desktop

GET DATA WITH POWER BI DESKTOP
• Connect to data from different sources
• Combine data from multiple sources
• Use Power Query to clean and transform data

CREATE A DATA MODEL
• Entities and Relationships
• Work with the data model and add relationships
• Use DAX to create a calculated tables
• Use DAX to create calculated Columns

CREATE A POWER BI REPORT
• Create DAX Measures
• Add Visualisations
• Add other content (logo/banner)
• Add custom visualisations

WORKING WITH A POWER BI REPORT
• Spotlight, and Focus Mode
• Formatting Visualisations
• Adding Conditional Formatting
• Hierarchies
• Groups
• Filters and Slicers

ADDING TIME INTELLIGENCE
• DAX time intelligence functions
• CALCULATE function
• Add time intelligence measures
• Organise measures effectively
• Utilise time intelligence in analysis

SHARING POWER BI REPORTS
• Export to CSV or PDF
• Publish to PBI Service
• Create Power BI Dashboards
• Add alerts to card visuals
• Share Dashboards with your organisation

Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.

PREQUALIFICATIONS
Advanced Excel training is for people who can already create moderately complex spreadsheets and want to add more sophistication and automation. Candidates should have completed the Intermediate level, or feel competent they have an intermediate knowledge of Excel.

Format:
2 x 3-hour web-based virtual sessions

  • Extensive Learning & Reference Guides provided on USB
  • Participation in the full day workshop
  • Access to a Microsoft technical expert throughout and post the workshop