Power BI MasterClass: Learn Data Analytics with Power BI

Learn to install the SQL Server standalone, choose features like machine learning and localdb, and troubleshoot installation issues, including Visual Studio prerequisites and Windows authentication.

Connect to a webpage in Power BI, scrape table data from Wikipedia, validate open data sources, transform and clean columns, and build clean datasets for analysis.

Connect to OData to fetch data from websites, load product details from XML, and transform and expand related tables to bring in product, order details, unit price, and employee data.

Explains three methods to change data types in Power BI, shows entering data via enter data, and covers copying, pasting from sources, and renaming tables for better data management.

Connect to a database, import tables, and expand related tables to combine products with their subcategories and categories, building cross-table relationships in Power BI.

Create and connect a product hierarchy in Power BI by combining product, product category, and subcategory tables, then design drill up and down paths to enhance analytics.

Master left anti and right anti joins in Power BI, using minus logic to return records only from the left or right table, illustrated with employees and departments.

discover how to perform append queries in Power BI, combining two or more tables with matching columns and data types, handling duplicates, and understanding union versus union all.

Explore area charts in Power BI by turning product category and sales data into visual area charts, learning axes, measures, dimensions, and formatting options.

Learn to use Power BI slicers to select single or multiple values, enable show all, and adjust format, text size, and headers, while exploring visual and page filters.

Learn to apply filters on measures within visuals, including advanced, visual, and page level filtering. See how to filter sales amount and quantity by geography using maps, charts, and slicers.

Learn to use visual, page, and report level filters in Power BI, and master advanced rules such as contains, does not contain, and is blank with proper precedence.

Explore data modelling concepts in Power BI by comparing star and snowflake schemas, defining facts, dimensions, and measures, and designing robust relationships.

Explore cardinality in power bi by distinguishing one-to-one, one-to-many, and many-to-one relationships, and learn how active and inactive relationships affect filtering in the model.

Create calculated columns in Power BI using DAX functions to compute profits from sales data and build a measure totaling profits across internet and factory sales channels.

Create a calculated table from an existing table and add a conditional column in Power BI, using distinct countries and sales ratings like good, great, excellent, and amazing.

Create a calendar table with the DAX calendar function, generating dates between start and end dates; explore today and now, end-of-month, and weekday calculations for Power BI analytics.

Explore DAX text functions in Power BI, including concatenate for words or columns and handling spaces, and replace and substitute for targeted text edits with examples.

Explore DAX text functions 2, including find and replace, find, search, uppercase, left, right, trim, and substitute. Learn differences in case sensitivity, starting positions, wildcards, and building new columns.

Master DAX filter functions in Power BI by using calculate and filter, exploring related and all, to compute year-specific internet sales across geography such as country and province.