Data Analysis, Visualisation and Power BI

In today's business world, making smart, quick decisions is essential for success. Organisations must adapt to the data-driven environment to stay competitive, and this webinar by KPMG Cyprus addresses the growing need for effective data usage.

The webinar is designed to help participants understand the value of business intelligence and learn how to present information clearly and impactfully using Microsoft Power BI, a leading business intelligence tool. It aims to enhance participants' ability to present data in ways that support strategic decision-making within their organizations. The first part of the webinar introduces the importance of data analysis and data quality, with an example of data processing using Python, a valuable tool for data analysis. Through practical examples, participants will gain a deeper understanding of how to apply these skills in their daily tasks. The second part of the webinar takes a hands-on approach, guiding participants through the key steps and processes that a Business Intelligence Analyst uses to effectively present data using Power BI. Tailored to meet the needs of any organisation, the webinar encourages active engagement, offering opportunities for participants to ask questions and address real-world challenges in their daily work.

By the end of the training, participants will be able to:

• Explain and describe the importance of data analysis in their various departments
  
• Recognise the usefulness of Microsoft Power BI
• Understand data processing through programming in Python
• Develop a complete business intelligence report
• Apply these concepts to their own Power BI projects to solve business problems or meet business requirements
• Import, clean and model data using Python, create and present powerful reports with Microsoft Power BI
• Perform DAX (Data Analysis Expressions) calculations to extract more insights from data
• Create dynamic reports with Power BI.

In the past, business intelligence tools were mainly used by data analysts and IT users. Now, self-service BI platforms make business intelligence accessible to everyone, such as business owners and managers, executives involved in data analysis within organisations, and other relevant professionals.

All participants should be currently employed.

*The number of participants is restricted to 16.

Join the webinar (8:30 a.m. - 9:00 a.m.) *

Sessions: 

Day 1: 9:00 a.m. – 12:15 p.m. including a 15-min break between sessions

Day 2: 9:00 a.m. – 12:45 p.m. including a 15-min break between sessions
 

1. Introduction to Data Analysis with Microsoft's Tools (30 min)

• What is data analysis?
• The importance of data analysis
• How to embed a data-driven culture in your company
• What is data quality?
• Why is the proper utilisation of data vital for organizations?
• What is Power BI?
• Key components of Power BI
• Power BI workflow

2. Data Processing with Programming in Python (2 hr)

• Python for automating data processes (Extract, Transform, Load)
• Brief introduction to Python programming and Pandas
• Extract: Extracting data from an SQL database
• Transform: Data transformation
• Load: Loading data into an SQL database
• Executing Python scripts

3. Connecting and Transforming Raw Data for Data Analysis (30 min)

• Basic data sources
• Loading data into Power BI Desktop
• Introduction - What is Power BI Query Editor?
• Data quality checks
• Creating a common date table
• Basic table transformations
• Changing column types
• Importing tables into Power BI Desktop
   

-- Day 2 --
 

4. Creating a Data Model (30 min)

• Available views in Power BI: Report view, Data view, Model view
• What are the advantages of a well-structured model?
• Creating relationships between tables

5. Adding Calculated Fields with DAX (1 hr)

• Introduction to the DAX language
• Creating a table with all measures
• Power BI functions with simple and more complex measures
• Time intelligence functions

6. Creating and Designing Interactive Power BI Reports (2 hr)

• Overview of Power BI Report View
• Adding basic charts to Power BI reports
• Defining hierarchies
• Formatting and filtering options
• Cards & KPIs (Key Performance Indicators)
• Map visualisations
• Adding custom visuals
• BI and Artificial Intelligence
• Editing report interactions
• Navigation buttons
• Tooltips (descriptive guidance for the functionality / more information on a visual element).

*Note: Please join the meeting 30 minutes prior to the webinar’s start time (join at 8:30 a.m.), in order to make sure that you do not face any connection or other technical issues.

If you wish to register for the webinar, please complete the registration form.

Once your registration is submitted, you will receive an email stating the participation fee, including any discounts, if applicable. Kindly note that the payment should be settled at least two days prior to the webinar's date for your registration to be confirmed.

The programme has been approved by the HRDA. Enterprises participating with their employees who satisfy HRDA’s criteria, are entitled to subsidy. Please note that there are limited seats available, therefore enroll in this webinar as soon as possible.

If you do not receive our confirmation e-mail regarding your registration, your participation cannot be guaranteed.

Cost

€260 Net investment after subsidy from the HRDA of €130: €130 for all eligible participants*

€260 + VAT (19%) for all participants who are non-eligible for the HRDA subsidy.

*Last Date for 10% Early Bird Discount: 15/10/2024
 

Note

We do not provide a soft copy of the presentation for face-to-face seminars. However, if you would like to request one, please contact us. We may be able to provide it, subject to approval. In this case, the cost of the soft copy will be €50 for participants who have already attended the relevant training, or €100 for those who have not.

