Enterprise DNA
Labs
Develop the skills to construct scalable, real-world data solutions guided by leading global experts.

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here
Cover: Bookmarks & Navigation
intermediate
Total points: 128 XP clock-blue 1 hours

Bookmarks & Navigation

Page navigation is important in Power BI reports leveraging performance and user experience. On the other hand, bookmarks you save the currently configured views and settings in your reports.

Tools
Power BI
Skills
Report Design
Jarrett Moore
Jarrett Moore
See details
Cover: AI Feature in Power BI
intermediate
Total points: 62 XP clock-blue 1 hours

AI Feature in Power BI

Learn why the AI feature is seriously one of the most incredible features within the Power BI suite.

Tools
Power BI
Skills
Data Modeling
Sam McKay
Sam McKay
See details
Cover: Power BI Bar Charts
intermediate
Total points: 53 XP clock-blue 1 hours

Power BI Bar Charts

Learn how we can customize the bar charts in Power BI reports using native visuals, custom visuals, and Charticulator.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: CALCULATETABLE Function
intermediate
Total points: 40 XP clock-blue 1 hours

CALCULATETABLE Function

Learn about CALCULATETABLE well is the beginning of many advanced calculations that you can do in Power BI.

Tools
Sam McKay
Sam McKay
See details
Cover: Administering Power BI in the Service
beginner
Total points: 93 XP clock-blue 1 hours

Administering Power BI in the Service

The apps available in Power BI have a simple workflow that enables you to work around the online services easily. It helps you navigate to the key consolidated information within your organization.

Tools
Sam McKay
Sam McKay
See details
Cover: ALL & ALLSELECTED Functions
intermediate
Total points: 84 XP clock-blue 1 hours

ALL & ALLSELECTED Functions

The ALL function is an extremely important part of the DAX language in Power BI

Tools
Power BI
Skills
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Calculate Function in Power BI
intermediate
Total points: 26 XP clock-blue 1 hours

Calculate Function in Power BI

Learn how to use the DAX function CALCULATE in Power BI.

Tools
Power BI
Excel
Skills
Data Strategy
Data Analysis
Mudassir Syed Rashid Ali
Mudassir Syed Rashid Ali
See details
Cover: Custom Financial Year
intermediate
Total points: 32 XP clock-blue 1 hours

Custom Financial Year

Learn how to get financial quarters aligned to the correct months using a calculated column.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Sam McKay
Sam McKay
See details
Cover: ALL & ALLEXCEPT Function
advanced
Total points: 30 XP clock-blue 1 hours

ALL & ALLEXCEPT Function

Learn how to use the ALLEXCEPT function to stop Cumulative Totals from resetting each time you make a date selection in Power BI.

Tools
Sam McKay
Sam McKay
See details
Cover: Anomaly Detection
advanced
Total points: 54 XP clock-blue 1 hours

Anomaly Detection

Anomaly detection in Power BI enables report creators to enhance line charts by automatically detecting anomalies in a time series data.

Tools
Power BI
Skills
Advanced Analytics
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Currencies Analysis
intermediate
Total points: 52 XP clock-blue 1 hours

Currencies Analysis

There are many instances with financial analysis wherein we need to integrate exchange rates in Power BI.

Tools
Power BI
Skills
Data Modeling
Sam McKay
Sam McKay
See details
Cover: "What If" Analysis
intermediate
Total points: 85 XP clock-blue 1 hours

"What If" Analysis

Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Application Like Reports
beginner
Total points: 77 XP clock-blue 1 hours

Application Like Reports

Advanced visualization tips and tricks for Power BI to make compelling analysis stand out

Tools
Sam McKay
Sam McKay
See details
Cover: Color Palettes in Power BI
intermediate
Total points: 42 XP clock-blue 1 hours

Color Palettes in Power BI

Using great color schemes in your Power BI reports is essential to engage the consumer in your insights over the long term.

Tools
Sam McKay
Sam McKay
See details
Cover: Power BI Advanced Editor
advanced
Total points: 34 XP clock-blue 1 hours

Power BI Advanced Editor

Learn the best practice tips using Advanced Editor inside Power BI.

