Astonishing content Man 💯💯💯 Thanks to share your knowledge with us 🔥🔥
@datalab3656 ай бұрын
Thanks 🙏
@razeennevarekar91606 ай бұрын
GREAT....EFFORTS.........INSHALLAH YOU BECOME....THE GREAT INSTRUCTOR
@datalab3656 ай бұрын
Thank you
@alienc59202 ай бұрын
Great job. It gives a lot of useful ideas of "how to". Thank you!!
@datalab3652 ай бұрын
Thank you. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj
@mostafahwafy6 ай бұрын
like the design so nice... excited to watch your tips and tricks in this video... thank you for sharing
@mohammadsujon1246 ай бұрын
I think this is very nice project. I did not see this project yet, but I will see and I think I can include this project in my portfolio. Thank you so much for your hard work.
@datalab3656 ай бұрын
Sure
@fernandaycastillo85945 ай бұрын
Will you include this project in your portfolio? You didn't do it!!
@mufasamurife6 ай бұрын
Outstanding 🙏
@datalab3656 ай бұрын
🙏
@menghao45766 ай бұрын
Hello brother, i just came across your channel just now. May I ask if there is a part 2 for Maven Airlines Analysis you did a year ago? I can't seem to find it in your channel. Thanks.
@fang-wenhsiao26966 ай бұрын
amazing!! thank you
@HameezAqeel4 ай бұрын
If anyone struggles with the fact that total target remains same for all rows at 1:10:46: Reestablish the relationship between the monthly store target table and the sales person table. This time, you would have to connect the two tables using the Store ID column in the monthly store target table and the Sales Person ID column, instead of the store name column in the sales person table.
@IsaacFemi637Ай бұрын
GOD BLESS YOU SIR. I'VE BEEN STOCK HERE FOR DAYS THINKING I HAVE SOME KIND OF BADLUCK FOLLOWING ME
@jayakaranam2 ай бұрын
Thank you for sharing the tutorial, I got stuck at the slicer , in the slicer Total target showing only in the month of Jan, remaining all months showing blanks. Please let me know where did i miss?
@knowledgeshowhinditv3 ай бұрын
Amazing video. This is what I am searching 😊
@datalab3653 ай бұрын
Thank you
@exploreyourexcel6 ай бұрын
Please upload part 2, waiting for this one
@datalab3656 ай бұрын
Sure, I will soon.
@master573v35 ай бұрын
Age locale issue -" Go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)"
@tao39643 ай бұрын
keep doing the great work.
@datalab3653 ай бұрын
🙏
@ITGate24h2 ай бұрын
Thank you
@datalab3652 ай бұрын
Thank you. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj
@mudassirkhan2285 ай бұрын
That's really great and to go in deep to explain each and everything is greatly appreciated. Would you mind if I follow and create this to include it in my portfolio.
@datalab3655 ай бұрын
You can use it anywhere.
@adeasemoyosore4 ай бұрын
Bravo Bravo Bravo👍👍❤❤, I Doff my cap for you
@datalab3654 ай бұрын
Thank you.
@arunk55176 ай бұрын
Can you please create a video on Excel bucket list of salary Category wise
@amalahmed20666 ай бұрын
I leik ❤❤
@frednobleman4 ай бұрын
Excellent work done! If I want the dates in my Date Table to start from January 1 and end at December 31, how do I achieve this?
@datalab3654 ай бұрын
Create a month number and use the month number to sort the month in power Pivot. That's all.
@sass13304 ай бұрын
Can i use this for strategic dashboard, i mean by changing the content
@datalab3654 ай бұрын
Yes
@nourreldeenmohamed3676 ай бұрын
Ismila , If I want to buy one of your courses about dashboards on excel Which one you prefer -Interactive Microsoft Excel Dashboard for Data Analyst 2023 Or -Advanced Microsoft Interactive and Dynamic Excel Dashboard
@datalab3656 ай бұрын
Buy the one I have it's link on the description of this video
@nourreldeenmohamed3676 ай бұрын
@@datalab365 Ok I will buy it with ( Interactive Microsoft Excel Dashboard for Data Analyst 2023 that is 28 hours and you made about 10 dashboards) I think both together will be great
@nourreldeenmohamed3676 ай бұрын
I will buy the course you mentioned with (Interactive Microsoft Excel Dashboard for Data Analyst 2023 which is 28 hours and 10 dashboards) I think the both together will be great
@cherubicchild56 ай бұрын
@nourreldeenmohamed367 How did you like the courses? I'm also interested. Would love to know your experience.
@sherril90045 ай бұрын
love it!!!
@datalab3655 ай бұрын
🙏
@herivaldocamargo21986 ай бұрын
Vessoni, o fofoquinha da fiel!
@ahmedshousha9123 ай бұрын
there is something missing at 1:37:53 , when you stopped recording and came back after making the Total revenue connected with the month slicer ?? plz get us the missed point here ! ,, thanks for you efforts 😉
@royarahmatian45413 ай бұрын
Thank you so much
@datalab3653 ай бұрын
You are welcome
@matthewfigueroa8465 ай бұрын
Great videos, thank you! It is very difficult to understand you, it my help to find someone to interpret for you or AI of course. But overall great dashboards!
@datalab3655 ай бұрын
😂😡😭
@YasserAhmedBaharetha4 ай бұрын
Great Lecture Sir, Actually , my excel version is 2016 so it's not shown all options like when you add new column for month name or name of day shown only numbers , is it right ?
@datalab3654 ай бұрын
It has all the options, just check patiently
@krishna62966 ай бұрын
Awesome content. Im became fan of your content. Appreciate your hard work and dedication. I have a question...how do you get dadhboard design ideas?
@datalab3656 ай бұрын
As a data analyst, I work on data every day, creating dashboards/Reports so coming up with design seems natural.
@krishna62966 ай бұрын
@@datalab365got you! Please keep iploading the valuable content. Thank you!
@tao39643 ай бұрын
Tbh. the dashboard design ideas is the most challenging part for me.
@tao39643 ай бұрын
the formula used for formatting the arrow and the percentage looks complex, but this does thesame thing =IF((R14-S14)/S14 > 0, "⬆", "⬇") & TEXT((R14-S14)/S14, "+0.0%;-0.0%")
@saloriasaxon73235 ай бұрын
BRAVO!!!!!
@irtazasaleem791925 күн бұрын
I am using zebra free trial ..wont be i able to use this in future would i have to pay ?
@datalab36525 күн бұрын
Yes
@zaibi0123 ай бұрын
The following DAX formula is invalid: SUMX(facts,RELATED(products_table[Sales Price])*facts[Quantity Sold]) why i am getting this errors, in all the DAX measures???
@mdashraful20896 ай бұрын
How do u connect "Filter by Month" with the "Total Revenue, Total Target & Variance and some other stuff "? 1:40:10 min.
@datalab3656 ай бұрын
What is your question ⁉️ make it clear.
@luckychourasiya72074 ай бұрын
Hii.. this project is good but I'm facing issues at last in Variance it is same colour using conditional formatting
@datalab3654 ай бұрын
Re watch it carefully
@busta00794 ай бұрын
Well Done.. could you show us a Star Schema for football please
@datalab3654 ай бұрын
K
@itrusteddeliveryandlogisti625 ай бұрын
Good morning. I tried uploading the downloaded excel file in power query, and my date column is text character, I tried converting it to data and I couldn't. Please is there anyway I could do that? I am stuck. Thank you.
@datalab3655 ай бұрын
Close it and start all over again. Make sure you open the data in Excel first and convert the date column to date then close and load it to Power Query. I wish it helps.
@GauravguptaL_fin3 ай бұрын
Hey. Its in the error at date part
@jannah-nj7sp5 ай бұрын
Hi, can we send this dashboard to outlook and the reciever can open and navigate with the dashboard?
@datalab3655 ай бұрын
I have done it before
@plantonemore4 ай бұрын
I just started watching this promising lesson, noticed when i select the date of birth column, the age option under date is greyed out. then i figured the date of birth column wasn't formatted as date data type. I tried converting it but it's giving so many errors for date entries. only few converted correctly. please help.
@plantonemore4 ай бұрын
just figured it out. thank you. changed locale to English USA
@datalab3654 ай бұрын
Okay, thank you.
@Adesola_Analyst3 ай бұрын
This video is very interesting and educative. However, you didn't show how you calculated "Qty Returned" and " Total Qty Sold". Please, can show how to calculate them 🙏
@datalab3653 ай бұрын
@@Adesola_Analyst I did. Please, watch the first video
@knowledgeshowhinditv3 ай бұрын
Yes, he has done those calculation.
@herivaldocamargo21986 ай бұрын
Fala Diogão, Augusto melo todo mês tá aprontando uma hein, empréstimo da Arena, reunião com Andres, pelo amor de Deus
@jamesjohnathan44244 ай бұрын
Hello I'm facing an issue while working with dates. It showing me blank whenever I'm putting total revenue against Month any help in this regard?
@datalab3654 ай бұрын
Relationship issues.
@datalab3654 ай бұрын
Make sure there is relationship between your FactTable and the date table
@jamesjohnathan44244 ай бұрын
@@datalab365 Hi thanks for the assistance. However I followed the exact same steps as in the video. But still got an error.
@uchenwodo46036 ай бұрын
Hi, this is a nice job you have done here with excel. However, When i load the fact_table, the date column shows as a text data type. I have tried all i could to transform it but i am not succeeding. When i try to change data type with locale, my laptop hangs. Any help from anyone please?
@master573v35 ай бұрын
I hope not late but i can help, go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)" - cheers
@timileyinanthony57705 ай бұрын
Bro pls us add number format formular you used to format the KPI in the comments 🙏
@mdwamik4095 ай бұрын
Bravo this is real time project?
@datalab3655 ай бұрын
Yes.
@mdwamik4095 ай бұрын
@@datalab365 thanks brother 👍
@ashleymuwi95084 ай бұрын
Can you please share the dataset you used
@datalab3654 ай бұрын
Is in the description box
@victorbuquel2 ай бұрын
I've got this error The following DAX formula is invalid: SUMX(fact_table,RELATED(products_table[Sales Price]) * fact_table[Quantity Sold])
@datalab365Ай бұрын
Check out the data type make sure they are either whole number or decimals. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj
@Amathylar6 ай бұрын
Do you do custom dashboards for businesses?
@datalab3656 ай бұрын
Yes
@Amathylar6 ай бұрын
@@datalab365 Ok, I assume the whatsapp number is the best way to get in touch with you?
@Amathylar6 ай бұрын
@@datalab365 I assume the whatsapp number is the best to get in touch with you?
@ShubhamSharma-d7l4 ай бұрын
I am getting error for month slicer it is not showing target for another months just showing for january
@andruleoladotun94034 ай бұрын
Same issue I am encountering, have you been able to resolve it?
@andruleoladotun94033 ай бұрын
I was able to solve this issue, after a long try.. Make sure the Date format in the monthly target is in English USA... i.e Day/Month/Year... Format it before Querying it.
@onneilemogawane28433 ай бұрын
@@andruleoladotun9403 I experienced the same issue aswell, let me try this Date format to my column.
@ayushsarwankar83373 ай бұрын
Guys help
@ayushsarwankar83373 ай бұрын
@@andruleoladotun9403try your method but not working
@consult210326 ай бұрын
I can't add new column to calculate the age of the customer on power query, the date is showing as parse how can i fix this please.
@datalab3656 ай бұрын
Make sure you convert your date column to date data type
@plantonemore4 ай бұрын
@@datalab365 Please I had the same problem, then I tried converting to date data type and it gave me so many errors on a lot of the date of birth entries. How do I fix these errors please?
@shaikhy1855Ай бұрын
can anyone help me by slicing ttotal target i am getting zero
@TravelTalesbyDisha4 ай бұрын
The data I downloaded in the date column in customers_table, its type is ABC but when I chage its type to date it gives an error. I have tried multiple times but it always gives an error. Any idea how can I fix this issue?
@datalab3654 ай бұрын
Change the region. Your region Date format doesn't match the one on the dataset.
@TravelTalesbyDisha3 ай бұрын
@datalab365 Thank you so much. It worked.
@arsalanahmad10686 ай бұрын
When I try to duplicate column at the very start at 4:34 mins the Date of Birth column doesn't allow me to select Age through the add column section and therefore, I am unbale to move forward :/
@datalab3656 ай бұрын
Convert your date column to date data type. It will work. You can as well use Transform.
@milomalaysia70346 ай бұрын
I get the same problem, after I changed data type to Date, many columns appears "Error", although most of the can be converted successfully.
@seyio61986 ай бұрын
@@milomalaysia7034 right click on the date of birth column, click on change type, then using locale, change data type to date and Locale to English (United states) then ok
@adesugbajerome16666 ай бұрын
How can I create a Microsoft account so I can use zebra bi
@datalab3656 ай бұрын
The same way you create Gmail. Sign up for Outlook or just search on Google for sign up for Microsoft account. Just create one. Is easy.
@monamagdy88525 ай бұрын
Is there an alternative to zebra ?
@datalab3655 ай бұрын
Yes, use charts. One chart for revenue and targets and the other for variance. Just do revenue - Target and have your variance. Just be creative.
@RakeshKumar-cw7gu5 ай бұрын
unable to connect date and order date , order date in fact table to order date in date table
@datalab3655 ай бұрын
Why? Make sure your two dates from the two tables are using date data type. If the data type is wrong from either of the tables it will give you errors. Try it again.🙏
@intovedia.c5 ай бұрын
i can't bring up for age, i tried like there but can't. Why?
@master573v35 ай бұрын
I hope not late but i can help, go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)"
@intovedia.c4 ай бұрын
@@master573v3 Thank You
@Healinggroup24185 ай бұрын
How to install and login wit our personal email
@datalab3655 ай бұрын
Our Microsoft account.
@VISIONVIBES20244 ай бұрын
This is not a fully dashboard video
@datalab3654 ай бұрын
Is 3 parts. I have uploaded them all.
@arindambhattacharya78483 ай бұрын
Why do you have all your dashboards where data has to be loaded in power query/power pivot? You can’t still have simpler ones Also your dashboards doesn’t look like tutorials that explain what your dashboards are for…you just do demo like you a working demo
@datalab3653 ай бұрын
@@arindambhattacharya7848 Really? 😱😂
@arindambhattacharya78483 ай бұрын
@@datalab365 absolutely..please introduce with business concepts and explain what you are doing..a work instruction based demo can be found anywhere
@monamagdy88525 ай бұрын
Thanks for your effort but may i ask u for the reason i found huge blank for total reveneu with store name 4,818,877
@datalab3655 ай бұрын
I don't know. Reload the dataset and start all over you might fix it that way.
@monamagdy88525 ай бұрын
@@datalab365 Thanks for qick response
@monamagdy88525 ай бұрын
@@datalab365 In fact, the problem is with the Fact table. When I download the file, the file does not complete the data in the preview has been truncated due size limts How can i fixed this problem
@inemesitumoh85445 ай бұрын
You might want to take a look at your data model again. Reestablish the relationship between the monthly store target table and the sales person table. This time, you would have to connect the two tables using the Store ID column in the monthly store target table and the Sales Person ID column, instead of the store name column in the sales person table.
@monamagdy88525 ай бұрын
@@inemesitumoh8544 The data model has limition Row 1000 How i Can remove it