Excel & Power BI for Business Intelligence & Data Analysis

Get a quick overview of Excel Power Pivot! Learn how it helps you work with large datasets, build relationships, and create complex calculations. Understand where Power Pivot fits in and how it enhances your data analysis workflow.

Wondering which Excel versions support Power Pivot? Learn how to activate it and discover the key differences between Power Pivot and Pivot Tables. See why Power Pivot is a game-changer for handling large datasets and complex calculations!

Learn how to create Pivot Tables using Excel tables and the Power Pivot data model! See how to load data, work with external sources, and generate reports efficiently. Master the basics before diving into advanced Power Pivot features!

Explore the Power Pivot interface in Excel! Learn about key features like the Manage button, Data Model, KPIs, and Relationships. Understand how to load, model, and prepare data before creating Pivot Tables. Get a complete overview of Power Pivot’s ribbons, settings, and views!

Learn how Power Query and Power Pivot work together in Excel! Understand how Power Query fetches and transforms data from external sources, while Power Pivot helps with data modeling, relationships, and calculations. See how these tools complement each other to create powerful data visualizations using Pivot Tables, Pivot Charts, and Power BI!

See Power Query and Power Pivot in action! In this practical demo, learn how to load external data into Power Query, transform it (remove columns, change data types, calculate age, and round values), and then load it into Power Pivot for data modeling. Finally, watch how to create a Pivot Table in Excel to generate insightful reports!

Learn to import data from Access into Power Pivot, filter fields before and after import, and manage data efficiently.

Learn about Data Model Manager, tables, relationships, and data tables in Power Pivot. Understand how data models improve reporting and reduce redundancy.

Learn to design a data model using Power Pivot. Create relationships between tables to generate reports without merging data manually.

Learn to create relationships in Power Pivot. Use drag-and-drop or the "Create Relationship" tool to link tables for accurate reports.

Understanding relationships in Power Pivot: Learn how primary and foreign keys connect tables, enabling meaningful reports. Normalization reduces redundancy!

Learn about DAX (Data Analysis Expressions) powers Power Pivot, enabling calculated columns & measures. Unlike Excel, DAX functions work on entire tables & relationships!

Learn DAX syntax in Power Pivot! Understand how to write DAX formulas, use fully qualified column names, follow naming rules, and create calculated columns. Master DAX for Power BI, Power Pivot & Excel!

Understand DAX operators! Learn about arithmetic, comparison, logical, IN, and text concatenation operators used in DAX formulas. Get ready to apply them in calculated columns and measures effectively.

Learn how to create calculated columns in Power Pivot using DAX formulas. Understand row-level calculations, text functions like LEFT, RIGHT, CONCATENATE, and SEARCH to derive new column values.

In this module, we discuss creating calculated columns using text functions like LEFT, MID, RIGHT, CONCATENATE, and SEARCH to extract and manipulate data from existing columns in a table.

Explore DAX measures in Power Pivot. Learn the difference between calculated columns and measures, how to create explicit and implicit measures, and how they dynamically generate values in a pivot table

Learn about Key Performance Indicators (KPIs) in Power Pivot. Understand how KPIs provide visual performance measures, and see how to create and use them to evaluate sales targets and employee performance.

Learn how to use basic logical functions in DAX, such as IF, AND, OR, and ISBLANK. Understand how these functions can help you create calculated columns based on conditions, with practical examples like determining price remarks and mileage categories.

In this module, learn how to use the AND, OR, and ISBLANK functions in DAX to enhance your data analysis. Explore practical examples like creating vehicle remarks based on conditions and handling missing data with ISBLANK. See how to use these logical functions in pivot tables for dynamic reporting.

In this module, we explore the SWITCH function in DAX, which provides a simpler alternative to multiple nested IF statements. Learn how to use SWITCH to evaluate expressions and return specific results based on conditions, both with static values and more complex checks. Practical examples include creating weekday names from week numbers and categorizing delivery charges as low, medium, or high.

In this module, we learn about iterator functions in DAX, such as SUMX and MAXX, which iterate through each row of a table to evaluate expressions and apply aggregations like sum, max, or min.

In this module, we discuss the RANKX function, which ranks values in a table based on an expression. It offers options for ordering (ascending/descending) and handling ties (skip/dense)

Learn how to use filter functions like CALCULATE in Power Pivot to create dynamic measures, apply filters, and evaluate expressions based on specific conditions in this detailed tutorial.

In this module, we explore the FILTER function, which filters and returns a table based on specific conditions. Learn how it differs from CALCULATE and its impact on pivot table results.

In this module, we explore the ALL filter function, which removes any applied filters on a table or column, allowing you to calculate unfiltered totals. Learn how to use it in measures and pivot tables.

Learn about the RELATED function in Power BI to pull data from related tables. Understand how it works like VLOOKUP and integrates with table relationships for enriched data modeling.

Learn about the RELATEDTABLE function in Power BI to change context and evaluate table expressions with filters. Understand how it counts related rows based on table relationships.

Explore basic DAX date and time functions like DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, and more. Learn how they help in time intelligence calculations for data analysis.

