Power BI Intro to Data Analysis Full Course Tutorial

Course overview

Title: Power BI — Intro to Data Analysis (three-part full course/tutorial)

• Materials: exercise files included in the video description.
• Additional options: instructor/organization offers ad-free course options and exams/certificates at learnitanytime.com.

Course structure — what each part teaches

Part 1 — Getting started / Data preparation and modeling

• Power BI Desktop interface
  • Start screen; Report / Table / Model / DAX (Query) views.
  • Panes: Fields, Visualizations, Filters.
  • Ribbon tabs: Home, Insert, Modeling, View, Optimize, Help.
• Connecting data
  • Get Data (Excel, SQL Server, Web, etc.).
  • Example dataset: Excel workbook with tables t_customers, t_products, t_sales.
• Data import & relationships
  • Automatic detection of relationships and data types; manual relationship creation.
  • Option to auto-detect relationships (Options > Data load).
• Power Query Editor (Transform Data)
  • Applied Steps model, Advanced Editor (M script) and diagnostics.
  • Common transforms: change data types, remove duplicates, filter rows, split/unpivot/transpose, rename/move columns, fill, trim/clean, extract text, date/time transforms.
  • Add Column tools: custom columns, column from example, indices; text/number/date operations; unpivot/pivot.
  • Support for running R/Python scripts (requires local R/Python installation).
  • Data profiling: column distribution/profile, formula bar, query dependency view.
• Building a data model
  • Create/connect relationships (one-to-many between customers/products and sales).
  • Create a calendar/date table with DAX (CALENDARAUTO); add calculated date columns (month number/name, year) and mark as Date Table for time intelligence.

Part 2 — Data visualization & interactive reporting

• Visual creation
  • Tables, bar, line, pie charts; drag fields or let Power BI auto-create visuals.
• Visual formatting
  • Style presets, gridlines, borders, fonts (global font), column headers, totals, data labels, titles, accessibility alt text, tooltip behavior, general sizing.
• Sorting and exporting
  • Sort visuals by axis/legend; use the ellipses menu to show as table or export data as CSV.
• Filters & Slicers
  • Text slicers: vertical/horizontal/list, search, multi-select, select-all.
  • Numeric slicers: range selectors.
  • Timeline / timeslicer: downloadable from AppSource.
  • Buttons (Insert > Elements > Buttons) to clear slicers or trigger bookmarks.
• AppSource
  • Install/import custom visuals (e.g., timeline slicer).
• Bookmarks & Buttons
  • Create bookmarks to capture page state/filters (for example, region/category combinations) and assign bookmarks to buttons for interactive navigation.
• Report layout tips
  • Grid/snapping, page renaming, and organization across pages.

Part 3 — Advanced analysis (DAX) and sharing insights

• DAX fundamentals
  • Two main artifacts:
    • Measures: single-value aggregations (avoid row context for measures).
    • Calculated columns / tables: row-level or table-returning expressions.
  • Naming & organization best practices: prefix measures (e.g., mm_); use display folders (e.g., AAA Measures).
• Common DAX functions demonstrated
  • Aggregation: SUM, AVERAGE (AVG), SUMX (row-wise expression summed).
  • CALCULATE: modify filter context (examples include total sales for a specific product).
  • FILTER: return a subset table (used to create a new table of sales > 700).
  • RELATED: pull related column values into another table (e.g., product name/price into sales via relationship).
  • IF: conditional column (e.g., high/low sales flag based on a threshold).
  • DATEADD and other time intelligence functions: shift date context (e.g., sales last month using DATEADD inside CALCULATE).
• Examples & practical usage
  • Measures: Total Quantity, Total Sales Amount using SUMX, Average Quantity; add cards and tables to display measures.
  • New tables via DAX: e.g., t_sales_above_700.
  • Calculated columns with RELATED to enrich sales rows with product fields.
• Resources
  • Recommended: DAX reference/support pages — no need to memorize ~250+ functions; use documentation and examples.
• Publishing & sharing
  • Publish report to Power BI Service (My workspace or other workspace).
  • Sharing options: share within organization, export/embed.
  • Dataset refresh: schedule up to 8×/day; use on-premises data gateway (personal gateway for local files) for scheduled refreshes.
  • Shared reports receive live updates when refresh cycles are configured.

Key product features & capabilities highlighted

• Power Query: GUI transforms, applied steps (M), Advanced Editor, diagnostics, data profiling, support for R/Python.
• DAX: measures vs columns vs tables; CALCULATE to override filters; SUMX for row-level math; RELATED for lookups; DATE functions for time intelligence.
• Visuals & interactivity: rich formatting, exportable data, custom visuals from AppSource, slicers (text/numeric/timeline), bookmarks/buttons for guided interactions.
• Publishing & sharing: Power BI Service integration, refresh scheduling, gateways, sharing/embed options.

Practical guidance / tutorial elements

Step-by-step walkthroughs included in the course:

• Importing Excel tables and inspecting previews and worksheets.
• Cleaning: remove duplicates, set data types, filter rows, replace values.
• Creating a calendar table with CALENDARAUTO, adding month/year columns, and marking it as the date table.
• Building visuals (table, bar, line, pie), choosing formatting, and adding data labels and legends.
• Adding slicers (text, numeric, timeline) and creating bookmarks + buttons for quick filter states.
• Writing DAX measures (SUM, SUMX, AVERAGE, CALCULATE) and calculated columns (RELATED, IF) with examples and best practices.
• Publishing to Power BI Service and configuring refresh/gateway.

Files and the sample dataset are included with the video for follow-along practice.

Presenter / source

• Presenter: Faz Karim
• Organization / channel: LearnIt (LearnIt / LearnItAnytime.com)