PDF Add to WishList
Microsoft’s Power Pivot and business intelligence tools allow you to effectively mine large amounts of data. In this advanced Microsoft Excel training course, you gain the knowledge and skills to import and merge large amounts of data, summarize and aggregate data, present strategic data, provide better business insights, and empower informed decision-making.
Introducing Power Pivot
Employing Power Pivot in the BI process
Defining a consolidated view of data
Denormalizing data to simplify usage within other BI reporting tools
Querying SQL Server data
Fixing common data issues with Power Query
Defining measures for business performance
Implementing DAX functions in Power Pivot
Exploiting data analytics with aggregation
Mining for information with date and time analysis
Setting key business targets with KPIs
Articulating and analyzing data
Designing effective dashboards
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will: