POWER BI data Analytics Course and DASHBOARDS creation

Learn to enable Copilot in Power BI Desktop, configure quick measure suggestions, and generate DAX measures while understanding your data and refining results for tasks like total sales by weekday.

Resolve Power Query errors by locating the missing source file in your repository, updating the data source path, and refreshing the dashboard to restore data loading.

Build a hotel booking dashboard in Power BI using resort and city hotel data. Analyze 2016 July–August with cancellation level, average daily rate, revenue generated, and revenue lost.

Build a calendar date table in power bi by creating a new table, using calendar auto, adding year, month, weekday, and day columns, and linking it in the model.

Explore loading and transforming data in Power BI: import excel data, clean and split tables, merge queries, build a date calendar, and establish relationships for dashboards.

Create measures for total revenue and revenue lost, then compute cancellations and their percentage in Power BI. Visualize monthly revenue and cancellations with a column chart.

Explore hotel lead time and transform it into actionable buckets (0–30 days and more than 30 days) in Power BI, then build a dashboard with cancellation insights and color storytelling.

Learn to build a focused Power BI dashboard by applying visual filters for city vs resort and year 2016, using visual filtering and page filters to tailor insights.

Format and color-match Power BI visuals and PowerPoint templates for dashboards, adjusting axis and legend settings and using color codes to distinguish revenue, cancellations, and average daily rate.

Create a custom PowerPoint template for dashboards by capturing screenshots with the snipping tool, inserting visuals, shaping and coloring elements, and exporting a ready-to-use PNG template.

Explore building clear dashboards and reports in a BI service, following 15 rules for clean data, organized pages for orders and locations, and PowerPoint templates from scratch.

Import and clean data in Power BI using Power Query, transforming and checking column quality and data types, then load data and build a star schema with dimensions and facts.

Create a PowerPoint home page template to display KPIs, link to dashboard sections, and enhance visuals with hex colors, gradient fills, and subtle shadows.

Create a home page template by inserting shapes and lines, drag connectors to shape anchors, link elements, adjust color, and save your progress.

Select multiple shapes with the ctrl key, format lines with gradient stops, adjust colors, brightness, and transparency, then export the home page template slide as png, jpeg, or gif.

Learn to import a PowerPoint template with animated icons, adjust canvas backgrounds, set transparency to 0%, and configure animated icons from Fly Flat Icon to fit with fill options.

Customize the home page in Power BI by linking product, product analysis, and order pages, and displaying key metrics for sales, customers, locations, and product details.

Create a custom date table in Power BI using calendar auto, adding month, year, quarter, weekdays, and week numbers, then relate it to your data.

Power BI data analytics course teaches building a customer retargeting analysis by creating last purchase date measure and since last purchase metric to identify customers not seen for 12 days.

Search for and add a horizontal bar chart visual in Power BI, then design a custom template in PowerPoint to style the dashboard and export it for use in reports.

Import a template and animated icons into a regional sales dashboard, insert and resize assets, apply fill and style, and set up inner navigation between home and other pages.

Add cards to a Power BI dashboard to display customers over time and total transactions, then customize labels, background, color, alignment, and size for a clear, navigable view.

Format the customer table in Power BI by adjusting background, header color, and text for readability, removing totals, and applying conditional data bars for visual insight.

Explore the transactional dashboard to analyze shipping status, delivery status, and create shipping and delivery intervals using order date, ship date, and delivery date with a custom column.

Build a conditional column in Power BI to classify shipping versus delivery days into quick, early, late, and very late delivery, and then prepare a dashboard to visualize these intervals.

Learn to build a custom Power BI template by designing visuals with shapes, colors, text boxes, and layout adjustments for dashboards and transaction analysis.

Import a custom Power BI template by browsing to the file and double-clicking to load it. Adjust transparency to zero, fit the image, and center it to preview the template.

Create Power BI measures to track shipping status, including early and late shipping and delivery status, and summarize orders on a dashboard with data modeling and Power Query steps.

Learn to create a sumx measure for aggregation to compute total revenue, cost of goods sold, and gross profit in Power BI, including discount handling and unit costs.

Learn to build a readable order status visualization in Power BI by converting shipping status to delivery status, customizing a legend, and aligning colors for quick delivery insights.

Analyze the sales channel in Power BI, building a chart with a legend and blended colors for online, in-store, distributor, and wholesale, using CALCULATE and FILTER to compute total orders.

Create measures in Power BI to compute early versus late shipping and delivery percentages, by combining shipping status with total orders, and format as zero-decimal percentages.

Explain percentages in power bi by adding and formatting text boxes and callouts, showing 60% late vs 40% early and 30% quick delivery vs 70% late.

Add a product slicer to your Power BI dashboard, customize the dropdown, adjust background and text color, and configure filters to refine yearly data.

Add legend values in a Power BI dashboard by duplicating fields, adjusting online, distributor, in-store, and wholesale labels, verifying data, clearing blanks, and removing filters to ensure correct totals.

Explore the product analysis dashboard to highlight top selling and top profitable products by profit, and identify the lowest performing items using templates to build a complete product table.

insert a template into power bi desktop by exporting it as jpeg, png, or gif and saving, then open template, set transparency to zero, and fit or fill the canvas.

Learn to build Power BI visuals that show the top five products by sales and gross profit, and identify the lowest performing items using visual, page, and all-pages filters.

The lecture shows inserting a custom visual, a horizontal bar chart, from the marketplace, signing in online, and adjusting title, font color, and labels for Power BI dashboards.

Learn to highlight bars in a chart by customizing colors and axes, starting from zero, and using bold legends and clear labels for profit and gross profit.

Create and format a Power BI table to display product name, transactions, quantity ordered, revenue, cost of goods sold, and gross profit, then apply consistent formatting and decimal controls.

Apply conditional formatting in a Power BI table by selecting color bars for total revenue and total orders, then refine or remove formatting and add filters.

Explore regional filters to compare the top three sales teams, displaying revenue, cost of goods sold, profit margin, orders, and products sold, then build a dashboard template from PowerPoint.

Build a Power BI column chart of revenue by regions, using region as dimension, revenue as measure, zero-based axis, and tooltips for cost of goods sold and gross profit.

Learn to create a Power BI dashboard that highlights the top three sales teams by revenue, using visual filters, correct dimensions and measures, and page-wide filter effects.

Ensure internet access before building the dashboard to use chat and map features, then analyze host by location, identify the top three profitable locations and location types, and leverage templates.

Design a custom PowerPoint template by building a background, shapes, and headers, adjust colors and spacing, and export the current slide for use on your page.

Name the visual element and apply a location template in Power BI Desktop, adjusting transparency to reveal the design, then proceed to the main analysis and display.

Power BI dashboard that identifies the top three profitable location types and cities using gross profit and total revenue, with filters and ranking.

Create and format measures in Power BI to count distinct states and cities, applying distinct count and comma-separated formatting for interactive visuals on dashboards.

Create a map in Power BI to visualize sales and gross profit by state. Load the state dimension and format bubbles, colors, and tooltips for interactivity.