Business Intelligence (BI) and Analysis using MS Excel

Business Intelligence (BI) and Analysis using MS Excel

Data is exploding exponentially and now the world requires analyst to analyze them. Business Intelligence (BI) is the method for analyzing this data and presenting actionable information to help corporate executives, business managers and other end users to make informed business decisions.

Close

Overview

Course Summary

Business Intelligence is the new buzz word. Multi National Corporation and different companies are hiring professionals who understand data and BI. Microsoft Excel is the most commonly used BI Tool in the market. In this Course, you will receive healthy understandings of the Business Intelligence Concept and of course be a master in MS Excel. The course will also maximize your skill set with Microsoft Excel. The course simplifies powerful features like PivotTables, Charts, Formulae, Power-Pivot, Sparkline, Conditional Formatting and many more!

Close

Course Structure

    BEGINNERS EXCEL Part 1: Introduction
    • What is Business Intelligence (BI)?
    • How excel is used as a Business Intelligence Tool?
    • Understanding the BI Terminologies
    Part 2: Understanding and Preparing the Data
    • Data Preparation
    • Sorting by Color
    • Other ways to Filter
    • Understanding Tables
    Part 3: Text Handling Trick for Business Intelligence
    • Drag the Fill Handle
    • Create Your Own Series
    • Joining Text
    • Rapid Formula Copy
    • Convert to Proper Case
    • Formulas to Values
    • Breaking Apart Text
    • Parsing Fixed Width
    INTERMEDIATE EXCEL Part 4: Essential Formulas for Business Intelligence
    • AutoSum Tricks
    • Relative Versus Absolute Formulas
    • IF Formulas
    • Sumifs
    • VLOOKUP
    • Month()
    • Text()
    • Year()
    • Day()
    • Choose()
    Part 5: Charting
    • Creating and Formatting a Chart
    • Adding or Removing Chart Data
    • Pie Chart Tricks
    • Sparkline
    • Part 6: Visual Impact
    • Color Scales, Icon Sets, Data Bars
    • Icons for Only a Subset
    • Paired Bar Charts with Negative Data Bars
    ADVANCE EXCEL Part 7: Business Intelligence with Pivot Tables
    • Creating a Pivot Table
    • Changing a Pivot Table
    • Pivot Formatting
    • Drill Down
    • Pivot Calculations
    • Summarizing Dates
    • Pivot Sorting
    • Top 10 Report
    • Filtering a Pivot Table with Slicers
    • Slicers on Two Pivot Tables
    • Connecting Slicers with multiple tables
    Getting to know about Power BI Features of Excel
    • Introducing Dashboards, Scorecards and KPIs
    • PowerPivot: Extend the capacity of excel with PowerPivot
    • PowerView: Explore amazing data visualization technique using these amazing new features
    • PowerQuery: Finally!!! ETL is now available in Excel. We will explore the wonderful data merging tool
    Part 8: Tips and Tricks
    • Navigate Fast through Range workbooks and Worksheets
    • Removing Duplicates
    • Shrink Text
    • Transposing Tricks
    • Hide Data
    • Important Sheet
    • Data Validation
    • Fill up in the sideways
    • Switch Column Trick
    • Fill Blank Trick
    • Formula to Value
    • F4 trick
    • Format Part of Cell
    • Copying Sheets
    • Insert Blank Rows
    • Pick from List
    • Print Small Selection
    • Fit to One Page Trick
    • Speak Cells

Close

Course Benefits - What do I learn?

The course is separated in three Difficulties level- Beginner, Intermediate and Advance. As the course progresses you will be introduces with Powerful Technics that will take you from Novice to Professional. How participants will benefit after the course. This course will walk you through the world of business intelligence. You will learn BI Terminologies, Concepts and start building your own self service business intelligence platform using Microsoft excel immediately after the course completion. You be explored to many uncovered area of MS Excel that will help you to become more productive from day one.

Close

Target Participants

This course is very useful for anyone who works with Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.

Close

  
Calender 2018

Code: Type: Location: Fees: Start date: Duration: Register:
PPP104 Weekday Ikeja,Lagos N68,250 7-May-2018 2 days Register Online
PPP104 Weekday Ikeja,Lagos N68,250 6-Sep-2018 2 days Register Online
Close

NOTE: To further leverage the value and impact of the Programme, we encourage organisations to send cross-functional teams of executives to P4PE Institute. We offer one of two exciting group benefits to companies sending three or more participants to this programme.

Course Registration

Advanced registration is required to join this course. Limited class size and registration window means early birds have an advantage. Register now and access qualifying discounts.