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
Highest rated
*
22,708 students
Created by *
Last updated 1/2023
English
English [Auto]What you'll learn
==============================
pass:damaswiki.net
*
===============================
Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions
Highest rated
*
22,708 students
Created by *
Last updated 1/2023
English
English [Auto]What you'll 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
==============================
pass:damaswiki.net
*
===============================
