Course Navigation
The main purpose of the course is to give delegates a good understanding the power of Power BI to develop dashboards using large data sets.
Microsoft Power BI is becoming the world’s most powerful self-service BI platform. This business analytical tool delivers insight into any organization and will give you the ability to drive and direct informed and agile business decisions. Power BI is the easiest to use data analysis, reporting and interactive tool. You can create your own dataset based on a single or multiple source and transform this data into professional-quality interactive dashboards.
- Learn Power BI Best Practice, Tips and Tricks
- Understand Power BI Desktop and its components
- Learn how to connect to different data sources using Query Editor
- Learn how to work in different views of the Data Model
- Learn to create calculated columns and measures
- Learn to use the DAX Formula language to develop powerful calculations
- Learn how to create a wide range of charts and visualizations
- Learn how to create, modify and customize interactive dashboards, visualization and reports to convey specific business KPI and measures
Course Summary
- Introducing Power BI Desktop
- An Introduction to the Query Editor (Extract, transform & Load)
- Working on the Data Model
- Working with DAX
- Working in Report View to Visualize our results
This masterclass runs for 2 days
R 7 999.00
Group discounts available on request.
Our A Complete Introduction to Power BI Desktop is available in a variety of formats to best match your needs
In-House training: We bring the training to your location. Available with customized features created to meet your requirements.
Virtual Training: Delivered totally online, our virtual sessions are designed to keep participants engaged through relevant training, activities for practice, and ongoing reinforcement.
- Anyone looking to pursue a career in data analysis or business intelligence
- Data analysts and Excel users hoping to develop advanced data modelling, dashboard design and business intelligence skills
- People who want to understand how to create customized visuals
- All Excel users who work with data, reports, and dashboards
- Management Accountants who are required to report on transactional data sets
- Marketing and Operational Analysts
- Entrepreneurs / CEO /Accountants looking to master the Data Analysis process
- Anyone wanting to transition into Business Analytics.
Course Categories
- Asset Management Masterclass
- Environmental & Social Management Systems
- Fraud Prevention & Anti Corruption Masterclass
- Risk Appetite & Strategy Masterclass
- Governance, Risk and Compliance Masterclass
- Risk based combined assurance
- Leadership and structures of corporate governance
- Corporate Governance – Role of the board
- Corporate governance Fundamental
- Principles and practices of corporate responsibility
- Engaging stakeholders to build a sustainable plan
- Advanced enterprise risk management masterclass
- Conducting effective lifestyles audits course
- King IV governance compliance and assurance workshop
- Budgeting Skills for managers.
- Financial Analysis, Planning & Control.
- Government Accounting.
- Government Budgeting Including SCOA.
- Accounting for VAT
- Understanding and analyzing financial statements workshop
- Strategic planning, budgeting and rolling forecast workshop
- Strategic forecasting & projections of financial statements masterclass
- Preparing financial statements and annual reports masterclass
- Project finance and modelling
- Pension fund governance, regulations and best practices.
- Mining TAX and strategy masterclass
- International financial reporting standards (IFRS) &updates
- IFRS 9 International finance reporting standards 9 and expected credit loss
- Business intelligence & analytics for finance professionals
- Advanced Recruitment Analysis & Assessment Workshop.
- Disciplinary Code & Procedure Training.
- Employment Equity Legislation Masterclass.
- HR Processes, Culture & Change Management Training.
- Performance management systems training
- Principles and practices of corporate responsibility
- Union responsibilities in the workplace
- Workplace skills plans & annual training reports
- Mining social & labor planning
- Payrol preparation, analysis and management
- New CCMA rules & latest case law
- Human resources & development personnel management
- Developing & Implementing Electronic Documents & Records Management Systems.
- Pragmatic Approach to Managing Records.
- Basic registry, records & archives management
- Pragmatic approach to managing records
- Records management, library management and inventory
- management
- Principles of records management basic – Level 1
- Records management Intermediate – Level 2
- Advanced records management – Level 3
- Fleet Operations Management Accident Investigation & Report Writing.
- Fundamentals of Stores & Stock Control.
- Logistics & Distribution Management.
- PFMA Supply Chain Management Bid Committees Workshop.
- Stockpile Management Best Practices.
- Strategic Procurement & Supply Chain Management.
- Supply Chain Management Introduction Forecasting & Acquisition Management.
- Tender Advisory Seminar.
- Tendering Procedures & Bid Evaluation.
- Understanding the Amended BBB-EE Codes BEE Fundamentals.
- Advanced Circuit Breaker Operation and Maintenance
- Environmental Engineering for Non-Environmental Engineers
- Contaminated Soil and Groundwater, Assessment and Remediation
- Introduction to Six Sigma
- Lean Leadership
- Lean Maintenance Planning & Scheduling
- Mechanical Engineering for Non-mechanical Engineers
- Mineral Process Plant Optimisation Technology and Continuous Improvement
- Mineral Resource Estimation and Process Control of Mineral Processing Systems
- Solar PV System Design
- Structural Engineering for Non-structural Engineers
- Technical Report Writing & Presentation Skills for Engineers & Technical Professionals
- Total Productive Maintenance
- Wastewater Purification and Treatment Course
- Welding Design and Metal Fatigue for Structural Engineers
- Fundamental Hydraulic Theory and Maintenance
- Fundamentals of Mineral Resource Estimation and Valuation of Mineral Projects
- High Voltage Safety Training