- 275
- 799 371
Matador Software
Приєднався 26 чер 2021
print("Hello World!")
I'm a passionate Business Intelligence Developer, focusing on the mutual strength of Data, SQL, Power BI & Python to make data driven decisions and Improve lives! Over anything, I strongly believe in the power of self-learning and empowering others!
If you want to get in touch regarding any Business Intelligence or Data enquiries, you can reach me via my website:
www.matadorsoftware.me/
I'm a passionate Business Intelligence Developer, focusing on the mutual strength of Data, SQL, Power BI & Python to make data driven decisions and Improve lives! Over anything, I strongly believe in the power of self-learning and empowering others!
If you want to get in touch regarding any Business Intelligence or Data enquiries, you can reach me via my website:
www.matadorsoftware.me/
Two Ways to Automatically Open Windows Folders with Python
In this short, two minute tutorial, I showcase two different methods that will allow you to automatically open your Windows explorer folders using Python. We'll begin with a short and sweet method, and then building in the concept of try except blocks for a more realistic method of error handling.
Enjoy!
🤝 Want 1:1 mentorship, data career guidance or interview prep?
topmate.io/james_andrew_matad...
🤝 Connect with me on LinkedIn:
www.linkedin.com/in/ja376
Enjoy!
🤝 Want 1:1 mentorship, data career guidance or interview prep?
topmate.io/james_andrew_matad...
🤝 Connect with me on LinkedIn:
www.linkedin.com/in/ja376
Переглядів: 2 594
Відео
Tackle This Data Analysis SQL Interview Question with the Except Operator
Переглядів 331Рік тому
In this tutorial, I cover the except operator in SQL, how this can be used to tackle a data analysis based interview problem, RBMS that support the operator, it's origins in set theory (set difference), a custom venn diagram and a worked example. Enjoy! 🤝 Want 1:1 mentorship, data career guidance or interview prep? topmate.io/james_andrew_matad... 🤝 Connect with me on LinkedIn: www.linkedin.com...
Kivy Builder & Changing Window Colour- Creating Modern GUIs & Apps with Python Kivy Tutorial #6
Переглядів 993Рік тому
Check out the sixth tutorial in this Python Kivy series, where we explore a vital class: the Kivy builder- responsible for loading and parsing Kivy language files, allowing us to explicitly separate the design of the user interface from the logic of the application, following the principle of separation of concerns. I'll also include a handy (and sometimes hard to find) tip for changing the win...
Building a Dynamic Form with Grid Layout- Creating Modern GUIs & Apps with Python Kivy Tutorial #5
Переглядів 1,1 тис.Рік тому
Check out the fifth tutorial in this Python Kivy series, where we explore another hugely common layout, the Grid Layout. We'll use this as a basis to create an employee GUI that stores passwords and prints details to the console- further building on concepts learned in episodes before. In the next episode we'll look into the Kivy Builder and other helpful tips and tricks. Enjoy! 🤝 Want 1:1 ment...
Sizing & Positioning Widgets- Creating Modern GUIs & Apps with Python Kivy Tutorial #4
Переглядів 841Рік тому
Check out the fourth tutorial in this Python Kivy series, where we explore a fundamental but hugely important building block of our app development: sizing & positioning widgets within our Kivy design language file. We'll cover a common roadblock, different methods of sizing, positioning and helpful tips along the way! In the next episode we'll further dissect layouts & our fundamental building...
Better Code with the Kv Design Language- Creating Modern GUIs & Apps with Python Kivy Tutorial #3
Переглядів 1,1 тис.Рік тому
Check out the third tutorial in this Python Kivy series, where we explore coding the design in our main Python file vs adhering to good practice and breaking apart our design code into a Kv design language file. I'll also gently break into some other concepts such as spacing and setting RGBA colours. In the next episode we'll further dissect layouts & our fundamental building blocks, as we move...
SQL Server for Beginners | A Complete Guide | Theory, Set Up, Practice Datasets & Querying
Переглядів 1,3 тис.Рік тому
A complete guide to SQL for beginners: this tutorial can act as a one stop shop for understanding SQL background, how to actually start writing SQL in a database management system, getting a huge array of free data that simulates real world datasets & data models and learning the core and most widely used SQL querying functionality, as well as creating your own tables. The specific areas I cove...
Box Layout, Input Boxes & Buttons- Creating Modern GUIs & Apps with Python Kivy Tutorial #2
Переглядів 2 тис.Рік тому
Check out the second tutorial in this Python Kivy series, where we'll advance from the basic single label/ text widget GUI that we created in episode 1. We introduce two new widgets and a new layout, in order to create a sleeker and more dynamic GUI that responds to click/ touch events. In the next episode we'll further dissect widgets & layouts. Enjoy! 🤝 Want 1:1 mentorship, data career guidan...
Kivy Set-Up & Creating Your First GUI- Creating Modern GUIs & Apps with Python Kivy Tutorial #1
Переглядів 6 тис.Рік тому
Check out the first tutorial in this extensive Python Kivy GUI & App series. In this episode we'll look at an overview of the series, set-up, installations, virtual environments and creating our first application- producing meaningful and actionable Python code. In the next episode we'll explore more widgets! Enjoy! 🤝 Want 1:1 mentorship, data career guidance or interview prep? topmate.io/james...
Create a professional DASHBOARD DESIGN wireframe IN MINUTES | Simple & Powerful Wireframe Tool
Переглядів 2,1 тис.Рік тому
In this tutorial, I demonstrate an example of a great online dashboard design tool, allowing you to create professional, powerful and interactive dashboard mock ups very quickly. Enjoy! 🤝 Want 1:1 mentorship, data career guidance or interview prep? topmate.io/james_andrew_matadorsoftware 🤝 Connect with me on LinkedIn: www.linkedin.com/in/ja376
How To Create a SQL WHILE Loop- Syntax, Example & Alternatives
Переглядів 440Рік тому
How To Create a SQL WHILE Loop- Syntax, Example & Alternatives
SQL Shades- A Simple & Complete Dark Theme Solution For SQL Server Management Studio in 2023
Переглядів 4 тис.Рік тому
SQL Shades- A Simple & Complete Dark Theme Solution For SQL Server Management Studio in 2023
3 Ways to Create a Running Total in Python Pandas | Adding a New Dataframe Column
Переглядів 369Рік тому
3 Ways to Create a Running Total in Python Pandas | Adding a New Dataframe Column
Learn These 3 Simple ChatGPT Tricks to INSTANTLY Become Better at Coding
Переглядів 233Рік тому
Learn These 3 Simple ChatGPT Tricks to INSTANTLY Become Better at Coding
Create a Python Google Searcher in Less Than 10 Lines of Code
Переглядів 721Рік тому
Create a Python Google Searcher in Less Than 10 Lines of Code
Python Automation Tutorial | How to Extract File Metadata with Python #code #automation
Переглядів 2,6 тис.Рік тому
Python Automation Tutorial | How to Extract File Metadata with Python #code #automation
How to Practice SQL for FREE Using These 5 Awesome Platforms
Переглядів 521Рік тому
How to Practice SQL for FREE Using These 5 Awesome Platforms
Extract Date Parts in Python Pandas | Day, Month, Year & SQL Comparison
Переглядів 569Рік тому
Extract Date Parts in Python Pandas | Day, Month, Year & SQL Comparison
A Guide to SQL Date Functions | Extracting Date Parts & Date Differences
Переглядів 184Рік тому
A Guide to SQL Date Functions | Extracting Date Parts & Date Differences
Get Ahead Of The Competition With These 5 Data Analytics Trends
Переглядів 214Рік тому
Get Ahead Of The Competition With These 5 Data Analytics Trends
Seaborn Heatmap- A Deep Dive into Visualising Trends & Patterns using Python
Переглядів 231Рік тому
Seaborn Heatmap- A Deep Dive into Visualising Trends & Patterns using Python
Python for Data Analysis- Create SQLite Databases Quickly with Python
Переглядів 320Рік тому
Python for Data Analysis- Create SQLite Databases Quickly with Python
Python for Data Analysis- Real World Pandas & Data Viz Project #dataanalytics #python #datascience
Переглядів 488Рік тому
Python for Data Analysis- Real World Pandas & Data Viz Project #dataanalytics #python #datascience
A Complete Guide to Building Your Own Python Functions
Переглядів 272Рік тому
A Complete Guide to Building Your Own Python Functions
Instant Python Exploratory Data Analysis (EDA)
Переглядів 479Рік тому
Instant Python Exploratory Data Analysis (EDA)
Use this SQL Server Script to Monitor Wide Tables & Redundant Data
Переглядів 263Рік тому
Use this SQL Server Script to Monitor Wide Tables & Redundant Data
Simply Connect Google Colab to GitHub- Easily Sample Projects & Concepts
Переглядів 4,8 тис.Рік тому
Simply Connect Google Colab to GitHub- Easily Sample Projects & Concepts
Use SQL to Create an Email Validator- Real World Data Project
Переглядів 777Рік тому
Use SQL to Create an Email Validator- Real World Data Project
using SUM() over partition was briliant, learnt something new today! thanks a lot man!
Great video, thank you. I can't stand SSMS anymore - so NOT user friendly. VS Code is King!
Thank you so much Brother
It would be helpful if you demonstrated how to link to other files in the same repository from this notebook.
The first two answers are incorrect and do NOT SHOW A RUNNING TOTAL IN ACCORDANCE TO ASCENDING MONTHS (just look at the answers). Since the Month field is a VARCHAR, you've ordered the running total alphabetically ('Apr' first month, 'Sep' last month). A solution as follows could be used to overcome that: SELECT *, SUM(Revenue) OVER (ORDER BY CASE WHEN Month= 'Jan' THEN 01 WHEN Month= 'Feb' THEN 02 WHEN Month= 'Mar' THEN 03 WHEN Month= 'Apr' THEN 04 WHEN Month= 'May' THEN 05 WHEN Month= 'Jun' THEN 06 WHEN Month= 'Jul' THEN 07 WHEN Month= 'Aug' THEN 08 WHEN Month= 'Sep' THEN 09 WHEN Month= 'Oct' THEN 10 WHEN Month= 'Nov' THEN 11 WHEN Month= 'Dec' THEN 12 END ASC) FROM Revenue
DROP TABLE IF EXISTS Employee; CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, HireDate DATE NOT NULL, Salary DECIMAL(10,2) NOT NULL ); INSERT INTO Employee (EmployeeID, FirstName, LastName, HireDate, Salary) VALUES (1, 'John', 'Smith', '2019-01-01', 75000), (2, 'Jane', 'Doc', '2019-02-15', 80000), (3, 'Bob', 'Johnson', '2019-03-30', 90000), (4, 'Sarah', 'Lee', '2019-04-15', 85000), (5, 'Mike', 'Brown', '2019-05-01', 95000), (6, 'Lisa', 'Davis', '2019-06-15', 100000), (7, 'Tom', 'Wilson', '2019-07-30', 110000), (8, 'Ann', 'Jones', '2019-08-15', 120000), (9, 'Peter', 'Parker', '2019-09-01', 125000), (10, 'Mary', 'Kim', '2019-10-15', 130000); DROP TABLE IF EXISTS Revenue; CREATE TABLE Revenue ( Year INT NOT NULL, Month VARCHAR(3) NOT NULL, Revenue DECIMAL(10,2) NOT NULL); INSERT INTO Revenue (Year, Month, Revenue) VALUES (2021, 'Jan', 50000), (2021, 'Feb', 75000), (2021, 'Mar', 90000), (2021, 'Apr', 65000), (2021, 'May', 80000), (2021, 'Jun', 95000), (2021, 'Jul', 110000), (2021, 'Aug', 120000), (2021, 'Sep', 100000), (2021, 'Oct', 90000), (2021, 'Νον', 75000), (2021, 'Dec', 60000);
Great video, Big Help.. Thank you. Could you please provide the hex code for Background color and Green one too.
Seu video me inspirou para fazer um dashboard
not working with sql 2014 ?
How do we do the same thing for the walking time?
Nice trick, but it doesn't work when you have columns without data (i.e. sales for Aug/Sep/Oct/Noc/Dec when you are still in July) that are forced with "Show items with no data"
thankk you for this. I was searching for this. now i need to do something else per row get the absolute varainace/sum( total absolute variance column) how would you do that?
The demos of this look nice but I've tried it on UK geojsons and haven't get it working.
Thank you so much for sharing your knowledge and experience.
how to open a epxlorer window of a certain size in a certain location?
so helpful thanks boss
Pls continue
your video helped me, thanks bro!
I am in tension how to achieve total and subtotal in sql query. But this video make me free from tension. I believe everything is possible in sql. Thanks
Has anyone tried this in 2024? I've tried to troubleshoot this for 30 mins and mine still isn't working >.< I think to do with google not allowing me to login using the SMTP? Thanks for any help.
How can you make the table you added be more dynamic for all employees? Will this work on Groups?
Sorry, but how did you manage to insert line breaks in text inside the buttons?
Great Workaround. so simple. I have another challenge on advanced filtering and can't find a solution. I want to filter on certain phrases: e.g. "today is a great day" and "today is the best day". How can I filter on exactly these phrases if they're a part of a longer text block?
Dear sir you show google sign up without phone number automation
This was helpful and very well explained. Thank you for sharing this video.
thank you man!
OMG!! Rockstar! Thank you sir - saved a BIG headache! How stupidly obvious-but-not-intuitive MS.
Nice explanation in step by step procedure. Thank you!
bro, you are the Best, thanks
Very good content, nice and simple. I have a question regarding the email automation. If I want to send automatically every week an email, do I have to run the script or can I "program it" somehow for this to be sent without me running the script? Thanks in advance! :D
Did you have any issues running this script recently? Thanks for any help :D
very helpful, thanks a lot.
Hi, Can we use this method without premium subscritpion? Is there any other ways?
Thanku so much ...i have resolved successfully.... thnaks a lot
Storing keys as plaintext is a good start but using environment variables is a bit nicer because you can upload your code and run it in public
Real nice tutorial. Crisp and to the point.
Matadorjob Very Bad Service And Customer Support Bad Service
can you please tell how to show a number in K which is in thousands? For eg. 989,575.98 should be shown as 990K.
Great tutorial and thanks for sharing! Is it also possible for you to share the example data file?
thank you blud, you did what other pros in microsoft community didn't do. respect
Will this run, even if I didn't turn on the pc?
Solution 1 doesn't work, look at September column, it's still wider than others due to its header longer than 0000 value. It's easy to solve by adding more zeroes in that case where we have constant amount of 12 columns only, that' fine, however what it is not useful for tables with huge number of potential columns which may appear depending on page or visual filtering, when we don't exactly know, which header can be the largest one...
Great! Thanks a lot🙏
So aesthetic ngl 🥺
thank you so much broo
Thank you for creating these videos, they've been extremely helpful in getting started with Kivy. I hope you continue the series!
I've been wanting to learn Kivy to build mobile apps and I had struggled getting started. This video was so helpful, thank you!
Thank you
Wow
awesomeeeee
This is magical