Enterprise DNA
Labs
1 hoursBookmarks & 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.
1 hoursAI Feature in Power BI
Learn why the AI feature is seriously one of the most incredible features within the Power BI suite.
1 hoursPower BI Bar Charts
Learn how we can customize the bar charts in Power BI reports using native visuals, custom visuals, and Charticulator.
1 hoursCALCULATETABLE Function
Learn about CALCULATETABLE well is the beginning of many advanced calculations that you can do in Power BI.
1 hoursAdministering 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.
1 hoursALL & ALLSELECTED Functions
The ALL function is an extremely important part of the DAX language in Power BI
1 hoursCalculate Function in Power BI
Learn how to use the DAX function CALCULATE in Power BI.
1 hoursCustom Financial Year
Learn how to get financial quarters aligned to the correct months using a calculated column.
1 hoursALL & 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.
1 hoursAnomaly Detection
Anomaly detection in Power BI enables report creators to enhance line charts by automatically detecting anomalies in a time series data.
1 hoursCurrencies Analysis
There are many instances with financial analysis wherein we need to integrate exchange rates in Power BI.
1 hours"What If" Analysis
Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis.
1 hoursApplication Like Reports
Advanced visualization tips and tricks for Power BI to make compelling analysis stand out
1 hoursColor 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.
1 hoursPower BI Advanced Editor
Learn the best practice tips using Advanced Editor inside Power BI.
1 hoursCalculation Groups
How to use Power BI calculation groups to create custom groupings with an insightful visualization.
1 hoursDAX Function - Cumulative Totals
Learn how to combine important DAX functions to find complex and valuable data insights that make a difference
1 hoursConditional Formatting
Advanced visualization tips and tricks for Power BI to make compelling analysis stand out
1 hoursCustom 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.
1 hoursDate 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.
1 hoursDays since last transaction
Learn in-depth the many time related calculation possibilities available to use within Power BI
1 hoursData Load and Transform Best Practices
Best practices while preparing Power BI reports on data loading and transformation which will be instrumental in your journey.
1 hoursDay Related Calculations
Get rid of anomalies that can possibly make things complicated during the data analysis.
1 hoursCustom Groups Analysis
Solve unique analytical problems faced within many business functions, industries and data scenarios.
1 hoursDelimited Data in Power Query
Turn your data into a format that’s more suitable for analysis from merged delimited data within multiple columns.
1 hoursAppend Queries in Power BI
How to import and open an Excel file with multiple sheets to one Power BI table.
1 hoursConcatenate Function
Learn different ways of how to combine values using advanced DAX functions. CONCATENATE function is used to join two text strings into one.
1 hoursData 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.
1 hoursFinancial Reporting Tips
In this learning lab, I'll explain the key techniques to structuring your data when completing any type of financial reporting.
1 hoursLast 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,
1 hoursData 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.
1 hoursPower 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.
1 hoursWeekday 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.
1 hoursDATEADD 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.
1 hoursVariables 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.
1 hoursDATESINPERIOD
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.
1 hoursFinancial Year Sorting
In this miniseries, you will learn how to sort your dates by financial year in Power BI.
1 hoursMargin Analysis
Dive into the concept of measure branching. It is layering measures one on top of the other until you get the desired result
1 hoursDAX 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.
1 hoursPARALLELPERIOD 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
1 hoursMoving 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
1 hoursLayered 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.
1 hoursPower BI Models
An insightful discussion on valuable tips and best practices for organizing Power BI models.
1 hoursReport 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.
1 hoursPractice Data set in Power Query
I’m going to show you how to keep your practice dataset updated every time you do a refresh.
1 hoursInventory 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.
1 hoursMeasure 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.
1 hoursMultiple 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.
1 hoursProducts Analysis
Run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI.
1 hoursMagic 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.
1 hoursPivot/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.
1 hoursProfit Analysis
These are some great DAX techniques that you could potentially use. These insights into Profit Margins are applicable across different scenarios and organizations.
1 hoursProfit Prediction
Cover with this tutorial are some great examples of profit prediction in the future using Power BI.
1 hoursRanking Techniques
In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI.
1 hoursScatter Charts in Power BI
Create some compelling visualizations in Power BI, especially around scatter charts.
1 hoursINTERSECT & CROSS JOIN Functions
Utilize the two tables that you place within it and bring them together.<br>
1 hoursPower 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.
1 hoursStaff Analysis
By utilising DAX in Power BI, we can in fact dynamically uncover these insights and easily visualize information of this sort.
1 hoursVirtual Tables
Virtual tables are a unique analytical technique that you can use to visualize interesting insights inside Power BI.
1 hoursWorking with Averages
Learn and understand the logic of some tools and iterating functions inside your visualizations.
1 hoursRanking 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.
1 hoursReporting 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.
1 hoursLast 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.
1 hoursTransformations - Date/Time
Analyzing the data that we have can be difficult if it is not correctly arranged.
1 hoursScenario 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.
1 hoursSales 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.
1 hoursMTD, QTD, YTD Calculations
This is a unique scenario inside Power BI that you most likely need to solve in some way, shape, or form
1 hoursPareto 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.
1 hoursReport 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.
1 hoursRevenue Growth Analysis
We will analyze a specific insight using Power BI analytics and then demonstrate it in a compelling way.
1 hoursRunning Totals
This great technique where you can cumulatively compare information over different months that will showcase diverging trends in your data.
1 hoursSensitivity Analysis
Rather than just looking back and reporting on historical information, what we can do with scenario analysis is almost predict the future.
1 hoursSupply Chain Analysis
Supply chain management happens within a certain business operation that involves the flow of goods and services.
1 hoursTime Intelligence
Calculate difference in days between purchases using DAX in Power BI.
1 hoursTotals & Sub Totals
This demonstrate how you can implement advanced logic in Power BI and achieve the desired total that you’re after.
1 hoursDAX 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.
1 hoursDAX 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.
1 hoursForecasting Techniques
Learn how to project a historical trend in Power BI and repeatedly project it forward.
1 hoursGantt 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.
1 hoursGrouping 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.
1 hoursIF & 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.
1 hoursTreatment of Outliers/abnormalities in Power BI
This will take you through an outlier detection analysis, detecting and visualizing outlier results.
1 hoursDynamic 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.
1 hoursWorking 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.
1 hoursLASTNONBLANK 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.
1 hoursMAXX Functions
Learn why you don’t need to create calculated columns. You can do this all within a measure very easily.
1 hoursModeling Techniques in Power BI
Learn how to work on a data set that has relationships and multiple dates in Power BI.
1 hoursMonth on Month Change
Learn how you can run time intelligence calculations over custom calendars in Power BI.
1 hoursVirtual 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.
1 hoursVisual Interactions
Using Power BI visual interactions allows you to showcase data in a way that’s both compelling and easy to digest.
1 hoursBudgeting in Power BI
Analyze seasonal budget trends in Power BI by utilizing variables to manipulate data and represent the relationships between data tables.