Tools
Power BI
Skills
Data Analysis
Data Modeling
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Calculation Groups
intermediate
Total points: 97 XP clock-blue 1 hours

Calculation Groups

How to use Power BI calculation groups to create custom groupings with an insightful visualization.

Tools
Power BI
Skills
Data Visualization
Mudassir Syed Rashid Ali
Mudassir Syed Rashid Ali
See details
Cover: DAX Function - Cumulative Totals
advanced
Total points: 82 XP clock-blue 1 hours

DAX Function - Cumulative Totals

Learn how to combine important DAX functions to find complex and valuable data insights that make a difference

Tools
Power BI
Skills
Data Analysis
Data Visualization
Advanced Analytics
Sam McKay
Sam McKay
See details
Cover: Conditional Formatting
beginner
Total points: 63 XP clock-blue 1 hours

Conditional Formatting

Advanced visualization tips and tricks for Power BI to make compelling analysis stand out

Tools
Power BI
Skills
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Custom Functions in Power Query
beginner
Total points: 55 XP clock-blue 1 hours

Custom Functions in Power Query

Develop best practices in connecting, combining and refining data sources to effectively provide automated and high-quality data for reporting and analysis.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Melissa de Korte
Melissa de Korte
See details
Cover: Date table in Power Query
beginner
Total points: 102 XP clock-blue 1 hours

Date table in Power Query

Develop best practices in connecting, combining and refining data sources to effectively provide automated and high-quality data for reporting and analysis.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Melissa de Korte
Melissa de Korte
See details
Cover: Days since last transaction
beginner
Total points: 46 XP clock-blue 1 hours

Days since last transaction

Learn in-depth the many time related calculation possibilities available to use within Power BI

Tools
Power BI
Skills
Data Analysis
Business Analytics
Sam McKay
Sam McKay
See details
Cover: Data Load and Transform Best Practices
beginner
Total points: 69 XP clock-blue 1 hours

Data Load and Transform Best Practices

Best practices while preparing Power BI reports on data loading and transformation which will be instrumental in your journey.

Tools
Power BI
Skills
Data Analysis
Report Design
EDNA Experts
EDNA Experts
See details
Cover: Day Related Calculations
beginner
Total points: 92 XP clock-blue 1 hours

Day Related Calculations

Get rid of anomalies that can possibly make things complicated during the data analysis.

Tools
Power BI
Skills
Data Analysis
EDNA Experts
EDNA Experts
See details
Cover: Custom Groups Analysis
advanced
Total points: 69 XP clock-blue 1 hours

Custom Groups Analysis

Solve unique analytical problems faced within many business functions, industries and data scenarios.

Tools
Power BI
Skills
Data Strategy
Advanced Analytics
Sam McKay
Sam McKay
See details
Cover: Delimited Data in Power Query
advanced
Total points: 24 XP clock-blue 1 hours

Delimited Data in Power Query

Turn your data into a format that’s more suitable for analysis from merged delimited data within multiple columns.

Tools
Power BI
Skills
Data Analysis
Melissa de Korte
Melissa de Korte
See details
Cover: Append Queries in Power BI
advanced
Total points: 55 XP clock-blue 1 hours

Append Queries in Power BI

How to import and open an Excel file with multiple sheets to one Power BI table.

Tools
Power BI
Excel
Skills
Data Modeling
Melissa de Korte
Melissa de Korte
See details
Cover: Concatenate Function
intermediate
Total points: 33 XP clock-blue 1 hours

Concatenate Function

Learn different ways of how to combine values using advanced DAX functions. CONCATENATE function is used to join two text strings into one.

Tools
Power BI
Skills
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Data Source Analysis - Web URL
advanced
Total points: 14 XP clock-blue 1 hours

Data Source Analysis - Web URL

Bring the latest exchange rates for financial reports where you have to deal with sales from a variety of different regions around the world.

Tools
Power BI
Skills
Advanced Analytics
Data Strategy
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Financial Reporting Tips
beginner
Total points: 76 XP clock-blue 1 hours

Financial Reporting Tips

In this learning lab, I'll explain the key techniques to structuring your data when completing any type of financial reporting.

