Business Intelligence Fundamentals

Business intelligence; the term is bandied about so frequently today that it might seem like everyone except you already understands it. The truth is that like its partner “Big Data”, business intelligence is actually not well understood at all. Most people who talk about business intelligence have at best a general notion of what it means and almost no experience with actually using BI in a meaningful way. However, BI is an important new tool for modern business. Advances in computing power can now give businesses ways to analyze data that they never could before. With these advances, firms can make decisions about pricing, marketing, new products, and resource allocation more effectively than they have ever been able to in the past. Major corporations like Kroger are starting to use BI to help determine what products they should advertise to specific customers. General Electric is using BI to more efficiently run its industrial maintenance schedules. Citi is using BI to help proactively figure out the maximum interest rates various customers are willing to pay. BI is useful in all of these settings and a lot more.

What you'll learn:

  • Understand what business intelligence is.
  • Describe how business intelligence works on a theoretical basis.
  • Discuss the broad advantages and disadvantages of business intelligence.
  • Explain in general terms what steps firms need to take to implement business intelligence
  • Identify areas where business intelligence can alter the way a company conducts operations.

Have Any Questions? Call Us Today!

+91 9787371365

Brochures

Click On Download Button Below And Check Our Courses

Business Analytics Course Outline

  • Oracle – SQL
  • Oracle SQL – Home
  • Oracle – SQL – Introduction
  • Oracle – SQL – Environment Setup
  • Oracle – SQL – Getting Started
  • Oracle – SQL – DDL Statements
  • Oracle – SQL – Create Table
  • Oracle – SQL – Alter Table
  • Oracle – SQL – Drop Table
  • Oracle – SQL – Truncate Table
  • Oracle – SQL – Constraints
  • Oracle – SQL – Not Null Constraint
  • Oracle – SQL – Unique Constraint
  • Oracle – SQL – Primary Key Constraint
  • Oracle – SQL – Check Constraint
  • Oracle – SQL – Foreign Key Constraint
  • Oracle – SQL – Managing Constraints
  • Oracle – SQL – Data Manipulation Language
  • Oracle – SQL – Insert Statement
  • Oracle – SQL – Update Statement
  • Oracle – SQL – Delete Statement
  • Oracle – SQL – Select Statement
  • Oracle – SQL – Sorting Data
  • Oracle – SQL – Filtering Data
  • Oracle – SQL – Functions
  • Oracle – SQL – General Functions
  • Oracle – SQL – Joins
  • Oracle – SQL – Group Functions
  • Oracle – SQL – Group By Clause
  • Oracle – SQL – Creating Users

Business Intelligence Basics / Data warehouse Fundamentals

  • What is a Data Warehouse?
  • Data Warehousing Schemas
  • Modelling Types
  • BI Architecture Overview
  • Star and Snow Flake Examples and differences
  • Dimensions and Fact Table types
  • Overview of BI and Data Integration Products

Microsoft Power BI Desktop Visualisation

  • Basics of Data warehouse Concepts / BI Concepts (Data Model types , Facts and Dimensions)
  • Overview of Power BI Tools.
  • Introduction to Tools and Terminology.
  • Connecting to Microsoft Excel , Web Data , Overview of Power Query Editor , Data Model.
  • Gives you an overview of the interface and gets you started in creating
  • your first Power BI Report
  • gets you started with the Power Query Editor (cleaning up messy data)
  • create your custom datestable using MCode Method.
  • you learn advanced Power Query Transformation Steps
  • Using Themes and Import Custom Themes from Gallery.
  • How to set up your data model – Setup and Manage relationships.
  • Using Edit Interactions.
  • Creating Calculated Columns.
  • Starting with Measures and Quick Measures.
  • DAX: SUMX function
  • Create a measures table to keep all the custom measures at single Place.
  • DAX: SUMX with RELATED
  • DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, FILTER,
  • ALLSELECTED, MAX
  • Build your Report, use custom visuals
  • DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, DATEADD
  • RANKX, ALL, GENERATESERIES, IF with Parameter
  • DAX Timeintelligence: CALCULATE, FILTER, ALLSELECTED, MAX (=>
  • cumulative Sales)
  • Visualizing DAX Calculations.
  • Hierarchies and Groups Concepts.
  • Using Various types of graphs and Slicers to filter the data.
  • Using Filters – Page and Report Level.
  • Using Tool Tips at Page Level and Field Level
  • Conditional Formatting in Tables and Graphs.
  • Using Buttons and Actions.
  • Creating Bookmarks with Various actions.
  • Using Ask a Questions to create Custom visuals.
  • Using Market Place to add Custom visuals to Visualisations (Aster , Radar , Sankey and Chord Plots demo)
  • Use Scrollers and Hierarchy Slicers from Market Place.
  • Sample Reports using Database Tables – Demo to connect any database.
  • Publish reports to Power BI Service.
  • Creating Dashboards and Insights.
  • Interacting with your Dashboards
  • Sharing Dashboards and Reports.

Additional Topics: (with DAX)

  • Text functions
  • Mathematical functions
  • Time intelligence functions
  • Filter functions
  • Aggregate functions
  • Logical functions
  • Count functions
  • Information functions

