Excel and PowerBi for Data Visualization

Connect to data in Power BI Desktop using Get Data to import Excel files, Access databases, XML, PDFs, SQL, and more, then load and visualize the data.

Explore basic DAX functions in Power BI, including date, month, year, and quarterly calculations, and learn to import Excel data, transform it, and create tables for visual analysis.

Create and apply measures in Power BI to filter data by region and compute profit from Excel data, then visualize results in charts by dragging data fields.

Learn to apply if and or statements in Power BI by creating a new column to evaluate balance based on channel, such as online, and troubleshoot syntax errors.

Learn how to create a new measure in Power BI using the sum function to total sales and profit, and display results in the table.

Learn how to create a new measure using the calculate function in Power BI to compute total profit by applying date and product profit filters, with formatting options.

Apply font formatting to highlight headings by bolding text, adjust font size to 14, and apply fill colors or underlines using the home tab, with control plus b for bold.

Explore conditional formatting in Excel, using highlight cells rules to mark values greater than 80 marks and visualize expenditures and monthly budgets in data sets.

Format a Power BI table by adjusting visual styles, headers, and grid; customize colors, borders, font sizes, and alignment using options like bold headers, alternate rows, and global fonts.

Learn to create a 2D column chart in Excel from a data range, customize chart elements, styles, colors, titles, data labels, and axis settings.

Learn to create and customize a pie chart in Excel, including 2D, 3D, and donut options, data selection, rotation, explosion effects, and adding chart elements like title, labels, and legend.

Learn to create and insert charts in Power BI, selecting bar, column, pie, funnel, and globe charts, and mapping fields like sales and discounts from the financials sheet.

Use vlookup to retrieve salaries and prices. Place the lookup value in the first column; specify table array and column index; use exact matches with data validation and named ranges.

Master the h lookup function for horizontal data in row-wise tables, including table array and exact-match options, and use it like vlookup to retrieve the mobile price.

Explore how to use Excel index plus match to retrieve prices by product and weight, create dropdown lists with data validation, and lock references for precise row and column lookups.

Learn to apply filters in Power BI across visuals, pages, and all pages, using pie and funnel charts with sales, profit, discounts, and sum of sales data.

Explore the Power BI filter flow by applying country filters to financial data, updating bar charts and tables for metrics like sales, gross sales, discounts, and profit.

Create a pivot table in Excel from your data to summarize by salesperson and region, using orders and total sales, with subtotals and grand totals.

Create and modify pivot tables in excel to arrange data by name and region, aggregate values like sales and cogs, apply slicers, and adjust layout for clear visualization.

Learn how to create a pivot chart in Excel, understand how pivot charts provide subtotals and flexibly summarize region and sales data, and customize fields, axes, and styles.

Explore how to filter pivot charts by region and salesperson, using slicers to control total sales and chart elements in the analyze tab.

Demonstrates the if function as a logical tool for comparing B16 and C16, returning true/false, 1/0, or text such as pass/fail and yes/no, and date calculations.

Learn to use nested if statements and the and function in Excel to evaluate multiple subject scores against a 35 pass mark and return pass or fail.

Create and customize Power BI reports by building multiple charts, from pie charts to funnel and waterfall visuals, exploring sales, profit, and country data interactively.

Create a matrix visual in Power BI by dragging fields into rows, columns, and values, then customize headers, fonts, and grid settings to display sales by country.

Learn to build a tree map in Power BI by selecting country, sales, discount, and profit, then customize colors to visualize regional performance.

Learn to create and format a Power BI line chart to map sales by date, profit, and product, and apply forecasting with axis customization.

Create and manage roles in Power BI to filter data by region, such as United States, and save these roles to control what data appears in reports.

Publish a worksheet from Power BI Desktop to the Power BI service by clicking publish, saving changes, and entering your account email to generate a shareable link.