Centida BI & Analytics
Centida BI & Analytics
  • Видео 31
  • Просмотров 53 065
Power BI: Visual Calculations Format (Preview)
🚀 In this video, we dive into the latest August 2024 Update for Power BI, which, among other things, introduces a new feature: formatting for visual calculations. This enhancement transforms how you can work with visual calculations, making them more practical for real-world reporting.
📊 What you'll learn:
- How to create and use visual calculations.
- Step-by-step process to format a visual calculation in Power BI Desktop.
🔗 Useful links:
Power BI August 2024 Update summary: powerbi.microsoft.com/en-us/blog/power-bi-august-2024-feature-summary/
Visual calculations: learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
🤝 Let's Connect:
LinkedIn: www.linkedin.com/...
Просмотров: 80

Видео

Power BI: Field Parameters
Просмотров 3912 месяца назад
In this video, we’re focusing on the field parameters feature in Power BI. We’ll walk through practical steps to make your visuals more dynamic and user-friendly, ensuring your reports are both effective and easy to understand. ⏱️ Timestamps: 00:44 - Importance of simplicity when building Power BI reports. 04:09 - Create a field parameter. 06:36 - Change measures in a visual with a field parame...
Power BI: Calculation Groups
Просмотров 7312 месяца назад
In this video, we’ll walk you through using calculation groups and field parameters in Power BI, enhancing your reporting capabilities by simplifying and organizing your measures. Calculation groups allow you to define DAX calculations once and apply them across multiple measures, reducing redundancy. Field Parameters enable dynamic measure selection, making your reports more flexible and inter...
Power BI: End-to-End Project | Beginners
Просмотров 6344 месяца назад
In this video, we'll guide you step by step through building a Power BI report. We'll cover everything from importing and cleaning data to creating a data model, using DAX for calculations, and effective data visualization. We'll also touch on some advanced topics like time-intelligence calculations and new features such as Visual Calculations. 📊 What you'll learn: - Import data to Power BI. - ...
Power BI: Visual Calculations in Power BI Service
Просмотров 3215 месяцев назад
🚀 The March 2024 Update brought a new key update to the visual calculations feature. You can now add and edit visual calculations in Power BI Service. 📊 What you'll learn: - How to create visual calculations in Power BI Service. 🔗 Useful links: Power BI March 2024 Update summary: powerbi.microsoft.com/en-us/blog/power-bi-march-2024-feature-summary/ Visual calculations: learn.microsoft.com/en-us...
Microsoft Fabric: Dataflow Gen2 (Cleaning Sales Data)
Просмотров 3355 месяцев назад
🚀 In this video, we are learning how to clean and transform sales report data using Dataflows Gen2 in Microsoft Fabric. We'll show the step-by-step process of cleaning sales report data in Excel, transforming it into a normalized table, optimized for storing in a database and analyzing in Power BI. 📊 What you'll learn: - Import data using Dataflow Gen2 - Clean and transform sales report data us...
Microsoft Fabric: Dataflow Gen2 (Cleaning Finance Data)
Просмотров 6245 месяцев назад
🚀 In this video, we're looking at data cleaning and transformation with Dataflows Gen2 in Microsoft Fabric. We'll walk through the process of cleaning financial data efficiently, turning raw data in Excel spreadsheet into a normalized table, optimized for storing in a database and analyzing in Power BI. 📊 What you'll learn: - Data normalization - Import data using Dataflow Gen2 - Clean and tran...
Power BI: Import SharePoint Folder
Просмотров 7686 месяцев назад
🚀 In this video, we are looking at a common scenario for many companies - importing multiple files from a SharePoint folder to build reports in Power BI. This is an effective solution for businesses that do not have a large-scale database system yet or companies that are in transition and in need of immediate reporting. 📊 What you'll learn: - Connect to a SharePoint folder using Power BI Deskto...
Power BI: Visual Calculations (Preview)
Просмотров 2626 месяцев назад
🚀 In this video, we provide a quick review of the visual calculations feature now available in preview in Power BI. The February 2024 update brought many exciting features to Power BI, including visual calculations. 📊 What you'll learn: - How to activate the visual calculations feature in preview - How to create visual calculations in Power BI 🔗 Useful links: About Visual calculations: learn.mi...
Microsoft Fabric: Write-back to OneLake
Просмотров 7236 месяцев назад
🚀 In this video, we are looking into how to use write-back in Power BI with Microsoft Fabric's OneLake. First, we perform write-back to Azure SQL Server using the Power ON solution. Then update the data in OneLake using Dataflow Gen2 and Pipeline. If you want to integrate real-time data changes into an analytical workflow, this video will guide you through the process. 📊 What you'll learn: - Pe...
Microsoft Fabric: Data Warehouse
Просмотров 4377 месяцев назад
In this video, we deep dive into the Data Warehouse within Microsoft Fabric. If you caught our introductory video, you know the basics - now, let's dig deeper into the warehouse features, test its SQL query performance, and revisit the Direct Lake mode. 📊 What you'll learn: - Difference between Lakehouse and Data Warehouse in Microsoft Fabric. - Test the data warehouse with SQL queries. - Use t...
Microsoft Fabric: Introduction
Просмотров 4497 месяцев назад
🚀Welcome back to our channel! In this video, we revisit Microsoft Fabric and its components, including OneLake. If you're familiar with our earlier content, this video serves as the perfect refresher for Microsoft Fabric, an all-in-one analytics solution for analytics and data management. This video highlights the capabilities of Microsoft Fabric's unified platform, showcasing how it can elevat...
Microsoft Fabric: Direct Lake Performance
Просмотров 1,4 тыс.7 месяцев назад
In this video, we dive into Power BI's data models, datasets, and storage modes, with a special focus on the new Direct Lake mode in Microsoft Fabric. We perform a test comparing Direct Lake with the traditional Import and DirectQuery modes, using a dataset of 3-million rows and complex DAX calculations. 📊 What you'll learn: - Understand Power BI data models, datasets and storage modes. - Overv...
Write-back in Power BI: End-to-End Project
Просмотров 3 тыс.8 месяцев назад
In this video, we take a detailed look at the write-back feature in Power BI using Insightsoftware’s Visual Planner (formerly Power ON). This session will walk you through the steps of creating a Power BI report and setting up a robust write-back solution. Join us to learn about write-back in Power BI. 📊 What you'll learn: - Overview of Insightsoftware’s (former Power ON) writeback solution. - ...
Microsoft Fabric: Paginated Reports
Просмотров 8808 месяцев назад
In this video, we explore the enhanced experience of creating paginated reports in Microsoft Fabric. Gone are the days of using separate tools like Power BI Report Builder for this task. Fabric has streamlined the process, making it more accessible and efficient than ever before. 📊 What you'll learn: - Understand what paginated reports are and their key features. - Step-by-step walkthrough of c...
Microsoft Fabric: Dataflows to Convert CSV Files to Tables
Просмотров 1 тыс.8 месяцев назад
Microsoft Fabric: Dataflows to Convert CSV Files to Tables
Microsoft Fabric: End-to-End Project
Просмотров 28 тыс.9 месяцев назад
Microsoft Fabric: End-to-End Project
Microsoft Fabric: Spark Notebooks (Part 2)
Просмотров 36410 месяцев назад
Microsoft Fabric: Spark Notebooks (Part 2)
Microsoft Fabric: Spark Notebooks (Part 1)
Просмотров 88810 месяцев назад
Microsoft Fabric: Spark Notebooks (Part 1)
Microsoft Fabric: Real-Time Analytics
Просмотров 97610 месяцев назад
Microsoft Fabric: Real-Time Analytics
Microsoft Fabric: OneLake Shortcuts
Просмотров 44110 месяцев назад
Microsoft Fabric: OneLake Shortcuts
Microsoft Fabric: Zero-Copy Clones in Warehouse
Просмотров 60310 месяцев назад
Microsoft Fabric: Zero-Copy Clones in Warehouse
Microsoft Fabric: Set Up Data Warehouse
Просмотров 2,1 тыс.10 месяцев назад
Microsoft Fabric: Set Up Data Warehouse
Microsoft Fabric: Direct Lake Mode in Power BI
Просмотров 2,5 тыс.11 месяцев назад
Microsoft Fabric: Direct Lake Mode in Power BI
Microsoft Fabric: Build Report With Default Power BI Dataset
Просмотров 55911 месяцев назад
Microsoft Fabric: Build Report With Default Power BI Dataset
Microsoft Fabric: Understand Workspace Elements
Просмотров 34911 месяцев назад
Microsoft Fabric: Understand Workspace Elements
Microsoft Fabric: Build Power BI Report From LakeHouse
Просмотров 1,7 тыс.11 месяцев назад
Microsoft Fabric: Build Power BI Report From LakeHouse
Microsoft Fabric: Tables in LakeHouse (Part 3)
Просмотров 46011 месяцев назад
Microsoft Fabric: Tables in LakeHouse (Part 3)
Microsoft Fabric: Tables in LakeHouse (Part 2)
Просмотров 55411 месяцев назад
Microsoft Fabric: Tables in LakeHouse (Part 2)
Microsoft Fabric: Tables in LakeHouse (Part 1)
Просмотров 790Год назад
Microsoft Fabric: Tables in LakeHouse (Part 1)

