Power BI Classes Perth

Learn how to easily create measures to find SUM, COUNT, MAX, and more with a click of a button. Make the best use of the mysterious filter context and use Power BI’s DAX language to power your data visualizations. You’ll also get tips on which Power BI experts to follow to gain the knowledge that will transform you into an expert at your workplace.

This 1-day Power BI for Excel course will teach those with advanced knowledge of Excel how to incorporate some business intelligence elements into their Excel workbooks. The course explores a range of Power BI tools and concepts, including how to link data to Query, accessing data types from Query, transforming data, importing data into PowerPivot, data model relationships, the differences between PowerPivot and Query, the DAX language and DAX measures, text-based calculations and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day Power BI Essentials course will teach students how to develop and share dashboards using Microsoft’s dynamic business intelligence software. The course explores a range of Power BI reporting concepts, including a broad overview of business intelligence and data analytics, understanding and getting started with Power BI, importing data, transforming data, an introduction to Power Query, data modeling, an introduction to DAX, data visualization best practices in Power BI, working with filters and slicers, Power BI publisher, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

Learn to seamlessly move raw data from an Excel spreadsheet to Microsoft BI for analysis in this two-day, basic-level class. Students build on their basic Excel knowledge to model the data then create and publish reports. Participants also master colors, text boxes, interactions, and other data visualization tools. Additionally, students examine sharing and publishing issues, including dashboards, workplaces, and personal gateways.

Move into advanced data analytics and explore the latest Microsoft Power BI features in this intermediate-level, two-day course. Students learn how to import data from PDF and other files in order to create advanced analytical models. Through hands-on learning, participants also explore topics like script visualization, report design, data analytics, and dashboard design.

Master the skills needed to examine and leverage business data in this advanced, three-day Microsoft Power BI class. Students become intimately familiar with the full suite of Power BI products. Through both individual and group projects, participants learn basic Business Intelligence concepts, manage dataflow with Excel and other platforms, combine and shape data into an effective model, work with direct connectivity options and interactive visualizations, and examine mobile business intelligence applications.

Get to know Microsoft Power Query, one of the most powerful Microsoft BI and Excel tools, in this introductory one-day class. Power Query allows users to transform and combine data from numerous sources. Through a combination of live instruction, class discussions, and hands-on learning, participants explore concepts like database connection, loading, and grouping, data merges, Power Query syntax, and CSV, text, and Excel management.