ΠΕΡΙΓΡΑΦΗ

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.

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

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.

Trainers

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.