BI Tricks
BI Tricks
  • Видео 123
  • Просмотров 789 604
How to Normalize Data in Power BI with Power Query
Learn the Basics of Database Normalization with Easy-to-Follow Tutorials
In this video, you’ll discover how to turn a single merged table into a well-structured data model using Power Query in Excel or Power BI.
We’ll show you how to apply data normalization techniques to clean up your data, remove duplicates, and create models that are efficient and easy to work with for analysis or reporting.
Here’s what we’ll cover:
✔️ What normalization is and why it’s important
✔️ How to create star and snowflake schemas by separating merged tables
Tags:
database normalization, Power Query, Power BI, Excel, data modeling, data normalization, relational database, star schema, snowflake schema, data analysis,...
Просмотров: 728

Видео

How to Document in Power BI Faster: Extract Tables, Column names & Measures with DAX Query View
Просмотров 44914 дней назад
Are you tired of manually documenting your Power BI reports? In this tutorial, I’ll show you how to automate the documentation process by extracting table names, column names, measure names, and their DAX expressions directly from Power BI using the DAX Query View. By the end of this video, you’ll know how to save time and streamline your documentation tasks with just a few simple steps. Perfec...
New List Slicer Visual vs. Classic Slicer | Power BI October 2024 Update
Просмотров 1 тыс.Месяц назад
In this video, we dive into the exciting new List Slicer visual introduced in Power BI's October 2024 update! Discover how to utilize this powerful feature, compare it to the classic slicer visual, and learn tips and tricks for enhancing your data analysis. Whether you're a beginner or a seasoned Power BI user, this guide will help you make the most of the latest enhancements. Don't miss out on...
How to Create Dynamic Insights in Power BI
Просмотров 1 тыс.Месяц назад
Don't know how we write insights from the visuals in Power BI? In this video, I have shown how to create dynamic insights from different visualizations in Power BI. #PowerBI #DataAnalytics #BusinessIntelligence #DynamicInsights #DataVisualization #Tutorial" Tags: How dynamic insights are derived in Power BI, Power BI Insights, Derive insights in Power BI, How to extract dynamic insights in Powe...
How to Enable Dark Theme in Power BI Desktop - October 2024 Update
Просмотров 3 тыс.Месяц назад
This is one of the most exciting Power BI updates that is released this October. In this video, I’ll show you how to enable the new Dark Theme feature in Power BI Desktop, one of the most exciting updates released this October! Follow along as I walk you through the step-by-step process to switch your interface to dark mode for a more comfortable visual experience. Don’t forget to like, subscri...
How to Edit Data Model in the Power BI service
Просмотров 4572 месяца назад
In this video you will know how to enable the settings required to use the Data model in Power BI Service. Tags: Power BI, Power BI Service, data modeling, data analysis, business intelligence, data visualization, Power BI tutorial, Power BI tips, data transformation, analytics, data management, BI tools, learn Power BI, data insights, Power BI for beginners, Power BI, Power BI Service, data mo...
Show Total Bar in Column Chart | Scenario based Power BI Interview Question
Просмотров 5752 месяца назад
In this video, I have shown how to show a total bar in the column chart and show the total profit for all the months. This is an interview question that was asked in the Power BI Interview. Scenario Based Interview Questions Playlist - ruclips.net/video/cC7O_SUhwXg/видео.html Tags: Power BI, Power Query, Data Transformation, Special Characters, Power BI Interview, Power Query Tutorial, Business...
How to Set Up Monthly Refresh in Power BI Using Power Automate
Просмотров 1,3 тыс.2 месяца назад
🔄 Looking to set up a monthly data refresh for your Power BI reports? In this video, we explore an effective workaround using Power Automate to achieve monthly scheduled refreshes. Power BI’s native options may not support monthly schedules directly, but with Power Automate, you can create a seamless and automated refresh cycle. Follow along as we walk you through the process of integrating Pow...
How to Extract Special Characters in Power Query | Power BI Interview Question
Просмотров 7462 месяца назад
In this video, we'll dive into how to extract special characters from a text column in Power Query. This is a commonly asked question in Power BI interviews, including those with Microsoft. I’ll walk you through the step-by-step process using a practical example and explain the Power Query functions used to achieve this. Whether you’re preparing for an interview or looking to enhance your Power...
Highlight Line Segment with Different Colors in Power BI | Scenario-Based Interview Question
Просмотров 4422 месяца назад
Master the technique of highlighting specific line segments with different colors in Power BI! In this video, I’ll guide you through a scenario-based interview question that challenges your Power BI skills. Whether you’re preparing for an interview or looking to enhance your data visualization techniques, this tutorial will provide valuable insights. Learn how to apply conditional formatting to...
The Ultimate Tool for Power BI Dashboard Designs: Mokkup.ai
Просмотров 9623 месяца назад
I recently came across Mokkup.ai www.mokkup.ai/ and found it to be a real gem for dashboard design. It simplifies the process of building dashboard wireframes, whether you're working with Power BI, Tableau, or other BI tools. With its extensive selection of dashboard templates and a straightforward drag-and-drop interface, it makes creating dashboard mockups much more approachable, even if desi...
Invoke Custom Function in Power BI
Просмотров 1,4 тыс.3 месяца назад
Invoke Custom Function in Power BI
Power BI DAX Speed Test: DIVIDE Function vs Operator
Просмотров 2483 месяца назад
Power BI DAX Speed Test: DIVIDE Function vs Operator
Drill Through in Power BI with a Single Button click
Просмотров 2,8 тыс.3 месяца назад
Drill Through in Power BI with a Single Button click
Drill Through in Power BI
Просмотров 7773 месяца назад
Drill Through in Power BI
Sort Dates from April to March in Power BI | Financial Year Date Sorting Guide
Просмотров 8513 месяца назад
Sort Dates from April to March in Power BI | Financial Year Date Sorting Guide
Highlight Filtered Months in the Column Chart in Power BI
Просмотров 8284 месяца назад
Highlight Filtered Months in the Column Chart in Power BI
Install and Connect Power BI Dataset in DAX STUDIO
Просмотров 7414 месяца назад
Install and Connect Power BI Dataset in DAX STUDIO
Calculate Cumulative Sum with Reset in Power BI DAX
Просмотров 9724 месяца назад
Calculate Cumulative Sum with Reset in Power BI DAX
Generate List of Dates between Start Date and End Date using DAX
Просмотров 5124 месяца назад
Generate List of Dates between Start Date and End Date using DAX
Display SELECTED Values From MULTIPLE Slicers
Просмотров 2,4 тыс.4 месяца назад
Display SELECTED Values From MULTIPLE Slicers
Show Selected Values from the SLICER in a New Line
Просмотров 6164 месяца назад
Show Selected Values from the SLICER in a New Line
How to Organize Power BI Reports in Power BI Service | BI Tricks
Просмотров 5184 месяца назад
How to Organize Power BI Reports in Power BI Service | BI Tricks
End to End Power BI Project | Dashboard | Complete Project - 2024 | UK Train Rides Analysis
Просмотров 1,6 тыс.4 месяца назад
End to End Power BI Project | Dashboard | Complete Project - 2024 | UK Train Rides Analysis
How to Refresh a Single Table in Power BI Using XMLA Endpoint
Просмотров 1,8 тыс.4 месяца назад
How to Refresh a Single Table in Power BI Using XMLA Endpoint
How to Configure Schedule Refresh in Power BI
Просмотров 15 тыс.5 месяцев назад
How to Configure Schedule Refresh in Power BI
How to configure Gateway Connection in Power BI Service
Просмотров 16 тыс.5 месяцев назад
How to configure Gateway Connection in Power BI Service
How to use Deployment Pipeline in Power BI Service
Просмотров 10 тыс.5 месяцев назад
How to use Deployment Pipeline in Power BI Service
How to Share Power BI report OUTSIDE the ORGANIZATION
Просмотров 20 тыс.6 месяцев назад
How to Share Power BI report OUTSIDE the ORGANIZATION
Power BI Service Overview 2024
Просмотров 1,8 тыс.6 месяцев назад
Power BI Service Overview 2024

