Applied Excel and Analysis Services

Unlock Excel's BI capabilities to analyze Analysis Services models and empower your organization with interactive data insights through versatile reports and dashboards.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is your go-to guide for tapping into Excel's BI features to analyze data from Analysis Services models. It's packed with practical tips to transform your data into reports, dashboards, and insights that can be easily shared. Get ready to be amazed by Excel!

Key Points

  • Unlock the power of Excel for data analysis
  • Ideal for BI managers, developers, and business users
  • Learn to create reports and dashboards
  • Share BI reports using SharePoint
  • Surprising capabilities of Excel BI tools

Learning Outcomes

  • Become a skilled data analyst using Excel
  • Create dynamic reports and dashboards easily
  • Publish and share your insights on SharePoint
  • Learn to analyze Multidimensional cubes and Tabular models
  • Discover unexpected features of Excel for BI

About This Course

Use the Excel BI capabilities to unlock the power of Analysis Services models

To BI managers and BI developers: You've implemented an organizational Analysis Service model. Congratulations! Now you need to choose a tool for interactive data analytics and train your users. As you know, there is a proliferation of Business Intelligence tools on the market and each claims to solve your challenges. But the chances are that you already have what you need – Microsoft Excel. And, as far as the documentation goes, who has time to document all Excel BI features and demo them to users? I designed this class to help you empower your users and get them excited about BI with Excel.

To business users: If your organization have Analysis Services Multidimensional cubes or Tabular models and you want to gain valuable insights from them, then this course is for you. Designed as a step-by-step tour, this course teaches you how to become a data analyst and unlock the hidden power of data. You'll learn how to apply the Excel desktop BI capabilities to create versatile reports and dashboards for historical and trend analysis. You'll learn also how to share your BI artifacts across the organization by publishing them to SharePoint. "I never knew Excel can do this" is the most common feedback we hear from our students.

The course includes 5.5 hours of recorded content. For best visual experience, turn on the HD option in the video controller because the hosting site doesn't support this by default.

  • Acquire data analyst and BI skills to analyze Analysis Services models

  • Create tabular, chart, geospatial reports and dashboards

  • Share reports by publishing them to SharePoint

Instructor

Profile photo of Teo Lachev
Teo Lachev

Teo Lachev is a consultant, author, and mentor with more than 20 years of industry experience. Through his company, Prologika (Microsoft Gold BI partner) located in Atlanta, United States, he has implemented BI solutions that have added tremendous value to his customers. A Microsoft Certified Trainer, Teo has developed several BI classes that deliver applied, under-the-hood training. He has authored...

Review
4.9 course rating
4K ratings
ui-avatar of Ikanyeng Kwenampe
Ikanyeng K.
5.0
8 years ago

Teo explains the concepts clearly in simple language. Excellent Content.

  • Helpful
  • Not helpful
ui-avatar of Kdprof
Kdprof
5.0
9 years ago

Excellent course material and coverage of concepts with step-by-step demos.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses