Get in Touch
 Duration 14 hours

Course Outline

Review and Data Modeling Fundamentals

  • Exploring the data modeling layer within Power BI
  • Concepts of star and snowflake schemas
  • Establishing and controlling relationships between tables

Fundamentals of DAX (Data Analysis Expressions)

  • DAX syntax and data type structures
  • Distinguishing between calculated columns and measures
  • Key DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX Implementation and Business Logic

  • Time intelligence functions (YTD, MTD, QTD)
  • Conditional logic and dynamic calculation techniques
  • Ranking, running totals, and comparative metric analysis

Data Transformation and System Optimization

  • Utilizing Power Query for sophisticated data transformations
  • Efficiently integrating multiple data sources
  • Boosting performance via query folding and relationship management

Advanced Visualizations and Interactive Features

  • Custom visuals and marketplace extensions
  • Drill-downs, bookmarks, and what-if parameter implementation
  • Developing paginated and dynamic reporting structures

Performance Management and Governance in Power BI

  • Best practices for dataset administration
  • Refining refresh schedules and optimizing query performance
  • Deploying row-level security (RLS)

Practical Project: Creating a Sales Intelligence Dashboard

  • Constructing KPIs using DAX measures
  • Designing a model-driven dashboard to drive business insights
  • Applying governance and data sharing best practices

Recap and Future Directions

Requirements

  • Proficiency with the Power BI interface and report generation
  • Practical experience in constructing Power BI dashboards
  • Fundamental understanding of data relationships and filtering mechanisms

Target Audience

  • Business intelligence professionals
  • Data analysts and reporting specialists
  • Developers focused on data visualization and analytics

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (4)

How to use relationships in Power BIand the differences between columns and measurements

LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

The application of Data Modelling and DAX

Rachel KY Wong - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Emoji setting. SharePoint data source linkage. Concept of DAX in measure and column.

Lam Chit Wui (Ray) - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Calculate, Measure

TONY ZHOU CHEN - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Upcoming Courses

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-11-10 09:30
14 hours
Iasi, City Center
495 EUR (Online)
895 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-11-24 09:30
14 hours
Bucharest, City Center
495 EUR (Online)
895 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-08 09:30
14 hours
ActiveOne Bucharest
495 EUR (Online)
895 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-22 09:30
14 hours
Brasov, Calea Bucuresti Street
495 EUR (Online)
895 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2027-01-05 09:30
14 hours
Sibiu
495 EUR (Online)
895 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2027-01-19 09:30
14 hours
Cluj-Napoca, Pitești Street
495 EUR (Online)
895 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Romania (online or onsite) is tailored for business analysts, data analysts, and developers who want to leverage advanced Power BI features and tools to conduct complex data analysis and create interactive visual reports.

Upon completion of this training, participants will be able to:

  • Install and configure Power BI along with its necessary components.
  • Understand and explore the advanced features, components, and tools available in Power BI.
  • Gain valuable insights into advanced data analysis strategies.
  • Apply advanced data modeling techniques.
  • Learn how to implement advanced formulas and calculations using DAX.
  • Master tips and tricks for data handling, visualization, and presentation.
  • Create interactive reports and dashboards to facilitate collaboration within Power BI.
  • Learn and explore embedded analytics capabilities in Power BI.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live training on Romania supports both beginner and intermediate users in mastering data analytics with Power BI. Participants will acquire the skills to prepare data, build interactive dashboards, and securely share reports, fostering practical capabilities for making data-informed decisions within contemporary business environments.
Read more...

Data Analysis with Python, R, Power Query, and Power BI

 21 Hours

This instructor-led, live training in Romania (online or onsite) is aimed at beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations using these tools.

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

  • Understand the basics of Python, R, Power Query, and Power BI for data analysis.
  • Clean and organize datasets using Python and Power Query.
  • Perform statistical analysis and projections with R.
  • Create professional dashboards and reports with Power BI.
  • Integrate and analyze data from multiple sources effectively.
Read more...

Excel to Power BI

 7 Hours

