Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard

[@akramemrahnejad1476]

in 1:45:47 you can use [Green]▲+0.0%;[Red]▼-0.0%;0.0% in format cells

[@HameezAqeel]

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

[@dennisbalajadia7714]

This is very helpful, and it is easy to understand. Thank you for sharing.

[@datalab365]

Glad it was helpful!

[@MasterBrain182]

Astonishing content Man 💯💯💯 Thanks to share your knowledge with us 🔥🔥

[@datalab365]

Thanks 🙏

[@teresiahkarumba5905]

This is truly amazing. I got to learn alot. Thank you

[@mostafahwafy]

like the design so nice... excited to watch your tips and tricks in this video... thank you for sharing

[@mufasamurife]

Outstanding 🙏

[@datalab365]

🙏

[@alienc5920]

Great job. It gives a lot of useful ideas of "how to". Thank you!!

[@datalab365]

Thank you. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@mohammadsujon124]

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.

[@datalab365]

Sure

[@fernandaycastillo8594]

Will you include this project in your portfolio? You didn't do it!!

[@razeennevarekar9160]

GREAT....EFFORTS.........INSHALLAH YOU BECOME....THE GREAT INSTRUCTOR

[@datalab365]

Thank you

[@fang-wenhsiao2696]

amazing!! thank you

[@menghao4576]

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.

[@tao3964]

keep doing the great work.

[@datalab365]

🙏

[@adeasemoyosore]

Bravo Bravo Bravo👍👍❤❤, I Doff my cap for you

[@datalab365]

Thank you.

[@exploreyourexcel]

Please upload part 2, waiting for this one

[@datalab365]

Sure, I will soon.

[@knowledgeshowhinditv]

Amazing video. This is what I am searching 😊

[@datalab365]

Thank you

[@herivaldocamargo2198]

Vessoni, o fofoquinha da fiel!

[@ITGate24h]

Thank you

[@datalab365]

Thank you. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@sherril9004]

love it!!!

[@datalab365]

🙏

[@krishna6296]

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?

[@datalab365]

As a data analyst, I work on data every day, creating dashboards/Reports so coming up with design seems natural.

[@krishna6296]

​@@datalab365got you! Please keep iploading the valuable content. Thank you!

[@tao3964]

Tbh. the dashboard design ideas is the most challenging part for me.

[@mudassirkhan228]

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.

[@datalab365]

You can use it anywhere.

[@matthewfigueroa846]

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!

[@datalab365]

😂😡😭

[@jayakaranam]

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?

[@royarahmatian4541]

Thank you so much

[@datalab365]

You are welcome

[@frednobleman]

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?

[@datalab365]

Create a month number and use the month number to sort the month in power Pivot. That's all.

[@amalahmed2066]

I leik ❤❤

[@master573v3]

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)"

[@ahmedshousha912]

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 😉

[@sass1330]

Can i use this for strategic dashboard, i mean by changing the content

[@datalab365]

Yes

[@nourreldeenmohamed367]

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

[@datalab365]

Buy the one I have it's link on the description of this video

[@nourreldeenmohamed367]

​@@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

[@nourreldeenmohamed367]

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

[@cherubicchild5]

​@nourreldeenmohamed367 How did you like the courses? I'm also interested. Would love to know your experience.

[@hebamahfouz5129]

alot of thanks , i have an issue that when i made atext box besides total revenue and make =the value of the total revenue from sheet analyss 01 , it make error , how can i solve it

[@saloriasaxon7323]

BRAVO!!!!!

[@tao3964]

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%")

[@arunk5517]

Can you please create a video on Excel bucket list of salary Category wise

[@YasserAhmedBaharetha]

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 ?

[@datalab365]

It has all the options, just check patiently

[@mdwamik409]

Bravo this is real time project?

[@datalab365]

Yes.

[@mdwamik409]

@@datalab365 thanks brother 👍

[@mdashraful2089]

How do u connect "Filter by Month" with the "Total Revenue, Total Target & Variance and some other stuff "? 1:40:10 min.

[@datalab365]

What is your question ⁉️ make it clear.

[@arsalanahmad1068]

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 :/

[@datalab365]

Convert your date column to date data type. It will work. You can as well use Transform.

[@milomalaysia7034]

I get the same problem, after I changed data type to Date, many columns appears "Error", although most of the can be converted successfully.

[@seyio6198]

@@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

[@Amathylar]

Do you do custom dashboards for businesses?

[@datalab365]

Yes

[@Amathylar]

