Microsoft Power BI Advanced Dashboard Full Practical Course

Learn to build a free, professional portfolio to showcase dashboards and work using Maven Analytics; publish projects, embed media, and share a LinkedIn-ready profile with prospective employers.

Discover how to build a personal finance dashboard in Power BI, exploring income and expenses, targets, debt alerts, and category filters to create a clean, dynamic overview.

Create KPI measures in Power BI using DAX, including total amount, total expenses, and available balance, and visualize trends with a sparkline while organizing measures in a dedicated table.

Create a custom PowerPoint template by designing a slide with a black background, rounded shapes, precise dimensions, center alignment, and color coding for a print-ready presentation.

Learn to build a gauge chart comparing total income against a target in Power BI, connect slicers across tables, and create measures that reveal the gap and hover details.

Build a dynamic measure in Power BI using variables to compute the variance between total income and targeted income, based on the selected month, with conditional formatting and currency formatting.

Explore creating a monthly income trend in a Power BI line chart, enabling slicer interactions, and formatting axes, header, colors, and background to highlight main versus side income.

Learn to separate income from expenses in Power BI by using category fields to create main income and side income measures, and build slicers for monthly dashboards.

Duplicate and customize a PowerPoint alert icon by resizing, changing colors using hex codes, inserting a bell icon, and adjusting text to create a bright, reusable alerts element.

Learn to write DAX to create alerts in Power BI, counting records, using variables, filtering by status, calculating late payments and their amounts, with a month-aware display.

Create expenses part of the Power BI dashboard with housing, personnel, and transportation categories, dynamic titles, and highlight of the highest and lowest months. Submit a screenshot via Q&A.

Connect and transform the historical data using probiotic stock, create relationships, and build Dak's measure to compare continent sales to targets. Design a clean dashboard to track continental sales performance.

Learn to build a Power BI dashboard featuring KPI cards, a custom chart, and target tracking, then analyze top products and switch views in focus mode to reveal performance insights.

Load and transform data from Excel and CSV sources in Power BI using Power Query; check data quality with column quality, promote header, and adjust data types.

Explore correcting relationships in Power BI model view by manually linking tables, configuring one-to-many and many-to-many relationships, and creating a custom date table for dashboards.

Fix data source folder path errors in Power BI and Power Query by updating the path in the Advanced Editor, enabling refreshed dashboards to load without errors.

Create KPI cards in Power BI by selecting quantity sold, revenue, and profit margin; set start of month date as trend axis, format measures, and compute percentage margin with divide.

Select all visuals for KPI cards, set a uniform height of 1.1, then remove backgrounds and align titles; keep total revenue and profit margin with percentage, copying formatting as needed.

Power BI custom chart comes to life by creating continent revenue measures with CALCULATE and FILTER, then visualize with a donut chart against a USD 50 million target.

Learn to build a Power BI custom chart by copying measures across regions, renaming Europe and North America measures, and linking to the revenue fields with color formatting.

Fix a custom blank space error in a Power BI dashboard by correcting currency-region fields (Europe and North America revenue) to ensure accurate totals and automatic updates.

Learn to customize Power BI charts and titles by editing text boxes, changing colors, hiding titles, removing backgrounds, duplicating visuals for regions, and adding a bold targeted revenue card.

Learn custom value formatting in Power BI by creating a measure with an if condition to color-code Europe and North America revenues against targets using field value formatting.

Learn to insert up and down arrow symbols in Excel and create measures for conditional formatting to visualize continent revenue versus targets in a Microsoft Power BI advanced dashboard.

Explore using a what-if parameter to dynamically control top N in Power BI, ranking products by revenue with measures, variables, and slicers.

Learn to create dynamic titles and format charts in power bi by using measures to drive top-end rankings, customize titles, colors, axis labels, and remove legends for clean templates.

Create a custom template for your Power BI dashboard by designing a branded layout, adding visuals, screenshots, and logos, then export and refine the template for reuse.

Explore how to create a dashboard that shows profit trends by month, weekdays, and years, with KPI comparisons. Set up the page in Power BI for a simple client project.

Create a custom template for Power BI dashboards by designing and aligning visuals, duplicating components, adjusting colors, and saving or exporting the template for reuse.

Create a one-page resume dashboard in Power BI using a dataset from 2020–2022 with personal information, education, and experience; explore the data dictionary and download datasets.

connect to an excel workbook via get data, transform data in Power Query, use first row as header, check column quality, then close and apply to load into Power BI.

Transform data in Power Query and add a conditional column to rate tools and skills like Excel, Tableau, and WordPress to visualize progress.

Rate and categorize tools and skills across WordPress, SQL, Adobe Premiere Pro, and Excel; assess data analysis, data visualization, project management, business knowledge, and languages; load into Power BI.

Build a 100% stacked progress bar in power bi by creating and formatting measures, using calculate and filter to visualize each tool's rating as a percentage of tools learned.

Learn to build a progress bar in Power BI by creating and copying measures, calculating percentages (70% and left out of 100%), and aligning and formatting visuals for polished dashboard.

Fill the bar visuals by creating measures and setting the percentage rating first, then the percentage left, and adjust formatting manually when copying formatting fails to keep the highest-to-lowest order.

Add descriptor names in a text box, adjust font and alignment, and manage layering by sending elements to back or front, then copy and paste to replicate across items.

Create a skills, language, and interests chart from scratch in Power BI by configuring a target bar chart and descriptors, then adjust visuals and finalize a PowerPoint template.

