Microsoft Power BI Desktop Data Analyst Masterclass

Power BI takes you from data preparation to analysis, visualization, and sharing, using Power Query and Power Pivot to shape, relate, and filter data before presenting insights.

Install Power BI desktop and sign in to your account. Download from the Microsoft Store or powerbi.com, and sign up using an organizational email or an Office 365 trial.

Launch Power BI Desktop, sign in, and navigate the interface with the ribbon, three views (report, data, model), and panes for visuals, filters, and fields.

Explore Power BI desktop's Get Data menu, revealing six basic data source types from file sources (Excel, CSV, XML, PDF) to databases such as SQL Server and Access.

Load data from an Excel workbook called Median Age Years from Gapminder into the Power BI Desktop data model, then transform and save as a pbix.

Connect to a CSV file in Power BI desktop by selecting the text/csv data source, choosing the delimiter, previewing sample data, and loading it for data view and analysis.

Open a PBIX file or Excel data model to bring data into Power BI Desktop, using Power Pivot and Power Query; access files via file, open, or recent files.

Load data and build visualizations in Power BI using sample HR data to gain hands-on experience, and learn about the interface and optional sharing with online workspaces.

Connect to Excel data in Power BI and load the Melinta employee HR dataset, starting with table one and exploring fields like employee id, name, department, hire date, salary.

Explore the Power BI interface, switching between report, data, and model views; learn to adjust canvas settings, leverage the responsive 16:9 layout, and use the filter pane and visualizations.

Explore building stacked column and pie charts in Power BI to visualize department sizes and gender distribution, with hands-on data transformation using Power Query to handle missing values.

Use the power query editor to reduce the GDP data model to the top 20 World Bank GDP per capita countries, remove unused columns and errors, and extract first characters.

Explore advanced Power Query Editor options for transforming columns, including transpose, reverse rows, data type detection, and column operations like split, trim, clean, prefix or suffix, and extracting text.

Use Power BI Desktop and Power Query to combine multiple Excel sheets into a single data model by adding continent columns, removing population data, and loading five queries.

Replace the duplicate key with an index starting at one, renamed ID. Clean and load population by country and population growth rate data in Power Query, then validate and save.

Switch to report view to add visuals from your data model, building a geospatial map of continents by population percent and a stacked bar chart by country.

Format and standardize Power BI visuals by adjusting map types and zoom options, and apply consistent title styling with blue fonts.

Explore how slicers act as page-wide filters in Power BI, enabling filtering of visuals. Create and format a continent slicer, adjust orientation, and configure single or multi-select with select all.

Learn to add natural language Q&A to Power BI reports, typing questions to generate visuals like country lists, maps, and population charts, with synonyms and ambiguity handling.

Publish from Power BI Desktop to the service, selecting a new experience workspace, review mobile view options, and enable map visuals in tenant settings to share reports via Teams.

Download the Contoso sales sample pbix from the Microsoft Download Center, then open it in Power BI Desktop to see the tables and fields for building the data model.

Create your first measure in Power BI using the sum function in DAX by selecting the sales table and the sales amount column, then name and save the measure.

Explore DAX syntax by building a measure named total sales, using the equals sign and a DAX function to sum the sales amount column, with IntelliSense guiding selections.

Learn to build matrix visuals in Power BI by using measures like total sales, display by brand or product, and apply persistent currency formatting with zero decimals.

Create a measure named No Class using countblank on the product class name, then use a matrix to reveal any missing class name values.

Explore calculated columns in Power BI, comparing them with measures to compute gross profit as sales amount minus total cost, and learn when stored values aid filtering and performance.

Learn to create a net sales measure in Power BI by summing sales amount and subtracting total cost, discount amount, and return amount, with proper context and formatting.

Build DAX skills to create measures like staff percentage using the safe divide function, format as percentage, and analyze salary-based counts and proportions across departments and managers.