London Business Analytics Group
London Business Analytics Group
  • 84
  • 841 989
Visual Calculations In Power BI
Visual Calculations offer an easy way to write business-type calculations such as a running total or change on previous value. Visual Calculations are DAX made easy.
Our speaker, Jay ter Heerdt is a Product Manager with Microsoft and leads the team who have built Visual Calculations so there is no-one better equipped to demo these and explain all about them.
This is a recording of a meetup from the London Business Analytics Group on the 8th April 2024.
zhlédnutí: 1 819

Video

Python for Data Analysis
zhlédnutí 827Před 5 měsíci
Sue Bayes shows us how to analyse data with Python starting with the basics and focussing on actionable knowledge. If you are interested in understanding what Python is and how to use it, this talk is for you. This is a recording on a LBAG event on 5th Feb 2024. Topics: Introduction to Python and data analysis Python basics: syntax, variables, data types, control structures, functions and libra...
Microsoft Fabric for Power BI Users Tutorial 02 - Load data into a lakehouse using Python and Spark
zhlédnutí 4KPřed rokem
In this short hands-on tutorial, we use Python and Spark to load an external CSV file with 28 million rows as a table in a lakehouse. We then quickly look at the table with a SQL SELECT query and build a Power BI report. We use simple straight-forward Python code in this tutorial and explain every line. Python is my favourite method for analysing data in Fabric. If you are new to Python, I hope...
Microsoft Fabric For Power BI Users Tutorial 01 - Getting Started
zhlédnutí 11KPřed rokem
This is a hands-on tutorial to help Power BI people get started with Fabric in under 10 minutes. We first create a workspace and lakehouse. We then create a dataflow to clean and shape sample data sourced from a CSV file then load into a table in a Fabric lakehouse. We then run some SQL queries on the table, create a measure in the data model and visualise the data with Power BI. Timestamps 00:...
Data Wrangler - Prepare data with Python and pandas in Power Query Style
zhlédnutí 2,8KPřed rokem
Data Wrangler provides a nice user interface to clean and prepare data in a pandas dataframe. In this tutorial video, I start with data in a pandas dataframe. I use Data Wrangler to view and profile the data, then to clean the data: rename some columns, drop other columns, find and replace values in a column, change the datatype of a column, and add a column by example. Data Wrangler then gener...
Build an SPC Chart in Power BI
zhlédnutí 11KPřed rokem
An SPC (Statistical Process Control) chart is a popular chart, especially in healthcare and in manufacturing processes, but is not an out-of-the-box standard visualisation in Power BI. In this video we build a SPC chart. We start with a line chart, add a couple of slicers, write a few measures, and use these to add reference lines. If you want to follow along and build your own chart, the raw d...
Modern Excel
zhlédnutí 1,2KPřed rokem
Excel has improved a lot over the last few years. This session will demo practical features and functions of modern Excel. We'll start with XLOOKUP(), a better and more flexible alternative to VLOOKUP. Spill functions can spill their results not only to the cell containing the formula but to neighbouring cells also. This sounds boring but in fact makes them very useful. We will look at a few po...
Data Analysis With Excel
zhlédnutí 1,3KPřed rokem
For many people who work with data, Excel is all they’ve got. But Excel has many great capabilities for cleaning and analysis of data. This session is a whirlwind tour of Excel’s data-related features including: * Import and shape data with Power Query * Combine tables with the new VSTACK() and HSTACK() functions * The many advantages of Excel tables: * Summarise data with the SUMIFS() function...
An introduction to Power BI’s new DAX OFFSET function (Sports League Table example)
zhlédnutí 1,7KPřed rokem
The new OFFSET function in DAX is very useful. This short video introduces OFFSET using an example based on data from a sports league table to calculate how many points lead a team has over the team below it in the table. This is the first in a series about OFFSET and the other DAX Window functions, WINDOW and INDEX. Other videos will follow in the next few weeks that show more use cases and ex...
Modern Excel Course
zhlédnutí 292Před rokem
Our Modern Excel course is for people who would like to refresh and improve their Excel skills and learn about the capabilities and functions in more modern versions of Excel. This is a short overview of what we cover in that course. The course outline and more details are at www.zomalex.co.uk/modern-excel/ . We can provide the course either virtually or in-person at your office. If you are int...
Scenario Analysis of a Financial Model in Excel
zhlédnutí 5KPřed rokem
Scenario Analysis answers what-if questions - as well as the expected case, what is the possible upside and how bad could things get? In this tutorial, we start with a simple financial model, the income statement of a fictitious company. The net profit depends on three variable factors: the inflation, interest and tax rates. We look how the net profit varies over the best and worst cases as wel...
Add pre-set filter buttons to a Power BI dashboard - a DAX approach
zhlédnutí 33KPřed rokem
This video shows how to use DAX tables and measures and a slicer to create useful "pre-set" buttons so that users can easily apply a favourite set of filters. This technique has widespread application - each button can apply any filter conditions. It is an alternative option to the usual approach of using bookmarks - and one I prefer because it is elegant, flexible and versatile. If you would l...
Explicit Measures , Measure Tables and Field Parameters in Power BI
zhlédnutí 1,4KPřed 2 lety
A brief tutorial that explains explicit measures, how and why to create them, how to create a measures table for them and how to use field parameters. We improve the chart we built in the last video in three ways. The chart currently shows only the close price. We add a field parameter so that report viewers can choose which of these price types, open, high, low as well as close, to plot on the...
Writing Effective DAX Course
zhlédnutí 887Před 2 lety
Our DAX course is the third course in our Power BI learning path after the Foundation and Data Modelling courses. This is a short overview of what we cover in that course. The course outline and more details are at www.zomalex.co.uk/power-bi-dax/ We can provide the course over 2 or 3 days, either virtually or in-person at your office. If you are interested, please contact us at info@zomalex.co.uk.
Data Modelling In Power BI Course
zhlédnutí 436Před 2 lety
A short overview of our 2-day Data Modelling in Power BI course. This is the second course in our Power BI learning path after the Foundation course. Data modelling is fundamental to Power BI - a good data model helps us build great visualisations with ease and means that our calculations are consistently correct. This is a hands-on practical course. We build a Power BI data model step by step,...
Build a Finance Chart in Power BI
zhlédnutí 2,4KPřed 2 lety
Build a Finance Chart in Power BI
Power BI Foundation Course (for beginners to Power BI)
zhlédnutí 1,1KPřed 2 lety
Power BI Foundation Course (for beginners to Power BI)
Build a financial portfolio in Excel using linked data types and spill functions
zhlédnutí 725Před 2 lety
Build a financial portfolio in Excel using linked data types and spill functions
London Business Analytics Group - Welcome
zhlédnutí 376Před 2 lety
London Business Analytics Group - Welcome
Analyse and Visualise Balance Sheet Data In Power BI
zhlédnutí 6KPřed 2 lety
Analyse and Visualise Balance Sheet Data In Power BI
Visualise a company’s balance sheet
zhlédnutí 2,2KPřed 2 lety
Visualise a company’s balance sheet
LBAG at the Movies
zhlédnutí 133Před 2 lety
LBAG at the Movies
Coronavirus vs COVID vs Brexit vs Porn: Google Trends with Python & Power BI - Ned Stratton
zhlédnutí 949Před 2 lety
Coronavirus vs COVID vs Brexit vs Porn: Google Trends with Python & Power BI - Ned Stratton
Monte Carlo Simulations - Prof. Mark Whitehorn
zhlédnutí 1KPřed 2 lety
Monte Carlo Simulations - Prof. Mark Whitehorn
Power BI: Applying Row and Object Level Security to an Organisational Hierarchy
zhlédnutí 1,8KPřed 2 lety
Power BI: Applying Row and Object Level Security to an Organisational Hierarchy
SDN Advanced Excel Course - Welcome and Excel Version Checks
zhlédnutí 253Před 2 lety
SDN Advanced Excel Course - Welcome and Excel Version Checks
Elland Row'd (R + Python + maps + APIs + football)
zhlédnutí 558Před 2 lety
Elland Row'd (R Python maps APIs football)
Data Analysis Using Power BI for Beginners - Pragati Jain
zhlédnutí 3,3KPřed 3 lety
Data Analysis Using Power BI for Beginners - Pragati Jain
Scenario (What If) Analysis with Power BI
zhlédnutí 12KPřed 3 lety
Scenario (What If) Analysis with Power BI
Power BI: The Cash Flow Statement
zhlédnutí 29KPřed 3 lety
Power BI: The Cash Flow Statement

