Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Power BI Desktop Training

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.

Description

Microsoft Power BI is becoming the world’s most powerful self-service BI platform. This business analytical tool delivers insight into anyorganization 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.

Course Objectives

  • 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

Prerequisites

  • Microsoft Power BI Desktop downloaded (free download) on a Window computer
  • You will need to know the basics of working with data in Excel
  • Basic understanding of data analysis is a plus but not required
  • No prior knowledge of Power BI required

Who is this Training Course for?

  • 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

The Course Content

Introducing Power BI Desktop

  • Understanding the Power BI tools
  • An Overview of the Workflow
  • Introducing the Different Views of the Data Model

 

An Introduction to the Query Editor (Extract, transform & Load)

  • What is the Query Editor
  • Looking at the Query Editor Interface
  • Types of Data Connectors
  • Transform basic tables
  • Formatting text, numbers and dates
  • Index and Conditional columns
  • Pivoting and unpivoting columns
  • Modifying, merging and appending queries
  • Query Editor and Power BI best practice

 

Working on the Data Model

  • Introduction to Database Normalization
  • FACT tables vs DIMENSION tables
  • Introducing and understanding relationships
  • Active vs Inactive Relationships
  • Understanding Cardinality
  • Star vs Snowflake Schemas
  • Connecting Multiple data tables
  • Cross filter selection and Many-to-many relationships
  • Hiding fields from the Report view
  • Data Modelling and Power BI best practices

 

Working with DAX

  • Introduction to DAX
  • DAX and calculated columns
  • DAX syntax and operators
  • Common Power BI functions
  • Date and Time intelligence formulas
  • Logical and Conditional Formulas
  • Text, Math and Stats functions
  • DAX and Power BI best practices

 

Working in Report View to Visualize our results

  • Introduction to Report View
  • Understand the Power View Interface
  • Adding basic charts
  • Formatting and filtering options
  • Matrix visuals
  • Slicers and Timelines
  • Creating Cards and KPI
  • Power BI Maps
  • Types of visualizations
  • Applying different filter types
  • Managing and Viewing roles
  • Data Visualization best practices

Similar courses

Accounts Payable: From Accounting to Management

Accounts Payable (AP) is not just processing checks, mailing them and then filing the backup paperwork. To truly and effectively manage accounts payable, one must understand the AP department's building blocks including, but not limited to customer service, vendor management, check requests and Purchase Orders (POs).

More Information
Logistics and Supply Chain Management

Supply chain and logistics management have been among the fastest evolving business disciplines over the past two decades. The continuous arrival of innovative concepts and techniques into the mainstream has resulted in a non-stop journey of learning and development for professionals in supply chain and logistics.

More Information
Effective Delegation Skills

One of the key skills of effective management is achieving success through others, enabling your team to develop their skills and achieve success.

More Information
Inventory Management and Stock Control

Inventory Management training course is designed for people working with warehouse or storeroom managers who are responsible for what comes in and goes out of the company. They must understand how to lead an efficiently operated and cost-effective process, with the right amount of products available.

More Information
Advanced Project Management

This programme is aimed at candidate who will be involved in the implementation, managing and leading of projects within different working environments. Participants will acquire an understanding of concepts of project management and will be able to plan and organise projects.

More Information
Intermediate Project Management

This Intermediate Project Management course is for participants who already know about project life cycles, goal setting, creating a vision, and statement of work, this one-day Intermediate Project Management courseware program will be ideal for further skill development. At this level, participants learn to approach projects at a deeper level, and to function within a project team.

More Information
Project Management Fundamentals

This Project Management Fundamentals course is a basic introduction for administrators or supervisors who may be asked to take on project tasks as part of their regular work. This training program is intended to familiarize participants with common project management terms, identify the benefits of projects, teach the concepts of project life cycles, prioritizing and setting goals, use some basic, simple planning tools, and explore charters and statements of work.

More Information
Risk Management

Managers and business owners know that risk management can reduce the negative impact of crises, and provides measurable benefits and cost savings. Our course offers a risk management framework that is flexible and works with any organization. It can be applied to a single project, a department, or an enterprise-wide risk management program.

