Power BI : With Augmented Analytics, Auto ML and Gen-AI

Download Power BI Desktop for 64-bit or 32-bit systems and publish dashboards to the free service; upgrade to Pro or Premium for advanced analytics, including logistic regression and classification models.

Explore the Power BI interface, create reports, import data, build table relationships, apply filters, and use a variety of visuals, including third-party options.

Import and load data from Excel into Power BI from multiple sources, preparing ABC company sales data with product types, segments, country, date, price, profit, and discounts for visuals.

Transform and clean data in Power BI by importing data, transforming datasets, removing columns and rows, renaming fields, adjusting data types, removing blanks and duplicates, and applying changes.

Demonstrates data transformation techniques in Power Query Editor, including handling nulls, splitting a hyphen-delimited column to extract AQI and numbers, merging columns, and using group by.

Explore data transformation in Power BI, including filling null values with fill down, and pivoting columns to group and summarize sales by brand, using Power Query Editor.

Master DAX in Power BI to create new measures and columns using formulas for month, date, and sum, and work with profits and discounts after importing and loading data.

Explore six dax function types: date and time, lookup value, logical, math, percentile, and text, and learn where to write them—measure, new column, quick measure, and conditional column—in Power BI.

Create a gauge chart in Power BI to visualize profit against a target and a maximum value by defining new measures for the target and max.

Create a conditional column in Power BI using DAX and Power Query Editor to classify profit or loss, with nested if and switch alternatives and basic debugging tips.

Create a max value measure with max and maxx across tables, then format date columns using format to display month and year.

Learn to use year-to-date in Power BI by building a revenue by customer matrix, adding a grand total percentage, and creating a YTD quick measure for a card visual.

Develop expertise using the calculate function to filter data and create a month-to-date measure within a matrix visual, displaying discount by country and financial segment.

The video demonstrates how to use the lookup function in Power BI to fetch regional data from a second table using a common country key, mirroring vlookup in Excel.

Learn how to build visuals in Power BI using visualization options, filter reports by product or country, and create and format a text box banner for dashboards.

Build and format a card visual in Power BI to display total profit, total sales, and total discounts, with borders, titles, alignment, font size, color, and data label settings.

Learn to build a stacked column chart, standardize decimal places, format data labels, and apply a date hierarchy to compare sales by product lines and deals across years.

Learn to create and format a stacked bar chart in Power BI, with product on the axis, sales as values, and legend settings, plus borders, font size, and background options.

Build a multi-row card to display the top three products by profit. Use top filters, customize the title and colors, and create a dashboard that auto-updates and can be shared.

Create a treemap to compare units sold by product. Format borders and data labels, adjust font sizes, and center the title to build a clear Power BI dashboard.

Create a pie chart on a new page in Power BI, set product as the legend and profit as values, and format legend, data labels, and title for clear visualization.

Create a dual axis chart in Power BI using a line for units sold and a stacked column for profit by segment, then format with borders, shadows, and axis options.

Create a ribbon chart in Power BI to display performance and ranking across countries and quarters, with customizable tooltips showing profit and optional trend lines.

Learn to visualize profit across products with a bar chart and filter it by country using a slicer, including setting multi-select and single-select options and proper visual placement.

Create a map visualization that displays profit, sales, and discounts by country, using circle size to reflect profit and tooltips to show detailed metrics.

Create a dedicated tooltip page, set its size to tooltip, and use it as a custom tooltip for a map chart; hover to view sales and profit.

Create a final Power BI chart to compare country performance by profit and output, grouping United States and India, and adjust color and font size for clarity.

Learn to perform what-if analysis in Power BI by building scenario-based sales visuals, adding a constant target line, and creating sales potential measures to compare actual versus projected outcomes.

Learn to use the key influencers visual in Power BI to quickly identify drivers of profit and sales, including country, government segment, product, and discounts, for a clear high-level explanation.

Explore auto generated insights with Power BI's Q&A, using an uploaded sales dataset to answer cost, discount, and country-based questions through interactive visuals and AI-populated prompts.

Learn to establish a one to one relationship in Power BI between a product table and sales table, then create a calculated column for total sales using related unit price.

Explore how to establish one to many relationships across tables using common keys like customer ID and product ID, enabling computations for different visualizations in Power BI.

Learn how to merge two tables in power query using product and sales data, exploring left outer, right outer, full outer, and inner joins with a visual venn diagram.

Publish your Power BI desktop visuals to the web service, sign in, and publish to a workspace. Share, export, embed, manage permissions, and track who opens the report.

Implement row level security to restrict dashboards by country, using country filters and rules like Canada and Germany sales managers, publish securely, and test access with view as.

Explore Benford Law and its use in fraud detection by analyzing the leading digit distribution in Power BI, comparing actual versus Benford Law expectations to flag potential noncompliance.

Learn to build an aging analysis dashboard in Power BI by creating age and age-group columns, grouping delays into 30-day intervals, and visualizing revenue and aging counts with interactive slicers.

Learn to create advanced visuals in power bi by using python, building a multi-dimensional scatter plot of charges vs age by sex and smoking status, powered by pandas and seaborn.