Computer Skills Training

Event details

  • Virtual
  • November 18, 2024 - November 19, 2024
  • 9:30 AM to 12:30 PM (Everyday)

Contact event manager

Thank you Kindly

Power BI Essentials (Virtual)

VIRTUAL (AEST)

Mon, 18 November, 2024 to Tue, 19 November, 2024
November 18, 2024

000000

Power BI Essentials (Virtual)

VIRTUAL (AEST)

Mon, 18 November, 2024 to Tue, 19 November, 2024
November 18, 2024

PRINT
  • Share event
Save event

 

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).

  • Power BI is Windows only
  • Participants require the full version of Power BI before attending the course

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.

• 2-day Virtual instructor-led program
• 2 x 3-hour web-based virtual sessions

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