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.

Master how to apply filtering in Power BI visuals, including filtering between 200000 and 2000000, using basic, top, and advanced filters, and drilling down by top customers to tailor reports.

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.

Control cross-visual interactions in Power BI by selecting a table and using the format options. Disable interactions with specific visuals like pie charts or bar charts.

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.

Learn to tailor Power BI reports for mobile by switching to the phone view, pinning visuals, and resizing and rearranging charts, tables, and maps for a responsive mobile layout.

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.

Explore time intelligence functions like total YTD, QTD, and MTD to analyze sales across days, months, and quarters, using measures and a dedicated measures table for clarity.

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.

Learn to build a Power BI report from Google Analytics data, using bookmarking to switch pages, and create visuals like a funnel chart, a map, and forecasting line chart.

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.

Learn to create navigation in Power BI reports by adding bookmark-driven buttons, linking them to page bookmarks, and duplicating across pages to enable seamless navigation.

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.

Power BI dashboards offer a high-level view of key indicators from multiple visuals, while reports provide detailed, interactive data with filtering and navigation to detailed views.

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 edit a Power BI dashboard for mobile view by switching to phone view, pinning visuals, and resizing charts for an Android or iOS layout.

Explore two Microsoft Power BI custom visuals, data text box and Visio, to show dynamic text, image support, field mapping, cross filtering, and interactive organization charts.

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.