The Inside Story: Self-Service-BI in MS Excel 2013
0.0 (0 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.
235 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Inside Story: Self-Service-BI in MS Excel 2013 to your Wishlist.

Add to Wishlist

The Inside Story: Self-Service-BI in MS Excel 2013

Be a master in self-service business intelligence tools in MS Excel
0.0 (0 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.
235 students enrolled
Created by GreyCampus Inc.
Last updated 10/2016
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Explore and connect to data sources using Power Query
  • Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle MySQL DB & others
  • Comprehend the Power Pivot user interface
  • Extract and transform data using Power Query
  • Build a cascading relationship and manage data models
  • Build a relationship between tables from different sources
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

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

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Explore and connect to data sources using Power Query
  • Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle MySQL DB & others
  • Comprehend the Power Pivot user interface
  • Extract and transform data using Power Query
  • Build a cascading relationship and manage data models
  • Build a relationship between tables from different sources

The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365  to create self-service data models and reports. This course is designed for customers who are interested in learning Self-Service BI tools and techniques.

Who is the target audience?
  • This course teaches how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.
  • The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies.
  • Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 02:01:23
+
Course Introduction
1 Lecture 02:36
+
Importing data present in other formats
1 Lecture 09:27
+
Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
1 Lecture 20:23
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
1 Lecture 11:02
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
1 Lecture 09:32
Formatting columns and modifying data types dynamically ; using simple DAX comma
09:32
+
Linking Excel to external data sources / websites
1 Lecture 11:25
Linking Excel to external data sources / websites
11:25
+
Exploring new components of Charts in MS Excel
2 Lectures 28:10
Exploring new components of Charts in MS Excel Part 1
17:08

Exploring new components of Charts in MS Excel Part 2
11:02
+
Introduction to Power Pivot tool to create instant Data Models and link tables
2 Lectures 26:44
Introduction to Power Pivot tool to create instant Data Models and link tables
18:01

Introduction to Power Pivot tool to create instant Data Models Part 2
08:43
+
Overview of visualization of geographical data
1 Lecture 00:51
Overview of visualization of geographical data
00:51
+
Additional Material
1 Lecture 00:02
Additional Material
00:02
3 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
1,723 Reviews
21,060 Students
42 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.