Advanced Topics: (With DAX)

  • Inter and Intra column operation
  • Data handling with tables
  • Variables
  • Conditional operation
  • Introduction and Overview
  • BI and Data warehouse Overview
  • Why Tableau? Why Visualization?
  • Getting Started – creating some powerful visualizations quickly
  • The Tableau Product Line
  • Things you should know about Tableau
  • Getting Started
  • Connecting to Data and introduction to data source concept
  • Working with data files versus database server
  • Understanding the Tableau workspace
  • Dimensions and Measures
  • Using Show Me!
  • Tour of Shelves (How shelves and marks work)
  • Building Basic Views
  • Help Menu and Samples
  • Saving and sharing your work
  • Creating Views
  • Marks
  • Size and Transparency
  • Highlighting
  • Working with Dates
  • Date aggregations and date parts
  • Discrete versus Continuous
  • Dual Axis / Multiple Measures
  • Combo Charts with different mark types
  • Geographic Map Page Trails
  • Heat Map
  • Density Chart
  • Scatter Plots
  • Pie Charts and Bar Charts
  • Small Multiples
  • Working with aggregate versus disaggregate data
  • Analyzing
  • Sorting & Grouping
  • Aliases
  • Filtering and Quick Filters
  • Cross-Tabs (Pivot Tables)
  • Totals and Subtotals Drilling and Drill Through
  • Aggregation and Disaggregation
  • Percent of Total
  • Working with Statistics and Trend lines
  • Getting Started with Calculated Fields
  • Working with String Functions
  • Basic Arithmetic Calculations
  • Date Math
  • Working with Totals
  • Custom Aggregations
  • Logic Statements
  • Formatting
  • Options in Formatting your Visualization
  • Working with Labels and Annotations
  • Effective Use of Titles and Captions
  • Introduction to Visual Best Practices
  • Building Interactive Dashboard
  • Combining multiple visualizations into a dashboard
  • Making your worksheet interactive by using actions and filters
  • An Introduction to Best Practices in Visualization
  • Sharing Workbooks
  • Packaged Workbooks
  • Publish to Tableau Server and Sharing over the Web
  • Putting it all together
  • Scenario-based Review Exercises
  • Best Practices

Repository Basics

  • Exploring Oracle BI architecture components
  • Exploring a repository’s structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository
  • Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

  • Importing data sources
  • Setting up connection pool properties
  • Defining keys and joins
  • Examining physical layer object properties
  • Creating alias tables

Building the Business Model and Mapping Layer of a Repository

  • Building a business model
  • Building logical tables, columns, and sources
  • Defining logical joins
  • Building measures
  • Examining business model object properties

Building the Presentation Layer of a Repository

  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties

Testing and Validating a Repository

  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Executing analyses to test a repository
  • Inspecting the query log

Managing Logical Table Sources

  • Adding multiple logical table sources to a logical table
  • Specifying logical content

Adding Calculations to a Fact

  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Creating new calculation measures using the Calculation Wizard
  • Creating measures using functions

Working with Logical Dimensions

  • Creating logical dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating dimension-specific aggregation rules
  • Creating presentation hierarchies
  • Creating parent-child hierarchies
  • Using calculated members

Using Aggregates

  • Modeling aggregate tables to improve query performance
  • Setting the number of elements in a hierarchy
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard

Using Partitions and Fragments

  • Exploring partition types
  • Modeling partitions in an Oracle BI repository
  • Using the Calculation Wizard to create derived measures

Using Repository Variables

  • Creating session variables
  • Creating repository variables
  • Creating initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters

Modeling Time Series Data

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data

Security

  • Exploring Oracle BI default security settings
  • Creating users and groups
  • Creating application roles
  • Setting up object permissions
  • Setting row-level security (data filters)
  • Setting query limits and timing restrictions

Creating Oracle Business Intelligence Dashboards

  • Introduction to dashboards and dashboard pages
  • Creating and editing dashboards
  • Using the Dashboard Builder
  • Exploring dashboard object properties and options
  • Publishing dashboard pages
  • Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

  • Types of dashboard content
  • Embedding content in dashboards

Creating Dashboard Prompts and Variables

  • Overview of variables
  • Introduction to dashboard prompts and prompt types
  • Adding a named dashboard prompt to a dashboard
  • Adding a hidden named dashboard prompt to a dashboard
  • Creating additional prompt page and setting page preferences
  • Variables and prompts
  • Adding variable prompts to a dashboard
  • Wiring dashboard prompts

Using Oracle Business Intelligence Delivers

  • Introduction to Oracle BI Delivers
  • Configuring delivery devices and adding delivery profiles
  • Introduction to alerts
  • Adding an Alert Section to a dashboard
  • Overview of Agents
  • Configuring an Agent
  • Using Analysis and KPI conditions to deliver content with Agents
  • Subscribing to an Agent

Oracle Data Integrator 12c Administration and Development

  • Lesson 1: Introduction
  • Lesson 2: Administering ODI Repositories
  • Lesson 3: ODI Topology Concepts
  • Lesson 4: Describing the Physical and Logical Architecture
  • Lesson 5: Oracle Data Integrator Model Concepts
  • Lesson 6: Setting Up a New ODI Project
  • Lesson 7: Organizing ODI Models and Creating ODI
    Data stores
  • Lesson 8: ODI Mapping Concepts
  • Lesson 9: Designing Mappings
  • Lesson 10: Mappings: Monitoring and Debugging
  • Lesson 11: Designing Mappings: Advanced Topics 1
  • Lesson 12: Designing Mappings: Advanced Topics 2
  • Lesson 13: Using ODI Procedures
  • Lesson 14: Using ODI Packages
  • Lesson 15: Managing ODI Versions
  • Lesson 16: Managing ODI Scenarios
  • Lesson 18: Working with Changed Data Capture
  • Lesson 19: Advanced ODI Administration
Plan to Join This Course?

We Are Ready To Help You!!!