Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions
Sub Category
- Business Analytics & Intelligence
{inAds}
Objectives
- 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
Pre Requisites
- 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
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)