Busi­ness Data Pro­cessing and Busi­ness In­tel­li­gence

Course content

Data driven decision making is core of business processes in the current age. It has become ever more important for business students to get acquainted with end to end process for business data analytics. 

The aim of this course to provide knowledge about all processes of business data analytics that includes data collection, data storage, data processing and reporting. Student get hands on experience with data analysis process and learn the complete life cycle of analysis with examples and real data sets. Following topics are covered:

• Introduction to data collection using WEB API : Learning how data can be retrieved from APIs and open WEB Api services. Understanding Web API framework is essential to understand data integrations. 
• Introduction to data formats : Getting familiar with data formats used for data sharing on digital platforms
• High level understanding Data Storage models for operational as well as analytical databases 
• Introduction to relational databases and the structure and functions of Relation Database Management Systems
• Brief Introduction to NoSql Databases : Comparison with Relational Databases
• Structured Query Language (SQL) : How to use SQL for fetching, aggregating and filtering data.
• Introduction to Dataware house concepts and schemas.
• Tools: Tableau or Power BI for reporting, Open source PostgreSQL for Relation Databases and SQL, MONGO DB for NoSql, Scripting language or visual tool for WEB API