RADACAD
RADACAD
  • 543
  • 6 907 756
Building Data Analytics Team
Recently, I did a presentation at a conference, and the topic was non-technical, unlike many other presentations that I do. I thought it would be helpful for you all to know about it, as I spent some time and gathered some information about it combined with the experiences I had with some of my customers. This article and video are split into two: this one will be about things needed to make a successful data analytics team, and the other one will be about the roles needed within the team.
read my article about it here: radacad.com/building-a-data-analytics-team-in-this-golden-era-of-technology
zhlédnutí: 514

Video

Microsoft Fabric Glossary
zhlédnutí 1,1KPřed dnem
There are a lot of similar terminologies and words when working with Fabric. We have Data Lake, Delta Lake, OneLake, and Lakehouse, and the list continues. I found it confusing for some to understand the differences between them. Although explaining these terms and their differences requires many different blog articles, having one place for a quick definition for each can be helpful. Hence, th...
SCD Type 2 in Microsoft Fabric and Power BI
zhlédnutí 1,5KPřed 14 dny
In the previous video, I explained SCD (Slowly Changing Dimension) and its different types. In this video, I'll show you how to implement SCD Type 2 (one of the most common types) using Microsoft Fabric and Power BI. This article includes using Lakehouse, Dataflow, Warehouse, Data Pipeline, SQL Stored Procedures, Power BI Semantic model, and report in Microsoft Fabric. Get all the codes from my...
SCD Slowly Changing Dimension An Ultimate Guide
zhlédnutí 2,2KPřed 14 dny
If you want to use Power BI, Microsoft Fabric, or any other data analytics tools, one of the key concepts to understand when working with a data warehouse system is the SCD (Slowly Changing Dimension). I will do this in a series of at least two articles. The first one (this one) will be on the concept of what SCD is, its meaning, and its different types. Then, the next one will discuss how to i...
Copilot in Microsoft Fabric Warehouse Magic SQL
zhlédnutí 1,3KPřed měsícem
Microsoft Copilot is utilized in different technologies in Microsoft; in Microsoft Fabric, one of the places that you can use Copilot is in the Data Warehousing workload, which will guide you through your SQL commands and enhance your SQL coding experience. I’ll show you how the Copilot in the Data Warehouse works in this article and video. See the codes and get more information from my blog ar...
What is Spark in Microsoft Fabric
zhlédnutí 1,3KPřed měsícem
Microsoft Fabric runs some workloads under the Spark engine, but what is it really? In this article, I'll take you through the question of what Spark is, What benefits it has, how it is associated with Fabric, what configurations you have, and other things you need to know about it. Read my blog article about it here: radacad.com/what-is-spark-in-microsoft-fabric
Power BI DAX Query View Updates June 2024 and Copilot Demo by Zoe Douglas
zhlédnutí 2,2KPřed měsícem
Zoe Douglas from Power BI Team showing us some of the exciting updates of Power BI DAX Query View in June 2024 plus some of the Copilot features
Power BI Default Semantic Model or Custom A guide for using in Fabric Environment
zhlédnutí 2KPřed měsícem
The Lakehouse or Warehouse comes with a default Power BI Sematic model, which can be used for reporting and analytics. However, you can also build and use a customized semantic model. There are significant differences when using the semantic model in real-world analytics projects. In this article, I'll explain the difference between these two, which one is recommended, and why. Learn more using...
Find All Errors in All Columns using Power Query in Power BI
zhlédnutí 3,9KPřed 2 měsíci
Errors often happen when loading data into any BI system. In this video, the 2nd video after my previous one in the series, I am explaining how to catch the error rows and columns, even in a situation where you don't know which column might cause the error. You will learn how to use Power Query inside Power BI to capture the error details and build an exception reporting in Power BI.
Time Travel in Fabric Warehouse Query Snapshots of the Data at Any Point in Time
zhlédnutí 993Před 2 měsíci
Time travel is now available in Fabric Warehouse, which was previously only possible in Lakehouse. This means that you can all be Dr. Strange and use your time stone to travel through time and look at a snapshot of the data at that point in time. It is an amazing feature, and it is so simple to use that you can't believe it. I'll explain what it is and how it can be used in this article. Read t...
Button Slicer Enhancing the Power BI Visualization
zhlédnutí 3,9KPřed 2 měsíci
The Button Slicer is one of the recent visuals that is very helpful in taking your report layout and visualization to the next level. Although this visual has been available for some time, many are still unfamiliar with its features. In this article and video, I'll take you through this visual, its features, and how you can use them to have a better Power BI report layout. Read more details in ...
Fabric Power BI Auckland Usergroup 20240501 Daniel Marsh Patrick Deneb Viz in Power BI
zhlédnutí 987Před 3 měsíci
The recording of Auckland Power BI, Fabric and Analytics user group on the 1st of May 2024. Link to the event: www.meetup.com/new-zealand-business-intelligence-user-group/events/300002686/ Topic: Deneb: Declarative Visualization in Power BI Deneb is a certified custom visual for Power BI that lets you create your bespoke visuals right inside Desktop using either the Vega or Vega-Lite visualizat...
Delta Lake Table Structure Demystified in Microsoft Fabric
zhlédnutí 1,9KPřed 3 měsíci
The structure of storing data in OneLake for the Lakehouse tables is interesting. The commonly used structure is called the Delta Lake Table structure. In this article and video, you will learn what this structure is, how it works, and what the difference is with Parquet, and you will see some related demos. Get the codes from my blog article here: radacad.com/delta-lake-table-structure-demysti...
Mirroring Snowflake in Fabric Supercharged Analytics at No Extra Costs
zhlédnutí 2KPřed 3 měsíci
Microsoft Fabric offers an end-to-end SaaS analytics solution; however, the world is using all kinds of data sources in its implementation. Mirroring is a new functionality in Fabric that allows customers to keep their data wherever they are, but then they can use Fabric analytics solutions with the same speed and performance as if their data were in Fabric. Best of all, this won’t cost extra. ...
Reza Interview with the Microsoft Fabric Team Rick Xu
zhlédnutí 370Před 3 měsíci
Reza Rad interviewed Rick Xu from the Microsoft Fabric product team. This talk covers aspects of Microsoft Fabric administration related to security, certifications, and the roadmap.
Reza Interview with the Microsoft Fabric Team Meenal Srivastva
zhlédnutí 357Před 3 měsíci
Reza Interview with the Microsoft Fabric Team Meenal Srivastva
Reza Interview with the Microsoft Fabric Team Radhakrishnan Srinivasan
zhlédnutí 270Před 3 měsíci
Reza Interview with the Microsoft Fabric Team Radhakrishnan Srinivasan
Reza Interview with the Microsoft Fabric Team Faisal Mohamood
zhlédnutí 341Před 3 měsíci
Reza Interview with the Microsoft Fabric Team Faisal Mohamood
Fabric and Power BI Auckland User group recording - Fabric CAT Updates of Fabric Conference
zhlédnutí 1,2KPřed 3 měsíci
Fabric and Power BI Auckland User group recording - Fabric CAT Updates of Fabric Conference
Reza Interview with the Microsoft Fabric Team Nellie Gustafsson
zhlédnutí 414Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Nellie Gustafsson
Reza Interview with the Microsoft Fabric Team Josh Caplan
zhlédnutí 395Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Josh Caplan
Reza Interview with the Microsoft Fabric Team Jeroen Jay ter Heerdt
zhlédnutí 384Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Jeroen Jay ter Heerdt
Reza Interview with the Microsoft Fabric Team Bogdan Crivat
zhlédnutí 534Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Bogdan Crivat
Reza Interview with the Microsoft Fabric Team Miguel Llopis and Miguel Escobar
zhlédnutí 533Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Miguel Llopis and Miguel Escobar
Reza Interview with the Microsoft Fabric Team Justyna Lucznik
zhlédnutí 616Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Justyna Lucznik
Reza Interview with the Microsoft Fabric Team Arthi Iyer
zhlédnutí 777Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Arthi Iyer
Reza Interview with the Microsoft Fabric Team Wee Hyong Tok
zhlédnutí 557Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Wee Hyong Tok
Reza Interview with the Microsoft Fabric Team Christian Wade
zhlédnutí 1,3KPřed 4 měsíci
Reza Interview with the Microsoft Fabric Team Christian Wade
Reza Interview with the Microsoft Fabric Team Zoe Douglas
zhlédnutí 178Před 4 měsíci
Reza Interview with the Microsoft Fabric Team Zoe Douglas
Reza Rad Interview with the Microsoft Fabric Team Will Thompson
zhlédnutí 1KPřed 4 měsíci
Reza Rad Interview with the Microsoft Fabric Team Will Thompson

