Microsoft Power BI-A Complete Data Analysis Training Package

Import excel data into Power BI and open the query editor. Ensure correct data types, including numbers and text, and track applied steps with the refresh preview.

edit and delete rows and columns in Power BI to clean your data. learn to remove unwanted columns, filter rows (nulls, blanks, duplicates), and transform text (uppercase) in selected columns.

Discover how to replace specific values in a Power BI column and apply a transform to add a fixed amount to every value, using replace values and transform options.

Explore how to split and merge columns in Power BI using delimiter and character-based methods, including renaming, duplicating, and applying transforms to produce proper date formats.

Explore creating and linking Power BI visuals—bar and line charts, clustered columns, pies, maps, gauges, tables, and cards—using filters and slicers to analyze sales by product and region Outremer.

Explore scatter, area, and bar visuals in Power BI by configuring x and y axes, size, and legends; use the play axis to study time-based trends.

Learn to drill down in charts by adding country and customer name, explore hierarchical drill-down in bar and pie visuals, and filter to reveal country-specific customer details.

apply conditional formatting in Power BI using color scales, data bars, and advanced controls; set rules for values, create gradients, and highlight text columns like customer names using a flag.

Enable drillthrough to filter values across report pages, allowing filters chosen on one tab or page to apply to other pages, such as country and product lines.

Explore Power BI's natural language query that lets you ask data questions by typing. Type questions to generate visuals, like bar or pie charts, for country or status with filters.

Learn to model data in Power BI by joining tables from multiple sources using a common key, then create relationships, manage cardinality, and control cross-filter directions.

Build a Power BI report using line and clustered column charts, stacked bar chart, a scatter chart, and a drilldown donut chart to analyze sales by year, category and country.

Master regression analysis in Power BI by exploring the relationship between independent and dependent variables, using scatter charts, a regression line, trend lines, and data filters to reveal patterns.

Learn to compare this year vs last year sales using a dax formula, create sales measures for same period last year, and apply conditional formatting to visualize variance.

Learn to perform sentiment analysis on sales data by building a calculated column with nested if statements to classify readings as positive, neutral, or negative, and visualize results with slicers.

Learn clustering in Power BI by grouping data into clusters based on similar properties, using scatter visuals to reveal three clusters and outliers in sales data.

Learn how to sync slicers across report pages in Power BI, applying product, date, sentiment, and country filters to page 1 and page 2, with single or multiple selections.

Summarizes the end-to-end Power BI project, featuring 100% bar, line, and scatter visuals with filters and drill-downs, plus sentiment analysis, clustering, regression, and chiclet slicers.

Learn how the CALCULATE function in Power BI evaluates an expression under filters, letting you compute sales for large deal sizes using string literals for size.

Learn how the dateadd function in Power BI creates measures to compare sales across last year, last quarter, last month, and last two years, using user-defined intervals for flexible analysis.

Create a calculated column in Power BI using nested if statements and or conditions to classify ratings into low (0-40), medium (40-70), and high (>70), then compare columns with measures.

Explore power bi visuals from the marketplace, set up r scripting visuals, and analyze page views, unique page views, and new users by browser and operating system with interactive sorting.

Create a clean final project report in Power BI for website performance analysis, featuring simplified navigation, bookmarking, and a q&a data query for dynamic visuals.

Create and share a Power BI dashboard by pinning visuals from a report, viewing live updates, and sharing dashboards within the same workspace.

Learn to format visuals with visual headers and wallpapers, customizing colors, borders, transparency, and per-page backgrounds across a Power BI report.

Create and enable a report-level tooltip page, set its page size, so hovering over visuals reveals a dedicated tooltip page with visuals like total units and sales amount.