Microsoft Power BI: DA-100 Data Analytics using Power BI

Install Power BI Desktop on Windows via the Microsoft Store and launch the app. Navigate the report, data, and model views to import data, create visualizations, and define table relationships.

Learn to get data from an Excel sheet in Power BI using the Excel connector, navigate tables in the navigator, and load data from local or cloud Excel files.

Learn to connect to a SQL Server database, choose Import or DirectQuery, authenticate (Windows or SQL Server), and load data from local or Azure-hosted databases into Power BI.

Explore Power BI storage modes: import, direct query, and composite, and learn how datasets and schemas are loaded from diverse sources (Excel, SQL Server, other databases) into desktop or cloud.

Learn to switch data sources in Power BI by connecting to development and live servers, using three access points: the data source settings drop-down, file options, and the query editor.

Create custom tables in Power BI desktop, add or delete columns, name the table, load it, and publish to the service to apply your schema.

Explore core and advanced data transformations in Power BI's Power Query, including text operations such as split and extract, number and date transformations, JSON parsing, and data type conversion.

Explore how transpose, pivot, and unpivot transform data in Power BI, converting rows to columns and columns to rows, and understand how headers are affected during reshaping.

Master table and column transformations in Power BI by grouping by age and gender, replacing spaces, applying text transformations, and filling missing values to clean and analyze data.

Create columns in Power BI by applying transformations like lowercase and extract, then use custom and conditional columns to divide values and label age groups as young or old.

Explore how to merge two tables in Power BI using six join types—left, right, inner, full outer, left anti, and right anti—highlighting common keys and column selection.

Explore appending tables in Power BI by using append queries to combine two sales tables with the same schema, and configure primary and secondary rules for the merged data.

Learn how to enable load and include in report refresh for specific tables in Power BI, so static or lookup tables refresh selectively while others update automatically.

Explore how Power Query M language records data transformations as applied steps, showing source data, step references, and functions, with examples of converting text to uppercase or lowercase.

discover how query dependencies connect tables and how query folding converts transformations into efficient queries, improving power bi performance across data sources like excel and sql server.

Create and manage a country parameter in Power BI, link it to your table, and filter visuals using default and current values. Export a template and apply changes across reports.

Explore data profiling in Power BI by evaluating column quality, distributions, and distinct values. Learn to run diagnostics, view timing, and use tracing for deeper insights and issue diagnosis.

Learn how data modeling defines relationships between tables, creates calculated columns and measures with DAX, and applies star or snowflake schemas to connect lookup and fact tables in Power BI.

Learn how Power BI uses a star schema to relate tables, covering one-to-many, one-to-one, and many-to-many relationships, creation and deletion of connections, and lookup tables to simplify reports.

Discover Power BI's Q&A feature, accessed via the insert tab, where you type questions about your data in natural English and convert results to visuals.

Explore filter directions in Power BI, comparing single and both cross-filter directions in one-to-many relationships. Use a lookup table to simplify many-to-many filtering.

Explore how Power BI hierarchies let you drill down from year to quarter to month to day, revealing granular sales trends and enabling custom hierarchies like product and price.

Explore cross filter behavior in Power BI by linking a one-to-many sales and location relationship, demonstrating how location filters propagate to sales while sales filters do not affect location.

Explore DAX, a library of functions for creating columns, tables and measures in Power BI; use related, sum, and sumx for data calculations and analytics.

Explore DAX basics with the count function, including handling blanks, distinct values, and counting across tables, with context and if statements for robust Power BI analyses.

Learn to use the if function in Power BI to categorize revenue as low, moderate, or high with a revenue group column, and explore switch and M language options.

Learn to create a month name column from a date using the switch function, mapping month numbers to names, and apply switch for revenue grouping while comparing with if.

Apply filter and calculate functions in Power BI to create filtered measures and tables, using location and revenue examples to demonstrate multiple filters and expressions.

Explore DAX filter functions in Power BI, including ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS, with practical examples of how they control internal vs external filters on revenue by state and city.

Explore time intelligence functions in Power BI, build a date table and relationships, and create measures with calculate to compute year-to-date, month-to-date, quarter-to-date, and dates between.

