Duration

20 hours

Ways of Attendance

Online & On demand

Language of Delivery

Greek

Start Date

2 June 2025

Location

Athens, Greece

Description

The Data Analysis – Power BI course is designed to provide participants with the knowledge and skills necessary to effectively analyze and visualize data. Participants will learn to manage and model data, create interactive reports and dashboards, and apply advanced analysis techniques using the DAX language. They will also learn to connect to databases and use the SQL language, write queries to retrieve data and integrate this data into Power BI for further analysis.After completing the course, participants will be able to:

  • Import, clean and transform data from various sources
  • Use SQL queries to retrieve and initialize data in Power BI
  • Create and optimize data models
  • Develop interactive reports and dashboards
  • Apply advanced data analysis and visualization techniques
  • Use Power BI for data sharing and collaboration

Who it is addressed to

The seminar is addressed to professionals and executives who wish to use Power BI for data analysis and visualization, such as:
  • Business and finance executives
  • Data and business intelligence analysts (BI Analysts)
  • Sales and marketing professionals
  • Business consultants and freelancers
  • IT and data management executives
  • Database Administrators (DBAs) and Data Engineers

Lecturer

Nikos Balatsoukas is a graduate of the Physics Department of the Faculty of Sciences of the University of Athens and holds a Master’s degree in Electronic Automation from the University of Athens. He is a teacher of Computer Science in Secondary and Primary Education since 2000. Registered in the Register of Certified Adult Educators of the E.O.P.P.E.P. (formerly E.KE.PIS) and in the Register of LSEK Instructors of OAED in subjects related to computer science and programming. Member of the writing team of three books.

Structure

  • What is Power BI and how it is used
  • The Power BI Desktop interface
  • Basic concepts and data structure

  • Importing data from files (Excel, CSV, SQL Databases, Cloud)
  • Using Power Query for data transformation
  • Data cleansing, managing missing values
  • Creating and merging queries

  • Connecting Power BI to SQL Server, MySQL, PostgreSQL, etc. databases.
  • Using DirectQuery vs. Import Mode
  • Writing and executing SQL Queries from within Power BI
  • Filtering, clustering and complex SQL queries
  • Combining data from SQL and other sources in Power Query
  • Optimizing SQL query performance in Power BI

  • Understanding the relationships between tables
  • Designing and creating data models
  • Creating hierarchies and calculated columns
  • Optimizing performance with proper modeling

  • Introduction to the DAX language
  • Creating calculated columns, tables and measurements
  • Using basic functions (Aggregation, Filter, Date & Time Intelligence)

  • Selecting appropriate graph types
  • Tailoring reports with filters, analysers and interactive elements
  • Use of maps, tables, heatmaps and custom visuals
  • Dashboard configuration for data analysis

  • Publishing reports to the Power BI Service
  • Creating and managing workspaces
  • Roles and access levels (Row-Level Security)
  • Best practices for data sharing

Modes of Delivery

  • Online: the monitoring of the programme can be done fully online in real time, having access to the courses and content of the programme is possible in real-time through the easy-to-use and modern platform of IST College.
  • On-Demand: The programme offers the possibility of on-demand attendance. This means that you will have access to video-recorded lessons that you can watch or refer to during the course. This means that you can access video lectures during the training.
  • Mixed : Create your own flexible study schedule using any of the above tracking modes in combination.

You may also be interested in:

Learn more
Express your interest here! ➜