HRDA Note

For HRDA approved trainings, all individuals who wish to attend our training courses should not only fill out our registration form, but also complete the registration process through the ERMIS platform in order to be approved by the HRDA. Please reach out to the HRDA Ermis officers on 22 390 300 for more details regarding this process. Kindly also note that each participant regardless if they are claiming the HRDA subsidy or not, will need to complete their registration through ERMIS as a physical person and choose our training in order to be able to attend (either as an employee whose company is claiming the subsidy or as an individual not claiming the subsidy).
 

Discounts available

• For more than two (3+) participants from the same company a 10% discount is available on the total cost, before the VAT and HRDA subsidy. This discount only applies for participants who enroll in the same training, on the same day. This discount can only be combined with the early bird discount and the HRDA subsidy, when applicable.
• For individuals/legal entities who/which register in more than two (3+) trainings during the same semester (January-June & July-December), a 10% discount is available on the total cost, before the VAT and HRDA subsidy. This discount only applies for individuals/legal entities who/which enroll in more than two (3+) trainings during the same semester, on the same day. This discount can only be combined with the early bird discount and the HRDA subsidy, when applicable.
• There is a 10% discount for alumni members. This discount should be applied before the VAT and HRDA subsidy and can only be combined with the early bird discount and the HRDA subsidy, when applicable. For more information on our alumni scheme, click here.
• There is a 10% early bird discount on selected trainings for participants who enroll in a training course until a specific date which is stated above. This discount should be applied before the VAT and HRDA subsidy and can only be combined with the HRDA subsidy, when applicable.
• HRDA subsidy for all HRDA approved trainings. 
• Please note that while participants may qualify for multiple discounts, a maximum of two discounts, up to a total of 20%, can be applied per registration.

Contact

For any queries, please contact Vasiliki Sioziou on +357 22 207 460 or at academy@kpmg.com.cy

CPD

This webinar may contribute to Continuing Professional Development requirements. At the end of the webinar, participants will be given a certificate of attendance confirming the total number of training hours (6,5 CPD).

Kyriaki Pilia
Senior Manager, Technology Consulting, KPMG in Cyprus

Kyriaki is a Senior Manager in the Technology Consulting Department of KPMG in Cyprus. With over 20 years of professional experience, she has successfully managed and set up strong teams in the areas of Risk, MIS, Compliance and Strategy for companies in the financial sector. Her accomplishments include achieving departmental efficiency and effectiveness through the proper design of procedures and processes.

She is highly solution-oriented, utilising data-driven approaches to ensure compliance and corporate governance. In addition to her expertise in Risk, MIS, Compliance, and Strategy, she also possesses exceptional skills in data modeling. With a deep understanding of data structures and relationships, she leverages her data modeling knowledge to design databases and data warehouses. Her proficiency in data modeling enables her to create robust and efficient data models, supporting accurate data analysis and reporting for her clients. Her data-driven approach and data modeling expertise make her a valuable asset in helping companies make informed decisions based on reliable and well-structured data.

Daphne Papaioannou
Senior Advisor, Technology Consulting, KPMG in Cyprus

Daphne is a Senior Advisor within the Technology Consulting department of KPMG in Cyprus.​ She is a member of the Digital Lighthouse in the Business Analytics stream.

She holds a BSc in Management from Lancaster University and a Master’s degree in Management from the London School of Economics and Political Science, where she specialised in Marketing and Business Analytics.

She has over five years of professional experience with a strong background in business analysis, data analysis and digital marketing analytics. She ​has provided business intelligence solutions for various clients across several industries, including Banking, Insurance, Oil & Gas and the Public sector.​ Her expertise lies in data visualisation, utilising Microsoft Power BI to create interactive dashboards that facilitate business monitoring and inform data-driven decision-making. She focuses on defining appropriate KPIs by identifying business objectives and conducting thorough data analyses to develop tailored solutions that effectively meet her clients’ specific business requirements.

Giorgos Drousiotis
Senior Team Member, Technology Consulting, KPMG in Cyprus

Giorgos is a Senior Team Member in the Technology Consulting department at KPMG in Cyprus. With over 4 years of professional experience, he specialises in Data Governance and Data Analytics, contributing to projects across the Insurance, Banking, and Retail sectors. He possesses a robust background in statistics and artificial intelligence, and is proficient in programming languages such as Python, SAS, and SQL.

Giorgos is also skilled in utilising Power BI, PowerApps, and Azure Synapse Analytics. He has successfully developed a Microsoft Power Platform application to optimise seminar request processes and led data governance initiatives, including gap analyses and the creation of advanced data management strategies. His expertise extends to crafting clustering models for banking customer profiling, managing data collection, and data processing through APIs, and designing interactive dashboards in Power BI. Additionally, Giorgos has implemented ETL processes using SAS, built and maintained data pipelines in MySQL and Azure Synapse Analytics, and supported projects involving revenue recalculation and platform interface matching.