Lunch & Learn: "Explore and Analyze your Data using Excel" - CANCELLED

Enter today’s new world of Business Intelligence using Excel PowerPivot, PowerMap, PowerQuery, PowerView. Excel's Power Tools are a total game changer!
 
Description:
An overview of how the four components of Microsoft’s Power BI suite (Power Query, Power Pivot, Power View, and Power Map) work together to provide amazing data analysis possibilities, all within Excel
During the presentation, you will see the following features demonstrated
• Import and transform data from various data sources using PowerQuery 
• How Power Pivot adds significant power to Excel’s existing data analysis tools
• The Power Pivot user interface, and how to create pivot tables with Power Pivot
• The DAX language in Power Pivot to build powerful calculations
• Hierarchies and KPIs (key performance indicators) created with Power Pivot
• Power View and Power Map to create insightful reports and maps with very little work

Presenter: Garland Johnston - Johnston BI Consulting

For more than 30 years, Garland has been working with business's of all sizes to identify needs, define strategy, and delivery methods of analytics to measure performance against goals and identify trends.