Business Analytics

Get Started. It's Free
or sign up with your email address
Business Analytics by Mind Map: Business Analytics

1. Automating Business Processes

1.1. Spreadsheet modeling design

1.2. Basic Programming (Python)

1.2.1. Learning the simple coding in Python (simple functions & calculations, pandas dataframe), and learn how to read and write files in python. Also learned the basic of performing analysis such as Regression, ANOVA, and creating graphs

1.3. Excel Bult-in function application

1.4. Excel: Creating functions

1.5. VBA (Visual Basic)

2. Optimization Modeling

2.1. Identify problems appropriate for optimization

2.2. Network Models

2.3. Allocation, Covering, Blending Problems

2.4. Paramter Analysis

2.5. Integer Programming Models

2.6. Optimiaztion Modeling in Python

2.7. Constrainnts for Linear & Nonlinear Models

2.8. Evolutionary Algorithms

3. Enterprise Information Management

3.1. SQL Server Database Design and Programming

3.2. Visual Studio Windows Forms

3.3. Visual Studio Windows Integrated Application

4. Foundations of Information Management

4.1. Database Initial Study, Design and Modeling

4.2. Database Implementation and Data Loading

4.3. Database Querying using Structured Query Language (SQL)

4.3.1. By learning the basics of SQL coding and applying it to a higher level when building database in VS instead of Access

4.4. Microsoft Access

4.5. Visio Graphing: ERD

5. Data Warehousing & Business Intelligence

5.1. Plan, Design, and Model the DW/DM (using VS, Visio, Word and Excel)

5.2. Build the DW/DM (using VS and SSMS)

5.3. Extract, Transform, and Load the DW/DM (using VS and SSIS)

5.4. Develop Tabular and Multidimensional Analysis from the DW/DM (using VS, Excel and SSAS)

5.5. Create Reports and Dashboards from the DW/DM (using VS and Power BI)

6. Project Management and Simulation

6.1. Big Picture: Project Management Overview

6.2. Project Integration Management

6.2.1. Methodology

6.2.2. Predictive & Agile

6.2.3. Strategic Planning

6.2.4. Project Charters and Plans

6.3. Project Scope Management

6.3.1. Work Break Down Structure

6.3.2. Validating & Controlling Scope

6.4. Project Time Management

6.4.1. Planning

6.4.2. Sequencing Activities

6.4.3. Estimating/Simulation

6.4.4. Developing/Controlling Schedules

6.5. Project Cost and Quality Management

6.5.1. Project Cost/Estimating

6.5.2. Budget

6.6. Project Human Resource Management

6.6.1. Managing and Leading People

6.6.2. Developing the HR Plan

6.7. Project Communications Management

6.7.1. Good Communication

6.7.2. Managing & Controlling Communication

6.8. Project Risk Management

6.8.1. Quantitative Risk Analysis

6.8.2. Controlling Risk

6.8.3. Planning for RISK

6.8.4. Qualitative Risk Analysis

6.9. Project Procurement Management

6.9.1. Conducting Procurements

6.9.2. Closing Procurements

6.10. Project Stakeholder Management

6.10.1. Identifying Stakeholders

6.10.2. Managing Stakeholders

6.10.3. Controlling Stakeholders

6.10.4. Using Software to Assist

7. Data Mining and Visualization

7.1. Exploring/Visualizing Your Data

7.2. Logistic Regression Models

7.3. Time Series Forecasting

7.4. K-Nearest Neighbor/General Linear Models

7.5. Tableau Story and R Dashboard

7.6. Data Mining with R

7.7. JMP

8. Complex Data Analytics

8.1. Concepts of Big Data Analytics

8.2. Text Analytics

8.2.1. Reviews: movies, hotels, restaurants

8.3. Network Analytics

8.3.1. Friendship, Romantic Relationships, Sports Fans

8.4. Social Media Analytics

8.4.1. FB, Twitter

8.5. Disparate Data Sources

8.6. SPSS Modeler Application

9. Capstone/Senior Project

9.1. A combination of all major courses that include all the techniques, skills and sofetwares we learned in college to work on a comprehensive project