- Видео 123
- Просмотров 789 604
BI Tricks
Индия
Добавлен 3 авг 2021
Welcome to my RUclips channel! I'm Ashish, committed to guiding individuals or businesses in unleashing the potential of data through Power BI. Join me as I share invaluable tips, tricks, and tutorials on crafting clean, informative Power BI reports.
Whether you're a seasoned professional or new to the world of data analytics, my goal is to equip you with the knowledge and skills to create impactful reports that drive actionable insights.
For business inquiries or collaboration opportunities, please don't hesitate to reach out to me on LinkedIn. Let's embark on this data-driven journey together!
Whether you're a seasoned professional or new to the world of data analytics, my goal is to equip you with the knowledge and skills to create impactful reports that drive actionable insights.
For business inquiries or collaboration opportunities, please don't hesitate to reach out to me on LinkedIn. Let's embark on this data-driven journey together!
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,...
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
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
Thank you... I have been cracking my head for several days how to share my report to specific people. (no sensitive data)
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"
Good bless for you creating such a wonderful and Unique content
I was getting nuts investigating how to do this. Thanks !
Thank you so much 🙏😊
Very useful.. thq bro
Glad it was helpful !
Wowwww, I was used to create combine key in dimension table & then merge it in fact table
How to publish without work email?
Good buddy nice video
Glad you enjoyed
the page type under the page information is not showing :(
Make sure your Power BI desktop is updated
Thank you, its working
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.
Glad it was helpful !
Can we use Python for this gateway? I want to use an API for this, which can help.
Thank you very much
Power BI Refresh is not there
Thanks broo
How to publish to power bi APP??
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
Thank u so much bro❤❤❤❤❤❤
Can I paste this link to my resume if i have created a dashboard??
Yes you can, but there is one caveat. Once you make this link public anyone can use this link and show it as theirs.
Amazing work. Ive finally learned field parameters
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?
You can create date table for all kinds of dashboard
Very valuable info sir thank u...can u give detailed info about it.
Dei Lusu kuthiiiiiii.... Na ena ketta ni enada solra . Paithiyakara pooooocghhhhuhhhh
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
How to analyse this now? If we want sales from past 20 years then it would have millions of records?
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?
This simple trick was what I was looking for years . Thanks
Does it work with multiple tables like i want to join tables using join function?
hi bro ur work is amazing, can u upload a complete power bi service tutorial.
Very helpful video. Much appreciated
Glad you liked it!
Finished watching
Wish u to reach more heights
The most under rated channel for power bi ...❤keep it up bro u r doing great job...
Thanks for the appreciation!
The best 35 minute of my life. Thank you 😊
Glad you liked this video so much!
Can you share this data set
This is cool …. You made my day 🫡
Glad it was helpful!
Thanks a lot brother 🙏🙏🙏🙏😊😊😊
nice man, it was very helpfull. i'm from Brazil
Glad you liked it!
its useless what about how to hid and unhide think about end user
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?
Great video
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.
Bro, I have a doubt. how you calculated "Orders" Measure ?
Thanks very much, very helpful
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
this tutorial really good for students 😇..
Nice video
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?