COMPUTER SKILLS
Computer skills are a valuable addition to any employee’s personal portfolio and can greatly increase your desirability to employers.
Overview
Microsoft Power BI is a business analytics tool that enables users to visualise and share insights from their data. It integrates with a variety of data sources, allowing users to create interactive reports and dashboards that help in making data-driven decisions. With built-in AI features, Power BI helps users uncover trends, identify key performance indicators, and streamline their data analysis processes, making it a powerful tool for organisations of all sizes.
Objectives
- Gain a comprehensive understanding of the Power BI components
- Learn how to connect to various data sources, import data, and use Power Query to clean, transform, and shape data
- Develop skills in creating data models and using DAX (Data Analysis Expressions)
- Master the techniques for designing interactive reports, dashboards, and visualisations
- Understand how to share reports and dashboards with others
- Learn best practices for optimising Power BI reports and dashboards for performance
Course Prerequisite
MS Excel Intermediate course.
Language of Delivery
English
Delivery Methods
Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential: Questions; Discussion; Exercises & Assessments.
Who should attend?
Data Analysts, Business Intelligence (BI) Professionals, IT Professionals, Finance and Accounting Professionals, Project Managers, Marketing and Sales Teams, Consultants and Advisors, Managers.
Duration
1 Day
Includes:
- Comprehensive Manual
- Lunch & Refreshments (not applicable to on-site training)
- Electronic Certificate (on successful completion of the course)
- Electronic Trainer Feedback Report
- Electronic Delegate Feedback Questionnaire
Course outline
| Module 1 | What Is Power BI? Getting to know Database Terminology Understanding Relationships Power BI Desktop Power BI Views Connect to Data Transform and Clean Data Create Relationships |
| Module 2 | Using Power Query to Reshape Data Extract, Transform & Load Understanding Query Steps Column‐Level Actions Data Transformation Remove Columns Removing Duplicate Records Filling In Blank Fields Filling In Empty Strings Concatenating Columns Changing Case Finding and Replacing Specific Text Trimming and Cleaning Text Extracting The Left, Right, And Middle Values Splitting Columns Using Character Markers Pivoting and Unpivoting Fields Getting Data from Folders |
| Module 3 | Dax Formulas Enhancing Power BI Data with Calculated Columns Creating Your First Calculated Column Utilising Dax to Create Calculated Columns Building Dax‐Driven Calculated Columns Referencing Fields from Other Tables Understanding Calculated Measures Creating a Calculated Measure Concatenating In PowerPivot |
| Module 4 | Create Visuals Create Reports Types Of Visualisations Slicers In Power BI Sync Separate Slicers Formatting In Reports Themes Customise & Save a Theme Save Report Themes Formatting Charts Using Conditional Formatting in Visuals Formatting Tables Manually Changing Background Colours Undo In Power BI |
| Module 5 | Create Visualisations Create Measures Create Cards to Display Measures Create a Map Create a Doughnut Chart Create a Column Chart Create a Decomposition Tree Create a KPI Visual Treemap Visual |