BAN401 Applied Programming and Data Analysis for Business
Spring 2020Autumn 2020
Programming and data analytical skills are best learned through practice. The topics are oriented on the modern high-demand programming techniques and concepts:
- Practical and modern introduction to Python:
Python is a powerful high-level programming language that is easy and fast to learn. This part of the course will gently cover fundamental programming concepts. You will learn how to develop your own code for the practical needs as a part of the professional analytical process.
Furthermore, the obtained skills will allow you to migrate to any programming language relatively easy since most of the languages are based on similar paradigms.
Python is not only a perfect base to learn programming, but the most in-demand language in the business-oriented job market. You will learn basic parts of the Python language, packages and libraries that are most required for efficient solving a variety of problems. In addition, you will learn how to combine Python with other analytical tools for the high-level flexibility. These and many other required techniques will be covered in this part of the course.
Applied programming skills will give you a confidence and privilege in the job market and in your future career.
- R-based programming and data analysis:
R is a powerful free software environment to tackle data analysis. Nowadays it has rapidly expended into the enterprise market and good skills in R programming are required for the majority of analytics oriented jobs. R covers all data manipulation, statistical modeling and data visualization techniques that are required in business-oriented data analysis. In this part of the course, you will learn a variety of R-based data processing, visualization and programming techniques. Being designed expressly for data analysis, R became one of the most in-demand languages in the job market. It is extremely popular due to the huge number of open-source packages. The most important and fundamental (must-know) R programming tools and techniques will be covered in this part of the course.
- SQL (Structured Query Language)
SQL is a special-purpose programming language for managing data. It is a "must-know" language for creating, accessing, retrieving and manipulating data in databases. Nowadays, SQL is required to know as well as Python and R for the most of data analysis-oriented jobs. The reason is that most companies and organizations work with big datasets that are managed by relational database management systems (RDBMS) based on the SQL-standards. In this part of the course, students will learn the most important aspects of SQL language.
In the end of the course, students will have practical skills in querying and managing data using SQL.
- Integration of Python, R and SQL
An integrated big data analysis requires knowing how to exchange data and analytical results between different apps. In this part of the course, students will get an overview of how to use Python, R and SQL mutually with different software tools.
The aim of the course is to develop practical skills in applied programming and data analysis for use in business and economics. Students will learn different techniques from scratch based on modern tools such as Python, R, SQL, etc.
Skills in applied programming are in high demand in the job market. Companies are looking for analysts and managers with good IT knowledge and expertise. In this course, students will learn in practice the most important programming and data processing techniques that will allow them to be fluent in applied data analytics. By the end of this course the students will be able to:
- understand fundamental programming concepts;
- understand data management concepts;
- get fundamental skills to work in applied analytics;
- analyze different problems and implement the required programming solutions;
- apply most important programming languages and IT tools for data analysis;
- develop the programming-based solutions for the variety of analytical purposes;
- understand the foundation of good programming skills and techniques for applied data analysis and decision-making processes;
- evaluate, verify, test and analyze different types of code;
- discuss basic principles and tools of applied programming in analytics.
Students will get a fundamental knowledge and practical experience in applied programming required for real-world applications. For example, practically oriented data analysis is in high demand in business analytics, decision-making support, capital budgeting, supply chain management, marketing, customer targeting, financial analysis and audit, investment banking, credit analysis, etc. The growth of digital technologies has enabled to collect massive amounts of data in the given areas and the knowledge of applied programming and data analysis tools are fundamental to retrieve, systemize, process and visualize data efficiently.
The gained skills in this course will allow learning and understanding in a short period any programming and analytical tools required in real company situations. Based on the acquired experience, students will have an advantage compared to many candidates in the job market.
The course is focusing on the foundations of applied programming and data analysis for business. The main goal is to develop fundamental skills that are in high demand in the job market covering, i.e., data, business and system analysis, business intelligence, risk management, etc.
Teaching will consist of lectures with a very gentle introduction to fundamental programming and data analysis concepts. Practical skills will be gained based on the set of assignments and exercises.
No previous knowledge in data analysis, computer programming and corresponding IT tools are required
Credit reduction due to overlap
Course identical to BUS455.
The course assessment will be a final group-based project (group size 3-4) consisting of a set of problems and exercises. One final grade will be given on the project. The project must be written in English. For students who wish to retake the course, the final group-based project must be retaken.
This course is a continuation of BUS455 and the total number of attempts applies to the course (not the course code).
Participants should have an access to a computer connected to the Internet.
The course contains an intensive use of open-source (free) software related to Python, R, and SQL. Details regarding the required software will be provided during the course.
Books (free; available online):
- Swaroop, C. H. "Byte of Python" (for Python 3).
- Venables, W. N., & Smith, D. M. "An introduction to R".
Recommended official free-access tutorials:
- The Official Python 3 Tutorial: https://docs.python.org/3/tutorial/
- An Introduction to R: https://cran.r-project.org/doc/manuals/r-release/R-intro.html
- SQL Tutorial: http://www.tutorialspoint.com/sql/sql_tutorial.pdf
- ECTS Credits
- Teaching language
Autumn. Offered Autumn 2019
Dr. Ivan Belik, Department of Strategy and Management.