Tools
Power BI
Skills
Business Analytics
Sam McKay
Sam McKay
See details
Cover: Last Refresh Date/Time
beginner
Total points: 27 XP clock-blue 1 hours

Last Refresh Date/Time

How to create a last refresh date and time to show on all your Power BI reports and help in knowing when the last time data was refreshed,

Tools
Power BI
Skills
Report Design
Data Strategy
Jarrett Moore
Jarrett Moore
See details
Cover: Data Source Settings
beginner
Total points: 11 XP clock-blue 1 hours

Data Source Settings

Without having access to the underlying data sharing queries in Power Query is all but impossible. See how to set a parameter so that a user can change the location of the folder of the underlying data files.

Tools
Nick Mone
Nick Mone
See details
Cover: Power BI Query Parameter
intermediate
Total points: 69 XP clock-blue 1 hours

Power BI Query Parameter

Here, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor.

Tools
Power BI
Skills
Data Analysis
Melissa de Korte
Melissa de Korte
See details
Cover: Weekday vs Weekend Dates in Power BI
intermediate
Total points: 74 XP clock-blue 1 hours

Weekday vs Weekend Dates in Power BI

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: DATEADD Function
intermediate
Total points: 54 XP clock-blue 1 hours

DATEADD Function

The DATEADD function is the one you need if you require a Power BI time intelligence function that you can use to create time comparisons over a variety of various time ranges.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Variables in DAX Formula
intermediate
Total points: 69 XP clock-blue 1 hours

Variables in DAX Formula

Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out much more intuitive.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: DATESINPERIOD
beginner
Total points: 30 XP clock-blue 1 hours

DATESINPERIOD

In this video, I will show you how on any single day, you can isolate two dates and count up the amount sold between those two dates. This is ultimately how you calculate running totals in Power BI.

Tools
Sam McKay
Sam McKay
See details
Cover: Financial Year Sorting
intermediate
Total points: 72 XP clock-blue 1 hours

Financial Year Sorting

In this miniseries, you will learn how to sort your dates by financial year in Power BI.

Tools
Power BI
Skills
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Margin Analysis
beginner
Total points: 52 XP clock-blue 1 hours

Margin Analysis

Dive into the concept of measure branching. It is layering measures one on top of the other until you get the desired result

Tools
Power BI
Skills
Business Analytics
Data Visualization
Sam McKay
Sam McKay
See details
Cover: DAX Formatter/Clean Up App
beginner
Total points: 17 XP clock-blue 1 hours

DAX Formatter/Clean Up App

One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work.

Tools
Other Tools
Sam McKay
Sam McKay
See details
Cover: PARALLELPERIOD vs DATEADD vs EARLIER
advanced
Total points: 122 XP clock-blue 1 hours

PARALLELPERIOD vs DATEADD vs EARLIER

Let’s really go deep into DAX formula with the Power BI functions. We’ll look into this amazing DAX function and see how to use this in quite an effective way inside some calculations

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Moving Averages in Power BI
intermediate
Total points: 64 XP clock-blue 1 hours

Moving Averages in Power BI

In this tutorial, I’m going to teach you how to highlight trends by using moving averages in Power BI in various ways

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Layered Scenario Analysis
intermediate
Total points: 54 XP clock-blue 1 hours

Layered Scenario Analysis

Be able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Power BI Models
beginner
Total points: 116 XP clock-blue 1 hours

Power BI Models

An insightful discussion on valuable tips and best practices for organizing Power BI models.

Tools
Power BI
Skills
Data Visualization
Data Modeling
Sam McKay
Sam McKay
See details
Cover: Report Navigations
intermediate
Total points: 57 XP clock-blue 1 hours

Report Navigations

Page navigation is important in Power BI reports to leverage performance and user experience. On the other hand, bookmarks let you save the currently configured views and settings in your reports.

Tools
Power BI
Skills
Data Visualization
Data Analysis
Brian Julius
Brian Julius
See details
Cover: Practice Data set in Power Query
advanced
Total points: 68 XP clock-blue 1 hours

Practice Data set in Power Query

I’m going to show you how to keep your practice dataset updated every time you do a refresh.

