Microsoft office 365 - Self-Service BI for Managers
4.0 (1 rating)
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.
465 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft office 365 - Self-Service BI for Managers to your Wishlist.

Add to Wishlist

Microsoft office 365 - Self-Service BI for Managers

Explore the Self-service BI tools which is intended for Analysts in Microsoft Excel.
4.0 (1 rating)
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.
465 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 6 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
What Will I Learn?
  • Utilize the data analysis and protection capabilities of worksheets
  • Reduce data speculation by using Excel’s data Analysis capabilities
  • Explore some of the amazing and lesser known functions aimed at providing meaningful information
  • Generate Pivot tables and charts to explore data sets
  • Implement slicers to develop instant dashboards
  • Explore and connect to data sources using Power Query
  • Comprehend the Power Pivot user interface
  • Build a relationship between tables from different sources
View Curriculum
Requirements
  • Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

This course is intended for the analysts and business users who are willing to explore the self-service business intelligence tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

  • Utilize the data analysis and protection capabilities of worksheets
  • Reduce data speculation by using Excel’s data Analysis capabilities
  • Explore some of the amazing and lesser known functions aimed at providing meaningful information
  • Generate Pivot tables and charts to explore data sets
  • Implement slicers to develop instant dashboards
  • Explore and connect to data sources using Power Query
  • Comprehend the Power Pivot user interface
  • Build a relationship between tables from different sources

Microsoft Excel still remains the top Business Intelligence tool in use today, and it will continue its reign despite marketing efforts of other BI technology vendors. Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self-service BI capability and tend to create their own BI solution intuitively without much dependence on IT. As capabilities continue to evolve that put tools into the hands of information workers that are easier and easier to use, we expect to see Self-Service BI continue to grow and complement Corporate BI for reporting and analytics.

Who is the target audience?
  • Multiple types of Self-Service BI with varying needs, abilities, and preferences.
  • Capabilities for the creation of reports and dashboards, data models, data integration and cleansing, statistical analysis, predictive analytics, as well as analysis of geospatial, unstructured, and streaming data.
  • Self-Service BI for Excel Course ensures that you get accurate, complete and timely reports from your enterprise system.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
36 Lectures
05:42:26
+
Course Introduction
1 Lecture 03:20
+
Starting Microsoft Excel
6 Lectures 51:07

Understanding Cell References
13:06

The Backstage view - Analysis Perspective
10:36

Printing Worksheets - Print Area, Headers /Footers
05:41

Excel protection features (password Protecting sheets, and hiding Formula)
06:29

Exporting Excel data to other formats - CSV, PDF, and others
07:58
+
Some Important Functions – for Scorecards and Performance Dashboards
5 Lectures 50:22
Useful Text Functions – TEXT, CONCATENATE, INSTR, REPT, etc.
16:43

Important Date Functions – EOMONTH, NETWORKDAYS, etc.
11:09

Common Financial Functions – NPER, PV, PMT, etc.
08:59

Exploring Volatile Functions - TODAY, NOW, RAND, RANDBETWEEN, etc. New
07:34

Using weighted average and RANK function for scorecards
05:57
+
Additional Material
1 Lecture 00:02
Additional Material
00:02
+
Exercises
1 Lecture 00:03
Exercises
00:03
+
Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
5 Lectures 01:09:48
Creating Pivot Tables using complex datasets
18:57

Generating Pivot Charts Instantly
15:26

Implementing Slicers to build Interactive dashboards
15:05

Grouping and Sub Total of Data in Pivots
09:42

Beautifying reports / tables using Sparklines
10:38
+
Advanced Data Validation and Analysis (What-If-Analysis)
4 Lectures 40:55
Designing Aged Reports and understanding data bucketing concepts Part 1
11:14

Designing Aged Reports and understanding data bucketing concepts Part 2
09:32

Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
13:46

Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
06:23
+
Additional Material
1 Lecture 00:02
Additional Material
00:02
+
Exercises
1 Lecture 00:03
Exercises
00:03
+
Import / Export Business with Excel (Data Mining)
5 Lectures 01:04:23
Importing data present in other formats
11:08

Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
20:23

Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle My
11:02

Formatting columns and modifying data types dynamically ; using simple DAX comma
09:32

Linking Excel to external data sources / websites
12:18
4 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
2,196 Reviews
26,757 Students
53 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.