OUR TRAINING COURSES

Business intelligence 5/5 (1)

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 Analytics
    Slicers
    Pivot tables
    Dashboard
    Power Pivot
    SQL
    Tableau

    UPCOMING BATCHES

    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.

    Please rate this

    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