• My account

OUR TRAINING COURSES

Business Intelligence

Review (0)

30,000.00

Business Intelligence is used for data analysis of business information and provide historical, current and future forecasting views of business operations. It helps in reporting, processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, Descriptive , predictiveand prescriptive analytics.

16 Sessions
64 Hours



Skills you will master

Excel
Tableau
SQL

UPCOMING BATCHES

26
May
Weekends
10:00 AM - 02:00 PM
23
Jun
Weekends
02:00 PM - 06:00 PM
Mob : +91-9810600764
Address : M8, Lower ground Floor, Sector 14 OLD DLF Gurgaon 122001
Email : info@palin.co.in

30,000.00

About The Program

Business Intelligence is used for data analysis of business information and provide historical, current and future forecasting views of business operations. It helps in reporting, processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, Descriptive , predictiveand prescriptive analytics.

Career Advisor
Vinit Kumar, Consultant
Palin Delivers real world relevance with activities n assignments that helps students build critical thinking and analytic skills that will transfer to other courses n professional life.
Program Description
Business Intelligence program is designed as per the needs of Analytics experts in the industry who are good at programming as well as analytical background to build models to bring out inferences and predictions from large amount of historical data over big data platform. It includes analytics using python and R language along with statistical modelling and machine learning algorithms to bring inferences for decision support in any business.
Curriculum
Click Here to Preview

   Session1 : Introduction to Data Analytics using Excel

Excel Tables, Sparklines, Conditional Formatting, Excel Data Tables, Slicers, Introduction, Slicers to filter your table data, Pivot Tables, Creating Pivot Tables, Use multiple ways to filter data in Pivot Tables, Slicers in Pivot Tables, Power Pivot, Introduction to Power Pivot and it’s uses, Pivot Tables v/s Power Pivot Tables, Creating Power Pivot Tables, Tables & Charts Combination, Power Pivot Hierarchies, Power Pivot using Slicers

   Session2 : Dashboards - Excel

Flexible data aggregation using pivot tables and pivot charts to create Dashboards, Introduction to Dashboards, Types of Dashboards, Analytical Dashboards, Dynamic Dashboards with Live Data, Excel Charts for Dashboards, Pie Chart, Stacked Bar Chart, Scatter Chart, Bubble Chart, Stock Chart, Radar Chart, Data Filter in Pivot to get Subsets of data & Advance Charts, Dashboard Data & Formats, Waterfall Chart, Band Chart, Gantt chart, Thermometer Chart, Histogram, Pareto Chart, Funnel Chart, Box and Whisker Chart, Waffle Chart, Reporting Layouts using formulas to aggregate the data as an alternative to Pivot Tables, Power view visualisation, Combination of power view visualisation, Interactive Nature of Charts in Power View Visualizations, Slicers & Tiles in Power View

   Session3 : Data Analysis & Data Visualisation using Excel

Data Gathering & Transformation from multiple sources, Combining Multiple worksheet, Get and Transform data, Concatenate Formatting, Discover and combine data in mashups, Append Data, Merging Data, Data Blending, Data model creation, Data Exploration, Analysis and Visualisation

   Session4 : SQL

Introduction to SQL, Fundamental of SQL

   Session5 : SQL

Joins, Functions

   Session6 : SQL Practice

Practice & Doubt Session on SQL

   Session7 : Tableau - What is Business Intelligence?

Deployment Types, Planning 3 Node Hadoop Cluster, Installing Cloudera Manager, Installing Multi Node Hadoop Cluster Using Cloudera Manager, Hadoop Configuration in Cluster environment, Specifying the Hadoop Configuration, Performing Basic Administration Tasks Using Cloudera Manager

   Session8 : GETTING STARTED WITH TABLEAU

GETTING STARTED WITH TABLEAU, NAVIGATION IN TABLEAU, TABLEAU ‘SHOW ME’, TABLEAU ‘DATA SOURCES’, TABLEAU ‘CUSTOM DATA VIEW ’, TABLEAU ‘EXTRACTING DATA ’, TABLEAU ‘OPERATIONS APPLIED ON DATA FIELDS’

   Session9 : TABLEAU ‘EDITING METADATA’