Tools
Power BI
Skills
Data Transformation
Melissa de Korte
Melissa de Korte
See details
Cover: Inventory Management
intermediate
Total points: 105 XP clock-blue 1 hours

Inventory Management

In this tutorial, I go through some inventory management demo data and show you how to effectively manage your stock levels based on sales through Power BI.

Tools
Power BI
Skills
Data Modeling
Sam McKay
Sam McKay
See details
Cover: Measure Group
beginner
Total points: 52 XP clock-blue 1 hours

Measure Group

Measure groups are like folders where you put similar measures together. They help make the entire process seamless, regardless if you’re completing simple calculations or are working on more advanced reports.

Tools
Power BI
Skills
Data Modeling
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Multiple Date Calculations
intermediate
Total points: 43 XP clock-blue 1 hours

Multiple Date Calculations

Understand how to use a particular formula pattern and inactive relationships to determine the number of days between various dates in your Fact table.

Tools
Power BI
Skills
Data Analysis
Data Visualization
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Products Analysis
beginner
Total points: 85 XP clock-blue 1 hours

Products Analysis

Run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Sam McKay
Sam McKay
See details
Cover: Magic of Tooltips
beginner
Total points: 128 XP clock-blue 1 hours

Magic of Tooltips

Use a dynamic tooltip in Power BI to highlight your visuals, this has been a relatively recent update embedded into the Power BI suite.

Tools
Power BI
Skills
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Pivot/Unpivot Options in Power Query
beginner
Total points: 53 XP clock-blue 1 hours

Pivot/Unpivot Options in Power Query

This is part of an unpivot variation series, which is all about turning your data into a proper tabular format that is suitable for analysis.

Tools
Power BI
Skills
Data Analysis
Melissa de Korte
Melissa de Korte
See details
Cover: Profit Analysis
intermediate
Total points: 112 XP clock-blue 1 hours

Profit Analysis

These are some great DAX techniques that you could potentially use. These insights into Profit Margins are applicable across different scenarios and organizations.

Tools
Power BI
Skills
Business Analytics
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Profit Prediction
intermediate
Total points: 47 XP clock-blue 1 hours

Profit Prediction

Cover with this tutorial are some great examples of profit prediction in the future using Power BI.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Ranking Techniques
intermediate
Total points: 75 XP clock-blue 1 hours

Ranking Techniques

In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI.

Tools
Power BI
Skills
Data Analysis
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Scatter Charts in Power BI
beginner
Total points: 53 XP clock-blue 1 hours

Scatter Charts in Power BI

Create some compelling visualizations in Power BI, especially around scatter charts.

Tools
Power BI
Skills
Data Visualization
Alex Badiu
Alex Badiu
See details
Cover: INTERSECT & CROSS JOIN Functions
beginner
Total points: 55 XP clock-blue 1 hours

INTERSECT & CROSS JOIN Functions

Utilize the two tables that you place within it and bring them together.<br>

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Power BI Slicer Selections
intermediate
Total points: 41 XP clock-blue 1 hours

Power BI Slicer Selections

Compare data from different timeframes within the same visualization. Get amazing Power BI insights using this great technique with time-related DAX.

Tools
Power BI
Other Tools
Skills
Data Strategy
Data Analysis
Sam McKay
Sam McKay
See details
Cover: Staff Analysis
beginner
Total points: 97 XP clock-blue 1 hours

Staff Analysis

By utilising DAX in Power BI, we can in fact dynamically uncover these insights and easily visualize information of this sort.

Tools
Power BI
Skills
Data Analysis
Data Strategy
Sam McKay
Sam McKay
See details
Cover: Virtual Tables
advanced
Total points: 121 XP clock-blue 1 hours

Virtual Tables

Virtual tables are a unique analytical technique that you can use to visualize interesting insights inside Power BI.

Tools
Power BI
Other Tools
Skills
Advanced Analytics
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Working with Averages
advanced
Total points: 149 XP clock-blue 1 hours

Working with Averages

Learn and understand the logic of some tools and iterating functions inside your visualizations.

Tools
Power BI
Other Tools
Skills
Data Analysis
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Ranking Tables in Power BI
beginner
Total points: 63 XP clock-blue 1 hours

