Module 1 – Preparatory Sessions – Data Transformation using Ms. Excel & Python
1
Python
- Introduction to Python and IDEs – The basics of the python programming language, how you can use various IDEs for python development like Jupyter, Pycharm, etc.
- Python Basics – Variables, Data Types, Loops, Conditional Statements, Functions, decorators, lambda functions, file handling, exception handling, etc.
- Object-Oriented Programming – Introduction to OOPs concepts like classes, objects, inheritance, abstraction, polymorphism, encapsulation, etc.
- Hands-on Sessions And Assignments for Practice – The culmination of all the above concepts with real-world problem statements for better understanding.
2
1. Excel Fundamentals
- Reading the Data, Referencing in formulas , Name Range, Logical Functions, Conditional Formatting, Advanced Validation, Dynamic Tables in Excel, Sorting and Filtering
- Working with Charts in Excel, Pivot Table, Dashboards, Data And File Security
- VBA Macros, Ranges and Worksheet in VBA
- IF conditions, loops, Debugging, etc.
3
2. Excel For Data Analytics
- Handling Text Data, Splitting, combining, data imputation on text data, Working with Dates in Excel, Data Conversion, Handling Missing Values, Data Cleaning, Working with Tables in Excel, etc.
4
3. Data Visualization with Excel
- Charts, Pie charts, Scatter and bubble charts
- Bar charts, Column charts, Line charts, Maps
- Multiples: A set of charts with the same axes, Matrices, Cards, Tiles
Module 2 - Certified Business Analysis Professional (CBAP®)
1
2.1 Introduction to Business Analysis
- Business Analysis overview
- Who is a Business Analyst?
- Introduction to governance body (IIBA)
- Business Analysis body of knowledge
- Knowledge areas of BABOK
- SDLC & requirement analysis
2
2.2 Business Analysis Concepts and Knowledge Areas
- Business Analysis overview
- Who is a Business Analyst?
- Introduction to governance body (IIBA)
- Business Analysis body of knowledge
- Knowledge areas of BABOK
- SDLC & requirement analysis
3
2.3 Requirement Lifecycle Management and Strategy Analysis
- Trace, maintain, & prioritize requirements
- Assess requirement changes and approval
- Analyze current state
- Define future state
- Assess risks
- Define change strategy
4
2.4 Requirement Analysis, Design Definition, Model Requirements, and Solution Evaluation
- Specify model requirements
- Verify and validate requirements
- Define requirement architecture and design options
- Measure and analyze solution performance
- Assess solution and enterprise limitations
- Recommend actions to increase solution values
- Data model, UI model, user stories
5
2.5 Agile Business Perspectives and Creating UML
- Introduction to business Agile perspective
- Business Intelligence perspective
- Information Technology perspective
- Business architecture perspective
- Business Process Management perspective
6
2.6 Understand BA Role on the Agile Team
- Write effective user stories and acceptance criteria
- Develop backlogs into great products
- BA role in new age Business Analysis
7
2.7 Underlying Competencies of a Business Analyst & Microsoft Visio
- Business Analyst underlying competencies
- BA Skills
- Soft skills, leadership and personal development
- UML diagrams using Microsoft Visio
- Types of flowcharts, cross-functional flowcharts
Module 3 - IIBA Certification in Business Data Analytics (CBDA)
1
3.1 Data Science and Analytics Fundamentals
- Introduction to data science and analytics
- Use cases in data science and analytics
- Data science life cycle
- Data Analytics: Types
- AI and Machine Learning: Overview
2
3.2 CBDA: Introduction
- CBDA: Overview
- What is Business Data Analytics?
- Eligibility criteria
- Six Business Data Analytics domains
3
3.3 Business Analysis and Data Analytics
- Business analysis in data analytics projects
- Comparison between business analysis and data analytics
4
3.4 Business Data Analytics Domains: Introduction
5
Domain 1: Identifying the Research Questions
6
Domain 2: Source Data
7
Domain 3: Data Analysis
8
Domain 4: Interpreting and Reporting Results
9
Domain 5: Using Results to Influence Business Decision-making
10
3.5 Techniques
Module 4 - Agile Methodologies for Project Management
Module 5 - UML 2.0
Module 6 - Career Essentials
Module 7 - Data Visualization using Tableau
Module 8 - Mastering MS Excel for Business Analysis
Module 9 - SQL for Business Analytics
Module 10 - Machine Learning for Business
Module 11 - Data Analysis with Python
Module 12 - Capstone Project
Productivity Hacks to Get More Done in 2018
— 28 February 2017
- Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
- Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
- Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!