Hi Chando, I am from Nigeria and I appreciate the great work you put in attempt to educate lots of people across the world. However, I would like to know the possibility of creating such map for countries like Nigeria, or even a local government area in Nigeria?
Which version of excel is needed for this map insert ? I am using win 32 & excel version - professional 2016. It shows "this chart isn't available in your version of excel"
Hi chandoo, I have around 6500 xml files and each xml file contains some data for healthcare claims. I want to load this xml files into one single excel file how I can do it. It tried using Powerquery but it gives me only 6500 rows with names of each xml file. Please help me to do this
Hi Hussain Ji, U can try this. 1. Using Excel's Import Data Feature: a. Open Excel and go to the "Data" tab. b. Click on "From XML" in the "Get External Data" section. c. Browse and select the first XML file you want to import. d. Excel will display a preview of the XML structure. Adjust any import options if needed. e. Click "OK" to import the data into Excel. f. Repeat steps c to e for each XML file you want to import. Each file will be imported into a separate worksheet. 2. U can use script or programming like VBA or Python, the latter will be the best. I hope U'll be able to solve UR situation.
How can we make dashboards / visualisations with the help of AI in just 2 minutes ? Also, please make some videos about PowerPoint presentation, m.s.word as well...using AI.
Sir , recently i got an offer as a business intelligence analyst, i always wanted to be a data scientist and i have done courses , is it advisable to start my career as business intelligence analyst . The company use jedox for analysis not python or r
Sir i VLOOKUPed some data and I need the link of that amount from where that amount is came, as that we know that CTRL+[ take up us to the link of that amount since when we manually put the formulas like =to the cell we click we want ,then when we click CTRL+[ thereby they take up us to the AMOUNT but when we Vlookup and check for link by clicking CTRL+[ they take up us to the LOOKUP VALUE but I NEED TO GET THE CELL REFERENCE OF THAT AMOUNT we Lookuped by Clicking CTRL+[ .Is there any solution for that Sir,really urgent sir .If u provide the idea it will be a great help for me.
If you are using XLOOKUP, you can try =CELL("address", XLOOKUP(your_lookup_formula)) VLOOKUP doesn't return references. So another option is to use INDEX MATCH which can return references and then pass the result to CELL like above.
🤫 Shh.. don't tell that to flat-earthers. On a more serious note, check if the state names have any invisible characters or spaces? Also try adding country column and make the chart.
Hi Chandoo, I wanted to create a map for the districts of a state in India. I am getting the state but not able to see the districts/cities. Would it be possible to create a map with the cities of a state. Please advise. Thank you
NZ maps are a nightmare. Especially when using pbi. The stats nz variables keep changing. Getting a list of meshblocks and matching area units and meshblock and the Stat Areas 1 and 2 and with census 2023 Stat area 3 being introduced, I tremble in fear.
I got settled in for my NZ nightmare today. First I tried to add a map using regions. No dice. Then I pulled some recent crime data by district (because it was right in front of me) and SUCCESS! I was really happy. So I rolled my regions into districts, which were a better view anyway. I was lucky I had districts.
The built-in maps are not customizable. But if you have a floor plan or something and want to show occupancy rates, you can create the layout in Excel and use conditional formatting to show that. Takes a bit of work, but the results can be beautiful. See this for an example - chandoo.org/wp/customer-satisfaction-scorecard/
Hello Chandoo, thank you for this video very helpful! On my map, could I colour each country/state with the colour of my choice or does it have to be a gradient colour always indicating the comparison between values/numbers (e.g., sales?). I would like for example to mark some countries in blue (where we do business) and some in red (where we have offices) etc. Is that possible in Excel? Thank you.
If you just want two colors (blue and red), you can still use the gradient option. Set up countries in A1:A10 and doing business in B1:B10, set the value in column B as 1 for doing business and 0 for not. Then create the graph, set the gradient from RED to BLUE with boundary values as 0 and 1. This will automatically color code the graph as you want.
I don't think they are possible at this time. Zipcodes are not technically areas. They are postal delivery zones. So it is possible for one side of a street to have one zip code and the other side a different code.
Hi Chando, I am from Nigeria and I appreciate the great work you put in attempt to educate lots of people across the world. However, I would like to know the possibility of creating such map for countries like Nigeria, or even a local government area in Nigeria?
Good question
I have two questions:
1.does data engineer need a good communication skill, and be good at math?
2.can work as freelancer as data engineer?
Thanks
Hey thanks for this awesome video can we have the excel 3D Map please
After watching *Code basics Hindi* channel I am here
Which version of excel is needed for this map insert ?
I am using win 32 & excel version - professional 2016.
It shows "this chart isn't available in your version of excel"
Hi Chandoo, thanks. The different map types are visible if you project the globe, say world. On Linkend in learning there is a course of #René Martin
I learn a lot from your channel, thank you.
Hi Chando , I am from France you are doing great help for our carrier growth according to your videos I changed my working pattens,thank u so much 😊
Hi chandoo, I have around 6500 xml files and each xml file contains some data for healthcare claims.
I want to load this xml files into one single excel file how I can do it.
It tried using Powerquery but it gives me only 6500 rows with names of each xml file.
Please help me to do this
Hi Hussain Ji, U can try this.
1. Using Excel's Import Data Feature:
a. Open Excel and go to the "Data" tab.
b. Click on "From XML" in the "Get External Data" section.
c. Browse and select the first XML file you want to import.
d. Excel will display a preview of the XML structure. Adjust any import options if needed.
e. Click "OK" to import the data into Excel.
f. Repeat steps c to e for each XML file you want to import. Each file will be imported into a separate worksheet.
2. U can use script or programming like VBA or Python, the latter will be the best.
I hope U'll be able to solve UR situation.
Thanks for the video Chandoo, very cool!
Why isn't each city name showing in your Ohio map? I want my city names to show. How do I do this?
How can we make dashboards / visualisations with the help of AI in just 2 minutes ?
Also, please make some videos about PowerPoint presentation, m.s.word as well...using AI.
Hello Chandoo, I want to visualise two metrics in a filled map ? Is it possible to do it with Excel ?
Sir , recently i got an offer as a business intelligence analyst, i always wanted to be a data scientist and i have done courses , is it advisable to start my career as business intelligence analyst . The company use jedox for analysis not python or r
You have been my mentor from the starting I request UA-cam please help me in this problem. How to change the text into date format
When we create 3d map Australia doesn't appeared, do you know whats the reason?
Sir i VLOOKUPed some data and I need the link of that amount from where that amount is came, as that we know that CTRL+[ take up us to the link of that amount since when we manually put the formulas like =to the cell we click we want ,then when we click CTRL+[ thereby they take up us to the AMOUNT but when we Vlookup and check for link by clicking CTRL+[ they take up us to the LOOKUP VALUE but I NEED TO GET THE CELL REFERENCE OF THAT AMOUNT we Lookuped by Clicking CTRL+[ .Is there any solution for that Sir,really urgent sir .If u provide the idea it will be a great help for me.
If you are using XLOOKUP, you can try
=CELL("address", XLOOKUP(your_lookup_formula))
VLOOKUP doesn't return references. So another option is to use INDEX MATCH which can return references and then pass the result to CELL like above.
Replace chocolate 🎉
I plotted the data the same, but it shows it on the "flat earth" map and not just the state :(
🤫 Shh.. don't tell that to flat-earthers.
On a more serious note, check if the state names have any invisible characters or spaces? Also try adding country column and make the chart.
Hi Chandoo, I wanted to create a map for the districts of a state in India. I am getting the state but not able to see the districts/cities. Would it be possible to create a map with the cities of a state. Please advise. Thank you
As of now, Excel maps do not support Indian districts. May be in future?
is this applicable to every city around the world?
NZ maps are a nightmare. Especially when using pbi. The stats nz variables keep changing. Getting a list of meshblocks and matching area units and meshblock and the Stat Areas 1 and 2 and with census 2023 Stat area 3 being introduced, I tremble in fear.
That is right. I wanted to make this example with NZ data but it looked pathetic. So went with Ohio data.
I got settled in for my NZ nightmare today. First I tried to add a map using regions. No dice. Then I pulled some recent crime data by district (because it was right in front of me) and SUCCESS! I was really happy. So I rolled my regions into districts, which were a better view anyway. I was lucky I had districts.
Is this customizable? Meaning can I create my own map? For example, a map of an acute care hospital unit? No reason why I'm so specific 😂
The built-in maps are not customizable. But if you have a floor plan or something and want to show occupancy rates, you can create the layout in Excel and use conditional formatting to show that. Takes a bit of work, but the results can be beautiful. See this for an example -
chandoo.org/wp/customer-satisfaction-scorecard/
@@chandoo_ thank you chandoo. Love your channel
Can you do some A/B testing example ??
I am worring chatgpt replace data analyst
Hello Chandoo, thank you for this video very helpful! On my map, could I colour each country/state with the colour of my choice or does it have to be a gradient colour always indicating the comparison between values/numbers (e.g., sales?). I would like for example to mark some countries in blue (where we do business) and some in red (where we have offices) etc. Is that possible in Excel? Thank you.
Unfortunately, it can only be a gradient color.
@@chandoo_ too good to be true...! Thank you so much for the quick reply, much appreciated!
If you just want two colors (blue and red), you can still use the gradient option. Set up countries in A1:A10 and doing business in B1:B10, set the value in column B as 1 for doing business and 0 for not. Then create the graph, set the gradient from RED to BLUE with boundary values as 0 and 1. This will automatically color code the graph as you want.
@@chandoo_ oh wow, would not have thought of that (I am not an excel person obviously!😅) Thank you so much! 🙏
Thanks, that was easy!
Is there a way to make a map using zip codes?
I don't think they are possible at this time. Zipcodes are not technically areas. They are postal delivery zones. So it is possible for one side of a street to have one zip code and the other side a different code.
@chandoo_ thank you:)!
MAPS … they’re everywhere 😔
would like watch again and again.
map is not showing in my excel ...pls help
you might have an old version of excel. I had the same problem