Bernard has more than 15 Years of experience as part-time and full-time lecturer and trainer: University of Pretoria (Hons class in Informatics), Monash (First Year Introduction to Business Computing and Second Year Software Development), University of Witwatersrand ("Organization, Data, Information and Business Intelligence") and Oracle University.
Technical courses include :
Oracle Business Intelligence
Microsoft Power BI
Oracle Data Warehousing
Information Technology experience includes: IT blueprints, outsourcing, data migration, and software development. The project environments include: research, financial services, medical services, telecommunications, short-term insurance, mining, retail and IT outsourcing.
Project Management experience include acting as senior project manager on IT Projects, setting up project approaches and project offices, acting as a project mentor and trainer, and as an IT Team Service Manager
Project Management Society of South Africa
ACM (Signatory to Code of Ethics)
Award: Oracle University: â€œBest Fusion Middleware Lecturer. ZA FY2010 and ZAFY2011â€
Relevant Qualifications and Training:
Date: 2014 APM Group. Passed Agile Practitioner. Certificate Number 02905943-01-L9LH Date: 2005 APM Group, on behalf of the Office of Government Commerce (United Kingdom), London Passed PRINCE2 Practitioners Examination and certified as a "PRINCE2 Practitioner". Date: 1998 University of Pretoria Advanced Certificate in Information Systems Management (cum laude). Project Management and Decision Support were amongst the subjects Date: 1993 University of the Witwatersrand, Johannesburg Course in "Managing People in Software Development"
Lawrence is a Sales Manager and Training instructor at Leading Edge Business Solutions (Pty) Ltd since April 2008 and has been a technical instructor since 2004. Lawrence combines technical knowledge with good communications skills and consistently receives enthusiastic reviews from his students. Lawrence has trained in all 9 provinces of South Africa as well as in the DRC, Botswana, and Swaziland.
Operating Systems and Application Software Windows 95 – Windows 10, Office 97/2000/XP/2003/2007/2010/2013/2016 Linux PowerBI Microsoft Word, Excel, PowerPoint, Outlook, Access, Project, Visio, Microsoft Excel Dashboards Open /Libre Office Writer, Calc, Impress, Base Thunderbird Google Apps Gimp, Scribus Wordpress and Joomla Content Management Systems Soft skills / Business Skills Selling, Presentation, Communication, Time Management & Anger Management.
Certified Certified Technical Trainer (Ctt+) N5 Electrical Engineering Installation Liaison Officer (Telecommunication) Business Communication Entrepreneurship Microsoft Office Specialist, Word, Excel, PowerPoint ICDL Network+ I-Net+Hardware and Networking from City & Guilds of London IC3 Google AdWords Google Analytics
You are a business user of reports and dashboards and need to use a tool to support your decision making. You use data both in tabular and in graphical format and need to access both summarized and detailed versions of the data. You need to interact live with the data sets using a web-based application.
Makes use of the Microsoft PowerBI.com web-based application to create basic reports and dashboards. The reports and dashboards can be shared both inside and outside of the company
Focuses on the skills that will be needed by dashboards users to compile reports and dashboards, and share the dashboards with colleagues and clients
Covers the basic built-in visualizations in detail, with the relevant exercises
Covers the advanced built-in functionality for visualization as demonstrations and as self-study sections
Gives some guidelines for report and dashboard design
Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
This is a bespoke course for specific audiences and is therefore not on our public schedule. This course needs to be customised to the unique settings of a business and will, therefore, be quoted on separately. The possible audience includes the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data.
Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome. Delegates should be able to use one of the Microsoft Office applications on a basic level. Delegates should have some experience in doing reporting.
Course Outline / Curriculum
Overview of Business Intelligence and PowerBI
Microsoft Self-Service Business Solution
Microsoft PowerBI applications
Using Data Sources:
Data Sources available
Uploading Excel workbook
Uploading CSV file
Uploading a Web page containing tables
Accessing a SQL Server database
Accessing Microsoft PowerBI.com web-based application
Review the structure of the application
Accessing the first dashboards
Use Built-in Visualizations and Formatting to create Reports
Data Structure of the sample database
Switching between table types
Basic charting and the Bar chart
100% Stacked charts
Page background color
Interacting with the data
Using charts to slice data
Working with a Dashboard
Using the PowerBI application for Android
Create an alert
Line and stacked column charts
Bubble chart play axis
Best Practice for Dashboard design
Optional: Data sources and data manipulation
Accessing a SQL Server database
Split data columns imported from a CSV file
Schedule Dates and Booking
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule
a course. You can choose to be added to the waiting list by clicking the
button below and we will contact you when we have enough delegates
interested. Should we not get enough delegates, we will refund or credit
your paid booking.
Should you need this course urgently, the following options are
Pay for 6 delegates (whether you have them or not) and we will
schedule the course as soon as possible.
If you have fewer delegates and cannot pay for 6, we can negotiate
a shortened course where some of the time will be spent in blended
learning - watching videos and doing tutorials and exercises with
some contact time with the trainer. We would want to discuss what
your core needs are so that we cover those aspects. You need to have
paid for 3 delegates at least.
For clients who want to enjoy the convenience of public transport,
consider the Gautrain.
Take the Gautrain to the Malboro station.
Purchace a R15 ticket for the Woodlands Office Park Shuttle Service.
The shuttle will come directly down Western Service road.
Ask to be dropped at the entrace to Western Woods Office Park.
For more information you can download
the official Gautrain brochure.
Bringing your own PC
It is very important that you have full administrator rights to your
computer so that any software needed for the course can be installed
Please ensure that you arrive at least 30min early on the first day
of training in order to get your PC setup correctly.
If this is not possible then it will be better to make use of our