More Information
Effective Planning And Scheduling

This course will confidently teach you the essential skills of: estimation and breaking down work; task dependencies; resource scheduling; uncertainty and risk management; communication essentials; creating viable schedules; and more.

More Information
Conference and Event Management

Although it does take plenty of creativity to design an event that is memorable and meaningful, it also takes careful attention to detail, adaptability, effective delegating, and a lot of work. This course will walk you through the process of event management, from the beginning stages of planning, to the final touches (like decorations, food, and music).

More Information
Managing the Virtual Workplace

The International Data Corporation estimates that by 2020 mobile workers will account for nearly three quarters of the workforce around the world. Make sure you’re on top of the virtual workplace trend with this comprehensive Managing the Virtual Workplace training course.

More Information
Meeting Management: The Art of Making Meetings Work

Sitting through a long meeting where participants get side-tracked and issues don’t get resolved isn’t a good use of anyone’s time. With Meeting Management: The Art of Making Meetings Work, learn how to get results from a meeting, whether that involves solving problems, brainstorming, or sharing information.

More Information
Strategic Finance and Budgeting

Budgets and Managing Money will teach participants how to make informed and intelligent financial decisions. Rather than being omitted from the process, managers who don’t have a background in finance can fully participate in budgeting decisions and exercises once they have completed this training course.

More Information
Effective Supervisory Skills

Whether you are newly promoted or an experienced supervisor, the transition from being part of a team to leading one comes with a steep learning curve and can be extremely stressful. You may have reached where you are by hard work and technical skills but leading a team to improve results for the company requires a whole different skill set.

More Information
The ABCs of Supervising Others

As a supervisor, the success of your organization rests in your hands. This course provides you with the opportunity to develop highly effective and essential supervisory skills that will strengthen team work and organizational success. Also, this course will help you manage everyday operations with greater ease. Furthermore, it will help you leverage both your managerial and people skills to meet your new challenges as the 21st century supervisor.

More Information
Human Resources Training: HR Skills for Non HR Professionals

HR for Line Managers e-learning course is designed to help line managers manage their staff better by equipping them with critical HR skills. Also, this online course focuses on key issues for line managers, such as handling employee interviews, on-boarding, appraisals, training, and much more.

More Information
Mastering Sales & Marketing in the Age of New Social Media

This ICL training seminar will provide delegates with the practical knowledge needed to successfully plan, implement, manage, and measure social media sales and marketing efforts.

More Information
Women in Leadership

Women in Leadership: Impact through Self Awareness will take participants on a journey of self-discovery and self-mastery. It will enable participants to understand and leverage their core strengths to become authentic, fearless leaders and role models who empower everyone around them.

More Information
Health and Safety in the Workplace: The Supervisor’s Role and Responsibilities

Health and Safety at work is an arduous task for many managers and business owners. Health and Safety is not just a question of complying with the legislation, but it should be seen as an important feature of every business operation targeted at reducing the losses associated with accidents, ill health, sickness absence, etc.

More Information
Leadership Skills for Supervisors

Leadership Skills for Supervisors takes a unique perspective on the hot topic of management skills. We’ve designed a one-day course that teaches participants the essential skills of leadership: communication, coaching, and managing conflict. Perfect for those who are new to a supervisor role, Leadership Skills for Supervisors provides lessons in prioritizing, planning and managing time; identifying your primary leadership style; determining ways to meet the needs of employees; and exploring ways to solve pr

More Information
Conflict Resolution: Dealing with Difficult People

Dealing with difficult people is something that most of us will experience at one time or another in our lives. We may encounter people who are inconsiderate, stubborn, indecent, unhappy, angry, or passive-aggressive. These encounters may happen only once with an individual, or we may have ongoing issues with people who behave in these ways. How should we act when this occurs? And what should we do when these people are our employees?

More Information
Corporate Governance: Principles, Policies and Best Practices