Create a custom template in PowerPoint by starting with a blank slide, adjusting the background color, drawing and resizing a rectangle, and removing the line for a clean, reusable slide.

Format and export a custom template in Power BI, adjust colors, insert and crop images, group and align elements, and save as PNG or JPEG.

Import and arrange portfolio images into a custom PowerPoint template within a dashboard design, applying consistent spacing, shadows, and labeled panels to create a polished education portfolio display.

Format and design a work experience section with precise alignment, headers, shapes, color, and icons in PowerPoint, using resizing, snipping tool, and screenshot workflows.

Learn to add the companies you've worked for in Power BI, display years in a table, and pull data into a card with filters and top alignment.

Format and standardize dashboard colors by selecting each chart, applying a uniform color code, and adjusting bars for a cohesive Power BI dashboard.

Create a tooltip page, insert and edit images and icons, duplicate and align visuals, and apply a transparency measure (rgba 0,0,0,0) to hide text and enable tooltip effects.

Learn to add web links and tooltips in Power BI by configuring tooltips, creating a button, and linking to LinkedIn, YouTube, or portfolio URLs to enhance interactive dashboards.

Create and customize Power BI tooltips to display experience, description, and job details; design backgrounds, add text and callouts, and manage page-level versus visual filters.

Learn to transform data in Power BI, build a relational data model, and create interactive dashboards to compare current and last year revenue by product category, brands, and top products.

Explore building an interactive Power BI dashboard that responds to filters, shows final results, and uses simple modeling to analyze customer behavior and employee data, with logic you can implement.

Ensure internet connectivity to display marketplace visuals in Power BI dashboards; use the downloadable file and guide to create a working email for Power BI service.

Import data into Power Query to clean and transform, verify data quality, create a fact table, and load to the Power BI environment while configuring relationships and modeling.

Arrange, compress, and align multiple tables in Power BI, collapse panels, and position them to expose relationships, then create connections between tables to define data links.

Learn to design a snowflake schema with a central fact table linked to dimension tables, using primary and foreign keys to create correct one-to-many relationships in Power BI.

Create a date table from scratch with year, month, week, weekday, and day using calendar auto; connect it to the model to enable hierarchies and dynamic today.

Establish one-to-many relationships between a calendar date table and the fact table in Power BI, then sort months and weekdays using a date table for advanced dashboards.

Learn to hide unused tables and columns in Power BI to streamline your data model and focus analyses for visualizations, using practical steps to conceal keys and distractors.

Split the dashboard into dedicated pages for sales, customer, and employees, and create measures and custom columns to reveal transaction insights, customer behavior, and salary analysis on historical data.

Create a measure table in Power BI to build total revenue and measures using DAX on fact and dimension tables, with currency formatting and filters across visuals, pages, and reports.

Create measures for sales targets and variance, compute variance and variance percentage with sum and divide, format as currency and percentage, and visualize using a custom card visual.

Create an order measure to compute cost of goods sold from quantity and unit cost, then derive gross profit and the margin percentage with proper formatting and visuals.

Create a line chart showing gross profit and margin in Power BI, configure tooltips to display the margin percentage, and customize the header and layout for clear, readable visuals.

Visualize top selling products and brands in Power BI using simple measures and visual filters to display total sales, limit to top five or ten, and create a polished dashboard.

Learn to add a bullet chart by OKVIZ from the marketplace to visualize total sales, previous year, and target by category, configure fields, filters, and formatting for clear insights.

Open the PowerPoint tool to build a custom visual in a clean, blank slate, remove headers and backgrounds, adjust fonts and colors, dial in spacing, and format a sales dashboard.

Create a custom PowerPoint dashboard template by capturing a screenshot, inserting it, sizing, and layering shapes and lines to establish whitespace and structure.

Create a custom Power BI dashboard template by designing configurable connector lines with gradient colors, thickness, and transparency, then export and reuse assets across dashboards.

Master Power BI dashboard color formatting, including data colors, target line markers, and stroke, for a clear KPI view of revenue, variance, and gross profit.

Build an employee detail dashboard in Power BI using the employees table to track salary spend from inception to now and pinpoint the top paid employee, leveraging a custom column.

Develop step-by-step Power BI dashboards to visualize salary paid from start to today, historical data, top salaries by roles, and employees by walk distance and ready for work absence.

Learn to build dynamic titles in Power BI by using variables and selected value to reflect the chosen month and year, with conditional logic for static defaults.

Categorize employees by work distance using custom column with if logic in Power BI, then create a visual of near, far, and very far buckets with a bottom center legend.

Build an advanced Power BI dashboard showing employees by roles and totals, plus a monthly absence reasons line chart with interactive filters and a custom template for formatting.

Learn to arrange a Power BI dashboard by inserting cards, displaying total employees, formatting titles, colors, and spacing, and capturing a dashboard screenshot for presentation.

Create a custom dashboard template by crafting a PowerPoint layout, using screenshots, rounded-corner rectangles, alignment, lines, duplication, and transparency to demarcate sections for Power BI dashboards.

Create a cohesive custom template by applying consistent colors, borders, and shadows to dashboard cards, duplicating formatting with format painter, and exporting for PowerPoint integration.

Format the Power BI dashboard by applying conditional color formatting, adjusting visuals, and turning off legends, then enrich the template with icons from PowerPoint or free icon sites.