Power BI Fundamentals
Tuesday, 5 & 12 March 2024 | 9:00am – 12:30 pm AEDT | Online
Training Overview
Harness the power of your data.
Microsoft Power BI empowers business users to perform advanced data analysis, transforming data into actionable, impactful insights. Dive into our course to unlock the potential of Power BI Desktop, enabling you to source data from various channels and craft dynamic, interactive reports. We then catapult your insights into a captivating online dashboard, extracting invaluable business wisdom.
If you possess a fervent passion for data and seek to streamline the collection, cleansing, and visualisation processes, this course is your gateway! Join us for an engaging, comprehensive, and hands-on exploration of self-service Business Intelligence.
Who Should Attend
This course is designed for:
Excel Users (time to step up)
Anyone who uses data
and Local Data Gurus
Beginner Level Data Management
and Analytics Community
Learning Outcomes
Master Power Query for data extraction and transformation
Grasp data modelling fundamentals
Unlock the potential of the DAX language for data enhancement
Craft impressive Power BI visuals and differentiate between Reports and Dashboards in the Power BI Service
Meet Your Facilitator
Nicky Bull
IT Trainer and Courseware Developer
Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs. She lectures accounting students at Macquarie University and was the lead content designer for the hugely popular Excel Skills for Business course that received the Coursera Outstanding Educator Award for Student Transformation in 2018.
Nicky is passionate about learning and enabling people to use technology confidently and effectively in their workplace. She holds a BSc Hons in Computer Science (University of the Witwatersrand, South Africa), a BA in English Literature (University of the Witwatersrand, South Africa), and a Postgraduate Certificate in Education (University of Hertfordshire, U.K.)
Key Sessions
- Getting Started with Power BI Desktop
- What is Power BI
- Power BI Licensing
- Overview of Power BI Desktop
- Use Power Query to Get and Transform Data
- Data Connection Options
- Get Data from Excel
- Introduction to Power Query
- Get Data from a Folder
- Work with the Data Model
- Understand Relationships
- Add and manage Relationships
- Introduction to Data Analysis Expressions (DAX)
- Use DAX to create Calculated Columns
- Use DAX to Create Simple Measures
- Design and Create a Power BI Report
- Set Page and Canvas Settings
- Add Images
- Change and Customise Themes
- Add and Manage Pages
- Add and Customise Common Visualisations
- Add Map, Treemap & Card Visuals
- Work with Tables & Matrixes
- Add Line and Column Charts
- Work with Visualisations
- Work with Tool Tips and Cross Filters
- Focus Mode and Spotlight
- Sort and Drill Down
- Customise Visuals
- Add Multiple Pages and Custom Visuals
- Rename, Add and Duplicate Pages
- Add Custom Visuals
- Filter Visuals, Pages and Report
- Use the Filters Pane
- Work with Slicers
- Publish and Work with Reports in the Power BI Service
- Publish to the Power BI Service
- Workspaces & Sharing Options
- Subscribe and Comment
- Spotlight and Bookmark
- Export Data from a Report
- Create and Work with Dashboards in the Power BI Service
- Report vs Dashboard
- Create a Power BI Dashboard
- Work with Tiles and Q&A
- Customise for Mobile View
- Install Apps and work with Power BI Mobile
- How to find shared Reports
- How to find Apps
- Power BI for Mobile
Registration
Final Price
$1195
per person + GST
Interested In Learning More?