Ranking Tables in Power BI

We’ll look at a unique technique inside Power BI that allows us to create dynamic ranking tables using the RANKX function.

Tools
Power BI
Skills
Data Analysis
Business Analytics
EDNA Experts
EDNA Experts
See details
Cover: Reporting Best Practices
beginner
Total points: 127 XP clock-blue 1 hours

Reporting Best Practices

I’d like to present some Power BI report examples and best practices. In my own Power BI learning over the years, I’ve consumed many online resources which have been instrumental.

Tools
Power BI
Skills
Data Analysis
Data Visualization
Report Design
Greg Philps
Greg Philps
See details
Cover: Last Year Comparison
beginner
Total points: 34 XP clock-blue 1 hours

Last Year Comparison

Learn how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.

Tools
Power BI
Skills
Data Transformation
Sam McKay
Sam McKay
See details
Cover: Transformations - Date/Time
beginner
Total points: 90 XP clock-blue 1 hours

Transformations - Date/Time

Analyzing the data that we have can be difficult if it is not correctly arranged.

Tools
Power BI
Skills
Data Analysis
Business Analytics
EDNA Experts
EDNA Experts
See details
Cover: Scenario Analysis
intermediate
Total points: 67 XP clock-blue 1 hours

Scenario Analysis

Learn how to predict and optimize for results in the future, by utilizing 'what if' parameters and scenario analysis techniques and inside your Power BI models.

Tools
Power BI
Skills
Data Analysis
EDNA Experts
EDNA Experts
See details
Cover: Sales Analysis
beginner
Total points: 53 XP clock-blue 1 hours

Sales Analysis

Evaluate if most of your sales are attributed to people who are brand new to your company, or if you are adding consistent value to customers and they’re coming back for more and more, meaning greater sales.

Tools
EDNA Experts
EDNA Experts
See details
Cover: MTD, QTD, YTD Calculations
beginner
Total points: 49 XP clock-blue 1 hours

MTD, QTD, YTD Calculations

This is a unique scenario inside Power BI that you most likely need to solve in some way, shape, or form

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Pareto Analysis
beginner
Total points: 58 XP clock-blue 1 hours

Pareto Analysis

Using this rule and turning it into a chart and visualization is important as it helps you focus on the more important aspects of your business.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Report Background/Template
beginner
Total points: 74 XP clock-blue 1 hours

Report Background/Template

We will go through a simple but very important visualization concept for Power BI, which is to use dark backgrounds for reports and dashboards.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Revenue Growth Analysis
beginner
Total points: 60 XP clock-blue 1 hours

Revenue Growth Analysis

We will analyze a specific insight using Power BI analytics and then demonstrate it in a compelling way.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Running Totals
beginner
Total points: 104 XP clock-blue 1 hours

Running Totals

This great technique where you can cumulatively compare information over different months that will showcase diverging trends in your data.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Sensitivity Analysis
beginner
Total points: 60 XP clock-blue 1 hours

Sensitivity Analysis

Rather than just looking back and reporting on historical information, what we can do with scenario analysis is almost predict the future.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Supply Chain Analysis
beginner
Total points: 35 XP clock-blue 1 hours

Supply Chain Analysis

Supply chain management happens within a certain business operation that involves the flow of goods and services.

Tools
Power BI
Skills
Data Modeling
Sam McKay
Sam McKay
See details
Cover: Time Intelligence
beginner
Total points: 62 XP clock-blue 1 hours

Time Intelligence

Calculate difference in days between purchases using DAX in Power BI.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Totals & Sub Totals
beginner
Total points: 104 XP clock-blue 1 hours

Totals & Sub Totals

This demonstrate how you can implement advanced logic in Power BI and achieve the desired total that you’re after.

Tools
Sam McKay
Sam McKay
See details
Cover: DAX Patterns
beginner
Total points: 46 XP clock-blue 1 hours

DAX Patterns

Learn how you can speed up your Power BI development and think about ways on how we at the Enterprise DNA community can empower ourselves and also the Power BI community, in general, to develop much quicker inside of Power BI.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: DAX Pro Tips
beginner
Total points: 59 XP clock-blue 1 hours

