Microsoft Power BI Desktop User Course

Microsoft Power BI Boot Camp

COURSE TRAINERS

Mark Badham

Details

Microsoft Power BI is a comprehensive business intelligence (BI) platform designed to empower organizations to extract maximum value from their data. It transforms raw data into interactive and visually compelling insights, facilitating informed decision-making at all levels.

Organizations can empower their workforce to achieve significant success through Power BI training. This training equips employees with data analysis skills, enabling them to:

Make informed decisions: Data becomes the driving force behind every level, fostering better choices.
Streamline workflows: Processes become more efficient as insights guide resource allocation.
Boost productivity: Employees empowered to analyze data independently contribute to a more productive environment.
Gain a competitive advantage: Data-driven insights fuel strategic business decisions.

Successful completion of the Microsoft Power BI BootCamp and Advanced Courses prepares participants to write the PL-300: Microsoft Power BI Data Analyst Exam.

In this three-day course, attendees will learn the fundamentals of creating rich interactive reports and sharing their insights with others.

We will cover:

An Introduction to Power BI
Importing and cleansing data for use in the model
Creating interactive reports
Sharing your reports with others

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method	Duration	Price (excl. VAT)
Classroom	3 day	ZAR 8,250.00	Get a Quote
Live Virtual Training	3 day	ZAR 6,750.00	Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Information may change without notice.

Audience

It is intended for use by non-IT staff, including both Line and Senior Managers, Business Analysts, BI Specialists, and Knowledge Workers.

Pre-Requisites

Basic Understanding of Data Concepts: Familiarity with concepts such as data types, data sources, data manipulation, and data visualization can be helpful.
Proficiency in Microsoft Excel: Since Power BI is closely integrated with Excel, having a solid understanding of Excel functions, formulas, and data analysis features can provide a strong foundation.
A laptop with Power BI installed

IMPORTANT:

Please note that Power BI is a Microsoft app and as such, it is not designed to work on a MacBook. PowerBI Desktop is a Windows-only app. So Mac users will have to use parallels. You cannot use a laptop that does not have Windows installed. If you only have a MacBook to work on and you want to do the course, we can hire a laptop for you to use at your own cost. Please speak to your salesperson to assist you.

Course Outline / Curriculum

Module 1: Introduction to Power BI
- What is Power BI
- Understanding the power of BI architecture
- Installing Power BI desktop
- Signup with the Power BI service
- Understanding Power BI licensing
Module 2: Importing data using Power BI
- Loading data from files and databases
- Removing unwanted rows and columns
- Transforming data
- Cleansing and shaping data
- Using functions and parameters
- Discuss direct query and live query
- Power Query best practice
Module 3: Building Data Model
- Building Relationships
- Working with Complex Relationships
- Usability Enhancements
- Data Model Performance
Module 4: Enriching your data model with DAX
- Creating calculated columns and measures
- Understanding filter context
- Time intelligence functions
- Role Playing Table with Dax
- Dax Best Practice
Module 5: Visualising Data
- Chart types
- Formatting charts
- Understanding reports, pages, and visual filters, and slicers
- Designing interactive reports
- Enhanced reports with text boxes, annotation shapes, and images
- Custom visuals
- Using report themes
- Visualization best practice
Module 6: Digital Storytelling with Power BI
- Configuring drill through
- Capturing report views with bookmarks
- Combining object visibility with bookmarks
- Report pages as tooltips
Module 7: Sharing reports with the Power BI Service
- Publishing reports to the Power BI service
- Understanding the difference between reports and dashboards
- Creating schedules and alerts
- Q&A
- Setting up row-level security
- Keeping data up-to-date with scheduled refreshes and the data gateway
- Designing dashboards for mobile
- Creating Power BI apps
- Publish Power BI to Web

Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date	End Date	Branch	Status
Mon 20 May 2024	Wed 22 May 2024	Fourways	Provisional	Enquire
Mon 15 Jul 2024	Wed 17 Jul 2024	Fourways	Scheduled	Book Live Virtual Training
Mon 9 Sep 2024	Wed 11 Sep 2024	Fourways	Provisional	Enquire
Mon 7 Oct 2024	Wed 9 Oct 2024	Fourways	Provisional	Enquire
Mon 4 Nov 2024	Wed 6 Nov 2024	Fourways	Provisional	Enquire
Mon 2 Dec 2024	Wed 4 Dec 2024	Fourways	Provisional	Enquire

Submit Enquiry