Power BI Essential Training

Use the merge query option in Power BI essential training to join multiple tables with a left outer join and bring brand names and product keys into the sales table.

Explore Power Query tools and options in Power BI essential training, including changing data types, splitting columns, duplicating and removing duplicates, and extracting month names from dates.

Explore advanced Power Query concepts by connecting to diverse data sources, including Excel and CSV files, and forming folder connections. Combine all files into one table to prepare for visualisations.

Connect with multiple Excel sheets in a workbook to pull data, set the first row as headers, remove extra columns, and refresh automatically as new sheets are added.

Explore the Power BI Desktop canvas, connect data sources like Microsoft Access, build data models, and create visuals and dashboards with marketplace and AI visuals.

Explore how to select and switch visuals in Power BI, from column charts and treemaps to cards and metrics, and compare table versus pivot-like visuals for drilldown.

Master selecting visuals in Power BI to shape dashboards and reports, using appropriate charts, filters, and data relationships to clearly compare sales, costs, profits, and by year and category.

Learn to edit visuals in Power BI by adjusting legends, data labels, colors, titles, backgrounds, borders, and formatting options, and place visuals on the canvas.

Learn to use card visuals to display total profit, total sales, and total cost in a Power BI dashboard report, and arrange and size them effectively.

Learn to use slicers in Power BI to filter visuals, connect multiple slicers to charts, switch to focus mode, view data in tables, and explore subcategory filtering.

Learn to distinguish a fact table from dimension tables in Power BI, build many-to-one relationships, and apply a star schema to filter sales data by product, category, month, and salesman.

In this lecture, learn why DAX is essential for Power BI by building and using measures to calculate total sales, total cost, gross profit, and margin across data tables.

Explore model optimization in Power BI by creating measures for year-over-year and actual vs budget comparisons, using dashboards to analyze sales, margins, and time intelligence for period comparisons.

Explore Power BI's time intelligence feature to calculate same period last year, compare totals across years and months, and build dynamic visual insights.

Learn to solve Power BI case studies by building a complete dashboard with cards, slicers, and visuals, using data mapping, P&L style measures, and interactive year, month, or quarter views.

Case study 1 guides you to connect data, optimize the Power BI data model, trim unnecessary columns, and build a dashboard by linking product categories and subcategories.

Create DAX measures in Power BI from a data model, including total sales, total cost, and profit percentage, using arithmetic and aggregation for year-filtered visuals.

Learn to build a Power BI dashboard from visual inspection to interactive visuals, using slicers, charts, and trend lines to analyze sales, profits, and calendar year data.

Learn to customize visual colors in Power BI by selecting and editing data colors, applying a color theme, and instantly changing all visuals with the latest view options.

Consolidate three years of data and map traffic alarms in Power BI to build a time-aware dashboard, using Excel pivot data and mapping tables.

Demonstrates Power BI data preparation by importing two Excel tables, transforming and merging them, creating a mapping, and building relationships and a pivot to analyze revenue and expenses in USD.

Explore building a complete data model in Power BI by integrating 2017–2019 data from Excel and Word, creating mapping and calendar tables, defining relationships, and building interactive visuals with slicers.