- Видео 89
- Просмотров 36 652
Intelligence For Business
Индия
Добавлен 28 фев 2022
Business intelligence is a term used to encompass the technology and strategy that goes into data analysis for your company. The technology can give you a look into past performance, how your company is doing right now and make forecasts for potential future scenarios. So, business intelligence strategy is a blueprint for how you use the data a company generates.
3) REALTIME SCENARIO BASED DYNAMIC #SQL
REALTIME SCENARIO BASED DYNAMIC #SQL #powerbi #dataanalysis
#dataanalytics
#dataanalytics
Просмотров: 147
Видео
2) Real time business scenario based #SQL Problem.
Просмотров 16019 часов назад
Real time business scenario based #SQL Problem #powerbi #dax #dataanalysis #dataanalytics bill_date bill_no CATEGORY net_sales quantity PURCHASE_TYPE 2024-10-01 003-5523-678 SHIRT 2400 1 AB 2024-10-01 043-7823-570 T-SHIRT 1490 1 AB 2024-10-01 043-7823-570 TROUSER 2900 1 AB 2024-10-01 006-9923-645 SHIRT 2000 1 AB 2024-10-01 090-5463-690 JEANS 4900 2 AB 2024-10-02 367-5593-672 SHIRT 2000 1 AB 202...
4) How to extract Only numbers or Only Alphabets from a mixed data in #powerquery
Просмотров 13021 час назад
How to extract Only numbers or Only Alphabets from a mixed data in #powerquery #powerbi #powerbiinterview
1) Real-Time Scenario-Based #sql Query for Power BI Development | Video #1
Просмотров 9721 день назад
In this video, we dive into a real-time scenario-based SQL query designed for Power BI development. You'll learn how to calculate the Average Basket Size using a Common Table Expression (CTE). This query provides a breakdown of unique bill counts and quantities on a daily basis, demonstrating how to leverage SQL to handle essential metrics in Power BI.
55) How to make any day as the first day of that week in #dax #powerbi
Просмотров 702 месяца назад
How to make any day as the first day of that week in #dax #powerbi #dataanalytics Linkedin: www.linkedin.com/in/subhadip-sur211298 Instagram: jeet._.sur999
3) SUMX and SAMEPERIODLASTYEAR calculation in #powerbi #tableau
Просмотров 632 месяца назад
SUMX and SAMEPERIODLASTYEAR calculation in #powerbi #tableau #dataanalytics #dataanalysis #datavisualization #dax
2) This year vs Previous year month to date sales till yesterday in #powerbi #tableau
Просмотров 363 месяца назад
This year vs Previous year month to date sales till yesterday in #powerbi #tableau #datavisualization #dataanalytics
1) AllEXCEPT in Power BI vs FIXED (LOD) in Tableau
Просмотров 863 месяца назад
This video is about getting the 2 different functions works as same in 2 different bi tools #powerbi and #tableau #AllEXCEPT in Power BI vs #FIXED (LOD) in Tableau
54) Convert whole dashboard in FTD, MTD, YTD by a Single click😎 in #dax #powerbi
Просмотров 6904 месяца назад
Convert whole dashboard in FTD, MTD, YTD by a Single click😎 #dax #powerbi #dataanalysis #datanalytics #sql #dashboard
53) How to specify Quarter number dynamically in #DAX #powerbi
Просмотров 915 месяцев назад
This video is about How to specify Quarter number dynamically in #DAX #powerbi #datanalytics #dataanalysis #datavisualization #powerquery #sql
52) Dynamic hierarchy based on filter selection in #Matrix visual #powerbi
Просмотров 3617 месяцев назад
In this video we talked about how to make Dynamic hierarchy based on filter selection in #Matrix visual #powerbi #dax #powerbi_training #dataanalysis #dataanalytics #datavisualization #dataanalysis #parameter
51) Previous month sales till Today's Date in #dax
Просмотров 1338 месяцев назад
In this video we discussed about Previous month sales till Today's Date in #dax #powerbi #dataanalytics #dataanalysis #sql #datavisualization
50) Sales of Same Week previous year till Same Day(Today) #powerbi #dax
Просмотров 25411 месяцев назад
Sales of Same Week previous year till Same Day(Today) Here in this video we used: #today #all #year #weeknum #daynum #calculate function in #dax
3) Convert JSON data into Records In Power Query #powerquery #powerbi
Просмотров 170Год назад
Convert JSON data into Records In Power Query #powerquery #powerbi
2) Difference between two dates with time in #powerquery #powerbi
Просмотров 132Год назад
Difference between two dates with time in #powerquery #powerbi
49) #COALESCE function in #SQL and #DAX #powerbi
Просмотров 79Год назад
49) #COALESCE function in #SQL and #DAX #powerbi
1) Power Query Tutorial - Query Parameter #powerbi #powerquery
Просмотров 125Год назад
1) Power Query Tutorial - Query Parameter #powerbi #powerquery
48) #powerbi #dax Total sales of previous 3 consecutive days from any selected date.
Просмотров 456Год назад
48) #powerbi #dax Total sales of previous 3 consecutive days from any selected date.
46) How to get same date of previous year according to today's date in #dax #powerbi
Просмотров 351Год назад
46) How to get same date of previous year according to today's date in #dax #powerbi
45) How to create measure as a slicer in power bi #powerbi #dax
Просмотров 8 тыс.Год назад
45) How to create measure as a slicer in power bi #powerbi #dax
44) Multi conditional formatting in #dax #powerbi Conditional formatting with multiple conditions
Просмотров 6 тыс.Год назад
44) Multi conditional formatting in #dax #powerbi Conditional formatting with multiple conditions
43) How to rename filters in visualization level with #dax
Просмотров 615Год назад
43) How to rename filters in visualization level with #dax
42) How to collaborate between #calculate #sumx #treatas function for non related tables..
Просмотров 144Год назад
42) How to collaborate between #calculate #sumx #treatas function for non related tables..
41) Realtime problem solving with datatypes in #dax #convert #powerbi
Просмотров 306Год назад
41) Realtime problem solving with datatypes in #dax #convert #powerbi
40) How to count comma separated values from each row of a column in #dax #powerbi
Просмотров 2,3 тыс.2 года назад
40) How to count comma separated values from each row of a column in #dax #powerbi
39) How to calculate length of values of each row in #dax #substitute #powerbi
Просмотров 2712 года назад
39) How to calculate length of values of each row in #dax #substitute #powerbi
38) Realtime use of #earlier #values #countrows function in #dax #powerbi @intelligenceforbusiness
Просмотров 2382 года назад
38) Realtime use of #earlier #values #countrows function in #dax #powerbi @intelligenceforbusiness
37) Realtime use of #summarize and #filter function in #dax #powerbi
Просмотров 1752 года назад
37) Realtime use of #summarize and #filter function in #dax #powerbi
36) Dynamically selected Nth Highest Sales in #dax #powerbi
Просмотров 4592 года назад
36) Dynamically selected Nth Highest Sales in #dax #powerbi
Bro provide create & insert statement in the description box
@@chandanpatra1053 I will give from the next video.
plz share the scripts in all vedeo
@@siddharthpunn6177 I will give from the next video.
Can you share inside about business analyst vs Data analyst Job Profile , related work , salary , growth scenario
Can you share inside about business analyst vs Data analyst Job Profile , related work , salary , growth scenario
Can you share inside about business analyst vs Data analyst Job Profile , related work , salary , growth scenario
Hlo need example plese
Good one Bhai 😊
That is very helpful. Do you mind showing next step -- like extracting text or number starting from a certain position, or extracting text between numbers or vice versa? Thanks again
Hay Thanks, Obviously I will make a video in that ASAP.
@@intelligenceforbusiness in fact, I think for many people who are used to SQL and Regex type of string manipulation the powerquery apparent functionality seems inadequate, though as you have shown in the video there are ways to address such limitations.
Good explanation
@@Vlogsbyprasanthi Thanks. Watch my power bi interview questions Playlist, it will help you.
@intelligenceforbusiness please send me your number and we need classes
Super and nice
Super
Good explanation
Excellent excellent
Please post sql vedeos also
Super
Nice
Nice vedeo thanks
Excellent and good explanation
Super
Nice explanation
Nice explanation
I need this data for practice
Very nice explanation.. keep it up
Brilliant! Thank you!
Amazing! Thank you!!!
Nice video
Straight to the point , Thank you so much
Thanks for your content. Any reason you decided to go with LASTDATE vs MAX(Orders[OrderDate]), which would have been more consistent with the MIN functions you used for the first 7 month?
Excellent brother 😊
Excellent 👍
what is MTD FTD And YTD ??
First day of Month to today sales, Today sales, first day of year to today sales.
Nice one Bhai keep up the great work
Good Content! I have a question, when I tried to implement the similar logic using SUMX in Calculated column, it return all the Order dates from the table. Do you know why would it behave differently in calculated field ?
So helpful! Thanks very much!
Can this work with tables?
If i wanna see the future data with dax and acumulate real data , how i do ?
Thanks a lot, this was very helpful ❤
Khubi Bhalo..chalie Jaao..Need more videos like this😍! Learning a lot from these videos👌👌
Simply fantastic explanation brother keep up the great work 😀😊
thanks
Could you help. Create a new summarize table with selected columns (region, country, sum of sales) from the global superstore and filter the region based on the given conditions, Central Asia, North, South & East.
Thank You
Hello, I appreciate the quality of your videos and commend you for the clarity of your explanations. I'm wondering if it's possible to apply the "Earlier" function in a DAX measure for calculating the cumulative total of revenue by product category, for instance.
How to format the lines colours if we are using the parameters.
As usual. No change
New parameters in my power BI do not have Fields ?
Thanks mate 🤍
Awesome 👍
Thanks for the feedback Vikas..
but can a numeric slicer that has a range be created for such a measure? If yes please show that.
Thanks this worked but for a stacked column chart when I filter by top 5 or 10 I’m unable to get that result. Rather it displays all the values. Any tips ?
Hi appreciate your effort , but not able to understand can you explain it better with some other example.