@@datalab365 Ok, I assume the whatsapp number is the best way to get in touch with you?

[@Amathylar]

@@datalab365 I assume the whatsapp number is the best to get in touch with you?

[@itrusteddeliveryandlogisti62]

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.

[@datalab365]

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.

[@jannah-nj7sp]

Hi, can we send this dashboard to outlook and the reciever can open and navigate with the dashboard?

[@datalab365]

I have done it before

[@jamesjohnathan4424]

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?

[@datalab365]

Relationship issues.

[@datalab365]

Make sure there is relationship between your FactTable and the date table

[@jamesjohnathan4424]

@@datalab365 Hi thanks for the assistance. However I followed the exact same steps as in the video. But still got an error.

[@busta0079]

Well Done.. could you show us a Star Schema for football please

[@datalab365]

K

[@irtazasaleem7919]

I am using zebra free trial ..wont be i able to use this in future would i have to pay ?

[@datalab365]

Yes

[@plantonemore]

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.

[@plantonemore]

just figured it out. thank you. changed locale to English USA

[@datalab365]

Okay, thank you.

[@Adesola_Analyst]

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 🙏

[@datalab365]

@@Adesola_Analyst I did. Please, watch the first video

[@knowledgeshowhinditv]

Yes, he has done those calculation.

[@ShubhamSharma-d7l]

I am getting error for month slicer it is not showing target for another months just showing for january

[@andruleoladotun9403]

Same issue I am encountering, have you been able to resolve it?

[@andruleoladotun9403]

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.

[@onneilemogawane2843]

@@andruleoladotun9403 I experienced the same issue aswell, let me try this Date format to my column.

[@ayushsarwankar8337]

Guys help

[@ayushsarwankar8337]

@@andruleoladotun9403try your method but not working

[@consult21032]

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.

[@datalab365]

Make sure you convert your date column to date data type

[@plantonemore]

@@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?

[@zaibi012]

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???

[@uchenwodo4603]

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?

[@master573v3]

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

[@ashleymuwi9508]

Can you please share the dataset you used

[@datalab365]

Is in the description box

[@luckychourasiya7207]

Hii.. this project is good but I'm facing issues at last in Variance it is same colour using conditional formatting

[@datalab365]

Re watch it carefully

[@victorbuquel]

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

[@herivaldocamargo2198]

Fala Diogão, Augusto melo todo mês tá aprontando uma hein, empréstimo da Arena, reunião com Andres, pelo amor de Deus

[@timileyinanthony5770]

Bro pls us add number format formular you used to format the KPI in the comments 🙏

[@TravelTalesbyDisha]

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?

[@datalab365]

Change the region. Your region Date format doesn't match the one on the dataset.

[@TravelTalesbyDisha]

@datalab365 Thank you so much. It worked.

[@GauravguptaL_fin]

Hey. Its in the error at date part

[@adesugbajerome1666]

How can I create a Microsoft account so I can use zebra bi

[@datalab365]

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.

[@intovedia.c]

i can't bring up for age, i tried like there but can't. Why?

[@master573v3]

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.c]

@@master573v3 Thank You

[@monamagdy8852]

Is there an alternative to zebra ?

[@datalab365]

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.

[@shaikhy1855]

can anyone help me by slicing ttotal target i am getting zero

[@Healinggroup2418]

How to install and login wit our personal email

[@datalab365]

Our Microsoft account.

[@RakeshKumar-cw7gu]

unable to connect date and order date , order date in fact table to order date in date table

[@datalab365]

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.🙏

[@VISIONVIBES2024]

This is not a fully dashboard video

[@datalab365]

Is 3 parts. I have uploaded them all.

[@ZakiaAhmed-y9l]

The speaking accent was not clear to me at all. I faced problems to understand the explanations. Also i felt the speaker did not explain to deeply where he should have

[@datalab365]

@@ZakiaAhmed-y9l before you condemn someone accent check your sentences 😝😱

[@arindambhattacharya7848]

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

[@datalab365]

@@arindambhattacharya7848 Really? 😱😂

[@arindambhattacharya7848]

@@datalab365 absolutely..please introduce with business concepts and explain what you are doing..a work instruction based demo can be found anywhere

[@monamagdy8852]

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

[@datalab365]

I don't know. Reload the dataset and start all over you might fix it that way.

[@monamagdy8852]

@@datalab365 Thanks for qick response

[@monamagdy8852]

​@@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

[@inemesitumoh8544]

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.

[@monamagdy8852]

@@inemesitumoh8544 The data model has limition Row 1000 How i Can remove it