Explore how to define variables in DAX, compute total revenue, and use operators and logical conditions such as in and not equal to to filter data by state.

Explore number formatting in Power BI, using predefined formats like general number, currency, and scientific, plus custom formats with placeholders, decimals, thousand separators, and negative value handling.

Learn how to format time in Power BI with custom formats, leading zeros, and separators, and use predefined long, medium, and short time formats.

Use the FORMAT function on a Power BI date column to apply predefined formats—general date, long date, and medium date—and customize with two-digit day, month, weekday, week, and quarter.

Learn how to round numbers in Power BI using round, floor, and ceil, specify digits, and round to multiples, with cautions on negative values.

Create a date table with a calendar range from the minimum to maximum sales dates, formatting year, month, and quarter, then relate it to other tables for time intelligence.

Explore quick measures in Power BI's UI to create measures without writing DAX, noting advantages and limits. Filter by location to see total revenue and why knowing DAX enhances context.

Explore quick measures and time intelligence in Power BI to build year-to-date total revenue calculations, adjust date hierarchies, and apply filters with calculate.

Explore quick measures by creating a star rating for total revenue, using normalization to map values to 0–1 and five stars. Examine advantages and complexities of these DAX measures.

Choose the appropriate visualizations in Power BI to tell a data story with charts, maps, KPI, line, bar, and pie visuals, plus focus mode and drill-down.

Format visualizations in Power BI by adjusting chart types, axes, colors, backgrounds, and tooltips, and explore data colors, plot area, and diverging palettes to reveal revenue insights.

Learn to configure and format a Power BI report page, including page background and wallpaper, color and transparency, page alignment, tooltips, and reverting to default.

Apply and understand basic and advanced filters in Power BI, including contains and starts with, top N filtering, and total revenue thresholds, across visuals and pages.

Import visuals from the Microsoft Store, sign in with your account, and add new charts and maps to your Power BI report to enhance data visualization.

Learn to configure Power BI reports for mobile layout by switching to mobile view, dragging and resizing visuals, and ensuring each tile appears on mobile across pages.

Learn to create custom tooltips in Power BI, enable report page tooltips, and configure visuals and page size for accurate hover information.

Learn to edit interactions between visuals in a Power BI report, using the format tab’s interactions controls to set none, highlight, or filter effects across visuals.

Learn to sync slicers across multiple pages in Power BI, applying shared filters with dropdowns and multi-select to ensure consistent totals across pages.

Master selection pane basics in Power BI by managing layer order, moving slicers, grouping visuals, and controlling tab order across pages.

Use bookmarks and selections in Power BI to toggle visuals on a single page. Create bookmarks, group visuals, and assign buttons to switch views.

learn to create bookmarks in Power BI, use buttons to navigate between page one and page two, and control visibility with bookmark actions for interactive report navigation.

Learn to navigate a multi-page Power BI report using buttons, bookmarks, and a single-select slicer wired to a data table of page names, enabling efficient pagination.

Focus on specific visuals and export data from Power BI visuals. Learn to isolate time, regions, and hierarchical levels with focus, export data, and manage hiding before publishing.

Apply include and exclude options in Microsoft Power BI DA-100 to build filters, select years like 2018–2019, and revert changes by removing filters.

Explore how to insert and customize text, shapes, images, buttons, and bookmarks in Power BI’s insert tab, applying fonts, colors, links, and navigation to build interactive pages.

Explore the view tab in Power BI to lock visuals, snap to grid lines, and use the performance analyzer to monitor load times while managing themes and bookmarks.

Apply color formatting and conditional formatting in Power BI to make reports visually appealing, using color scales, diverging palettes, and rule-based formats on total revenue.

Explore dynamic reference lines in Power BI, including minimum, maximum, average, median, percentile, and constant lines, and learn how to customize them for different visuals.

Explore the play axis feature in Power BI to animate revenue and quantity by state over time, using the play button to view monthly trends and hover over data points.

Discover how key influencers in Power BI analyze revenue drivers by linking price and quantity, reveal data anomalies, and compare segments to understand which factors boost revenue.

Explore how to use the decomposition tree in Power BI to analyze revenue by price and product, drill into high and low value items, and compare monthly performance.