Business Intelligence with Power BI Desktop

Master transforming numerical data in Power Query Editor, computing averages, maximums, and rounded values. Add and manipulate columns to calculate discounts and discounted prices with rounding, then close and apply.

Group and aggregate data in Power BI Desktop with the transform 'group by' feature, using basic and advanced options to compute total quantities by product key and by customer key.

Append three csv-based tables in Power BI's Power Query editor to form a single dataset, load sources, rename the project, sort by date, and organize queries into a folder.

Adjust data types and categories in Power BI desktop by formatting dates and currencies, and transforming new tables like territories. Define data categories for maps to ensure accurate visuals.

Create a territory hierarchy by nesting continent, country, and region under one item, then drag the territory hierarchy into the map visualization to illustrate data.

Manage relationships in Power BI Desktop by editing connections between stock date, order date, and the calendar; toggle between active and inactive relationships.

Hide fields from the report view to prevent end users from filtering on customer key, product key, and full name, and learn how to hide them in the data model.

Learn to write conditional logic in Power BI using if, or, and to create calculated columns—classifying parents by total children and weekends by day of week.

Explore DAX count functions: count, count rows, count A, and distinct count, showing how to handle duplicates in total return and total orders with unique value counting.

Master using the DAX calculate function to apply filter context and return conditional measures. Explore examples like bulk orders, total orders, and weekend versus weekday sales.

Use the filter function to create a table subset by a filter expression, and compare with calculate; avoid using measures in filters when filtering by price above the overall average.

Learn time intelligence in Power BI Desktop to calculate year-to-date revenue and start-of-month totals. Create a previous-month revenue measure and a revenue target with calculate and date functions.

Master visual, page, and report level filters in Power BI to drive data across visuals; apply basic, top N, and advanced filtering with clear filter context.

Visualize orders, profit, and revenue on maps in Power BI using basic and field map visuals, with interactive slicers to compare continents and countries across a dynamic dashboard.

Create trendline and area chart visualizations to analyze weekly profit trends over time, using a line chart and stacked area chart with product categories and legends.

Edit report interactions among visualizations in Power BI Desktop, including slicers, KPIs, and maps. Learn to fix interactions, apply filter context, and highlight subcategories for precise data storytelling.

Create and link bookmarks in Power BI desktop to capture page states, rename tabs for clarity, and use buttons with bookmark actions to navigate between product detail and executive summary.