تحليل البيانات

Power BI: Intermediate Data Analysis Techniques

Users who can already build basic reports often struggle when data comes from several sources or when questions involve time comparisons and percentages of totals. This intermediate programme closes that gap: Power Query merges, appends, unpivoting and parameters, star-schema modelling with a proper date table, DAX with CALCULATE, FILTER and ALL, time intelligence, ranking, drillthrough and bookmarks, and introductory row-level security, preparing participants to deliver reliable departmental reports.

الحصول على الكتيب

للحصول على كتيب بكامل محتويات الدورة برجاء ملء النموذج التالي ببياناتك الصحيحة

تحميل الكتيب

دورات مشابهة
تحليل البيانات

IIBA Endorsed Certified Data Analyst

يوليو
، 2027
الإنجليزية
دبي
$3,600.00
اعرف المزيد
تحليل البيانات

Business Intelligence: Data Analysis and Reporting Techniques

أكتوبر
، 2027
الإنجليزية
جورجيا
$4,500.00
اعرف المزيد
تحليل البيانات

Power BI: Data Visualization and Dashboards

نوفمبر
، 2027
الإنجليزية
أمستردام
$4,900.00
اعرف المزيد
تحليل البيانات

مهارات تحليل البيانات باستخدام Excel وPower BI

يونيو
، 2027
العربية
الكويت
$3,600.00
اعرف المزيد
نوفمبر
، 2027
الإنجليزية
المنامة
$3,600.00
NEVADA | PROFESSIONAL EXPERIENCE

Program Professional Framework

Power BI: Intermediate Data Analysis Techniques

Program Overview

Users who can already build basic reports often struggle when data comes from several sources or when questions involve time comparisons and percentages of totals. This intermediate programme closes that gap: Power Query merges, appends, unpivoting and parameters, star-schema modelling with a proper date table, DAX with CALCULATE, FILTER and ALL, time intelligence, ranking, drillthrough and bookmarks, and introductory row-level security, preparing participants to deliver reliable departmental reports.

Learning Outcomes

  • ✓Combine data from multiple sources using merge, append and unpivot operations in Power Query.
  • ✓Restructure a flat dataset into a star schema with a marked date table.
  • ✓Write measures using CALCULATE, FILTER and ALL for percentage of total and filtered comparisons.
  • ✓Implement year-to-date, prior-year and moving average calculations with time intelligence functions.
  • ✓Add drillthrough pages, bookmarks and tooltips to support analysis.
  • ✓Apply basic row-level security roles and test them.

Target Audience

  • Analysts with basic Power BI experience
  • Departmental report developers
  • Finance and operations analysts
  • BI support staff

Detailed Program Modules

01Intermediate Power Query
  • Merging and appending queries
  • Unpivoting and pivoting data
  • Parameters and reusable functions
02Star-Schema Modelling
  • Separating facts and dimensions
  • Date tables and marking
  • Relationship troubleshooting
03DAX Filter Functions
  • CALCULATE and filter arguments
  • FILTER, ALL and ALLEXCEPT
  • Percentage of total and ratios
04Time Intelligence
  • Year-to-date and prior-period measures
  • Moving averages
  • Fiscal calendars
05Analytical Report Features
  • Ranking and Top N analysis
  • Drillthrough and tooltips
  • Bookmarks and selection pane
06Security and Sharing
  • Row-level security roles
  • Testing roles in Desktop and service
  • Workspace sharing practices

Training Methodology

Interactive expert-led sessions grounded in workplace examples
Case studies and practical exercises drawn from the region
Group workshops with peer review of decisions and deliverables
Formative feedback against clear performance criteria

Applied Project & Assessment

Applied Project

Participants rebuild a multi-source departmental report: combined queries, star-schema model, time intelligence and Top N measures, drillthrough analysis pages and row-level security for at least two roles.

Assessment

Short diagnostic at the start, practical tasks linked to each learning outcome, and evaluation of the applied project against published criteria.