Комментарии

  • @KurtJ-r8w
    @KurtJ-r8w 8 дней назад

    Please make more videos

  • @snackymcgoo1539
    @snackymcgoo1539 19 дней назад

    Microsoft is a terrible company which over-engineers every single feature and product. Our company is forcing us onto Fabric/Lakehouse/Browser version of PBI. And it is a terrible experience. Microsoft went from being my favorite to my least favorite. Unbelievably bad products these days.

  • @snackymcgoo1539
    @snackymcgoo1539 19 дней назад

    And that's no bueno!

  • @moumita5179
    @moumita5179 Месяц назад

    its really a informative video .. can you please tell me about the prerequisite like what type of license required for power bi desktop, power bi workspace, power on license.. also my data source is azure databricks so what will be the process of connecting the databricks.

  • @user-bo8pg1pi8r
    @user-bo8pg1pi8r Месяц назад

    Too much talks.

  • @khan.naved1
    @khan.naved1 Месяц назад

    instead of using flow for excel we can use notebook to populate data into new tables from excel

  • @fabiuskumgne3659
    @fabiuskumgne3659 2 месяца назад

    cool

  • @EvilClxwn
    @EvilClxwn 2 месяца назад

    Does this work when new files are added have additional columns then the original sample file? As in auto add new columns when it gets refreshed?

  • @dilipinamdarpatil6301
    @dilipinamdarpatil6301 2 месяца назад

    Thank you 🙏

  • @Siberian_valenok
    @Siberian_valenok 2 месяца назад

    Thanks man!

  • @VenkatprasadYadav
    @VenkatprasadYadav 2 месяца назад

    thanks for the video @centidaBI and I have a question/ How you loaded the factorders.csv file into data warehouse ? I could see other files as well loaded into warehouse. can you help me with the approach to load the csv files into warehouse ?

  • @arunv1909
    @arunv1909 2 месяца назад

    i just love the fact u said tbh this def might be little confusing right now at the beginning

  • @swatijaiswal7261
    @swatijaiswal7261 3 месяца назад

    sample data link is not working.

  • @dilipinamdar5523
    @dilipinamdar5523 4 месяца назад

    Thank you🙏

  • @TinuolaOshinubi
    @TinuolaOshinubi 4 месяца назад

    Thanks for sharing.. earned a new follower

  • @royalpriestly
    @royalpriestly 4 месяца назад

    I love this so much. Can I have access to the data used so I could practice it? Would really love that

  • @kennethgottfredsen767
    @kennethgottfredsen767 4 месяца назад

    I have made a PowerApp that is running in PowerBI, and I want to be able to write back to my SharePoint. Do you have any videos about this process?

  • @SujathaS-sx3kg
    @SujathaS-sx3kg 4 месяца назад

    Thanks sir, it was really helpful for beginners

  • @rochellethiel
    @rochellethiel 4 месяца назад

    Promo_SM

  • @cargouvu
    @cargouvu 5 месяцев назад

    Is there a way to prevent snakes and mosquitoes? I guess if the water isn't stagnant mosquitoes may not come but snakes can get attracted to water. I wasn't sure if this was accounted for during the construction. Beautiful home... absolutely phenomenal.

  • @guilhermemoura6441
    @guilhermemoura6441 5 месяцев назад

    Great video!

  • @dheerajy2202
    @dheerajy2202 5 месяцев назад

    Hello, @5:05 How to get the WWI_FactOrders table? Please help. Thank you in advance.

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Hi, thank you for your comment. Yes, it's there now.

  • @ThinakaraRajuChitra
    @ThinakaraRajuChitra 5 месяцев назад

    Thank you for the lesson. I have an doubt in the line chart, we can arrange the month in order on powerbi desktop .What we have done in powerbi sortby column that i cannot able to perform in fabric. Can you able to teach me to sort out this problem.

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      This is a good question, thanks! As of today, when building Power BI reports in the browser, you have some limitations when editing datasets. One of these limitations is the option to sort one column using another column. For example, when you need to sort the month name (January, February, March) by the column month number (1, 2, 3, …). One workaround is to use Tabular Editor. Here is the step-by-step process: 1. Open Tabular Editor > go to File > Open from DB. 2.In the field “Server” you need to put your Fabric workspace connection string. This can be found in Workspace Settings > Premium. 3. For the Authentication method choose Windows Integrated or Azure ID login. Once authenticated, connect to your Lakehouse or DWH. 4. In the object explorer, find your table under the folder “Tables”. 5. Select your column (MonthName). Under the Basic group of properties, find the field “Sort by Column”. Choose the name of a column by which you want to sort the selected column (Month Number). 6. In the upper menu, find the button “Save the changes to the connected database”. 7. Go back to the Power BI report and update it. After the update, you should see the changes. Hope this works for you.

  • @official_westhostel1004
    @official_westhostel1004 5 месяцев назад

    I have one Lakehouse and one warehouse in one workspace. And I read from Lakehouse and load those tables to warehouse by pipeline with option auto create table in destination. But when I again run that pipeline it add double data to the same table. Is there any way to solve this issue?

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Thanks for your comment. Yes, it is a common error people encounter with the Fabric DWH. Your data gets appended instead of updated, right? When setting the options in the "Connect to data destination" window, choose Overwrite instead of Append. It should be below the Destination table name field (may have been changed with latest Fabric updates, but the option should be somewhere in that vicinity.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank you🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank You🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank You🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank You🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank you!!!!!🙏 Nice

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank You!!!🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank you!!!!🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Welcome! Glad you liked the video.

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Thank You🙏

  • @dilipinamdar5523
    @dilipinamdar5523 5 месяцев назад

    Nice🙏

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      Thank you! I am glad you liked it.

  • @YassineZaddem
    @YassineZaddem 5 месяцев назад

    Thank you so much ,I appreciate your work! Can you create for us video of the full process from ETL to creating reports

    • @CentidaBI
      @CentidaBI 5 месяцев назад

      You are most welcome, thanks for the comment. We will be soon. More videos will be published.

  • @juliekim6892
    @juliekim6892 5 месяцев назад

    every model or dataset created in Azure Fabric will be in the direct lake mode?

  • @Coquito9431
    @Coquito9431 6 месяцев назад

    amazing video. tnks you

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Glad you liked it!

  • @sarihaddu
    @sarihaddu 6 месяцев назад

    I have lerned powerbi and sql. Should I learn datafabric, azure data factor to get job?

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thank you for your feedback! If you're already proficient in Power BI and SQL, I'd recommend focusing on getting hands-on experience with real-world projects to further strengthen your skills and build your portfolio.

    • @zvijer2960
      @zvijer2960 5 месяцев назад

      And Python

  • @mog370
    @mog370 6 месяцев назад

    Thank you so much for this series on Fabric. Honestly, it's much better that the 4 day Microsoft workshop I attended. The new storage mode is a good idea however if it can't be used in Desktop where calculated tables and columns are created then we are stuck. also not that power bi in the cloud does not allow you to create measure instead you will have to created them as part of semantic model. I might be wrong guys. please, correct me if I am.

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thank you for your kind words and feedback! You're absolutely right about the limitations of the new mode. While there are workarounds like using Tabular Editor, we agree that Power BI in the cloud isn't as robust as Desktop yet. I'm sure this will improve in the future though.

  • @User-jr5xf
    @User-jr5xf 6 месяцев назад

    100% not the right approach for this ! Intoduces so much room for wrror, if you really need to do this the please reach out.

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thanks for sharing your thoughts! What would you recommend in a similar scenario?

    • @EvilClxwn
      @EvilClxwn 2 месяца назад

      Does this work when new files are added have additional columns then the original sample file? As in auto add new columns when it gets refreshed?

  • @osamaasif9601
    @osamaasif9601 6 месяцев назад

    Hey man, great work

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thanks, appreciate man!

  • @shubhporwal8276
    @shubhporwal8276 6 месяцев назад

    in this whole process, were any landing zones used, if yes where , when ? i m beginner ;)

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thanks for your feedback. No, we did not use any landing zones. Data was imported using a Dataflow, a pipeline, and shortcut from a warehouse.

  • @mustafakamal5945
    @mustafakamal5945 7 месяцев назад

    Very Well explained, Thank you so much for sharing this! . Can you also advise on the integration of Azure Key vault in Fabric..

  • @ramusubbu3778
    @ramusubbu3778 7 месяцев назад

    You can use tabular editor to edit semantic model of direct lake.

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Yes, you are right.

  • @tiruveedipradeepkumar1487
    @tiruveedipradeepkumar1487 7 месяцев назад

    Very Good...

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thank you. I am glad you liked.

  • @byreshgowda7485
    @byreshgowda7485 7 месяцев назад

    It was awesome. Thank you!

    • @CentidaBI
      @CentidaBI 7 месяцев назад

      We are glad you liked it. If you have other questions about write-back in Power BI, please let us know. Have a great day!

  • @Cantblendthis
    @Cantblendthis 7 месяцев назад

    Thank you for this demo. Can you share the Order Details and Fact Orders as a csv? This way we can still complete the training without the shortcut or pipeline data load.

    • @CentidaBI
      @CentidaBI 6 месяцев назад

      Thanks for feedback. My bad, it was added in the shared folder, the link is in the description below.

    • @Cantblendthis
      @Cantblendthis 6 месяцев назад

      Thank you :D@@CentidaBI

  • @demon-h5p
    @demon-h5p 8 месяцев назад

    u should provide the data set link that you have used in the project..which will be helpfull for us to practice along with you

    • @CentidaBI
      @CentidaBI 7 месяцев назад

      Hi, thanks for pointing this out. Just added a SQL script to create the Fact table.

    • @demon-h5p
      @demon-h5p 7 месяцев назад

      @@CentidaBI thank you very much

  • @tyronefrielinghaus3467
    @tyronefrielinghaus3467 8 месяцев назад

    Your 'error' on the column data type (price), was actually very instructive...are you sure you didn't do it on purpose (laughs!) Good to see how to problem solve : thanks. OH, and super video. Glad you made it fairly straighforward.

    • @CentidaBI
      @CentidaBI 7 месяцев назад

      Thanks a lot! No, it was a real error, honestly :)

  • @CH-js4lg
    @CH-js4lg 8 месяцев назад

    This is a greate example. Thank you for your effort on creating the excellent content. I spent a lot of time to figuring out how to use directlake mode in warehouse, not using lakehouse, but I couldn't find any example of it. Is is possible to use directlake mode in fabric warehouse?

    • @CentidaBI
      @CentidaBI 7 месяцев назад

      Thanks for your comment. At the time of the recording, it was not possible to use Direct Lake in Warehouse. However, MSFT has fixed that now and you can use Direct Lake in Warehouse.

  • @msme-corpbusinessconsultan5549
    @msme-corpbusinessconsultan5549 8 месяцев назад

    Masterclass

    • @CentidaBI
      @CentidaBI 7 месяцев назад

      Thanks, we're glad you liked it!