Microsoft Business Analysis & Data Intelligence
Microsoft Business Analysis & Data Intelligence
This GLA Pro course on The Microsoft Business Analyst program helps you master the core competencies of a modern analyst, bridging the gap between business strategy and data-driven intelligence.
About this course
The Microsoft Business Analyst program helps you master the core competencies of a modern analyst, bridging the gap between business strategy and data-driven intelligence. The curriculum begins with the BA lifecycle, stakeholder elicitation, and professional process modeling using BPMN 2.0 and Microsoft Visio, and then focuses on the technical mastery in Advanced Excel and Power BI, learning how to do complex exploratory data analysis, build strong data models using DAX, and create impactful dashboards, and finishing with hypothesis testing and risk management to ensure that the organizational change is successful and sustainable.
Earn a certificate with an Academy Pro+ subscription
Stand out to recruiters
Share on professional channels
Globally recognised
Land your dream job
Course outline
Industry focussed curriculum designed by experts
Introduction to Business Analysis
3 items
0.23 hr
- Understanding the Business Analyst Role
- The 5 Key Phases in Business Analysis
- The Microsoft Business Analyst Toolkit
Requirement Gathering and Stakeholder Management
4 items
0.52 hr
- Requirements Elicitation with Microsoft Teams
- Requirements Elicitation with Forms and OneNote
- Stakeholder Analysis and Communication
- Writing Requirements and User Stories
Business Process and Data Modeling
5 items
0.40 hr
- Introduction to Process Mapping
- Process Mapping in Microsoft Visio
- BPMN 2.0 Standards - The Language of Process Mapping
- Microsoft Visio - Pools, Lanes, and Handoffs
- The Microsoft Synergy
Microsoft Excel for BA Data Work
24 items
3.48 hr
- Introduction to Excel (M)
- Excel Navigation (M)
- Data Collection and Preprocessing in Excel (M)
- Data Cleaning using Functions (M)
- Conditional Formatting in Excel (M)
- Data Validation (M)
- Lookup Functions in Excel (M)
- Pivot Tables in Excel (M)
- Data Visualisation using Excel (M)
- Error Handling in Excel (M)
- Introduction to Exploratory Data Analysis with Excel (M)
- Problem Statement (M)
- Data Understanding (M)
- Questions & Hypothesis (M)
- Data Cleaning & Manipulation (M)
- Outlier Detection and Handling in Excel (M)
- Univariate Analysis (M)
- Bivariate Analysis in EDA (M)
- Multivariate Analysis in EDA (M)
- Exploratory Data Analysis: Hands-on - Part 1 (M)
- Exploratory Data Analysis: Hands-on - Part 2 (M)
- Exploratory Data Analysis: Hands-on - Part 3 (M)
- Visualization Best Practices in EDA (M)
- Quick Peek into the Final Insights (M)
Power BI for Business Analysis
18 items
3.46 hr
- Overview of Power BI
- Overview of Desktop
- Importing Data in Power BI
- Introduction to Data Modeling
- DAX Formulas, Data Types and Functions
- Create Calculated Columns and Compare with Measures
- Learn about Row Context
- Create a Date Table
- Define Data Granularity and Resolve Modeling Challenges
- Use of Logical Calculation
- What-If Analysis
- Waterfall Chart
- Bubble Chart
- Heat Map
- Hierarchy
- Drill Through Data
- Outlier Detection
- Dashboard Design and Story-telling
Hypothesis Testing and Reporting
2 items
0.17 hr
- BA’s Guide to Hypothesis Testing
- Hypothesis Testing with Excel
Solution Design, Risk and Implementation Support
3 items
0.15 hr
- Strategic Evaluation and Risk Prevention
- Validation, Testing and Launch Readiness
- The Human Element and Sustainable Change
Get access to the complete curriculum with your free trial
Start 7-Day Free TrialGuided Projects
Solve real-world projects with a step-by-step guide, starter code templates, and access to model solutions to boost your skills and build a standout resume.
Get a project certificate to add to your resume
Earn a certificate for every project you complete.
- GUIDED PROJECT 1
- Designing a Data‑Driven Sales Performance & Customer Insights Solution using Microsoft Tools
- You are a Business Analyst at Contoso Retail Pvt. Ltd., a mid‑sized omni‑channel retailer (online + stores) facing stagnant sales growth and declining customer repeat purchases in key regions. Leadership has asked you to analyze sales and customer data, identify performance gaps, and recommend a Microsoft‑based, data‑driven solution (using Excel, Power BI, Visio, Teams, Forms, etc.). You will work end‑to‑end as a Business Analyst: from requirement gathering and stakeholder management, to process mapping, data analysis, dashboarding, solution recommendation, and implementation support—using Microsoft tools at each stage.
Gain skills & build your resume with complete access to guided projects in your free trial
Start 7-Day Free TrialCourse Instructors
Ms. Nayan Hridya Prakash
Our Learners Experience
Subscribe to Academy Pro+
Build skills and prepare for jobs with access to 500+ courses, certificates and tools.
Skill Prep
Build skills with courses, practice with tools and earn certificates.
500+ courses
500+ Coding Exercises
Microsoft & AWS certificates
Job Prep
Work on industry-relevant scenarios, build professional resumes & prepare for jobs with mock interviews
50+ Guided Projects
AI Resume Builder
AI Mock Interviews