Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer About Me - PowerPoint PPT Presentation

Jun 15, 2023 •926 likes •1.03k views

Simon Kingaby Manager, Global Data and Analytics, Big Data Engineer Deloitte Touche Tohmatsu Limited | Global Shared Services skingaby@deloitte.com Blog: omwtm.blog linkedin.com/in/skingaby Why Learn Python? A Microsoft DB/ETL/BI Developer's

Simon Kingaby Manager, Global Data and Analytics, Big Data Engineer Deloitte Touche Tohmatsu Limited | Global Shared Services skingaby@deloitte.com Blog: omwtm.blog linkedin.com/in/skingaby Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer
About Me Evolutionary Geek, Software Developer, Data Wrangler • First learned Basic on a TI 99/4A and a C-128 (remember Peek and Poke) • WordPerfect, Lotus 1-2-3 macros • MS Office and Windows for Workgroups • MS Access and VBA • VB 6.0, SQL, ADO • VB.Net, SQL • C#, SQL, SSIS, SSRS, Azure Data Factory, Azure SQL, Azure DW • Some ASP/HTML/CSS • JavaScript, Alexa Skill Development • Python, Machine Learning, Azure Data Bricks, Power BI • MCP since 1993 •
Why Learn Python? 1. It’s a powerful scripting language 2. It has a TON of pre-built modules 3. It is the language of choice for Machine Learning 4. It is essential for (Azure) Data Bricks 5. It is a first-class language in Azure and AWS
Which Language Should I Learn in 2020? https://insights.stackoverflow.com/survey/
https://insights.stackoverflow.com/survey/
Three Python Utilities You Can Use 1. Did you ever wonder which one of the hundreds of SSIS packages in your repository loads a specific table? 2. Did you ever wish you could figure out which of the myriad queries in your SSRS report is/are the slow one(s)? 3. You’ve got the address data, don’t you wish you could plot them on a map visual?
Demos
Demo 1 Did you ever wonder which one of the hundreds of SSIS packages in your repository loads a specific table? 1. SSIS Packages are just XML 2. Python has an xml module that’s quick 3. Pandas can easily write the results to Excel
Demo 2 Did you ever wish you could figure out which of the myriad queries in your SSRS report is/are the slow one(s)? 1. SSRS Reports are also just XML 2. Python has a clr module (as in .Net CLR) 3. pyodbc can be used to run SQL statements
Demo 3 You’ve got the address data, don’t you wish you could plot them on a map visual? 1. Using pyodbc we can read/write SQL data 2. Google has a free* Geocoding REST API 3. Python’s json and requests modules call the API * Free in reasonable batches, Credit Card required for authentication only

Recommend

We already know Java. Why learn Python? Using Python to Implement Algorithms Python has far less

We already know Java. Why learn Python? Using Python to Implement Algorithms Python has far less overhead than Java for the programmer. Tyler Moore Python is closer to psuedo-code on the English-pseudocode-code spectrum than Java or C/C++, but

615 views • 9 slides

We already know Java and C++. Why learn Python? Using Python to Implement Algorithms Tyler Moore

We already know Java and C++. Why learn Python? Using Python to Implement Algorithms Tyler Moore Python has far less overhead than Java/C++ for the programmer. Python is closer to psuedo-code on the English-pseudocode-code CSE 3353, SMU,

138 views • 9 slides

What are our goals?: Learn Python syntax and features Understand why Python is so powerful

presents Intermediate Python What are our goals?: Learn Python syntax and features Understand why Python is so powerful and popular for so many different uses 2 Why are doing this?: Because were nice people, who

1.03k views • 87 slides

Learn Python the Fun Way Liana Bakradze liana.bakradze@jetbrains.com @med_vector About Me

Learn Python the Fun Way Liana Bakradze liana.bakradze@jetbrains.com @med_vector About Me Saint Petersburg Photo made by Andrey Korzun is licensed by CC BY-SA 3.0 Learn Python Resources Why Games? No fear of failure Reward Competition

673 views • 30 slides

An introduction to Python Andreas Bjerre-Nielsen Agenda 1. Python: what it is; why and how we

An introduction to Python Andreas Bjerre-Nielsen Agenda 1. Python: what it is; why and how we learn it 2. Python scripts and Jupyter 3. Fundamental data types 4. Basic Python procedures: operators, functions, methods etc. 5. Conditional

978 views • 66 slides

Python for Data Science Overview of Python Why Python Installing Python Installing Python Modules

Python for Data Science Overview of Python Why Python Installing Python Installing Python Modules Overview of the course Assumptions: We are here to learn some new skills We learn new skills by doing We work better with others

442 views • 43 slides

Advanced #5: Python Modules SAMS SENIOR CS TRACK Learning Goals Learn how to install and use

Advanced #5: Python Modules SAMS SENIOR CS TRACK Learning Goals Learn how to install and use external modules Identify common popular modules for the Python language Python Libraries When you install Python on a machine, it comes with a large

1.01k views • 21 slides

COURSE Python/Numpy/Pandas CONTENT Introduction to EDA and Visualizations Python hands

LECTURE SESSION - 2 Introduction to COURSE Python/Numpy/Pandas CONTENT Introduction to EDA and Visualizations Python hands on exercises Python Simple programming language to learn Yet very powerful. Used in the following