This exciting ICL training course is designed to present, discuss and provide guidance on key governance principles, rules, best practice recommendations and various issues, pertinent to public-sector organizations. It will provide you with a guide of good governance, focusing on accountability, compliance, risk assessment, disclosure and transparency requirements, to ensure that administration and reporting obligations impacting on your organization are identified and addressed.

More Information
Anti-Money Laundering (AML) Compliance Masterclass

This course provides a comprehensive and practical analysis of Money Laundering schemes, Anti-Money Laundering legislation, and counter-measure techniques and implementation. Participants will learn to understand the complexities associated with the prevention and the protection of their organizations.

More Information
Preparation of Bills of Quantities

This Training will explore in depth; descriptions of Bills of Quantities, purpose of Bills of Quantities and their composition, their preparation, measuring of builders work, standard method of measuring building work, Marking up and billing.

More Information
Beyond Customer Service – Service Quality & Excellence

This dynamic, 4-day course gives customer service professionals the communication skills, technology tools, and motivation they require to build strong customer relationships and develop a customer centric organization.

More Information
The Certified Executive Secretaries and PA’s Training

This ICL training course will help increase your motivation and confidence through understanding of principles and best practices of successful office management.

More Information
Electronic Documents and Records Management Systems (EDRMS)

This programme is must for anyone planning or about to embark on the implementation of an Electronic Document and Records Management System (EDRMS) or Enterprise Content Management System (ECM).

More Information
Advanced Microsoft Excel ®

This course is aimed at professionals who have, or will soon have, responsibility for managing and manipulating data using MS Excel on a day to day basis.

More Information
Advanced Supervisory Skills

This course is designed for helping experienced supervisors develop advanced supervisory and managerial skills such as effective management, performance management, goal setting, motivation, and team development.

More Information
Strategic Key Account Management

This course is designed to provide Account Managers with the skills, behaviours and techniques to maximise the profitability from the accounts that they manage.

More Information
Project Scheduling & Cost Planning Skills

This Project Management training course focuses on how to deliver comprehensive reliable plans with time and cost estimates that gives the owner or sponsor of projects, high levels of confidence for project delivery.

More Information
Public Sector Management, Governance & Fiscal Sustainability Techniques Seminar

This ICL's Advanced Public Sector Management, Governance & Fiscal Sustainability Techniques seminar aims at improving the adaptation and integration of the fundamental components of Governance and Fiscal Sustainability Techniques.

More Information
Key Managerial Skills for New Managers and Supervisors

In today’s complex work environment, becoming a supervisor or a manager demands new skills and approaches to getting things done. Managers and supervisors must learn how to lead, motivate, and accomplish tasks effectively and efficiently working with others.

More Information
The 10 Day Project Management Professional

The Project Professional MBA is an intensive 10-day training course designed to sharpen your management skills focusing on current best practices in project management.

More Information
Mini MBA: Accounting & Finance

This finance & accounting training course is designed to cover the role and importance of accounting and finance in today’s business world. It will provide an ‘MBA level’ experience in terms of content, instruction, discussion and team exercises.

More Information
The 10-day Contract & Project Management Skills for Non-Professionals

The training course also provides non-project professionals a unique and simplified approach of the basic project management skills as practiced by those manage projects worldwide. It provides them with a practical and effective guide to learn what project professionals and their teams are doing and to acquire the project management skills to be an active, value-adding participant to the project team.

More Information
HR Processes, Culture & Change Management Programme

This important ICL HR Processes, Culture, & Change Management Programme online training seminar focuses on vital areas of modern Human Resource Management (HRM). It is a unique seminar that addresses core HR issues in a critical and evaluative way.

More Information
The ICL Advanced Finance Programme

This Advanced Finance Programme is a must for all those who would like to attend a course that comprehensively deals with all the key topics of strategic management, financial planning, and financial management. It is also for those who wish to sharpen up their financial management skills, or who wish to refresh or update the skills they already have.

More Information
The Strategy and High Impact Leadership Programme

This Programme will also focus on the critical roles of team leader and middle manager in harnessing their team's potential, and introduces and practices techniques for moving the organisation and the teams from average to excellence.

