Power BI by OrangeTree Global

Learn data manipulation in Power BI using the editor, set the first row as headers. Split columns by hyphens and slashes to create month-specific fields and filter for January.

Compare measures and calculated columns in Power BI, and learn when to create a new column or a new measure to keep your data model efficient and compact.

Master measures and columns in Power BI part 2 by creating new measures, understanding when a measure is activated across fields without increasing the dataset size.

Power BI course teaches using a new calculated column as a filter and a measure with sum and max to split sales into food and non-food categories, with decimal precision.

Explore the DAX function library in Power BI, covering aggregation, date, information, logical, math, and text functions, and learn to create measures using DAX expressions.

Learn how to use the DAX calculate function in Power BI to create measures, apply category-specific filters like furniture, and analyze total sales in a defined context.

Apply DAX functions with filter in Power BI to build measures and calculated fields, and use slicers to segment orders by date, category, and delimiter-based splits for insights.

Explore textual filters in Power BI using equals, contains, and not equals with or and logic, plus advanced options. Apply changes by closing and applying to filter results.

Explore numeric filters in Power BI, using between, greater than, less than, and equals to refine data; learn how to exclude blanks and apply multiple conditions to isolate values.

Explore how Power BI uses area and stacked area charts to visualize trends and total values, compare shipping costs across markets over years, and manage axes for clarity.

Explore how to create and customize a 100% stacked bar chart in Power BI, dividing data into categories, displaying percent shares, and adding a constant line for comparison.

Create and customize scatter plots in Power BI by selecting x and y axes, adding a categorical field for breakdown, and analyzing sales and profit across countries.

Create and customize a Power BI pie chart to visualize profit by city, using drag-and-drop selections and adjusting colors, legend, data labels, and display units.

Explore building interactive Power BI dashboards by adding text boxes, images, and shapes, adjusting sizes, grouping visuals, and embedding hyperlinks for rich, descriptive insights.

Explore KPI performance in Power BI by building key performance indicators, setting targets, and visualizing monthly progress and trends to gauge goal achievement.

Merge queries in Power BI by importing multiple data sources, identifying common key columns, and applying fuzzy matching to join tables on those bases.

Discover advanced data manipulation in Power BI, including replacing values, removing or keeping rules, moving or selecting columns, and creating custom columns.

Explore advanced data manipulation in Power BI by creating custom calculations from existing fields, generating formulas, and using menu-driven steps.

Learn how sum and sumx differ in Power BI by calculating a per-row value from quantity and unit price, then summing, and when to use a measure versus a column.

Explore Power BI's self documenting feature, which records applied steps with descriptions and purposes, lets you rename steps, add detailed descriptions in properties, and keep transformations documented within the project.

Power BI teaches how to establish and manage relationships between datasets using a common field like country, auto-detect relationships, validate them in the relationships view, and handle removal or re-creation.

Create and validate relationships in Power BI by linking common keys, such as country, between tables and verifying results in visuals and reports.

Explore how a waterfall chart in Power BI visualizes incremental changes across categories and reveals month over month and year over year profit with drill down from date to quarter.

Learn to create a line chart in Power BI by setting the x and y values, using legend and category to split lines, and drilling down to quarterly and monthly.

Explore creating a line and stacked column chart in Power BI, combining bar and line series with category and numerical values, adjusting axes and adding multiple lines for comparative insights.

Explore drilling down the hierarchy in a stacked column chart to analyze profit and orders across years, quarters, months, and regions in power bi.

Learn to create a horizontal stacked bar chart in Power BI, configure the x and y axes, and drag category and subcategory fields to legend to split data.

Learn how to format charts in Power BI by adjusting axis sizes, colors, and legend positions, applying sorting, showing data, and exporting visuals.

Learn how Power BI builds clustered bar charts and ribbon charts to compare category and market data, visualize rankings and changes, and customize color, spacing, and transparency.

Power BI visual interactions enable interactive exploration of a city-focused dashboard, linking maps and charts so selecting New York City reveals linked category values and aggregated figures.