Data Analysis And Business Intelligence With Microsoft Excel

Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions

Created by: Travis Cuzick
Data Solutions Engineer

What Will I Learn?

• Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for your analysis
• Master the art and science of Data Modeling in Excel, connecting your datasets from Power Query so they can be analyzed together
• Build "Power" Pivot Tables to rapidly extract insights from your Data Model, whether your data tables have 10 rows or 10 million
• Become proficient in the DAX formula language, to inject more sophisticated calculations and KPIs into your Pivot Tables than you even thought possible
• Polish your calculations into professional presentations with data visualization tools like Pivot Charts and conditional formatting
• Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen
• Retain - AND build on - everything you've learned, by tackling dozens of hands-on exercises that cover every concept in the course

Requirements

• Microsoft Excel 2013 or above
• A Windows PC (unfortunately, most of these tools won't work on Excel for Mac)
• Basic knowledge of Microsoft Excel, especially formulas and functions

Target audience

• Aspiring Analysts who want to take their careers to the next level by unleashing Microsoft Excel's Business Intelligence functionality to build data solutions that stand out and get noticed
• Data Professionals who want to quickly augment their skills by mastering an easy to use, yet industrial-strength Business Intelligence toolset
• Business owners or executives who want to empower their employees to deliver self-service Business Intelligence without buying expensive, specialized software
• Any Excel user who wants to unlock the secrets of their data using the best-in-class analytical tools right in their Excel spreadsheet