TABLEAU ‘EDITING METADATA’, DATA JOINS IN TABLEAU, DATA BLENDING IN TABLEAU, Union in data IN TABLEAU, WORKSHEETS IN TABLEAU

   Session10 : OPERATORS IN TABLEAU

OPERATORS IN TABLEAU, STRING CALCULATIONS, NUMERIC CALCULATIONS, FUNCTIONS IN TABLEAU, TABLE CALCULATIONS IN TABLEAU

   Session11 : BASIC SORTING IN TABLEAU

BASIC SORTING IN TABLEAU, BASIC FILTERS IN TABLEAU, QUICK FILTERS IN TABLEAU, CONTEXT FILTERS IN TABLEAU

   Session12 : ADVANCE CHARTS IN TABLEAU

ADVANCE CHARTS IN TABLEAU, ACTIONS IN TABLEAU, PARAMETERS IN TABLEAU

   Session 13 : LEVEL OF DETAIL

LEVEL OF DETAIL, LEVEL OF DETAIL (LOD) CALCULATIONS : INCLUDE, LEVEL OF DETAIL (LOD) CALCULATIONS : EXCLUDE, LEVEL OF DETAIL (LOD) CALCULATIONS : FIXED, LEVEL OF DETAIL (LOD) CALCULATIONS : USED CASE, DATES IN TABLEAU

   Session 14 :DASHBOARD DESIGN

DASHBOARD DESIGN, DASHBOARD DESIGN – PLAN, DASHBOARD DESIGN – LAYOUT, DASHBOARD DESIGN - INTERACTIVITY

   Session 14 :PROJECT: A DASHBOARD SHOULD BE CREATED THAT WOULD CONTAIN

A list of Orders returned by the Customers (in terms of refund), Top 10 Countries mapped on the World Map that had most of the refunds, Predict the refund for next 1 year category-wise, Actions to be Performed to Create the Dashboard, Create hierarchies and folders in the dataset provided, Generate a list of order returned from customers and compare it to the original sales, sort the visualization in ascending, Order in terms of returned order, for top 10 countries in terms of refunds, Map top 10 countries, with most of the refunds on the world map, Predict the returned sale with lowest and actual forecast of the data, Add a URL action to represent details of the countries, Finally publish your work to Tableau Server/ Online

Read More
Program Highlights
Instructor-led
Live interactive and classroom training will include the practical approach and assessments on regular basis.
Live Case Study
Domain Specific Live interactive case study using industry specific data, problem statements, solution architecture.
Assignments
Assignments which helps in conceptual understanding, Prepared for interview training & techniques.
Lifetime Access
Class recording, Study material ppt’s, pdf, assignments, datasets, case studies can be accessed through out the lifetime.
24 X 7 Support
We will support If any concern is raised related to the training, assignments, projects, case studies & interview questions.
Certification
After successful completion of the training and case study Palin will certify you as Palin certified Big Data Analyst.
Career Counselor
Avail career guidance and Professional guidance for resume building, unlimited opportunities and interviews.
Reviews

Reviews

There are no reviews yet.

Be the first to review “Business Intelligence”

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



Latest News

Emerging Future of Data Scientists
Data scientists will live one of the accomplished and encouraging careers prospective of all IT employment through 2020. Healthcare, Banking and Telecom industries are the...Read More
Average Salary of A data scientist and related profiles
The national average salary offered to data scientists and their related position is ₹ 6,50,000.Read More
Benefits of Data Science using SAS & R
Banking and Healthcare industry has been using SAS for years because SAS is licensed software which guarantees the accuracy of its results and its safer...Read More
Python Overtakes R
Python overtakes R, becomes the leader in Data Science, Machine Learning platforms. While in 2016 Python was in 2nd place ("Mainly Python" had 34% share...Read More
What are benefits of python
Simple and easy to learn and understand. Performance is very fast and attractive. Python works with all different data formats. We can directly import SQL...Read More
Python Data Scientists Average Salary
The average salary offered to data scientists in the past year was £47,000, with Python being the most desirable programming language, according to an analysis...Read More
Python Vs Julia
Python vs Julia Python is a general-purpose computing language that is easy to learn, and that has developed into a leading language for scientific computing....Read More
Quick Enquiry
close slider