Applied Excel and Analysis Services
4.0 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
91 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Applied Excel and Analysis Services to your Wishlist.

Add to Wishlist

Applied Excel and Analysis Services

Use the Excel BI capabilities to unlock the power of Analysis Services models
4.0 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
91 students enrolled
Created by Teo Lachev
Last updated 2/2015
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • Install AdventureWorksDW database (instructions provided in Lecture 1)
  • Install AdventureWorks Multidimensional cube and Tabular model
  • Have Excel 2007 or later (Excel 2013 recommended)

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.

Who is the target audience?
  • Business users
  • Managers
  • Data analysts
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
5 Lectures 29:32

Introduces the objectives of this class and explains prerequisites

Preview 03:45

Compares self-service and organizational BI to give you a high-level understanding of pros and cons of each approach.

Introducing Business Intelligence

Explains the advantages of having an Analysis Services BI semantic model to promote a single version of the truth.

Introducing Analysis Services

Why do use Excel as a BI tool?

Preview 02:57

Demonstrates how business users can create basic reports from Analysis Services.

Creating Excel Reports Connected to Analysis Services
Creating PivotTable Reports
11 Lectures 02:03:25

Learn how Excel works when connected to Analysis Services

Excel as Analysis Services Client

Walks you through connecting to Analysis Services

Preview 09:22

Introduces you to the PivotTable report anatomy and features.

Understanding PivotTable Reports

Discusses the elements of the PivotTable Field List

Understanding the PivotTable Field List

Learn how to perform different tasks to configure PivotTable reports, including layout changes, refresh options, creating PivotChart reports synchronized with the PivotTable reports, and showing member properties.

Configuring PivotTable Reports

Learn how to work with PivotTable Field List to create and change the report layout.

Creating the Report Layout

Practice different options for drilling data down, including working with hierarchies, fields, Excel 2013 Quick Explore, working with subtotals and member properties.

Drilling Down Data

Applying different options to filter and sort data.

Filtering and Sorting Data

Changing the report layout and applying conditional formatting

Modifying the Report Design and Appearance

Work with Analysis Services actions to extend your reports.

Working with Actions

Implementing calculated measures, named sets, OLAP formulas, and what-if analysis

Using Excel OLAP Features
Creating PivotChart Reports
9 Lectures 01:13:54

Explains elements of PivotChart reports.

Understanding PivotChart Reports

Learn how to create basic PivotChart reports

Configuring PivotChart Reports

Learn how to configure chart data series, secondary axis, and work with multiple measures.

Working with Data Series

Learn how to explore data at a lower level.

Drilling Down Data

Shows you how to filter and sort PivotChart reports.

Filtering and Sorting Data

Understand how PivotChart integrates with Analysis Services actions.

Working with Actions

Learn how OLAP features apply to PivotChart

Working with OLAP Features

Demonstrates how you can create dashboards that combine multiple reports.

Creating Dashboards

Learn how to work with slicers to filter multiple reports at the same time.

Working with Slicers
Creating Power View Reports
5 Lectures 58:50

Introduces you to Power View as an interactive reporting tool for data exploration.

Understanding Power View

Demonstrates how you can create Tabular visualizations.

Creating Tabular Visualizations

Shows you how you can work with chart visualizations

Creating Chart Visualizations

Learn how to analyze geospatial data by using the map visualization.

Performing Geospatial Analysis

Learn how to filter and sort data in Power View

Filtering Data
Sharing Reports
5 Lectures 31:33

Discusses SharePoint deployment options, including deploying to on-prem SharePoint, Office 365, and Power BI

Introducing SharePoint Insights

Discusses SharePoint connectivity options

Working with Shared Connections

Shows you how to deploy reports to SharePoint

Publishing Reports

Demonstrates how you can view Excel reports in SharePoint environment

Viewing Reports

About the Instructor
Teo Lachev
4.0 Average rating
4 Reviews
91 Students
1 Course
Consultant at Prologika

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 and co-authored several SQL Server Business Intelligence books and speaks frequently at industry conferences and local groups. He founded and has been leading the Microsoft Business Intelligence Group in Atlanta. Microsoft has recognized Teo's experience in Business Intelligence and contributions to the technical community by awarding him with Microsoft Most Valuable Professional (MVP) for ten years.