Data Analysis And Business Intelligence With Microsoft Excel

• 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

Who this course is for:

• 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