Event details
- Virtual
- September 21, 2023 - September 22, 2023
- 9:00 AMto12:00 PM (Everyday)
Contact event manager
Power BI Essentials (Virtual)
VIRTUAL (AEST)
Thu, 21 September, 2023 to Fri, 22 September, 2023
September 21, 2023
000000
Power BI Essentials (Virtual)
VIRTUAL (AEST)
Thu, 21 September, 2023 to Fri, 22 September, 2023
September 21, 2023
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