![MaKuData](/img/default-banner.jpg)
- 23
- 97 003
MaKuData
Registrace 9. 06. 2023
Welcome to MaKuData, your professional hub for Data mastery! I primarily work with Python and Excel - and everything in between.
Join me as I delve into the world of Data analysis and uncover the secrets of creating impressive visualizations. My tutorials will equip you with the skills to present data effectively and make informed decisions.
In addition to this channel's content, I also offer personalized services to meet your specific needs. If you're looking to take your data visualization to the next level, or need me to teach you some covered concepts, I am here to help. Just write me an email at makunadata@gmail.com and I'll get back to you!
And don't forget to check out my shop where I list my Templates: makudata.etsy.com
Join me as I delve into the world of Data analysis and uncover the secrets of creating impressive visualizations. My tutorials will equip you with the skills to present data effectively and make informed decisions.
In addition to this channel's content, I also offer personalized services to meet your specific needs. If you're looking to take your data visualization to the next level, or need me to teach you some covered concepts, I am here to help. Just write me an email at makunadata@gmail.com and I'll get back to you!
And don't forget to check out my shop where I list my Templates: makudata.etsy.com
Slicers in Google Sheets - all you need to know and more
Let's talk about Google Sheets slicers. If you're having problems understanding how they work, how to manipulate connections or how to customize their functionality - this is the video for you!
Here's the link to my etsy shop where you can purchase some of my templates: makudata.etsy.com
Contact me for custom dashboard requests at makunadata@gmail.com
Timestamps:
0:00 Introduction
0:56 Slicer Logic
3:15 Manipulating Slicer's Source Data
8:11 Slicer Data Connections
Here's the link to my etsy shop where you can purchase some of my templates: makudata.etsy.com
Contact me for custom dashboard requests at makunadata@gmail.com
Timestamps:
0:00 Introduction
0:56 Slicer Logic
3:15 Manipulating Slicer's Source Data
8:11 Slicer Data Connections
zhlédnutí: 128
Video
Interactive Google Sheets Dashboard in just 20 minutes
zhlédnutí 327Před měsícem
In this video, I'll demonstrate how to use and create an interactive Google sheets dashboard with gradient backgrounds Here's the link to the Dashboard in the video: docs.google.com/spreadsheets/d/1eEmwrWN58R8SnfkHNABskC_AdJZEHNJ8h3woIKDgn_0/edit?usp=sharing Here's the link to my etsy shop where you can purchase some of my templates: makudata.etsy.com Contact me for custom dashboard requests at...
Custom Google Sheets Calendar: Easy Daily Habit Tracking
zhlédnutí 206Před 2 měsíci
Create a custom google sheets calendar / habit tracker or download my template for free: docs.google.com/spreadsheets/d/1LLGGpttjAw6K8rq3Q7-i0ncumJehdg5VfVdqjTJSPRI/edit?usp=sharing Here's the link to my etsy shop where you can purchase some of my templates makudata.etsy.com Contact me for custom dashboard requests at makunadata@gmail.com
Introduction to Power BI and its capabilities
zhlédnutí 316Před 6 měsíci
In this video, I demonstrate my favorite capabilities of Power BI that I've discovered so far. I'm planning on creating tutorials on Power BI in the nearest future, so stay tuned for that! Here's the link to my etsy shop where you can purchase my Google Sheets templates: makudata.etsy.com Contact me for custom dashboard requests at makunadata@gmail.com
Plotting Maps and Geospatial Data in Google Sheets - My 3 Methods
zhlédnutí 699Před 7 měsíci
In this video, I'll show you my three methods of creating maps and displaying geographical data in Google Sheets. The method you'll choose depends on the data you're using. If it's countries or states - use Method 1 (The GOOD), if it's more specific - like regions or zipcodes - use Method 2 (The BAD), if it's very specific or not even real - use Method 3 (The UGLY). Here's the link to my etsy s...
Google Sheets Personal Finance Tracker Dashboard - Showcase and Tutorial
zhlédnutí 8KPřed 7 měsíci
In this video, I'll demonstrate how to use and create an interactive Google sheets personal finance tracker. Here's the link to my etsy shop where you can purchase this Template: makudata.etsy.com Contact me for custom dashboard requests at makunadata@gmail.com Timestamps: 0:00 Template showcase and introduction 5:35 Data preparation 14:50 Linechart 24:45 Barchart 30:15 Doughnut charts 39:30 Bo...
Interactive Google Sheets Dashboard Tutorial: Worker Management
zhlédnutí 14KPřed 8 měsíci
In this video, I'll demonstrate how to create an interactive Google sheets dashboard. Here's the link to my etsy shop where you can purchase my templates: makudata.etsy.com If you want to play around with the dashboard, here's a link to the dataset: docs.google.com/spreadsheets/d/1lQ2ym28gaLOg4dgeZYIrkJDz6vpk3i4R9K0rq8fgBXQ/edit?usp=sharing Contact me for custom dashboard requests at makunadata...
Solving Python Data Analysis Interview Questions - Apple
zhlédnutí 236Před 8 měsíci
In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question. If you have any questions or feedback regarding this content, please let me know in the comments or you can contact me directly via email: makunadata@gmail.com My solution to the problem: Apple product counts: df = playbook_events.merge(...
Solving Python Data Analysis Interview Questions - Airbnb
zhlédnutí 70Před 9 měsíci
In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question. If you have any questions or feedback regarding this content, please let me know in the comments or you can contact me directly via email: makunadata@gmail.com My solutions to the mentioned questions are: City With Most Amenities: df = a...
Solving Python Data Analysis Interview Questions - Microsoft
zhlédnutí 218Před 9 měsíci
In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question. If you have any questions or feedback regarding this content, please let me know in the comments or you can contact me directly via email: makunadata@gmail.com My solution to the mentioned question is: Premium vs Freemium: df = ms_downlo...
Solving Python Data Analysis Interview Questions - Google
zhlédnutí 53Před 9 měsíci
In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question. If you have any questions or feedback regarding this content, please let me know in the comments or you can contact me directly via email: makunadata@gmail.com My solution to the mentioned question is: Activity Rank: df = google_gmail_em...
Exploratory Data Analysis with Python and Pandas - Analyzing Chess Games
zhlédnutí 555Před 9 měsíci
Exploratory Data Analysis with Python and Pandas - Analyzing Chess Games
Exploratory Data Analysis with Python and Pandas - Analyzing Pizza Restaurant's Data
zhlédnutí 488Před 9 měsíci
Exploratory Data Analysis with Python and Pandas - Analyzing Pizza Restaurant's Data
Introduction to Excel Pivot Tables: Company Data Analysis
zhlédnutí 222Před rokem
Introduction to Excel Pivot Tables: Company Data Analysis
Top 10 Essential Excel Beginner Concepts (Part 2)
zhlédnutí 205Před rokem
Top 10 Essential Excel Beginner Concepts (Part 2)
Top 10 Essential Excel Beginner Concepts (Part 1/2)
zhlédnutí 279Před rokem
Top 10 Essential Excel Beginner Concepts (Part 1/2)
Interactive Google Sheets Dashboard Tutorial: Company Sales Data
zhlédnutí 64KPřed rokem
Interactive Google Sheets Dashboard Tutorial: Company Sales Data
Interactive Excel dashboard tutorial: Company employee data.
zhlédnutí 5KPřed rokem
Interactive Excel dashboard tutorial: Company employee data.
Where you used a Text Box to add the chart title 'CITY ORDER HISTORY', you can instead merge the cells and then type in the text in the merged cells. Output will be the same but that way you will be able to edit the content later.
Absolute banger!!
great tutorial
Wonderful, thank you
sir can you make a video on bookkeeping of accounts in Google sheets
are you copy pasting pivot tables from pivot table sheet to dashboard as values or pivot table? If you are doing it as values, how this dashboard can be dynamic when the data is static?
I'm copying them as pivot tables, otherwise it would be as you said.
Does the dashboard update with new data entries or its just static?
It's live. Whatever new data is populated in the data table, Google Sheets automatically updates all related pivot tables and their linked visualizations.
Very good. But probably if I am using Google Sheets it is because I don't have Excel 😅
That is a very good point 😅 Although the elements can be copied from anywhere, doesn't have to be Excel.
how to query from multiple sheets ?
This is brilliant! Thanks for sharing. Is it possible to use something like this as a client dashboard? I am dealing in education and am interested in a Dashboard like this for Parents to see their student(s) data. I wonder if it could be manageable even when dealing with 100's of students? I also wonder if a paywall could be introduced for access? Thank you for your advice as I continue to hunt for the best solution!
Thanks for reaching out. Drop me a line at my email and we'll continue from there. makunadata@gmail.com
Thanks sir for teaching lots of things 🙏🇮🇳
Очень хорошее видео. Наверное такая работа стоит не менее 1000 $
The other day I tried to go to a small dusty town about an hour away from my home. They refused me entry when I asked why they said,’ 37:40 .‘
lol
I'm having trouble inserting slicers. If I filter a value in the slicer, it filters those rows from the sheet and affects the charts in the sheet. Please help.
.
.
Can I lock the charts to prevent movement to other place.
Soylent Green : What is good for people, is people ;) and I am upset that I did not hear one kurwa once or a can of beer opened !!! work looks fantastic, will come back here druga
Thank you friend. The reason why you didn't hear any kurwa's is simple - I'm not polish, just your northern neighbor :)
@@MaKuData oh you are from srbija? nema problema :) hey i am going to be a data analyst, starting my education end of summer. any recommendations what to learn now before it starts, u know I want to focus now. excel/goo.sheets -> sql -> tableau/powerBI -> python is that correct? peace
Love it! More tutorials please. Learning a lot !
Thanks. More coming in!
Thanks for the video. Your demonstration is phenomenal !!
Appreciate the kind words!
Nice desing. ¡Great Job!
Thank you! Cheers!
Try to figure out how to create a map geo chart in google sheet and then I found this video. It is very useful! Thank you for sharing.
Glad it was helpful!
Great. I learned a lot from this✨️
Glad it was helpful!
I was looking for actual interaction like multimedia, where it moves with mouse over.
This sort of interaction can only be observed when hovering the mouse over the visualizations. It will display the exact data labels and points hover over.
thank you..looking forward to learn more from you
My pleasure and stay tuned for more!
need more google sheets tutorial like this. Keep it up
Thanks, will do!
Hello, I discovered your channel last night and think it’s very informative, keep up the good work! I am new to dashboards and have to make one for my apprenticeship, I tried your tip of copying shapes from Excel to sheets, however it does not seem to work. I click copy in excel and then paste in sheets however the results are blank - do you know why this is happening?
Thanks for the feedback. Make sure that you don't have any cells copied. Any local Google Sheets copies overwrite the memory slot, which you want allocated for the excel elements. In other words, try closing the Google Sheet and re-opening it again. Once it's open, boot up your Excel workbook and try copying it. If it doesn't work, let me know and we'll try to figure out something else.
@@MaKuData thank you :)
Thanks for content, MaKuData!
My pleasure!
dataset link ?
Added to the description.
Awesome content
Thanks!
Sir please make it inventory
Could you elaborate?
Like for manufacturing unit
@@shivusagar1059 Feel free to contact me via my email provided in the description for any custom inquiries.
Can this method be applied to google sheets?
Depends on the method you're referring. I'd recommend checking out my other videos where I specifically work with Google Sheets.
Awesome content! More google sheets dashboard please. 😊
You skipped over he most important and interesting part. How did you determine the X/Y coordinates. You just "prepared them" how? Trial and error on the live map?
Exactly. 1. I paste the whole scaled map, the same size as I want it to be in the visualization. 2. On top of the map, I paste over the bubble chart with 4 color points to have distinct colors. 3. The 10/10 on the X/Y axes at the bottom are there to set the upper limit of the scale (so it goes from 0 to 10) 4. The -5 does the same thing, determines the lower limit. 5. For each city, I just keep increasing the value on one axis, until it reaches the correct position, then I do it for the other axis. 6. Rinse and repeat for all points.
can you provide videos for this pls? thank you
Just released a video on this topic, you can go check it out: czcams.com/video/XZgMZFxo49o/video.html
Interesting 🤔 where should a beginner (with basic Python knowledge) start from if he wants to learn Pandas?
I can only speak from personal experience - I bought two udemy courses, $12 each. One for python, one for pandas. I learned everything I needed to be able to start doing my own research and projects. If you're interested, I can let you know the exact courses I got.
@@MaKuData Thank you! I have a done a Python course from Udemy around 2 years ago and before that we learnt it in college as well. For Pandas I had a PDF book (from O'reilley I think) that I was practising from few months ago in conjunction with YT videos, but it was intermittent. I think I will resume that. I did NumPy a bit too (perused its online documentation); SK Learn, Seaborn just cursorily done through some YT videos. Fascinating stuff. I did all this in Google Colab. :)
25:30 onward proved entire exercise futile (what a nuisance adding slicers and then changing all cell ranges in dashboard tab ... basically re-doing a lot of work). At the end, the rounded rectangle is eclipsing my slicers totally again and again i.e. when I drag and drop all slicers on the rectangle and click outside the rectangle anywhere, the rectangle comes to the fore hiding all the 4 slicers underneath itself.
Even in fullscreen mode at 720p resolution setting, I can not clearly see what you have been inputting in the cells. :( Hate to not reap this fantastic video fully.
Hate to hear that. Noted. If you have any specific questions, feel free to either to ask them here or contact me directly at my email.
@@MaKuData You've explained everything excellently. No questions or doubts about the content. :) Actually the onus is on me to get a bigger screen but I can't afford one so making do with my laptop. Also, I am not getting Poland's transparent map free online. Do I have to download a regular map and then try to remove its background? EDIT: I solved the map issue but had to abandon watching after 18:40. Way too rushed to keep up. Screen nowhere zoomed in for clearer view. There are tons of other similar good tutorials that are 40 to 50 minutes long and are very lucid. You have great content but the rushing ruined overall experience especially when you dealt with map portion. Whatever work you have covered in this video, it was certainly done in more than 28 minutes (the length of video) by you. Anyway good luck for your future videos.
Thank you for your honest critique@@echodelta7680 . I am trying to be more elaborate in my future videos!
@@MaKuData Rest of your videos are all cool. I guess it was just a bad day for me yesterday, though I did manage to accomplish 99% of what you explained in this video. Forgot to subscribe yesterday, but now you've gained one. Honestly, when I began watching this video, I was surprised you didn't already have hundreds of thousands of subs, but then I guess it's been only a short while for your content here.
@@echodelta7680 The thing is, it's the only video that is viewed. All others are more on the data analysis side. But anyways, appreciate your sub and I hope you'll check out my other videos.
Puikus darbas!
Ačiū! Kaip šachmatistas, tikiuosi kažką naujo sužinojot :)
Absolute crazy content
Thank you for the kind words!
Ty bo. good video
Thanks!
I want to know version excel to do that. Hope you answer
Thank you for the comment. As mentioned in my video, this dashboard is made in the newest Excel version Microsoft365. However, most of the features should be available on older versions as well.
@@MaKuData Thank you very much, waiting for some more dashboard. It's very useful
Awesome Maku please made some more amazing dashboard
Thank you. I'm definitely planning to make some more.
Thank you for sharing and your effort
My pleasure!
It's impressive. Thank you for sharing this!
My pleasure.
Insane Marius!! Insane!! 🤯🫡
Amazing,!!!!!!!
Cheers!
Nice! It would be even better if you shared the database so people can follow along. Will have to try this out with one dataset of my own and see how it turns out !
Thanks for the comment! I've added a link to the original dataset in the video's description and made it public. Tell me if it works.
This is great and I love how you break it down. How do you lock the dashboard so that users are only able to change the slicers and unavailable to delete the charts?
Thanks for the kind words. That's actually pretty simple. In the data tab, click protect sheets and ranges. Then add a sheet or a range. Here, you can select to either protect a specific range or the whole sheet. I would recommend clicking the whole sheet option. From there, select the "Except certain cells" and select all the cells that the slicer is a part of. Everything else will be locked.