Productivity Revolution in Excel

Overview

Discover how to leverage Excel and Power BI for powerful business intelligence. Learn to create charts, dashboards, and formulas, and master data extraction, modeling, and visualization techniques.

Syllabus

• Introduction to Excel for Business Intelligence
Overview of Excel's role in data analysis
Navigating the Excel workspace
Fundamental Excel functions and tools
• Data Extraction Techniques
Importing data from various sources
Cleaning and preparing data for analysis
Using queries to extract relevant data
• Advanced Formulas and Functions
Logical functions (IF, SWITCH, etc.)
Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
Text and date manipulation
Array formulas and dynamic arrays
• Data Modeling in Excel
Creating and managing Power Pivot data models
Understanding relationships and hierarchies
Using the DAX language for calculated columns and measures
• Data Visualization with Excel
Designing effective charts and graphs
Introduction to PivotTables and PivotCharts
Customizing visualization elements for clarity and impact
• Building Interactive Dashboards
Principles of dashboard design
Using form controls and slicers to enhance interactivity
Integrating multiple data visualizations
• Introduction to Power BI
Overview of Power BI and its components
Connecting and transforming data with Power Query
Creating reports and visualizations in Power BI
• Enhancing Reports with Power BI
Building interactive dashboards in Power BI
Publishing and sharing reports
Integrating Power BI with Excel
• Final Project
Developing a comprehensive business intelligence dashboard
Presenting insights and recommendations based on data analysis
Peer review and feedback session
• Course Summary and Next Steps
Review of key concepts and skills
Resources for further learning and practice
Career and application opportunities in business intelligence

Subjects

Conference Talks