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.
90 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.
90 students enrolled
Created by Teo Lachev
Last updated 2/2015
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Install AdventureWorksDW database (instructions provided in Lecture 1)
  • Install AdventureWorks Multidimensional cube and Tabular model
  • Have Excel 2007 or later (Excel 2013 recommended)
Description

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
05:17:14
+
Introduction
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
10:01

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

Introducing Analysis Services
06:40

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
06:09
+
Creating PivotTable Reports
11 Lectures 02:03:25

Learn how Excel works when connected to Analysis Services

Excel as Analysis Services Client
03:21

Walks you through connecting to Analysis Services

Preview 09:22

Introduces you to the PivotTable report anatomy and features.

Understanding PivotTable Reports
02:08

Discusses the elements of the PivotTable Field List

Understanding the PivotTable Field List
14:03

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
16:56

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

Creating the Report Layout
06:54

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
16:29

Applying different options to filter and sort data.

Filtering and Sorting Data
13:14

Changing the report layout and applying conditional formatting

Modifying the Report Design and Appearance
12:18

Work with Analysis Services actions to extend your reports.

Working with Actions
08:26

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

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

Explains elements of PivotChart reports.

Understanding PivotChart Reports
10:33

Learn how to create basic PivotChart reports

Configuring PivotChart Reports
13:15

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

Working with Data Series
05:01

Learn how to explore data at a lower level.

Drilling Down Data
07:06

Shows you how to filter and sort PivotChart reports.

Filtering and Sorting Data
07:01

Understand how PivotChart integrates with Analysis Services actions.

Working with Actions
04:13

Learn how OLAP features apply to PivotChart

Working with OLAP Features
03:56

Demonstrates how you can create dashboards that combine multiple reports.

Creating Dashboards
13:37

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

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

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

Understanding Power View
17:59

Demonstrates how you can create Tabular visualizations.

Creating Tabular Visualizations
08:34

Shows you how you can work with chart visualizations

Creating Chart Visualizations
16:41

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

Performing Geospatial Analysis
07:18

Learn how to filter and sort data in Power View

Filtering Data
08:18
+
Sharing Reports
5 Lectures 31:33

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

Introducing SharePoint Insights
05:44

Discusses SharePoint connectivity options

Working with Shared Connections
04:03

Shows you how to deploy reports to SharePoint

Publishing Reports
07:45

Demonstrates how you can view Excel reports in SharePoint environment

Viewing Reports
12:10

Summary
01:51
About the Instructor
Teo Lachev
4.0 Average rating
4 Reviews
90 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.