More Information
Leading Under Pressure

This highly participative training course will help you to develop your leadership skills to lead others in times of pressure, stress and crisis.

More Information
The Complete Course on Management & Leadership

This intensive 10-day training course gives a comprehensive overview of the principles and practices of management and leadership. It builds on the tenet that good management is the foundation of organisational success and progresses to consider the transitional skills and competencies that make great leaders.

More Information
Leading & Managing through Strategic Planning & Innovation

In this comprehensive two week training course, both strategic leaders and first line professionals will participate in how to develop, implement and structure the changes necessary to make a new strategy, vision or mission work effectively in today’s dynamic climate.

More Information
Accounts Payable: From Accounting to Management

This ICL Accounts Payable training seminar provides businesses and other organizations with a strong sense of where they stand against industry leaders and shows them how to take their services and organizational processes to state-of-the-art levels.

More Information
Accounts Receivables, Debt Recovery and Credit Policies Management

This course will enable you and your organization to manage your accounts receivable effectively without compromising your credit sales.

More Information
Dynamic Business Reports and Dashboards Using Excel

Attending this course will help you reach advanced Excel levels allowing you to produce such important reports. The course starts with pivot tables, the most important tool ever created to perform data reporting, analysis and reconciliation.

More Information
Budget Preparation, Allocation & Cost Control

This seminar provides participants with crucial cost awareness and budgetary skills by combining techniques analysis, problems and examples of real case studies, which is essential in managing and controlling processes / projects in times of increasing global competition where the budgets are inextricably linked with both strategy formulation and cost analysis.

More Information
Public Financial Management (PFMA)

This short course for middle and senior managers in the public sector aims to create an awareness and understanding of the Public Finance Management Act 1 of 1999 (PFMA), as amended, and its implications.

More Information
Financial for Non-Financial Professionals

You will learn about the accounting processes of recording and reporting business transactions, and how these are summarised as periodic financial reports in accordance with statutory requirements. You will also learn how these financial reports are analysed by a variety of user groups.

More Information
Corporate Governance & Risk Management for State & Public Sector Organisations

This training course will equip the board of directors, senior executives’ managers and head of departments to effectively discharge their staff and collective governance roles, responsibilities and accountabilities, and lead the organization to mitigate their risk and ensure the success and sustainability through governance excellence and efficient risk management.

More Information
Corporate Governance: Principles, Policies and Best Practices

This course covers the reasons why governance fails and how to avoid that and improve it. It also includes discussions about board structure, committees, their functions and duties, like the audit committee and the nomination and remuneration committees.

More Information
Advanced Enterprise Risk Management

This exciting seminar will help you to fully embed a risk culture across the whole organization, and develop a coordinated top down approach where every function evaluates its risks on a continuous and consistent basis.

More Information
Fraud Investigators Course

This ICL training course is aimed at all new or established investigators and has been devised in order to provide an initial introduction into the investigation of fraud within that industry and provides an understanding of practices and procedures when reporting offences of fraud.

More Information
Investment Fund Operations & Administration

Investment Fund Operations & Administration is a highly practical three-day course designed to give you a thorough working knowledge of how unit trusts, mutual funds, pensions funds and hedge funds are constructed, invested, managed and administered.

More Information
Effective Audit Committees

This course will explore the fundamentals of the role of the Audit Committee and the nature and essential qualities of its members, particularly the Audit Committee Chairman. The course will cover the relationships with all key stakeholders and will examine all the key information flows and decision processes.

More Information
Corporate Governance in Africa

This practical Corporate Governance training programme examines current best practice in all aspects of corporate governance, from the new role of board committees and directors' responsibilities and powers, to best implementation of governance in day-to-day activities.

More Information
Strategy & Leadership for CFO's and Senior Finance Executives

The Strategy & Leadership for CFO's and Senior Finance Executives Programme will enhance your ability to lead whilst giving you the wider business expertise required of today’s high-performing CFOs.

More Information
Advanced Technical Report Writing and Presentation Skills

This course provides technical professionals with the written communication skills to structure and write effective reports confidently, competently and persuasively.

