Data Visualization
with
Excel & Power BI
Organized by: Data Solution 360
Class 1: Orientation
Data Literacy
How data works
Scope and opportunities
Salary and benefits.
Class 2: Mastering Microsoft Office for
Academic & Career Success
[Link]: The Power of Microsoft Office
[Link] Word – Professional Documentation
[Link] PowerPoint – Effective Presentations
[Link] & OneDrive – Communication &
Collaboration:
[Link] & Best Practices:
Connecting Word, Excel, PowerPoint, and
Outlook for efficient workflows
Tips to highlight Office skills on resumes and
LinkedIn
Encouraging consistent practice and
application for career readiness
Class 3: Excel Fundamentals & Data Automation
1. Excel Overview – Interface, ribbons, and essentials
thing
2. Working with Normal Data – (Data Entry)
3. Filtering Data – Purpose and basic usage
4. Table Data Benefit’s
5. Filter Data vs Table Data – Comparison and
practical differences
6. Data Automation Techniques
7. Essential Formulas – SUM, AVERAGE, MAX, MIN,
COUNT
8. Conditional Formulas – SUMIF, SUMIFS,
AVERAGEIF/IFS, COUNTIF/IFS
9. Text Formula & XLOOKUP
Class 4: Conditional Formatting & Applied Data
Analysis
[Link] – Practical implementation .
[Link] Formatting – From basic to practical
business use cases
Highlighting rules, Data Bars.
[Link] an E-commerce Sales Tracking System
Preparing the dataset for analysis
Applying formulas with Conditional Formatting
Creating KPI
Class 5: Pivot Table & Business Insights
Introduction to Pivot Tables – Definition and use
cases
[Link] Table Structure – Rows, Columns, Values, and
Filters
[Link] Master Data – Organizing and
preparing data for analysis
[Link] Analysis with Pivot Tables
[Link] KPIs – What they are and how to
identify key insights
[Link] Basic Charts & Graphs – Column, Bar,
Line, Pie
[Link] Slicers & Report Connections for interactive
reports
Class 6: Dashboard Development & Visualization
[Link]
[Link] E-commerce Dashboard Project
Building interactive reports using Pivot Charts
and Slicers
Designing report connections and automation
[Link] Design & Visualization Techniques
Effective color combinations
Layout and formatting tips for professional
dashboards
[Link] Presentation & Exporting Reports
Class 7: Power BI UI Walkthrough
[Link] is Power BI?
[Link] BI Key Feature
[Link] Power BI is Important?
[Link] BI Market Demand & Career Opportunities
[Link] to install Power BI
[Link] data in Power BI: Folder, CSV, .XLXS, JSON,
My SQL Server, Web, Access Database
Class 8: Power Query in Power BI
[Link] Data type, Replace Values and Rearrange
the columns in Power BI
[Link] types (numeric, text, date/time etc.)
[Link] with text (split, trim, upper, lower etc.)
[Link] columns, remove columns, rows, etc
[Link] text with delimiter
[Link] between Add Column and Transform
[Link] to remove duplicates in Power BI
[Link] Queries using Power BI
[Link] Queries using Power BI
Class 9: Dax in Power BI
[Link] Introduction
[Link] is it for?
[Link] Column
[Link] Measure
[Link] Measure
[Link] Measure
[Link] Functions
[Link] with Dates
[Link] vs Iterator Functions
Class 10: End to End Project
[Link] an End to End Scenario based Interactive
Dynamic Dashboard