Power BI Hands-On ETL Course 2023 | Real-World Business Case

Learn to integrate data from multiple sources in Power BI by connecting to CSP files, Excel sheets, and folders, transforming data, and consolidating into a single model.

Prepare data by ensuring correct data types, converting numeric fields to text, and standardizing queries; remove unnecessary fields and rename items before loading into the desktop data model for transformations.

Perform advanced data transformation and cleaning in Power BI by splitting columns with delimiters, filling down, and extracting currency values to build a ready fact table for real-world analysis.

Remove top and bottom rows, use first row as headers, and transpose data in query editor to clean geography and manufacturing, then combine queries for U.S. and international into one.

Append multiple queries to create a single dataset, add a conditional column to fill country values, forming a unified fact table for Power BI reporting with M query.

Disable loading international sales to prevent data duplicates and optimize the data model for reporting. Execute the final ETL step by loading only validated transformed data into the model.

Learn to model data in Power BI by creating one-to-many relationships using a primary key, and build a concatenated zip country field to relate geography and sales with distinct values.

Explore data modeling in Power BI by creating relationships, managing cardinality, and configuring cross filter direction to control how geography and facts filter visuals in star or snowflake schemas.

Explore revenue by country using Power BI's Q&A feature to generate visuals, switch to a clustered column chart, and perform top N analysis for clearer, user-friendly reporting.

Create a group for top competitors and use a treemap to compare their revenue share against the rest, with cross filtering and currency switching.

Explore Power BI drill-down capabilities to perform year-over-year revenue analysis by drilling through year, quarter, month, and day to pinpoint drivers of revenue growth.

Use a slicer to filter Power BI data and create a reusable manual hierarchy of category, segment, and product in a matrix. Expand and collapse for drill-down across multiple visuals.

Explore measures vs calculated columns in Power BI, using DAX to perform aggregations, percent of grand total, market share, and year-over-year sales analysis across countries and product categories.

Create a last year sales measure in Power BI using calculate and same period last year, and build a custom date dimension table for seamless year-over-year analysis.

Learn to calculate percentage growth in Power BI by analyzing this year's revenue against last year's, creating a measure and using the divide function to display percentage changes.

Discover how to apply conditional formatting to a Power BI matrix visual, using background color gradients, data bars, and icons to reveal positive and negative revenue growth.

Import a custom json theme in Power BI to quickly apply a branded color scheme across all visuals and pages by importing hex-coded settings.

Transform Power BI reports by replacing text slicers with manufacturer logos as images in a horizontal slicer. Analyze revenue year over year and growth using line and gate visuals.

Learn to use bookmarks in Power BI to enhance storytelling by capturing snapshot views, spotlighting visuals, and guiding end users through the report.

Explore how to enhance Power BI reports with bookmarks and interactive buttons, using the bookmark navigator, custom shapes, and the gallery to create engaging, navigable visuals.

Learn to build toggle buttons in Power BI using bookmarks and the selection pane to switch a gauge between revenue and quantity.

Apply final touches to Power BI reports, backgrounds, headers, and logos, for a cleaner design. Use Azure maps, map visuals, and text boxes to craft a polished real-world business case.

Explore how the decomposition tree in Power BI analyzes revenue across hierarchies and dimensions. See how it explains by category, segments, and manufacturers to reveal top performance segments.

Explore the Power BI key influencers visualization to analyze revenue drivers, identifying factors that increase or decrease revenue across products, categories, manufacturers, and segments.

Power BI's magnetic visual and smart narrative analyze revenue changes with dynamic key influencers. See country-specific, interactive insights and the Maximus product driving growth.