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
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
Please note that many coupons are limited-time coupons. Please let us know if you find any expired coupon.
0 Comments