If you build reports in Excel, Power BI is the natural next step for interactive data visualization. This 75-minute introduction to Microsoft Power BI dashboards gives Excel users a clear picture of what the tool can do.
You'll compare data visualization in Excel and Power BI, then follow the Power BI workflow from desktop to service and mobile. The session looks at Power Query, relationships and data models in Power BI Desktop, and shows how to navigate reports in the Power BI service.
You'll also see interactive features such as slicers, filters, bookmarks, drill-down and drill-through, and how data moves between Excel and Power BI in both directions. Having Power BI Desktop and a Power BI service subscription is helpful but optional.
WHY SHOULD YOU ATTEND?
If you have wondered whether Power BI suits you or your organization, or large datasets are slowing Excel down, this session helps you decide. You'll see how Power BI builds on what you already know in Excel, which shortens the learning curve, and how its reports are more dynamic and interactive.
It suits data analysts, marketing and program analysts, supply chain professionals, manufacturing managers and anyone who works with Excel or Power BI reports, from newcomers to experienced users.
AREA COVERED
- What Power BI is and why it matters for data analysis
- Power BI vs Excel for data visualization
- The Power BI workflow: desktop, service and mobile
- Power BI Desktop: Power Query, relationships and data models
- Navigating and using reports in the Power BI service
- Interactive features: slicers, filters and bookmarks
- Drill-down and drill-through features
- Importing Excel data into Power BI and exporting report data to Excel
- Live Q&A
LEARNING OBJECTIVES
- Explain the key differences between data visualization in Excel and Power BI
- Describe the Power BI workflow from data import to dashboard
- Recognize the roles of Power Query, relationships and data models
- Navigate and interact with reports in the Power BI service
- Use slicers, filters, bookmarks, drill-down and drill-through
- Move data between Excel and Power BI
WHO WILL BENEFIT?
- Data Analysts
- Supply Chain Professionals
- Marketing Analysts
- Program Analysts
- Manufacturing Managers
If you have wondered whether Power BI suits you or your organization, or large datasets are slowing Excel down, this session helps you decide. You'll see how Power BI builds on what you already know in Excel, which shortens the learning curve, and how its reports are more dynamic and interactive.
It suits data analysts, marketing and program analysts, supply chain professionals, manufacturing managers and anyone who works with Excel or Power BI reports, from newcomers to experienced users.
- What Power BI is and why it matters for data analysis
- Power BI vs Excel for data visualization
- The Power BI workflow: desktop, service and mobile
- Power BI Desktop: Power Query, relationships and data models
- Navigating and using reports in the Power BI service
- Interactive features: slicers, filters and bookmarks
- Drill-down and drill-through features
- Importing Excel data into Power BI and exporting report data to Excel
- Live Q&A
- Explain the key differences between data visualization in Excel and Power BI
- Describe the Power BI workflow from data import to dashboard
- Recognize the roles of Power Query, relationships and data models
- Navigate and interact with reports in the Power BI service
- Use slicers, filters, bookmarks, drill-down and drill-through
- Move data between Excel and Power BI
- Data Analysts
- Supply Chain Professionals
- Marketing Analysts
- Program Analysts
- Manufacturing Managers