This instructor-led live training in Romania (available online or onsite) is tailored for data analysts who wish to acquire techniques for preparing data in Excel and then visualizing it in Power BI.

By the conclusion of this training, participants will be able to:

  • Understand the core principles, objectives, and approaches of data analysis.
  • Apply DAX formulas in Power BI for complex calculations.
  • Create and utilize visualizations and charts for specific analytical cases.
  • Import data with Power View to transition from Excel-based Power BI to an independent Power BI setup.
Read more...

Power BI - Advanced

 14 Hours

Course Format

  • Interactive lectures and discussions.
  • Extensive exercises and practical training.
  • Hands-on implementation within a live laboratory environment.

Customization Options for the Course

  • For requests regarding customized training for this course, please contact us to make arrangements.
Read more...

Power BI Dashboards

 14 Hours
Explore the methods for constructing interactive dashboards using Power BI. Acquire skills in data transformation, visual report generation, and sharing management within Romania. This course addresses core competencies, including data connectors, advanced filtering techniques, and best practices for robust business intelligence and enterprise-wide access.
Read more...

Power BI for Financial Analysts: Exam Preparation (PL-300)

 7 Hours

Advance your readiness for the Microsoft PL-300 certification through this instructor-led course in Romania. Specifically designed for financial analysts, the curriculum addresses data preparation, modeling, KPI development, and dashboard visualization within Power BI. Enhance your practical skill set through hands-on labs and exercises focused on exam scenarios.

Read more...

Power Apps

 21 Hours
This live, instructor-led session on Romania explores the fundamental concepts and practical techniques of Power Apps. It guides participants in constructing no-code applications utilizing templates, data connectors, and AI features to optimize daily business processes and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Elevate your productivity by mastering Microsoft Power Automate in this practical, hands-on session held in Romania. You will learn to construct efficient no-code and low-code workflows using simple drag-and-drop actions, effectively streamlining repetitive tasks across Office 365 and hundreds of other integrated applications.
Read more...

Power BI

 14 Hours

This live, instructor-led session in Romania (delivered online or onsite) is specifically designed for data professionals and business analysts ranging from beginner to intermediate levels, aiming to proficiently utilize Power BI for data analysis and visualization.

Following this training, learners will be capable of:

  • Comprehending the structure of Power BI and its central elements.
  • Linking with various data sources and executing data transformations.
  • Producing efficient visualizations and interactive dashboards.
  • Enacting row-level security and administering data access.
Read more...

Power BI and Power Apps for Data Visualization and Business Process Automation

 21 Hours
This practical course in Romania explores Power BI and Power Apps for visualizing data and automating workflows. Participants will learn to integrate data sources, construct interactive dashboards, and design low-code applications that enhance operational efficiency without requiring deep coding knowledge.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Romania (online or onsite) is tailored for data professionals ranging from beginner to intermediate levels who seek to create impactful data visualizations and dashboards with Power BI.

By the conclusion of this training, participants will be able to:

  • Import and transform data from various sources.
  • Develop and optimize data models.
  • Create visually appealing and interactive reports and dashboards.
  • Apply best practices in data visualization and dashboard design.
  • Utilize advanced features of Power BI for in-depth data analysis.
Read more...

Power BI: Basic, Intermediate, and Advanced

 14 Hours
This guided training in Romania supports users across all skill levels in developing Power BI dashboards. Through practical exercises utilizing real-world datasets, participants will master data transformation, DAX, and visualization techniques, enabling them to effectively share compelling and interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Romania empowers finance and HR professionals to visualize cash flow and payroll data. Attendees will master building interactive dashboards, applying DAX for financial metrics, and automating reporting workflows to enhance decision-making capabilities.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours

This live Power BI course in Romania empowers financial and HR experts to develop sophisticated dashboards for cash flow and payroll oversight. Participants will learn to utilize DAX formulas, merge diverse data sources, and visualize critical trends to enhance strategic decision-making, all reinforced through practical exercises and real-world case studies.

Read more...

Related Categories

Power BI
Power BI