Komentáře

  • @mv1597
    @mv1597 Před 12 minutami

    Thanks for this tutorial! I can't see the link to the blog in the description, could you please put it it in there as I'd like to have a go using the code.

  • @sahilkothekar9927
    @sahilkothekar9927 Před 2 dny

    I have one question , why does dax queries in query view or in dax studio do not preserve measure format strings?

  • @rob876
    @rob876 Před 2 dny

    This is almost exactly what I wanted but it's easy enough to change the DAX to give me what I want. Thank You.

    • @RADACAD
      @RADACAD Před 19 hodinami

      Glad it helped

  • @MuratBarbarosYamak
    @MuratBarbarosYamak Před 2 dny

    This is great information. Thanks for sharing!!

    • @RADACAD
      @RADACAD Před 19 hodinami

      Glad it was helpful!

  • @NutanPatel
    @NutanPatel Před 3 dny

    we need to manually add the user under the members list of dataset. do we really require because we implemented dynamic RLS?

  • @donnacarter1602
    @donnacarter1602 Před 4 dny

    This helped me so much, thank you for sharing!

    • @RADACAD
      @RADACAD Před 19 hodinami

      You're so welcome!

  • @kdorfman228
    @kdorfman228 Před 4 dny

    Nice video! Did you ever publish the other video covering the scheduled process to refresh this on a regular cadence (e.g. weekly)?

  • @haikalmuhammadaldan

    Thank you

    • @RADACAD
      @RADACAD Před 19 hodinami

      You're welcome

  • @laurentiuionutvita
    @laurentiuionutvita Před 4 dny

    thanks

    • @RADACAD
      @RADACAD Před 19 hodinami

      You're welcome!

  • @mikepasin372
    @mikepasin372 Před 5 dny

    Hi Reza, thanks for this content. I'm wondering how dataflows can be used with models that employ row-level security. Is this possible? Cheers.

  • @777bashir
    @777bashir Před 5 dny

    I stumbled upon this video while trying to query a lakehouse table for time travel. However, when I ran the same code, I encountered an error: "A non-versionable data source was specified in the time travel query."

  • @chrisdealemania
    @chrisdealemania Před 5 dny

    2024. Menu is different. Same function elsewhere hidden. Applying the sort function, no change.

  • @sefikatiraki729
    @sefikatiraki729 Před 6 dny

    it is so basic but so helpful thank u so much

  • @tiago5a
    @tiago5a Před 7 dny

    Can I install it on an Azure VM IaaS?

  • @bertalanronai2182
    @bertalanronai2182 Před 7 dny

    Thanks a lot! We don't have Fabric yet so I can't use practice to get to know these but I have to have at least some kind of idea what these things are in order to speed-up the process of getting access to them.

  • @shantar3608
    @shantar3608 Před 9 dny

    So the dynamic report that is sent is not the Power BI report, but a PDF snapshot of the report filtered?

  • @valentindufresne4757

    nice video you really saved my life no joke

  • @jagans6409
    @jagans6409 Před 10 dny

    Dear All, It is said that while using Filters on 'Order date' with 'between' you need to use "is after or equal to" And "is before", to avoid duplicates, is it right or wrong? please suggest. Thanks in advance!! ❤

    • @RADACAD
      @RADACAD Před 10 dny

      Hi. yes. Better to remove equal from on end (either from or to), so that it won't double count it.

    • @jagans6409
      @jagans6409 Před 9 dny

      @@RADACAD thanks a lot!!

  • @andresmaldonado2629
    @andresmaldonado2629 Před 11 dny

    thanks, very clear and to the point..

  • @samestate11
    @samestate11 Před 11 dny

    Excellent video. Answered all of my questions

    • @RADACAD
      @RADACAD Před 11 dny

      Glad it was helpful!

  • @javicano
    @javicano Před 11 dny

    Is this currently possible? I'm trying but it always fails to open.

  • @soraiapirfobarroso219

    Very good, well explained and good pace and speaking tutorial! I shall follow your videos! Thank you very much !

    • @RADACAD
      @RADACAD Před 11 dny

      Glad it was helpful!

  • @gauravguliani358
    @gauravguliani358 Před 11 dny

    Loved this video, Reza!

  • @johandreengelbrecht8981

    how do I make it Oficio paper size?

  • @manishkolli883
    @manishkolli883 Před 12 dny

    ❤Thanks a lot 🫂

  • @humbertogalvez2458
    @humbertogalvez2458 Před 12 dny

    Is there a way to synchronize the drilldown option between multiple visualizations?

  • @hasanakhtar2120
    @hasanakhtar2120 Před 12 dny

    What if a dataset has multiple upstream dataflow?

  • @nazimscr
    @nazimscr Před 12 dny

    Many thanks great video 👍👍👍

    • @RADACAD
      @RADACAD Před 12 dny

      Glad you enjoyed it

  • @ruwanc2003
    @ruwanc2003 Před 12 dny

    Thnak you

  • @txreal2
    @txreal2 Před 12 dny

    I gave up keeping up with names & definitions and switched to Google. Thanks.

  • @skjonas
    @skjonas Před 12 dny

    This was great stuff. I was having difficulty keeping straight all of the similarly-worded concepts in the DP-600 course material. This helps me to review that material efficiently.

    • @RADACAD
      @RADACAD Před 12 dny

      Thanks. Glad it is helpful.

  • @SandroQuinta
    @SandroQuinta Před 13 dny

    Can I apply this your SCD2 method when working with incremental loading?

  • @wplante2988
    @wplante2988 Před 13 dny

    Your method works quite well, but I'm wondering if you might know why it's not allowing negative start and end values. The data properly slots into the appropriate bands for positive values, but it seems to ignore ranges below 0. So, for example a start of -2.0 and an end of -1.0 with increments of 0.1 for the generate series. I can't seem to figure out what might be happening. I have double checked data types to be set to decimal. Any thoughts on this would be helpful.

  • @bichannel3419
    @bichannel3419 Před 13 dny

    Hello, I have a question regarding paginated reports in Power BI. I have an embedded paginated report that calls another drill-through paginated report. When I click the back button from the drill-through report, the main paginated report resets all filter selections to their default values. Is there a way to retain the selected filter values in the main paginated report when navigating back from the drill-through report? Any help would be appreciated!

  • @joaorataoo
    @joaorataoo Před 15 dny

    Thank you, Reza. Very helpful. You mentioned that you were going to put some links to other videos, but I don't see them.

    • @RADACAD
      @RADACAD Před 12 dny

      All the links are from the blog article that is in the description

  • @BajkeTheSerb
    @BajkeTheSerb Před 15 dny

    Would be nice to see SCD2 low-code support by Fabric Data Factory and Data Flow Gen2. Just imagine this SCD2 supported with simple configurations...

  • @shreesonlinediary
    @shreesonlinediary Před 16 dny

    You are smart, thanks for sharing

    • @RADACAD
      @RADACAD Před 13 dny

      Thanks for watching!

  • @LIV-FREE-VET
    @LIV-FREE-VET Před 16 dny

    Thank you soo much Reza! You are a Power Bi wizard. Can't wait to learn more :)

    • @RADACAD
      @RADACAD Před 16 dny

      Thanks. Glad to help :)

  • @erinfield1943
    @erinfield1943 Před 17 dny

    3:38- static row level security 5:57- dynamic row level security

  • @totvabe1
    @totvabe1 Před 17 dny

    Thanks Reza.

  • @VictorHugo-bd3bf
    @VictorHugo-bd3bf Před 18 dny

    Thank you very much, Reza. This is very helpful.

    • @RADACAD
      @RADACAD Před 16 dny

      You're very welcome

  • @thuynga2706
    @thuynga2706 Před 18 dny

    I guess you missed one information or I missed that in your video: For Power BI Embedded, only P SKUs and F SKUs equivalent to a F64 SKU or higher, allow free Power BI users to consume Power BI apps and shared content in Power BI service. Smaller SKUs require a Pro license to consume Power BI content. For A SKU every viewer still needs Pro License

  • @dekta4
    @dekta4 Před 18 dny

    Hi Reza, how to implement this in fabric?

    • @RADACAD
      @RADACAD Před 18 dny

      that will be the next video. stay tuned

    • @dekta4
      @dekta4 Před 18 dny

      @RADACAD I'll see you in Perth

    • @RADACAD
      @RADACAD Před 18 dny

      @@dekta4 Looking forward to seeing you

  • @jiashengfan2269
    @jiashengfan2269 Před 19 dny

    Thanks Reza

  • @AussieAlka
    @AussieAlka Před 19 dny

    This is such a timely video, I am going through something similar with an Ethics Management System and I have SCD using SK in my PowerBI model. Great work!!

    • @RADACAD
      @RADACAD Před 18 dny

      Glad it helps :) Thanks

  • @wuzizname1330
    @wuzizname1330 Před 19 dny

    Killer tip! Problem with me is, if I change the slicers to show different business groups the RANKX keeps the rank number as if all items are selected. For example Johnny is the #10 overall salesperson, but #1 in Canada. When I apply a filter to show only Canadian salespeople Johnny is at the top but his rank still shows as 10. Any way to fix this?

    • @wuzizname1330
      @wuzizname1330 Před 18 dny

      Replacing ALL with ALLSELECTED works

    • @RADACAD
      @RADACAD Před 18 dny

      Yes, I have another video about ALL vs ALLSelected too. depending on the requirement you may use one or the other

  • @genevieve3676
    @genevieve3676 Před 22 dny

    When I copy and paste image address, I get an error message : "No css selector was found" - How can we avoid this ? thanks

  • @amalia940
    @amalia940 Před 23 dny

    thanks for simplifying this!

    • @RADACAD
      @RADACAD Před 19 dny

      Glad it was helpful!

  • @Shriraj27
    @Shriraj27 Před 23 dny

    This video gave me a detailed flow of how live data can be captured, stored, reported, published and refreshed in real time

    • @RADACAD
      @RADACAD Před 19 dny

      glad it was helpful

  • @andres777video
    @andres777video Před 24 dny

    Have you been able to find an equivalent command to download rdl files (paginated reports) ? Export-PowerBIReport doesn't seem to work.... Thanks