Microsoft Excel Self-Service BI - Online Self Learning

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the maximum, rather than focusing on individual Excel functions and features. 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.

USD 400

1 year e-learning access
Hands-on videos
Data sets and Exercises
Additional Materials

Introduction of the Course :

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.

  • High impact, proven training – 30000+ professionals trained globally

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

  • Classroom Training programs delivered across 50+ locations globally

  • Content is developed in-house in GreyCampus by highly experienced industry experts

Course Objectives :

  • 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

FAQ's :

Q. What are the Pre-requisites for this course?

A. Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.

Q. Do I need to have statistics background to understand the concepts?

A. No. Not mandatory. However, people with such background would be able to apply the concepts easily to their working environment.