Duration

20 hours

Monitoring Method

Online & On demand

Language of Delivery

Greek

Start Date

31 March

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 aimed at

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

Lecture

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

  • The attendance of the program can be done by physical presence in scheduled classes at our facilities – 68 Sygrou Avenue (next to Metro “Sygrou – Fix”) but you have the opportunity through our modern educational platform to attend the courses online/on demand at your own time and place combining physical presence and distance learning.

You may also be interested in:

Learn more
Express your interest here! ➜