Business Intelligence & Data Visualization in Excel
Business Intelligence & Data Visualization in Excel
This course is part of Business Intelligence & Reporting Tools Specialization
Included with
Ask Coursera
What you'll learn
Analyze datasets using sorting, filtering, and conditional formatting.
Build Pivot Tables and charts for business insights.
Apply what-if analysis to support data-driven decisions.
Skills you'll gain
Tools you'll learn
Details to know
April 2026
20 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 5 modules in this course
Master Excel Business Intelligence tools to analyze data, create visual insights, and support better business decisions. Learn how to transform raw data into meaningful reports and dashboards.
This course provides a structured, hands-on approach to data analysis and visualization using Microsoft Excel. You will learn how to organize datasets, apply advanced sorting and filtering, and use conditional formatting to highlight key insights. Through practical modules, you will build professional charts, create dynamic Pivot Tables, and perform multi-level data analysis for business reporting. The course also covers what-if analysis techniques using data tables, enabling you to evaluate different scenarios and support strategic decision-making. By the end of the course, you will be able to analyze complex datasets, design visually compelling reports, and generate actionable insights using Excel BI tools. Ideal for students and professionals, this course equips you with job-ready skills in data analysis, reporting, and business intelligence using Excel.
This module introduces the core principles of Business Intelligence in Microsoft Excel, focusing on organizing, sorting, filtering, and visually enhancing datasets. Learners build foundational data control skills and apply conditional formatting techniques to transform raw data into structured and decision-ready information.
What's included
9 videos4 assignments
9 videos•Total 86 minutes
- Introduction to Business Intelligence•12 minutes
- Sorting in Business Intelligence•10 minutes
- Filtering Data in BI•10 minutes
- Example of Filtering the Data•10 minutes
- Advance Filtering Data•8 minutes
- Advance Filtering Data Continues•8 minutes
- Conditional Formatting in Excel•11 minutes
- Edit Conditional Formatting Rules•11 minutes
- New Formatting Rules and Format Cells•7 minutes
4 assignments•Total 60 minutes
- Foundations of Data Organization & Smart Formatting•30 minutes
- BI Fundamentals & Data Control•10 minutes
- Advanced Filtering Techniques•10 minutes
- Conditional Formatting Essentials•10 minutes
This module enhances data presentation capabilities by exploring advanced formatting logic, resolving rule conflicts, integrating interactive controls, and preparing structured datasets for visualization. Learners strengthen their ability to build professional and interactive Excel BI reports.
What's included
7 videos4 assignments
7 videos•Total 56 minutes
- Duplicates and Triplicates Formatting•9 minutes
- How to Create Alternate Row in Excel•7 minutes
- Conflicting Rules In Excel•6 minutes
- Checklist Demonstration using Developer•8 minutes
- Checklist Demonstration using Developer Continues•9 minutes
- Data Charts In Excels•8 minutes
- More on Data Chart•9 minutes
4 assignments•Total 60 minutes
- Advanced Formatting & Visualisation Readiness•30 minutes
- Advanced Formatting Mastery•10 minutes
- Interactive Excel Tools•10 minutes
- Introduction to Data Charts•10 minutes
This module focuses on transforming structured data into meaningful visual insights using Excel charting tools. Learners explore core chart types, advanced visualization techniques, and analytical enhancements such as trend lines and error bars to improve decision-making impact.
What's included
6 videos4 assignments
6 videos•Total 59 minutes
- Bar Chart and Line Chart•9 minutes
- Pie Chart Nd Its Difference•8 minutes
- Advance Data Charts•12 minutes
- Advance Data Charts Continues•12 minutes
- Chart Sheet in Data Chart•7 minutes
- Trend Lines and Error Bars In Data Chart•10 minutes
4 assignments•Total 60 minutes
- Data Visualization & Chart Intelligence•30 minutes
- Core Chart Types•10 minutes
- Advanced Charting Techniques•10 minutes
- Enhancing Chart Insights•10 minutes
This module develops advanced analytical capabilities through Pivot Tables in Excel. Learners organize, group, summarize, and compute dynamic business reports using multi-level analysis, frequency distribution, calculated fields, and calculated items for professional reporting.
What's included
7 videos4 assignments
7 videos•Total 58 minutes
- Inserting Pivot Table•8 minutes
- Darg Fileds•7 minutes
- Grouping Using Pivot Table•6 minutes
- Grouping Using Pivot Table Continues•7 minutes
- Multi Level Pivot Table•9 minutes
- Frequency Distribution•10 minutes
- Calculated Fields•10 minutes
4 assignments•Total 60 minutes
- Pivot Tables & Analytical Reporting•30 minutes
- Pivot Table Fundamentals•10 minutes
- Grouping & Multi-Level Analysis•10 minutes
- Statistical Analysis in Pivot•10 minutes
This module introduces advanced analytical modeling techniques in Excel, including structured tables, calculated intelligence within Pivot Tables, and scenario-based what-if analysis using one-variable and two-variable data tables. Learners develop strategic decision-support capabilities using Excel BI tools.
What's included
6 videos4 assignments
6 videos•Total 47 minutes
- Calculated Items•9 minutes
- Calculated Items Continues•6 minutes
- Insert A Table•6 minutes
- Sorting and Changing Style•6 minutes
- One Variable Data Table•12 minutes
- Two Variable Data Table•8 minutes
4 assignments•Total 60 minutes
- Advanced Analysis & What-If Modeling•30 minutes
- Advanced Pivot Intelligence•10 minutes
- Structuring Data & Styling•10 minutes
- What-If Analysis Using Data Tables•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Explore more from Data Analysis
- Status: Free TrialM
Macquarie University
Specialization
- Status: Free TrialS
Simplilearn
Course
- Status: Free TrialL
Logical Operations
Course
- Status: Free Trial
Why people choose Coursera for their career
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,