Mastering Power BI:Data Analysis and Visualization(Oct 2024)

Explore the Power Query Editor to clean, shape, and merge data from multiple sources, then model data and define relationships between tables for insightful Power BI visualizations.

Learn to clean and transform data using Power Query Editor, focusing on text functions like trim, case changes, merge and split columns, and prepare data for analysis.

Learn to transform text in Power Query Editor by merging columns, splitting text, and trimming spaces, preparing data for analysis in Power BI.

Learn to use left, right, and mid functions in Power Query to extract characters, create new columns, and transform data, preparing for subsequent text formatting steps.

Transform text in Power Query using uppercase, lowercase, and proper case, and add prefixes and suffixes to data columns for clearer Power BI visuals.

Master Power Query number functions from basic arithmetic to advanced calculations, including percentages, modulo, rounding, and logical checks for even, odd, and sign, applied to total sales and cost.

Practice 2-2 guides you through date functions in Power Query Editor, extracting year, month, day, quarter, week, and day names, and computing date differences, earliest and latest dates, and ages.

Learn to append multiple csv files from a folder into a single Power BI table, combine via Power Query, and auto-refresh with new files while controlling order.

Append multiple CSV files from a folder in Power BI using Get Data, Folder, and Combine and Transform Data to produce a single table that auto-refreshes with new files.

Append multiple Excel files in Power BI by loading from a folder, using Power Query to extract workbook content with a custom column, and consolidate into a single dataset.

Append multiple sheets from an Excel file in Power BI using the Power Query Editor. Combine sheets with different column counts into a single table, filling missing values with null.

Append data from Excel and CSV sources in Power BI to create a unified view, using Power Query Editor to load files and append queries as new.

Merge data from multiple sources in Power BI using Power Query, aligning tables by a common user ID, extracting job titles, and loading Excel sheets for integrated reporting.

Merge data from sheets and Excel files in Power BI using a common user ID, via Power Query, to join tables and extract merged fields.

Merge data from multiple Excel files in Power BI using Power Query, align on first name and last name, and uncheck use original column name as prefix.

Merge data from Excel and MySQL in Power BI by importing Excel workbook and loading the CSV into MySQL database, then merge queries on first name and last name.

Build a robust data model in Power BI by creating one-to-many relationships between candidates, applications, jobs, and recruiters, managing relationships, and using auto detect to ensure seamless data interaction.

Learn to bring data to life in Power BI with charts and visuals, using slicers, filters, drill through, and conditional formatting to reveal insights.

Create and format diverse visuals in Power BI, from bar and pie charts to funnel and ribbon charts, while building relationships and analyzing sales by product categories for insights.

Explore dynamic visualizations in Power BI, including map, filled map, treemap, and line charts, by loading data, enabling map visuals, and analyzing sales by region, state, year, and profit.

Explore slicers and filters in Power BI to interact with data, creating charts like column, pie, donut, and funnel while using category and year slicers.

Master Power BI with slicers and filters to create interactive visuals. Analyze profit by region and sales by segment using charts and year slicers.

Explore filters in Power BI beyond slicers, applying visual, page, and all-pages filters to drive charts like pie and funnel charts for precise data analysis.

Learn to implement advanced visualization techniques in Power BI, including drill through navigation from a summary page to detailed pages and conditional formatting to reveal deeper insights in sales data.

Explore drillthroughs in Power BI to filter from summary visuals to detailed reports. Create and link column, donut, bar charts and tables across pages by region, category, and year.

Master conditional formatting in Power BI to color cells, add data bars and icons, and apply gradient and field value rules for highlights and clarity.

Master DAX in Power BI by learning calculated columns, calculated tables, and measures, with basics and advanced functions. Grasp context, time intelligence, table functions, and variables for dynamic calculations.

Learn dax formulas to create calculated columns and measures in Power BI. See how total cost and profit margin are computed in order details and how measures respond to filters.

Master basic DAX aggregate functions in Power BI—sum, average, min, max, count, and count rows—by building measures for total sales, average cost, and orders.

Explore DAX aggregate functions by creating measures for total sales, average product cost, min and max quantity, and order counts, and learn to view results in tables.

Explore DAX logical functions in Power BI to perform conditional analysis and build calculated columns, using if, switch, and, or, not for selling price and region mapping.

Learn to use text functions in DAX to transform and manage string data in Power BI, including concatenate, left, write, mid, upper, and lower functions.

Master DAX date and time functions in Power BI to create current date measures. Use calculated columns to extract year, month, and day from order date and compute date differences.

Explore mathematical functions in DAX to perform calculations and manipulate numerical data in Power BI. Create calculated columns for absolute difference, rounding to one decimal place, int, and mode.

Master advanced DAX functions in Power BI to boost data analysis with time intelligence, filtering, and context manipulation, using filter, calculate, all, remove filters, lookup value, and running total.

Explore context in DAX, including row and filter context, and use time intelligence to analyze total sales. Create calculated columns and measures in Power BI to reflect report filters.

Discover DAX context, including row and filter context, and use time intelligence functions as you create a calculated column for total sales and a filter-aware measure in Power BI.

Master time intelligence functions in DAX to perform date-based calculations in Power BI, building measures for year-to-date, quarter-to-date, month-to-date, and same period in the previous year.

Explore DAX table functions to create calculated tables, including summarize, add columns, calculate table, cross join, select columns, union, and intersect, for dynamic Power BI analysis.

Learn to use variables in DAX to store results, simplifying calculations and boosting readability. Create measures for profit, average vs current sales, and profit margin with revenue and cost.

Learn to write and execute DAX queries in Power BI to retrieve data, filter records, summarize by product, and build calculated columns and variables.

Explore the Power BI service, a cloud platform for publishing, sharing, and collaborating on reports and dashboards. Learn benefits, features, publishing steps, dashboards, collaboration tools, security, and mobile access.

Publish a report to the Power BI service, create a dashboard, and explore collaboration features like comments, sharing, subscriptions, and exporting to PPT, Excel, PDF, or PBIX.

Leverage Power BI with Azure to connect to Azure data sources, enabling scalable analytics, real-time dashboards, and publish reports with integrated data from Azure services.

Connect Power BI to Azure SQL Database to bring cloud-based data into reports, enabling import or direct query for real-time analysis with authenticated access.

Publish your Power BI Desktop report to the service, create a real-time dashboard using an Azure SQL data source, and share, export, subscribe, or comment to collaborate.