COURSE TRAINERS
Lawrence Maoka
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
Mark Badham
Mark is the Managing Director of Leading Edge Business Solutions. Mark has been programming since the age of 10 when he wrote his fist Basic Program on an Apple IIe. He has always been passionate about computers and education and started tutoring matric students in 1994. Mark has been training advanced Linux courses, installing, configuring and maintaining Linux servers since November 1999. In 2002 Mark began training Perl courses. Mark was among the first group to write the LPI level 2 Certification in South Africa in 2004. Since March 2006 Mark has been training PHP, MySQL and JavaScript. Since 2009 Mark has started training Java and Python.
Mark's formal qualifications include:
Bsc (Engineering) Electrical
Institution: University of the Witwatersrand.
Final Subjects IncludedComputer Engineering
Certification: Level 2 Certification
Institution: Linux Professional Institute
This course is currently not active. Feel free to submit an enquiry.
Details
You have a good understanding of the role that reporting plays in the decision-making process of your organisation and you are proficient in the basic use of Microsoft Excel. You need to build reports and dashboards with the minimum involvement of the IT Department, for deployment on internal servers, Microsoft OneDrive, Web interfaces, tablets, and smartphones. Come and learn how to use Microsoft Power BI (Business Intelligence).
In this course you will learn to:
- Use the MS Power BI Desktop and Power BI Web application
- Load and report on existing Excel and CSV data
- Present and visualise Data using Reports and Dashboards
- Share Reports and Dashboards with colleagues
- Use Best Practices for compiling Reports and Dashboards using a BI tool
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.
Audience
Companies need to visualise data and information using a tool that can create shareable reports and dashboards with minimal support from the IT Department. This course introduces Microsoft Power BI, a free user-friendly tool that uses Microsoft Excel, CSV, Microsoft Access, SQL Server and non-Microsoft sources as data sources. It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers.
Pre-Requisites
Delegates should be able to use Microsoft Excel on a basic level. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
Course Outline / Curriculum
Lesson 1: Introduction:
- Power BI Desktop
- Microsoft Self-Service Business Intelligence Solution
- Installing Power BI Desktop
Lesson 2: A First Power BI Desktop Dashboard
- Introduction to the Power BI Desktop
- Loading Excel Data
- The Power BI Desktop Window
- First Visualisations
- Interactive Dashboards
- Creating and Modifying Reports
Lesson 3: Data Sources
- Importing Excel and CSV Files
- Loading Other Data Sources
- Re-Using and Refreshing Data
Lesson 4: Visualisations
- Text-Based Visualisations
- Charts
- Other Types of Visualisations
Lesson 5: Data Selection
- Filtering Data
- Using Slicers
Lesson 6: Enhancing Dashboards
- Text Boxes
- Background Colours
- Shapes
- Organizing the Visuals
- Exporting Data
Lesson 7: PowerBI.com
- Publishing Data to PowerBI.com
- Using the Desktop files
- Interaction with a Report
- Creating PowerBI.Com Dashboards
- Sharing Dashboards
- Create new Dashboards
- Tablet Devices
- Gateways
Lesson 8: Best Practices
- Stakeholders
- Designing Dashboards and Reports
- System Impact