Komentáře

  • @mohannadhamwi4518
    @mohannadhamwi4518 Před 2 dny

    Thanks for the great efforts, it’s really helpful, yet, I would like to ask what about having more than one company and need to apply filters, I’ve done that but every time I apply the filters, total assets, liabilities, and total equity + liability are always gone as if the filter is being applied to the totals display as well. Thanks for your answer in advance if you can help out

  • @azizquazi
    @azizquazi Před 5 dny

    Hi, was there any follow-up video of the sensitivity analysis? Looks like, I cannot find this video. Thanks.

  • @James-wl6bt
    @James-wl6bt Před 14 dny

    This works but makes my Power Bi really lag. Any ideas on how I can solve?

  • @bendavidson1269
    @bendavidson1269 Před 24 dny

    Hey, great vid! any advice as to how to handle the addition of new accounts? I feel like it would be very difficult considering the layout and order stuff

    • @Haleysilver-q5w
      @Haleysilver-q5w Před 19 dny

      agreed! I sort of found a work around so far but its only been a day since i replicated this so i maybe havent encountered all potential issues haha. I used formulas in my table like this for my sorting for my Primary Key column =IF(ROW()=2, 101, IF([@Account] = OFFSET([@Account], -1, 0), OFFSET([@[Primary Key]], -1, 0), OFFSET([@[Primary Key]], -1, 0) + 1)) I made a primary key column that literally goes from 1 and down until the end, i have my excel tab sorted by the FS order column which i made using this formula so that the income statement is the top always =IF([@[Financial Statement Type]]="Income Statement", 101, IF([@[Financial Statement Type]]="Balance Sheet", 201, IF([@[Financial Statement Type]]="Cash Flow Statement", 301, IF([@[Financial Statement Type]]="Cash Movement", 401, 0)))) then for my levels i did =IF(ROW()=2, 101, IF([@[Level 0]] = OFFSET([@[Level 0]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0) + 1)) and so on. These formulas are essentially saying if this rows level 0 is the same/equal to the level 0 cell above it then keep the sort # the same if not add 1. KEY thing though is DO NOT RESORT your data it will mess up your orders to help with that i added a copy and pasted version of the primary key column so if it ever got resorted by accident you have a starting point to resort it and then fix any that got out of order thankfully accounts arent added all that often. SO that being said when you add a new account you can just add a row in where you want it to be sorted so if its cash put it in the middle of your cash accounts or the bottom and those formulas will do their thing to edit the orders below once you add the rest for each level column. Sorry if thats too confusing and probably still not the best solution to make it smoother.

  • @user-vo3mt9wd2m
    @user-vo3mt9wd2m Před 27 dny

    This is very useful. Thank you. Instead of using current month, current quarter, current year, how would you go about choosing a specific period with a starting month and ending month or starting date and ending date?

  • @ramnathrajagopalan0510

    Perfect thank you

  • @peterrender4716
    @peterrender4716 Před měsícem

    Thanks Chris, this is excellent and solves several challenges for me carrying out this type of analysis. The one thing that I am struggling with is the sorting of the columns using the level orders. In particular, Level 1 does not work with my database which appears to be because the Level 1 column includes several blanks (same content) which have several different numbers in the Level 1 order column. I cannot find a way to resolve this issue. Can you help me to resolve this? Thanks

    • @Haleysilver-q5w
      @Haleysilver-q5w Před 21 dnem

      I am having the same issue

    • @Haleysilver-q5w
      @Haleysilver-q5w Před 21 dnem

      I got something to work. I filtered down to literally just one row of data then since it still said i couldnt sort my level 1s to each other i did more googling and i added this SortLevel1 = 'youtablename here'[Level 1 Order] as an added column into the mapping table. Still only one row of data. I then told it to sort my level 1 by this SortLevel1 and it worked i then went and unfiltered everything in powerquery. I did this for each level 1,2,3,4 for my work file. For some reason level 2 it wouldnt let me still so i will try again maybe later but the rest worked. Hope this helps you!!!

  • @infinger2006
    @infinger2006 Před měsícem

    Probably pedantic for many, but I loved the day of week sorting / key use.

  • @tracey-leefebruary4567
    @tracey-leefebruary4567 Před měsícem

    Hi there, Could you please explain the sorting for your level 3 order. I don't understand why level 1 and level 2 is sorted in sequence but level 3 skips a few numbers. I have been staring at the sheet for a while now and can't figure it out. Great video BTW!

  • @DeepakVasudevan-kg5ld
    @DeepakVasudevan-kg5ld Před měsícem

    thanks thalaiva😎

  • @JayWay-tb8sw
    @JayWay-tb8sw Před měsícem

    Can anyone elaborate on how to get PY Amount to calculate correctly?

  • @vipul4raf
    @vipul4raf Před měsícem

    How did you created Stop_word table you have not mentioned. I think you have skiped some timline.

  • @user-kf3nq6yx6e
    @user-kf3nq6yx6e Před 2 měsíci

    This is an excellent introduction thank you so much! Invaluable!!

  • @alexkoren7395
    @alexkoren7395 Před 2 měsíci

    Are you using the + and - in your grid in any kind of way? I am trying to get the values be negative and positive on certain levels of the hierarchy

  • @skymen4672
    @skymen4672 Před 2 měsíci

    Great Video! Would love to see how you mark the special variantions and especially how you model other rules for special variances like "9 items in a row ascending/descending".

  • @federicourrea1910
    @federicourrea1910 Před 2 měsíci

    Amazing Video!!! I am trying to combine the learnings from the video to a table I have in my company, quick question, how would you go about getting the initial share capital (assuming it has not changed in years) so when you take a desired year to filter it gets included?

  • @Sisi-vp7xs
    @Sisi-vp7xs Před 2 měsíci

    Thank you for the video. It’s really helpful and simple to understand ❤

  • @fer5466
    @fer5466 Před 2 měsíci

    Hello, i did this model for Qatar 2022 at my office and everyone were really excited for it, now as American Cup is coming I was requested to do another one but with American Cup design. So thank you very much for this video, it helped me a lot wit Power BI.

  • @va6771
    @va6771 Před 2 měsíci

    How did you color the result tab?

  • @funmilayoadabanija2413
    @funmilayoadabanija2413 Před 2 měsíci

    Thanks for the insightful tutorial, i learnt alot from it. I can't seem to find the next tutorial which is going to focus more on sensitivity analysis, monte carlo analysis, and Power BI visualization. If this has been posted, i would appreciate it if you respond with the link.

  • @shumalumuki
    @shumalumuki Před 2 měsíci

    Thank you for the great video explanation. This version is easier to learn. Following your steps I made one successful sample in Power BI. Just one question, why here we do not consider subgrouping the raw data? Xbar-R

  • @zm9475
    @zm9475 Před 2 měsíci

    So eloquently and patiently explained and thank you for sharing the files

  • @manuelbelenguer3336
    @manuelbelenguer3336 Před 2 měsíci

    Thank you very much! You're a master!

  • @nurqamarinamohdnoor2492
    @nurqamarinamohdnoor2492 Před 3 měsíci

    How the score sentiments is set?

  • @sureshsonti8097
    @sureshsonti8097 Před 3 měsíci

    Can someone please share the dataset file

  • @karthiktiruvanallur7377
    @karthiktiruvanallur7377 Před 3 měsíci

    Thank you this was very helpful 👌

  • @miransh
    @miransh Před 3 měsíci

    FYI -Volume is very low for Canada- cannot hear - would you please fix - thanks

  • @Broadb1ll
    @Broadb1ll Před 3 měsíci

    Hi - Great video - thanks! Am I right in saying the the Azure map visual will replace the shape map visual. If so, is there a way in Azure to create a polygon map based on MSOA's. Using a JSON file?

  • @Riftzed
    @Riftzed Před 3 měsíci

    Is this another Power BI version ? Because i havent these options specially when you create the lines

  • @brianbaheramouzegarletsbui6533

    Great work. You made it look so easy to repeat the steps. Thank you.

  • @katiereyes597
    @katiereyes597 Před 3 měsíci

    This was so helpful. Thank you.

  • @trevski65
    @trevski65 Před 3 měsíci

    Hi Mark, I have applied to attend the NHS course, has the path to the file you demo above changed? Thank you.

  • @chriscox3877
    @chriscox3877 Před 3 měsíci

    Great video, but I think there is something missing as the table is incorrect. Wolves and Sheffield Utd should be reversed as Wolves have a better GD than Sheffield Utd. The same goes for West Ham, Watford and Bournemouth. So how do you organise a rank based on Pts being the same to then filter by GD and if GD is the same then by GF?

  • @Jannerparejagutierrez
    @Jannerparejagutierrez Před 3 měsíci

    This is very good video my friend, thank you very much!

  • @oscarestorach6162
    @oscarestorach6162 Před 3 měsíci

    You are great, thanks a lot to share your knowledge

  • @Hansonartuk50
    @Hansonartuk50 Před 3 měsíci

    There's some really useful information here. Many thanks for taking the time to put it together, excellent tutorial.

  • @sadyaz64
    @sadyaz64 Před 3 měsíci

    thank you

  • @lambanlaa
    @lambanlaa Před 4 měsíci

    Your presentation of this topic is the most clear I have watched. Thank you.

  • @rahulmaurya2607
    @rahulmaurya2607 Před 4 měsíci

    Hi, I went through the video multiple times but couldn't find how the income statement rollup Excel sheet was getting used in DAX. Have a similar requirement where on the report we need to show positive amounts but rollup should be based on the sign of the parent. Any references are welcome or if someone could point me to the part in the video I might have missed. Thanks

    • @dpv343
      @dpv343 Před 4 měsíci

      I cannot find that in the video either and also want to show value without the negative sign but still want it subtracted.

    • @rahulmaurya2607
      @rahulmaurya2607 Před 4 měsíci

      ​@@dpv343 Maybe I missed something but will look at the video againPBIX file along with other video for chasflow he has shared I just liked the entirety of the solution here why I wanted to take this approach. @LondonBusinessAnalyticsGroup any reference would be helpful if you read this comment.

  • @namubiruevelyn2393
    @namubiruevelyn2393 Před 4 měsíci

    U jst won a subscriber

  • @namubiruevelyn2393
    @namubiruevelyn2393 Před 4 měsíci

    Excellent you saved me 😊It worked perfectly well... Watching from Uganda

  • @petercompton538
    @petercompton538 Před 4 měsíci

    Hi Chris, another great video, thanks very much. Just one question - in the date table, you have trues and falses in the current month, current quarter and current year columns - am I right to assume this is formula driven?

  • @petercompton538
    @petercompton538 Před 4 měsíci

    Thanks Chris, that is outstanding. So much easier to understand than anything I have seen elsewhere. I look forward to implementing it

  • @BigBrownTruck22
    @BigBrownTruck22 Před 4 měsíci

    My categories for some reason always includes a (Blank) option, even though there are no blanks in my dataset and I included no additional rows (or blanks) in the slicer table. How can I get rid of this (Blank) option? Thanks!

  • @akankshapriya6531
    @akankshapriya6531 Před 4 měsíci

    great content was searching from long

  • @parajf
    @parajf Před 4 měsíci

    Great explanation

  • @apamwamba
    @apamwamba Před 4 měsíci

    List of countries is limited. So one has to use json. Great video

  • @user-np8km1ib4b
    @user-np8km1ib4b Před 4 měsíci

    I can't find the follow-up video promised at the end. Is it uploaded on the channel?

  • @Ahmad_Askar
    @Ahmad_Askar Před 4 měsíci

    this is amazing, truly awesome

  • @aumschultz1750
    @aumschultz1750 Před 5 měsíci

    THIS IS AWESOME!!!!!!