431 views • 22 slides

Laboratory of Machine Learning with Python Numpy / Matplotlib / Scikit-learn Luca Erculiani

Laboratory of Machine Learning with Python Numpy / Matplotlib / Scikit-learn Luca Erculiani University of Trento Setup (on lab machines) Download and extract the Scikit-learn lecture material from:

291 views • 10 slides

Implementing Graph Analytics with Python and Numba Siu Kwan Lam Continuum Analytics Python for

Implementing Graph Analytics with Python and Numba Siu Kwan Lam Continuum Analytics Python for Exploratory Programming Flexibility : Rich Libraries : - interpreted - math: numpy, scipy - duck typing - machine learning: scikit-learn,

750 views • 28 slides

Python Tidbits Python created by that guy ---> Python is named after Monty Pythons

Python Tidbits Python created by that guy ---> Python is named after Monty Pythons Flying Circus 1991 Python 0.9.0 Released 2008 Python 2.6 / 3.0rc2 Current Python 2.7.1 / 3.2 *7 th most popular language

753 views • 37 slides

COMP 204 Intro to machine learning with scikit-learn (part three) Mathieu Blanchette 1 / 14

COMP 204 Intro to machine learning with scikit-learn (part three) Mathieu Blanchette 1 / 14 Today - Machine learning in Python scikit-learn is a Python module that includes most basic machine learning approaches. We will learn how to use it.

611 views • 14 slides

Learn the Python interpreter COMMAN D LIN E AUTOMATION IN P YTH ON Noah Gift Lecturer,

Learn the Python interpreter COMMAN D LIN E AUTOMATION IN P YTH ON Noah Gift Lecturer, Northwestern & UC Davis & UC Berkeley | Founder, Pragmatic AI Labs Three Laws of Automation 1. Any task that is talked about being automated,

526 views • 24 slides

How You Can Use Open Source Materials to Learn Python & Data Science Kamila Stpniowska,

How You Can Use Open Source Materials to Learn Python & Data Science Kamila Stpniowska, EuroPython 2018 github.com/KStepniowska/EuroPython2018 CC-BY What can you expect? - Sociology - Diversity: Geek Girls Carrots, Women Who Code,

453 views • 33 slides

Brewing beer with Python Chesco Igual @chescales What shalt thou learn? - Building an IoT

Brewing beer with Python Chesco Igual @chescales What shalt thou learn? - Building an IoT backend - - Technologies, Protocols and Tools - - Backend considerations - - Meet a full running architecture - - Learn to brew beer - What shalt thou

679 views • 53 slides

Quick & Dirty Python Professor Marie Roch 1 Quick and dirty Python 3.x About the

Quick & Dirty Python Professor Marie Roch 1 Quick and dirty Python 3.x About the language Interpreted high level language Reasonably simple to learn Rich set of libraries For details, see texts in syllabus or

774 views • 23 slides

External Modules 15-110 Monday 11/25 Learning Goals Learn how to install and use external

External Modules 15-110 Monday 11/25 Learning Goals Learn how to install and use external modules Identify common useful modules for the Python language Python Modules The Python programming language comes with a large set of build-in

510 views • 29 slides

Modules and Programs 1 / 14 Python Programs Python code organized in modules, packages,

Modules and Programs 1 / 14 Python Programs Python code organized in modules, packages, and scripts. Weve already used some modules, now well learn what they are, how theyre orgainized in packages, and how to write Python

398 views • 14 slides

Modules and Programs 1 / 12 Python Programs Python code organized in modules, packages,

Modules and Programs 1 / 12 Python Programs Python code organized in modules, packages, and scripts. Weve already used some modules, now well learn what they are, how theyre orgainized in packages, and how to write Python

435 views • 12 slides

X minutes X Learn Lua Lua in in minutes Learn Roberto Ierusalimschy What is Lua What is

X minutes X Learn Lua Lua in in minutes Learn Roberto Ierusalimschy What is Lua What is Lua Yet another dynamic language not totally unlike Perl, Python, Tcl A scripting language emphasis in inter-language communication

608 views • 37 slides

Intro to Python Peter Krenesky Lead Software Engineer Slides: http://bit.ly/nXwnzQ Why Python?

Intro to Python Peter Krenesky Lead Software Engineer Slides: http://bit.ly/nXwnzQ Why Python? Easy to learn. Easy to read. Large selection of stable libraries. Much easier to build and maintain complex system infrastructure than

862 views • 38 slides

Introduction to Python Python: very high level language, has high-level data structures built-in

Introduction to Python Python: very high level language, has high-level data structures built-in (such as dynamic arrays and dictionaries). easy to use and learn. Can be used for scripting (instead of Perl, awk), or for general programming.

414 views • 14 slides

1 Parallelism in Python The Problem with Shared State Python provides two mechanisms for

Python Example of a MapReduce Application The mapper and reducer are both self contained Python programs Read from standard input and write to standard output ! Mapper Tell Unix: this is Python #!/usr/bin/env python3 The emit function

464 views • 3 slides

Getting Started with Python The Python Interpreter A piece of software that executes

Object-Oriented Programming in Python Goldwasser and Letscher Chapter 2 Getting Started with Python The Python Interpreter A piece of software that executes commands for the Python language Start the interpreter by typing python at a

862 views • 27 slides