In this presentation, you'll learn how pivot tables fit into the world of analytics, earn what pivot tables are and how to create them, and even get an introduction to the next generation of pivot tables in Power BI.
WHY SHOULD YOU ATTEND?
Excel is a powerful tool for analyzing data, including data mining. In this presentation, you’ll discover how to use pivot tables to see data in new and exciting ways. And data mining in Excel is not just for accountants. The tools in Excel can benefit HR professionals as well.AREA COVERED
- An Introduction to Data Analysis
- A brief history
- Why Pivot tables?
- How pivot tables are used in data analysis
- Pivot table basics
- Creating a pivot table on a worksheet
- Manipulating the data
- Advanced pivot tables
- Getting and transforming data
- Meet the Power family
- PowerPivot
- PowerQuery
- Power BI
- Visualizations (aka Charts and graphs)
- Pivot tables
- Transforming and shaping data
LEARNING OBJECTIVES
- Why Excel ®?
- What are pivot tables?
- How to create pivot tables
- Data mining using pivot table
- Best practices
- Data normalization
- Conclusion
WHO WILL BENEFIT?
- HR professionals at all levels.
Excel is a powerful tool for analyzing data, including data mining. In this presentation, you’ll discover how to use pivot tables to see data in new and exciting ways. And data mining in Excel is not just for accountants. The tools in Excel can benefit HR professionals as well.
- An Introduction to Data Analysis
- A brief history
- Why Pivot tables?
- How pivot tables are used in data analysis
- Pivot table basics
- Creating a pivot table on a worksheet
- Manipulating the data
- Advanced pivot tables
- Getting and transforming data
- Meet the Power family
- PowerPivot
- PowerQuery
- Power BI
- Visualizations (aka Charts and graphs)
- Pivot tables
- Transforming and shaping data
- Why Excel ®?
- What are pivot tables?
- How to create pivot tables
- Data mining using pivot table
- Best practices
- Data normalization
- Conclusion
- HR professionals at all levels.