Confident use of Power BI Desktop - You will learn to navigate Power BI Desktop with confidence, understand its core features, and build analyses faster without getting lost in the interface or guessing where key options are.
Import data from multiple sources - You will learn how to bring in data from Excel, CSV files, databases, and web sources, so you can prepare reports on your own even when the information comes from several places.
Prepare cleaner data - You will master cleaning, filtering, merging, and reshaping data in Power Query, which will reduce manual fixes and help you build a consistent dataset ready for reliable analysis.
Build a reliable data model - You will learn how to create relationships between tables, choose the right filter direction, and structure your model properly, giving you more accurate results and easier report growth.
Create your first DAX calculations - You will learn the basics of DAX and start creating simple measures and calculated columns, so you can calculate business metrics that cannot be obtained by filtering raw data alone.
Design clear interactive reports - You will build charts, tables, cards, and maps, then add filters and slicers so report users can explore the data on their own, find answers faster, and work with reports more easily.
Publish and share online - You will learn how to publish reports to Power BI Service, configure dashboards, and share results with others, making collaboration easier and speeding up how analysis is delivered.
Create faster and cleaner reports - You will learn best practices for PBIX file organization, visual clarity, and model optimization, so your reports become faster, easier to read, and much simpler to maintain over time.
Power BI combines several components that serve different roles in reporting and analysis. The section introduces Desktop, Service and Mobile, explains the main areas of the Desktop interface, and clarifies how Power BI differs from Excel in everyday analytical work.
Working with Excel, CSV, databases and web sources starts with choosing the right connection method. This part explains how to retrieve data, configure sources, compare Import with DirectQuery, and handle refresh behavior for datasets used in reports.
Before data can be modeled, it often needs to be cleaned and reshaped in Power Query. Participants perform filtering, column transformations, type corrections, table merges and joins, and create custom columns to prepare structured datasets for further analysis.
Relationships between tables determine how data can be analyzed across the model. Here the focus is on keys, one-way and two-way relationships, basic DAX measures and calculated columns, along with data categories and formatting that support consistent reporting.
Building report pages in Power BI requires matching visuals to the type of analysis being performed. The section covers charts, tables, cards and maps, then moves to grouping, filtering and interactive elements such as slicers and visual-level interactions.
Once a report is ready, it needs to be delivered and maintained in Power BI Service. Participants work through publishing, arranging content online, configuring dashboards, sharing reports for team collaboration, and setting automatic data refresh for connected sources.
PBIX file structure affects both maintainability and report performance. This section focuses on organizing pages and report elements, improving visualization readability and usability, and applying practical optimization techniques to the data model and report layer.
Basic computer skills - You should be comfortable using Windows, working with files and folders, and installing or launching applications so you can complete the exercises without technical difficulty.
Understanding tables and spreadsheets - You should understand how tables and worksheets are structured, read rows and columns easily, and work with simple datasets, ideally with some familiarity with Excel.
Basic data analysis awareness - You should be able to interpret simple numeric data, understand sums, averages, and filtering, and know why reports are created so you can turn data into useful conclusions.
Readiness for hands-on work - You should be ready to work independently with sample datasets, test different settings, and draw conclusions, because the training is practical and exercise-based throughout.
