Your Training Partner in Cutting Edge Technologies

Your Training Partner in Cutting Edge Technologies:
CTTC has committed to enhance the quality and professionalism of IT Industry by administering and supporting quality education programs and industry recognized certifications. Whether the need is to train individuals the use of the latest Office Application or to retool engineers to support cutting-edge digital networks CTTC has the skill, knowledge and personnel to deliver the solution for your need.

 

Business Intelligence with Microsoft Excel

Course Description

In this fast moving technological business world the significance of business Insights increasing every passing day. Business users want Data Analytical abilities on their desktops, rather relying on IT Professionals for providing solutions.

Microsoft also envisioned this desire and replied with the tools, Power BI and Power Query, so that Business users can create their own Data Models and dashboards, using the slicing and dicing tool of Excel.
In this Training you will explore Microsoft Excel for available Business Intelligence capabilities of this tool

COURSE CONTENTS

PivotTable

  • Creating PivotTables
  • Summarizing Pivot Table Data
  • Sorting, Filtering and Formatting Pivot
  • Creating and Manipulating Pivot Charts

PowerPivot

  • What is PowerPivot
  • Importing Data into PowerPivot
  • Creating Data Model
  • Calculations with DAX
  • Creating KPIs
  • Data Analysis with Pivot Table and Charts

Building Interactive Reports and Dashboards with Power View

  • What is Power View
  • Creating Visualizations
    • Creating Table
    • Creating Matrix
    • Creating Chart
    • Creating Map
    • Creating Cards
    • Using KPIs
    • Filtering Data using Slicer and tiles
    • Exposing the Dashboard using SharePoint & Office 365

Power Query

  • Introducing Power Query
  • Power Query Data Sources
  • Transforming Data with Power Query
  • Introduction to M Language Concepts

Duration : 12 Hours

Please give us your valuable comment

Your email address will not be published. Required fields are marked *

*
*
*

 

cheap rolex watches replica rolex Cheap Rolex Replica Watches cheap rolex watches cheap rolex watches replica uk cheap rolex watches Cheap Rolex Watches Cheap Rolex Watches uk cheap rolex watches cheap rolex watches for sale uk replica rolex watches

  • Typepad
  • Trumba
  • Facebook
  • Twitter
  • Pinterest
  • Linkedin

© Copyright 1997 - 2015, All rights are reserved.

CTTC Partners