Power BI - Data Analytics Essentials with Power BI

Learn to add visuals on the Power BI canvas, create a pie chart of sales by ship mode, convert to a donut, plus a bar chart for sales by city.

learn how to create a top five cities by sales bar chart in Power BI, using top N filters, data labels, and visual formatting to highlight key values.

Use the filters pane to apply filters on this page for corporate or consumer segments, and use a slicer with focus mode to switch between list, drop-down, and button layouts.

learn to control visual interactions in Power BI by creating month slicers, configuring focus mode and dropdown views, and editing interactions to restrict visuals from being affected by specific slicers.

Enhance Power BI reports by arranging visuals, aligning with guides, and using a light gray background. Adjust slicer interactions, add boundaries, and insert a title for readability.

Create a horizontal boundary by inserting a line and rotating it 90 degrees, slim-fit to width, then add a bold reddish text box for the title at the top left.

Apply and customize report themes in Power BI to standardize titles, colors, and visuals across a report by adjusting text, page color, visuals, borders, and tooltips.

Add a back button in Power BI to navigate between report pages, rename pages like profit and sales, and compare button behavior on desktop versus online service.

Design a Power BI report optimized for mobile view using the phone layout, drag visuals from the right pane, arrange titles, and slicers for months, segments, and cities by profits.

Master Power BI's Q&A feature to type questions and instantly generate visuals. Convert Q&A results to standard visuals and rename fields, such as sales to income.

Load Excel data from the super store data in Power Query, remove unused columns, set data types, and create four queries for orders fact table and three dimension tables.

Test relationships across tables in the Power BI report view by selecting fields from customer segments, regions, and product categories and comparing them to a numeric field.

Discover DAX, the data analysis expressions language in Power BI, to generate new tables, add columns, and write measures, and use a calendar table for date functions.

Build a richer Power BI calendar by adding month, year, and quarter columns with the format function on the calendar dates, including month names and quarter labels.

Connect your calendar table to the orders data to align monthly sales; create a proper relationship so each month shows accurate values.

In Power BI, create a new column called month number using the MONTH() function, then sort the month column by this numeric order to achieve January to December.

Explore how Power BI uses a revenue measure across visuals to show revenue by month or by customer segment, and understand how evaluation context and filter context drive these calculations.

Explore how filter context shapes Power BI visuals by month and consumer segment, showing how selecting January filters charts and cards to reveal precise values.

Demonstrates using the calculate function to modify the filter context and compute revenue by region, creating central revenue and revenue versus central measures.

learn to create time intelligence calculations in Power BI, including previous month revenue, month-on-month variance, and year-to-date views using a matrix visual.

Create a measure using same period last year to compare revenue for a chosen period against the previous year, so January 2015 values reflect January 2014 figures in the visual.

Calculate year-to-date revenue in Power BI using two dax methods—calculate with datesytd and totalytd—aggregating from January to the currently selected month.

Learn to create automatic measures with quick measures in Power BI, using a base value and calendar dates to calculate revenue year-to-date.

Customize the report theme in Power BI by applying a theme, adjusting text size and color, and setting a background color with hex #E6E6E6, then apply.

Create a reusable Power BI report template with a horizontal line, a bold 24-point title, year and month slicers with focus mode, and a back button; duplicate for new reports.

Visualize monthly revenue and same-period-last-year revenue on a line chart, compare years, and adjust interactions to block the month filter from controlling the visual, while formatting axes.

Learn to create a forecast from a line chart in Power BI by setting revenue on the axis, enabling analytics forecast for two years forward, and comparing actuals to forecast.

Learn to visualize month-on-month revenue variance with a waterfall chart in Power BI, configure measures and interactions, and read negative red versus positive green variance magnitudes.

Create a matrix table report in Power BI to display revenue by year and month, using a revenue metric, data bars conditional formatting, and controlled interactions for precise insights.

Create a second page in Power BI, duplicate templates, and rename pages to build a donut chart showing revenue by customer segments; adjust the legend from right to left.

Combine three excel worksheets in Power BI by using append queries to create a single consolidated table from the central, east, and west data, then load the result for analysis.

Learn to consolidate multiple Excel worksheets in Power BI using the workbook property method, transforming workbook metadata, selecting worksheets, handling headers, and refreshing to evaluate the best consolidation method.

Use the folder approach in Power BI to consolidate workbooks with the same structure, select the contents, remove corrupt files, and use the combine files feature.

Consolidate un-clean Excel workbooks from a folder by connecting to the folder, cleaning headers, removing top rows, and aggregating one contents column across all workbooks.