Комментарии

  • @deokhyeyi9375
    @deokhyeyi9375 2 часа назад

    Thank you... I have been cracking my head for several days how to share my report to specific people. (no sensitive data)

  • @stevanmomcilovic4469
    @stevanmomcilovic4469 18 часов назад

    Really good video, but I won't call it "End to End", there is lot of things on Service side so it can be called "End to end"

  • @letsexplore0075
    @letsexplore0075 2 дня назад

    Good bless for you creating such a wonderful and Unique content

  • @mistertgmistertg
    @mistertgmistertg 2 дня назад

    I was getting nuts investigating how to do this. Thanks !

  • @aneelanarayanam
    @aneelanarayanam 3 дня назад

    Thank you so much 🙏😊

  • @Kunamaneniramlal
    @Kunamaneniramlal 3 дня назад

    Very useful.. thq bro

    • @bitricks
      @bitricks 2 дня назад

      Glad it was helpful !

  • @sanketpatil3698
    @sanketpatil3698 3 дня назад

    Wowwww, I was used to create combine key in dimension table & then merge it in fact table

  • @NishantKaushik-q5d
    @NishantKaushik-q5d 4 дня назад

    How to publish without work email?

  • @sureshkumar3015
    @sureshkumar3015 4 дня назад

    Good buddy nice video

    • @bitricks
      @bitricks 2 дня назад

      Glad you enjoyed

  • @robertdavid4493
    @robertdavid4493 5 дней назад

    the page type under the page information is not showing :(

    • @bitricks
      @bitricks 4 дня назад

      Make sure your Power BI desktop is updated

  • @naveenshindhe2893
    @naveenshindhe2893 7 дней назад

    Thank you, its working

  • @LarryHupe
    @LarryHupe 7 дней назад

    Dude! Thank you so much. I spent all day yesterday trying to figure this out. I am glad I came across your video. Very much appreciated.

    • @bitricks
      @bitricks 7 дней назад

      Glad it was helpful !

  • @AlgoExpert-AE
    @AlgoExpert-AE 7 дней назад

    Can we use Python for this gateway? I want to use an API for this, which can help.

  • @MahmoudAmin-j6k
    @MahmoudAmin-j6k 8 дней назад

    Thank you very much

  • @pranithaj5068
    @pranithaj5068 8 дней назад

    Power BI Refresh is not there

  • @riyajaiswal7902
    @riyajaiswal7902 9 дней назад

    Thanks broo

  • @RK-wf7re
    @RK-wf7re 9 дней назад

    How to publish to power bi APP??

  • @wasimbhatti6116
    @wasimbhatti6116 10 дней назад

    Good Morning sir need your guidance as i am stuck on one point, working on same dashboard as creation of sales by year quarter all my profit and sales are showing same amount, means profit and sales are equal for all quarters

  • @Rockroll_offcial4345
    @Rockroll_offcial4345 11 дней назад

    Thank u so much bro❤❤❤❤❤❤

  • @jagadeeshsagar1067
    @jagadeeshsagar1067 14 дней назад

    Can I paste this link to my resume if i have created a dashboard??

    • @bitricks
      @bitricks 13 дней назад

      Yes you can, but there is one caveat. Once you make this link public anyone can use this link and show it as theirs.

  • @Ktiy1857
    @Ktiy1857 15 дней назад

    Amazing work. Ive finally learned field parameters

  • @wasimbhatti6116
    @wasimbhatti6116 17 дней назад

    Thanks for your videos, very informative and great way to teach step by step, I have a questions, sir can we make date table for all type of dashboards? or we can use it as per the requirements?

    • @bitricks
      @bitricks 17 дней назад

      You can create date table for all kinds of dashboard

  • @kokilailan1660
    @kokilailan1660 18 дней назад

    Very valuable info sir thank u...can u give detailed info about it.

  • @npsg1466
    @npsg1466 20 дней назад

    Dei Lusu kuthiiiiiii.... Na ena ketta ni enada solra . Paithiyakara pooooocghhhhuhhhh

  • @prabuubarp3840
    @prabuubarp3840 21 день назад

    Bro I recently purchased power bi pro and configured with o365, i am having 1 user licence for one year, but I want to be used by other 20 members in my office how to do that

  • @umarhussain3923
    @umarhussain3923 21 день назад

    How to analyse this now? If we want sales from past 20 years then it would have millions of records?

  • @Anishkumar-xl9wv
    @Anishkumar-xl9wv 21 день назад

    in slicer there is one option to search the text when apply that and after that when I try to clear the slice the slicer got reset but the text in search bar don't. Any suggestion?

  • @Airsoftshowoffs
    @Airsoftshowoffs 21 день назад

    This simple trick was what I was looking for years . Thanks

  • @SaaquibMustafa-f1m
    @SaaquibMustafa-f1m 21 день назад

    Does it work with multiple tables like i want to join tables using join function?

  • @kokilailan1660
    @kokilailan1660 22 дня назад

    hi bro ur work is amazing, can u upload a complete power bi service tutorial.

  • @shubhabratadey
    @shubhabratadey 23 дня назад

    Very helpful video. Much appreciated

    • @bitricks
      @bitricks 22 дня назад

      Glad you liked it!

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 24 дня назад

    Finished watching

  • @kokilailan1660
    @kokilailan1660 26 дней назад

    Wish u to reach more heights

  • @kokilailan1660
    @kokilailan1660 26 дней назад

    The most under rated channel for power bi ...❤keep it up bro u r doing great job...

    • @bitricks
      @bitricks 25 дней назад

      Thanks for the appreciation!

  • @AamirSohail-s2c
    @AamirSohail-s2c 29 дней назад

    The best 35 minute of my life. Thank you 😊

    • @bitricks
      @bitricks 29 дней назад

      Glad you liked this video so much!

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

    Can you share this data set

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

    This is cool …. You made my day 🫡

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

      Glad it was helpful!

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

    Thanks a lot brother 🙏🙏🙏🙏😊😊😊

  • @1tiagoamancio
    @1tiagoamancio Месяц назад

    nice man, it was very helpfull. i'm from Brazil

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

      Glad you liked it!

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

    its useless what about how to hid and unhide think about end user

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

    I need some help on setting up gateway connection with files that are in share point (Teams). Is it possible to get one on one help?

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

    Great video

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

    Hey, thank you for the great video! I have a question: Is there a way to disable anyone from altering the slicer I have in my report? I want to send it to different People with specific slicer settings for each, which means they should not be able to use it themselves.

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

    Bro, I have a doubt. how you calculated "Orders" Measure ?

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

    Thanks very much, very helpful

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

    Hi, thank you for the video. I have a question. I got the percentage of returns 5.54%. When I select each country to filter this percentage, I get odd values for some of them, for example for Algeria it is 1498.6%! Could you please give me a hint on where I am doing wrong? Thank you

  • @RohitKumarChauhan-q9o
    @RohitKumarChauhan-q9o Месяц назад

    this tutorial really good for students 😇..

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

    Nice video

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

    thank you for the video. I had one doubt, if i am using month as filter, the max and min values wont be adjusted for that particular month. how to do that?