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.

University Certificate & International Accreditation

Professional Certificate accredited by Twintech International University College of Technology in Power BI: Intermediate Data Analysis Techniques

International accreditation: American Association of Innovation (AAI)