Python for Business Analysis and Excel
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 119 lectures (20h 50m) | Size: 5.77 GB
Supercharge your business analysis skills by using Python to analyze Excel data!
What you'll learn:
Import data from Excel and CSV files into Python
Clean and structure data in Python
Analyze data in Python
Export finalized data analysis back to Excel
Build compelling business analysis models using real world examples
Develop customer segmentation analysis
Conduct in-depth process and bottleneck analysis
Analyze seasonality and demand fluctuations
Structure a marketing promotion and analyze the return on investment
Basic understanding of Python
Basic understanding of Excel
A computer (PC or Mac)
In this course we'll use Python to:
Read data from Excel and CSV files into Python
Clean and analyze the data in Python going way beyond the functionality that Excel is capable of
Create reusable Python code which can make analyzing data in Python quick and easy
Write data back to Excel for final touches and creating charts
This course uses real world business cases to demonstrate practical applications of Python. By the end of the course you will have a portfolio of business analysis examples that will prove your mastery over Python. This includes:
Customer segmentation analysis - we'll look at a large set of customer data and tease out different customer segments which are more profitable. This will allow the marketing department to determine which groups to target. We'll focus on parents with babies and analyze how much money they spend and what their demographic characteristics look like.
Production bottleneck analysis - we'll look at the production line of a car factory to understand which machines are causing delays in completing the final cars. Using this analysis, we'll make recommendations on which new machines to invest in. Additionally, we'll look at how often machines break down and how this contributes to delays.
Seasonality - we'll analyze daily, monthly, and quarterly trends in a clothing manufacturers sales to understand which times of year produce the best results. We'll also look at how profit margins change over time.
Marketing promotion - we'll create a return on investment (ROI) analysis for a proposed marketing campaign and then analyze the actual results to determine whether our ROI analysis was accurate.
Along the way you will reinforce key Python concepts and learn how to debug and refactor your code. This course provides more guidance on debugging than any other. Debugging is a crucial skill which will help you solve problems more effectively and be more independent when writing your own code.
Who this course is for
Business professionals that want to supercharge their data analysis skills with Python
Anyone that has been introduced to Python and wants real world, practical examples
Download From Rapidgator
https://rapidgator.net/file/cc41d61fd54624771596bdf55e83145d https://rapidgator.net/file/040600d909c9a77031efc46217291298 https://rapidgator.net/file/93492a9935f728c56fa056aacd66a353 https://rapidgator.net/file/aaef81507e6acbe7e1340a2f608a0af0 https://rapidgator.net/file/9e3e606a03b2494ccb6a9e297b2fdfec https://rapidgator.net/file/b74ebafd3091cf7aaa76a358b1f4ec0f https://rapidgator.net/file/83f38d03eabd5e1b6c34451a2d5eeaef
Download From Nitroflare
http://nitroflare.com/view/EC6396F7EA01EAA/BaDshaH.Python_for_Business_Analysis_and_Excel.part1.rar http://nitroflare.com/view/BFAC0A39EEC8399/BaDshaH.Python_for_Business_Analysis_and_Excel.part2.rar http://nitroflare.com/view/2A1F1C97BC59D28/BaDshaH.Python_for_Business_Analysis_and_Excel.part3.rar http://nitroflare.com/view/6F457A9CC59093D/BaDshaH.Python_for_Business_Analysis_and_Excel.part4.rar http://nitroflare.com/view/006ABD9893F34DD/BaDshaH.Python_for_Business_Analysis_and_Excel.part5.rar http://nitroflare.com/view/0A5DBB2F5A3EB31/BaDshaH.Python_for_Business_Analysis_and_Excel.part6.rar http://nitroflare.com/view/37AD9A389279F87/BaDshaH.Python_for_Business_Analysis_and_Excel.part7.rar