Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Microsoft Power BI Basics Training Course
Quick Look Course Summary:Microsoft Power BI Basics Training Course
-
Next Public Course Date:
-
Length: 3 day(s)
-
Price (at your venue): 1 Person R 17,953 EX VAT 3 Person R 12,518 EX VAT 10 Person R 8,424 EX VAT
-
Certification Type:Non-Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Microsoft Power BI Basics Training Course
Duration: 3 days
Introduction
Power BI is a cloud-based suite of business analytics tools that lets anyone connect to, visualize, and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life.
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.
Course Outline
Lesson 1: Course Overview Lesson 2: Power BI
- What is Power BI?
- Examining Power BI Suite of Products
- Identifying Differences Between Products
- Understanding Power BI Updates
Lesson 3: Power BI Desktop
- Installing Power BI Desktop
- Exploring the Power BI Desktop Interface
- Utilizing File Types; PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lesson 4: Working With CSV, TXT and Excel Worksheets
- Importing, Transforming, and Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
Lesson 5: Connecting to Databases
- Working with Relational Data
- Understanding Relationships
- Importing from SQL Server Analysis Services Multidimensional and Tabular
Lesson 6: Merging, Grouping, Summarizing, And Calculating Data
- Understanding the Issues with Merges
- Performing Merges
- Grouping Options
- Summarizing
- Calculating
Lesson 7: Reporting
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
Lesson 8: Power BI Online
- Introduction to Power BI Online
- Importing Data
- Creating Reports
- Configuring Dashboards
- Sharing Reports and Dashboards
- Exploring Power BI Mobile
Who should attend this course?
This course is suitable for Business Managers, Report Developers, Analysts, Project Managers and Team Leads. IMPORTANT ACTION: Do Not Wait To Improve Your Skills.
Testimonials
“…Changed my perspective on some of the old analytic tools…” Delegate -Big SA Mining Group
“Impowered with the use of Power BI…Value Adding…” Delegate -Big SA Mining Group
“I learnt a lot and enjoyed the training. Presentation style was excellent…It was an eye opener” – Delegate Takeover Regulation Panel
See our Accredited Beginners to Advanced Excel course here.
Frequently Asked Questions
Is this course accredited?
BOTI offers a mix of SETA-accredited, internationally-certified (VMEdu) and non-accredited skills-programme courses. Please confirm a specific course's accreditation status with us when you enquire. All delegates receive a certificate of completion.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Yes - skills development training can contribute to your B-BBEE scorecard, and where learnerships apply you may also access SETA grants and the Section 12H tax allowance. Ask us how to structure it for maximum points.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.