PRO
Microsoft Business Analysis & Data Intelligence
Microsoft Business Analysis & Data Intelligence
10 hrs
1 project
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.
Build skills and get job ready
Skill prep
Job prep
50+ Guided Projects
AI Resume Builder
AI Mock Interviews
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
Subscribe To Pro+ • $29/Month
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
In this module, understand the Business Analyst role and the five key project phases while mastering the essential Microsoft toolkit for professional analysis and documentation.
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
In this module, master elicitation with Teams, Forms, and OneNote, and learn how to analyze stakeholders, manage communications, and draft quality requirements and user stories.
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
In this course you will learn how to map and model business processes using BPMN 2.0 standards and Microsoft Visio (including pools, lanes, and handoffs) to create clear, consistent process diagrams.
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
In this module, conduct end-to-end EDA with Excel, master data cleaning, lookup functions, pivot tables, and multivariate analysis to turn raw data into business insights.
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
This module helps you build data models, use DAX functions, create visualizations, and build interactive dashboards to perform What-If analysis and use storytelling to support business decisions.
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
In this module you'll learn the basics of hypothesis testing for BAs and how to execute and report with Microsoft Excel features.
2 items
0.17 hr
- BA’s Guide to Hypothesis Testing
- Hypothesis Testing with Excel
Solution Design, Risk and Implementation Support
This module teaches you to design practical solutions, manage risks with simple matrices, test the system with real users (UAT), and ensure tool adoption with Power BI and Microsoft Teams.
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.
Business Analyst Role & Project Phases
Microsoft BA Toolkit
Requirements Elicitation
Stakeholder Management
User Story Documentation
BPMN 2.0 Process Mapping
Process Mapping in Microsoft Visio
Data Preprocessing & Cleaning (Excel)
Exploratory Data
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
Nayan Hridya Prakash specializes in creating high-quality educational content in Data Science, Analytics, and Artificial Intelligence (AI). She holds an M.Sc. in Data Science and has completed a Master Program in Big Data Analytics from the Centre for Development of Advanced Computing (CDAC).
Her expertise includes Machine Learning, NLP, and Deep Learning, with proficiency in Python, R, and SQL. Nayan brings together strong academic foundations and industry-relevant content development experience, with a focus on making data science learning clear, engaging, and practical.
Our Learners Experience
An Absolutely Mind-Blowing course to the Future with Gen AI!
Exceptional course! It brilliantly demystifies Gen AI with clear explanations and practical projects. The hands-on approach built real confidence. Worth every penny and highly recommended for anyone curious about AI.
The course improved my technical knowledge and gave me a strong foundation in networking concepts.
Course was very informative and well-structured. The concepts such as OSI model, TCP/IP, IP addressing, routing, and network protocols were explained clearly with good examples. The practical demonstrations and diagrams helped in understanding the real-time working of networks.
Overall, the course improved my technical knowledge and gave me a strong foundation in networking concepts.
Data visualization with PowerBI
Really good depth to the topic. Got an opportunity to learn a lot. Maybe add the exact excel data sheet as the one that is being used as the instructor so we can understand even better.
Master Data Analytics in Excel
Course had a good structure and focused on fundamentals and practical applications.
Strong Foundation
This course provided a strong understanding of core Android development concepts. The modules were well-organized, and the instructor explained topics like activities, layouts, intents, and APIs very clearly. The practical assignments and demonstrations helped me build confidence in creating Android applications. Overall, it was a valuable and well-designed learning experience.
I really enjoyed this course!
The lessons were clear, beginner-friendly, and well-structured. The practical hands-on exercises helped me understand how to craft effective prompts and avoid common mistakes. The examples, refined prompts, and advanced prompt techniques were especially useful. A great starting point for anyone interested in Generative AI and ChatGPT.
The topic was explained in depth
This course is trending and helps many to enter into AI and analytics
Mastering digital marketing
It's really amazing i easily understand this course with the help of great learning and great couches amazing team thank you so much for helping me to learn this course.
Excellent Course for Beginners
This online course exceeded my expectations. The content was detailed yet easy to understand, and the instructor used real-world examples to make concepts relatable. The platform was user-friendly, and each module was organized logically. The quizzes and case studies helped test my understanding. I would recommend this course to anyone looking to upskil
Data visualization using Tableau
This course was easy to understand and well structured. I especially liked the practical explanations, quizzes, and tools used to explain data visualization concepts. It helped me gain basic confidence in Tableau and understand how to create effective dashboards. A good course for beginners.
Subscribe to Academy Pro+
Build skills and prepare for jobs with access to 500+ courses, certificates and tools.
Subscribe To Pro+ • $29/Month
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
Application-driven learning to
Become a Skilled Professional with Pro Courses
Gain work-ready skills with guided projects, top faculty and AI tools, all at an affordable price.
.jpg)
.png)
.png)
.png)
 (1).jpg)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
 (1).png)
.png)
.png)
.png)
.jpg)
.png)
.png)
.png)
.png)
.png)
.png)
.jpg)
.jpg)
.jpg)
.jpeg)
.png)
.jpg)
.jpg)
.png)