DAX Pro Tips

Learn the general strategies to improve your DAX or M capabilities. This is an opportunity to learn and understand each Power BI DAX function.

Tools
Power BI
EDNA Experts
EDNA Experts
See details
Cover: Forecasting Techniques
beginner
Total points: 33 XP clock-blue 1 hours

Forecasting Techniques

Learn how to project a historical trend in Power BI and repeatedly project it forward.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Gantt Chart
beginner
Total points: 40 XP clock-blue 1 hours

Gantt Chart

This is a very unique way in Power BI to create a visualization that represents time-related information. We work through how to create the right data model.

Tools
Sam McKay
Sam McKay
See details
Cover: Grouping based on Condition
beginner
Total points: 16 XP clock-blue 1 hours

Grouping based on Condition

Learn how to use dynamic grouping in Power BI for your accounts receivables so that you can understand when the cash is coming into the business.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: IF & Nested IFs Statements
beginner
Total points: 44 XP clock-blue 1 hours

IF & Nested IFs Statements

If you come from an Excel background, just like most of the Power BI users including myself, you are probably used to writing complex IF statements.

Tools
Power BI
Excel
Other Tools
Sam McKay
Sam McKay
See details
Cover: Treatment of Outliers/abnormalities in Power BI
beginner
Total points: 108 XP clock-blue 1 hours

Treatment of Outliers/abnormalities in Power BI

This will take you through an outlier detection analysis, detecting and visualizing outlier results.

Tools
Sam McKay
Sam McKay
See details
Cover: Dynamic Visuals
beginner
Total points: 200 XP clock-blue 1 hours

Dynamic Visuals

In this tutorial, we have looked at an advanced Power BI technique. It allows you to work and present your results in a dynamic way. Not only are you able to work with dynamic results, you can change the measure or the metric you want to show a comparison to.

Tools
Power BI
Skills
Data Visualization
Sam McKay
Sam McKay
See details
Cover: Working with Currencies
beginner
Total points: 154 XP clock-blue 1 hours

Working with Currencies

See how to easily convert aggregated values (i.e. Total Sales) from one currency to a multitude of currencies with a few measures.

Tools
Sam McKay
Sam McKay
See details
Cover: LASTNONBLANK Function
beginner
Total points: 31 XP clock-blue 1 hours

LASTNONBLANK Function

The LASTNONBLANK function is an interesting DAX formula that you can utilize in a number of different ways inside of Power BI. It is not a very used DAX formula because of the complexities around how it calculates results.

Tools
Sam McKay
Sam McKay
See details
Cover: MAXX Functions
beginner
Total points: 36 XP clock-blue 1 hours

MAXX Functions

Learn why you don’t need to create calculated columns. You can do this all within a measure very easily.

Tools
Power BI
Sam McKay
Sam McKay
See details
Cover: Modeling Techniques in Power BI
beginner
Total points: 33 XP clock-blue 1 hours

Modeling Techniques in Power BI

Learn how to work on a data set that has relationships and multiple dates in Power BI.

Tools
Sam McKay
Sam McKay
See details
Cover: Month on Month Change
beginner
Total points: 36 XP clock-blue 1 hours

Month on Month Change

Learn how you can run time intelligence calculations over custom calendars in Power BI.

Tools
Power BI
Other Tools
Sam McKay
Sam McKay
See details
Cover: Virtual Relationships using TREATAS
beginner
Total points: 75 XP clock-blue 1 hours

Virtual Relationships using TREATAS

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Sam McKay
Sam McKay
See details
Cover: Visual Interactions
beginner
Total points: 37 XP clock-blue 1 hours

Visual Interactions

Using Power BI visual interactions allows you to showcase data in a way that’s both compelling and easy to digest.

Tools
Power BI
Skills
Data Analysis
Business Analytics
Sam McKay
Sam McKay
See details
Cover: Budgeting in Power BI
intermediate
Total points: 40 XP clock-blue 1 hours

Budgeting in Power BI

Analyze seasonal budget trends in Power BI by utilizing variables to manipulate data and represent the relationships between data tables.

Tools
Power BI
Skills
Data Analysis
Sam McKay
Sam McKay
See details