Learn how to create a date table in Power Pivot to work with DAX time intelligence functions. Understand its importance for calculating comparisons like sales over different periods.

In this module, we explore time intelligence functions in DAX, specifically the Year-to-Date (YTD), Quarter-to-Date (QTD), and Month-to-Date (MTD) functions. These functions help in calculating cumulative values for a given period, making it easier to analyze data across time.

In this module, we explore the Dates in Period function, which is another time intelligence function in DAX. This function allows you to create a table of dates starting from a specified start date and spanning a specified number of intervals, which can be in days, months, quarters, or years.

In this module, we delve into the Dates Between time intelligence function in DAX, which is used to filter and calculate values over a specified range of dates.

This video explains why a date table is necessary for time intelligence functions.

This video explains how to use the LOWER, UPPER, and PROPER text functions

This video provides a practical understanding of LEFT, RIGHT, MID, and CONCATENATE functions.

The video explains the TRIM function with examples.

The video dives into the LEN function and provides an example to show how it works.

This video provides an explanation of the SEARCH function with an example.

This video shows how to use math functions like ROUNDUP, ROUNDDOWN, and ROUND.

This video explains the MROUND function in detail by showing an example.

This video explains how to use the SUMPRODUCT and POWER functions.

This video provides a practical understanding of the MOD function.

This video explains date and time functions, for example, DATEVALUE, NOW, and TIMEVALUE, with the help of examples.

This video explains other date and time functions, for example, WEEKDAY and MONTH.

The video provides a practical understanding of the DATEDIF function.

This video explains the DATE function with the help of an example.

This video offers a detailed understanding of the TIME function.

This video provides a practical understanding of the IF function.

This video explains the nested IF function.

This video provides a practical understanding of two logical functions — OR and AND.

This video dives into SUMIF, AVERAGEIF, and COUNTIF and provides examples.

This video provides a practical understanding of SUMIFS, COUNTIFS, and AVERAGEIFS.

This video explains the data validation feature in Excel.

This video shows some examples of data validation to help build a practical understanding.

This video improves one’s understanding of how data validation works.

This video explains how to create a cascading list using data validation and INDIRECT function.

This video shows how to use the advanced filter in Excel.

This video explains how to work with more features of the advanced filter tool in Excel.

This video shows how to apply the advanced filter using wildcard characters.

This video shows how to apply the filter with complex criteria.

This video shows how to use certain functions with advanced filter.

This video shows number and text custom formatting.

This video dives into different types of advanced custom formatting using numbers and texts.

This video shows how to custom format dates.

This video provides an introduction to conditional formatting and how to do it based on text and duplicate values.

This video shows how to do conditional formatting on a numerical cell.

This video explains the different types of formatting that one can apply to cells based on conditions.

This video provides an understanding of conditional formatting based on complex rules.

This video provides an introduction to what-if analysis and how it works.

This video explains the goal seek tool in what-if analysis.

This provides a practical understanding of a scenario manager, which is another what-if analysis tool.

This video provides an overview of Power BI.

This video dives into the Power BI desktop user interface.

This video covers how to create tables on the Power BI desktop application.

This video explores table styles and formatting.

This video provides a clear understanding of matrix visualization.

This video explores the different aggregation methods.

This video explains card visualization, which helps display single values, for example, count and total sales, in report pages and dashboards.

This video provides a clear understanding of how to utilize slicers for data filtration.

This video shows how to utilize visual filters.

This video provides a practical understanding of the clustered column chart in Power BI.

This video explains stacked graphs and 100% stacked graphs with the help of examples to develop a practical understanding.

This video discusses all key details concerning trend analysis graphs in Power BI.

This video explains the area graph and the stacked area graph.

This video explains ribbon graphs in detail with the help of examples.

This video provides a clear understanding of pie charts, treemap charts, and map charts.

This video provides a practical understanding of scatter charts and bubble charts.

This video explains the decomposition tree visual, which allows data visualization across different dimensions.

This video shows how one can create interactive reports in Power BI.

This video explains the process of publishing reports to Power BI Service.

This video shows how to create Power BI dashboards from a report so that one can view all key metrics and monitor the business quickly.

This video provides a practical understanding of how one can create Power BI reports on any mobile device.

This video explains themes in Power BI and how to apply them.

This video explains custom visualization with the help of examples.

This video shows how to create calculated columns and add them to power pivot tables.

This video explains DAX Date functions, for example, YEAR and MONTH, using examples to help learners build practical knowledge.

This video discusses the DAX FORMAT function. The example provided in the video can help one understand the real-world applicability of the function.

This video provides learners with an introduction to DAX measures in Power BI.

This video shows how one can create measures in Power BI.

This video covers several DAX functions, like SUM, AVERAGE, MIN, and MAX.

This video provides a practical understanding of a filter function.

This video provides an introduction to relationships in Power BI.

This video explores a couple of DAX functions that work with relationships.

This video explains the Power BI Query Editor.

This video improves learners’ understanding of the Power Query Editor.

This video explains how to do group by transformation utilizing Power BI.

This video provides a practical understanding of how to connect Power BI to Excel, create pivot tables from Power BI data, and export Power BI data to Excel tables.