Enterprise DNA
Labs
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.


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


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


CALCULATETABLE Function
Learn about CALCULATETABLE well is the beginning of many advanced calculations that you can do in Power BI.
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.
ALL & ALLSELECTED Functions
The ALL function is an extremely important part of the DAX language in Power BI


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




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



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.
Anomaly Detection
Anomaly detection in Power BI enables report creators to enhance line charts by automatically detecting anomalies in a time series data.



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


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


Application Like Reports
Advanced visualization tips and tricks for Power BI to make compelling analysis stand out
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.
Power BI Advanced Editor
Learn the best practice tips using Advanced Editor inside Power BI.




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


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




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


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.



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.



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



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.



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


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



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


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



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.


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.




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


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,



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.
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.


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.


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.


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.


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.
Financial Year Sorting
In this miniseries, you will learn how to sort your dates by financial year in Power BI.


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



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.

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


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


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.


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



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.



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.


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.


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.



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.




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



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.


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.


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.



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


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



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


INTERSECT & CROSS JOIN Functions
Utilize the two tables that you place within it and bring them together.<br>

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.




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



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




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




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.



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.




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.


Transformations - Date/Time
Analyzing the data that we have can be difficult if it is not correctly arranged.



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.


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.
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

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.

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.

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

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

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

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


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

Totals & Sub Totals
This demonstrate how you can implement advanced logic in Power BI and achieve the desired total that you’re after.
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.

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.

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

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.
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.

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.



Treatment of Outliers/abnormalities in Power BI
This will take you through an outlier detection analysis, detecting and visualizing outlier results.
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.


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.
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.
MAXX Functions
Learn why you don’t need to create calculated columns. You can do this all within a measure very easily.

Modeling Techniques in Power BI
Learn how to work on a data set that has relationships and multiple dates in Power BI.
Month on Month Change
Learn how you can run time intelligence calculations over custom calendars in Power BI.


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.



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



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

