Power BI Express: Unleashing Microsoft PowerBI in 6 Hours

Download and install Power BI desktop using the download link, run the setup wizard, accept terms, and complete the installation. Then access Power BI desktop from the start menu.

Learn to clean and transform data with Power Query: append multiple CSV files, unify column names, split and merge data, create custom columns, and compute total price via inner joins.

Learn Power Query basics for Power BI: remove and add columns, extract year from dates, pivot and unpivot data, and group by to summarize totals.

Discover an alternative method to build power bi reports without sql server or ssms by loading 288 records from an excel workbook into power bi desktop.

Learn how to back up and restore the AdventureWorks data warehouse using SSMS, including selecting a backup destination, restoring via device, and relocating the database to a preferred drive.

Drill into a clustered column chart using SQL Server data from AdventureWorks to compare sales by country and calendar year, with tooltips showing cost and drill up and down options.

Format a clustered column chart in Power BI by adjusting x and y axes, fonts, colors, titles, legends, grid lines, and data labels to refine the visual.

Explore how to format a clustered column chart by adjusting height and width, locking aspect ratios, positioning, and padding, then customize titles, subtitles, dividers, spacing, and colors.

Use line charts in Power BI Desktop to analyze trends, compare sales versus cost on a secondary axis, and apply filters and multipliers for yearly comparisons from 2005 to 2008.

Create and customize a Power BI pie chart with legend and values, showing sales by country and percentage. Adjust the title, rotation, and detail labels to reveal subcategories and groups.

Explore stacked column and stacked bar charts in Power BI, including 100% stacked variants, and learn how axis orientation and legends reveal country and year sales.

Master area charts in Power BI desktop to analyze trends with sales and cost on a secondary axis. Sort by month, apply filters, and add min, max, and average lines.

Explore creating stacked area charts in Power BI by using a legend for subcategories, comparing cumulative versus individual sales, and customizing lines, labels, and colors for clear insights.

Explore line with clustered column and line with stacked column combo charts to pack data in a canvas and compare sales and order quantity on same axis with year filters.

Build a dynamic Power BI report with a table, slicers as drop-downs, and cascading filters; create a profit measure, apply conditional formatting, and show data bars for total order quantity.

Use the matrix visual in Power BI Desktop to display summary data with dynamic columns driven by unique calendar year values. Drill down to countries and months, then drill up.

Explore how treemap visuals in Power BI Desktop represent hierarchical data with rectangles, revealing country-level top sales, yearly patterns, tooltips, and data label formatting.

Display single and multiple values with card and multi-row card visuals in Power BI. Learn formatting and interactive slicers to explore data across countries.

Explore gauge chart visuals in Power BI to track sales against targets using a sample dataset, with dynamic axes, slicers, and conditional color formatting.

Learn to build KPI charts in Power BI that compare the last value to a target and show monthly trends with an area chart.

Learn to build a funnel chart in Power BI that measures performance by stages—approached, applied, approved, delivered, and used—using area slicers and data labels.

Explore how data flows across one-to-many relationships in Power BI, using active product keys to filter related sales data, and how DAX sums compute total sales by color and product.

Power BI automatically creates relationships between tables using common keys, including primary and foreign keys, demonstrating one-to-many links and identical results for multi-table and single-table data.

Build dynamic dashboards in Power BI using an Excel workbook as data source, focusing on semantic modeling, date tables, and relationships to analyze sales, promotions, and product categories.

Build a Power BI dashboard in Power BI desktop by fetching data from AdventureWorks data warehouse, modeling dates, categories, subcategories, and promotions, then customize the canvas with color and logo.

Create a project measures table in Power Query, load it to model, define total sales, total cost, profit, and profit percentage with DAX, and present header cards and country slicer.

Format currency to US dollar for profit and total sales, show negatives in brackets, and add a category pie chart with blue legends on dashboard while refining labels and tooltips.

Create a Power BI dashboard showing sales by group with a donut chart and a promotion type clustered column chart, plus line chart with forecast and rectangles, using format painter.

Learn dynamic measures in Power BI with dax calculations using selectedvalue and switch, build a measures table and slicer, and format chart values dynamically.

Build a dynamic Power BI dashboard with dynamic measures and slicers that switch metrics like total sales, total cost, and total count, using drop-down country and year filters.

Learn to create and use bookmarks in Power BI to switch between sales by country and by category, using selections, buttons, and Q&A visuals.

Explore the three filter levels in Power BI: visual, page, and report, showing how selecting a visual reveals visual filters and how page and report filters apply across pages.

Learn how to use a report page as a tooltip in Power BI, turning a second page into an interactive tooltip for visuals with month sorting.

Publish reports from Power BI Desktop to the Power BI service, selecting your workspace, creating interactive dashboards, and sharing them with colleagues across departments.

Learn how the on-premises data gateway connects on-prem data sources to Power BI service, enabling scheduled data refresh for deployed reports.

Learn to refresh Power BI reports from csv data sources using manual and scheduled refresh, manage gateway and credentials, and view refresh history across published workspaces.

Power BI licenses include free, pro, and premium per user, enabling publishing and sharing, with pro offering data refresh limits and premium per user enabling live connections and storage.

Discover how dashboards in Power BI service combine visuals from multiple reports into a single page for meaningful business insights, and how reports, dashboards, and semantic model relate.

Pin visuals from reports to dashboards in Power BI service to build interactive dashboards. Rename reports and understand how dashboards differ from report pages.

Display dashboards and reports in full screen mode using Power BI, with fit to width or fit to screen options, and exit with the escape key.

Learn to export and download Power BI reports in PDF, PowerPoint, Excel, or Pbix, and embed, share, and subscribe to reports. Configure automatic subscriptions with recipients, timing, and previews.

Explore quick insights in Power BI service that apply to your semantic model to auto-generated visualizations, fast-tracking dashboard creation.

Explore the featured Q&A questions in Power BI, generate visuals from questions, pin visuals to dashboards, and manage the Q&A library in the workspace.

Create a new workspace to develop reports and dashboards with roles like admin, member, contributor, and viewer, then publish an app to share final content with end users.

Apply row level security in Power BI to restrict data by region, letting North America or Europe users view only their sales, profit, and profit percentage.

Learn to convert Power BI reports into mobile layout, arrange visuals and slicers for mobile and desktop layouts, publish to Power BI service, and test reports in the mobile app.

Publish report pages to Power BI service, test bookmark and tooltip features using normal clicks, and confirm the tooltip on total sales works across pages.