More Information
Estimating, Costing & Pricing of Construction Tenders

This course will look at the definition, importance and uses of estimating, costing and pricing. We will cover the contextual framework, general principles and measurement when it comes to the process of tenders. Quantity estimating, client costing, tenderer pricing and contract completion also forms a major part of this specific topic and will be covered in detail

More Information
Construction Site Management & Supervision

This course introduces the practical tools to control the cost and as well the time during the project. Moreover, the final cost and time for the project can be predicted based on the rates of achieving and the consumed money at any time of the project.

More Information
Developing Multi-Skilled Supervisors

Through this course, delegates are introduced to the concepts needed for leading a team and raising the technical, engineering, maintenance, production, logistics and quality team management standards.

More Information
Project Management Essentials

This essential training course is designed to present the basics of project management with a focus on understanding project management terms, project selection, planning, estimating, scheduling, and earned value management.

More Information
Microsoft® Project 2016: Advanced

This course is tailored for experienced users of Microsoft Project, wanting to consolidate their grasp of planning and tracking, and to explore the advanced features of the software.

More Information
Microsoft® Project 2016: Basic to Intermediate

This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project.

More Information
5 Day Implementing Cost Saving Projects

This Cost Saving Projects Practical course is designed for supervisors; managers and engineers. They are ultimately responsible and accountable for failure and deviation costs. They must investigate process errors including poor performance, low targets and other people issues. They need to identify; quantify; qualify and implement cost saving projects.

More Information
Call Centre Management

Advance the success of your call center and achieve your professional career goals with a solid foundation in planning and managing an exceptional call center.

More Information
The Outstanding Receptionist & Office Administrator

This course has been developed specifically to equip receptionists and office admin staff with all the essential skills to better manage the workloads and activity profiles that form the engine-room of efficient organizations.

More Information
Customer Service for the Public Sector

This Customer Service for the Public Sector training course is designed to give participants the communication skills, negotiation strategies, and public-sector customer service best practices they require to significantly improve customer service while lowering costs and increasing employee satisfaction.

More Information
Leading Virtual Teams - Online Snippet

ICL’s online snippet is a short 1.5 hour webinar delivered by one of our subject matter experts.

More Information
Managing Your Project During Crisis - Online Snippet

ICL’s online snippet is a short 1.5 hour webinar delivered by one of our subject matter experts.

More Information
Motivating Employees in Times of Crisis - Online Snippet

ICL’s online snippet is a short 1.5 hour webinar delivered by one of our subject matter experts.

More Information
COVID-19 Workplace Preparedness Health, Safety and Claims Management Course

The programme aims at equipping managers to protect employees, suppliers and customers by providing critical information in order to successfully manage COVID-19 within the work environment.

More Information
Planning, Organising & Controlling Projects

This online training seminar is designed to equip those involved in project work with the essential skills needed to fulfill their responsibilities in a professional way. The concepts, methods and techniques presented include both well established and latest thinking to provide the essential knowledge, skills, and toolkit to ensure more successful project outcomes.

More Information
Effective Project Coordination & Management in an Uncertain World

In this online course, we aim to look at a number of advanced concepts in Project Management, Leadership and Risk Management that will enable you to deal with the ever-changing business context and ever moving project goal posts.

More Information
Virtual Leadership Skills & Managing a Digital Workforce

Achieving Excellence with Virtual and Dispersed Teams

More Information
Strategies for Leading Successful Change Initiative

This ‘Leading Successful Change’ training course helps leaders develop the practical skills they need to bring about lasting change with minimum disruption to operations. It provides them with specific guidance and the opportunity to work with a host of practical tools for implementing and embedding change.

More Information
The Complete Course on Project Management

This training course explores the very foundations of how projects are different to the operational world, but an absolute necessity when it comes to changing the operational world. You will discover how the very best practice management techniques are used to take a project through a project lifecycle, from Inception, through Definition, Execution, Monitoring and Control to Closure.

More Information
Time Management

Three Days to Turbo-Boost your Time and Task Management

More Information

Press enter to see more results