Advanced Business Intelligence with Excel and PowerBI 2.0 training centre in Bangladesh


Advanced Business Intelligence with Excel and PowerBI 2.0


This is an Advanced Data Analysis Course. Users are expected to have working knowledge on vlookup function and Pivot Table. We are going to dive Deep in Data Analytics in Excel and Introduce A New Data Analysis Tool by Microsoft known as PowerBI.

Power BI is the Future of Excel and will transforms your company's data into rich visuals for you to collect and organize so you can focus on what matters to you.

It gives you a single view of your most critical business data. Monitor the health of your business using a live dashboard, create rich interactive reports with Power BI Desktop and access your data on the go with native Power BI Mobile apps. It`s easy, fast, and free.

How the Course is structured
The course will take you from an Intermediate Level to a Super User Level through hands on practice. Initially we will start with Excel Pivot Table, then gradually move on to other Business Intelligence Component Microsoft has introduced in 2013, PowerPivot and PowerQuery. Then we will jump into PowerBI, play with it, make some dashboards and then publish it in our website which we will see from your mobile app, Sounds Cool, right


This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

Contents of Training:

What is Business Intelligence (BI)?
How excel is used as a Business Intelligence Tool?
Understanding the BI Terminologies

Pivot Tables
Pivot Table is the most powerful feature of Microsoft Excel. The dream tool for any analysts. These lessons will help you to full up and running with pivot table! The topics include

Organizing your Data
# Learn to Organize Data
# Learn Concept of Table for Power Usage

Explore Pivot Table
# Learn to Create a Pivot Table
# Understand the behavior of Pivot Table
# Pivot Formatting
# Drill Down
# Pivot Calculations
# Summarizing Dates
# Pivot Sorting
# Filtering Row Fields
# Top 10 Report
# Filtering a Pivot Table with Slicers

Dashboard Capabilities
# Connect Slicers on Multiple Pivot Tables
# Understand Principle of Dashboard
# Building Enterprise Dashboards

PowerPivot compliments where Pivot Table Fails. It is the best thing that Microsoft has produced in last 20 years. These lessons will help you harness the power of PowerPivot! The topics include:

Working with PowerPivot
# Using the Data Model in Excel 2013 to Join Two Tables
# Getting data in PowerPivot
# Load Data into PowerPivot
# Define Relationships in the PowerPivot Window or Diagram View
# Creating the Pivot Table - Compare Choices
# Changing the Calculation from Sum & Other Differences

Power Query
Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more.

Here we shall learn to:
# Connect to a data source
# Transform the Data
# Load the Data in the Table

PowerBI is the complete Business Intelligence Solution from Microsoft. It blends, PowerPivot, PowerView and PowerQuery Capabilities in one single Product.

Getting Started to Know PowerBI
# Understand the Building Blocks
# Explore PowerBI Desktop and PowerBI Service
# Import Data from Various Data Source
# Clean and Transform Data in Query Editor
# Checking the Data in “Data” Tab
# Making Couple of Reports from Single Table
# Build Model Joining Multiple Tables
# Build Reports Using the Model

Exploring Report Component:
# Bar Chart
# Column Chart
# Area Chart
# Line Chart
# Pie Chart
# Card
# Normal Table
# Matrix Table

Report Filter:
# Page Level Filter vs Report Level Filter
# Slicer
Publish Report in Web
# Create a PowerBI Account
# Save Report
# Publish Report
# Explore and View Report in Web

Getting to know PowerBI Service
# Dataset Segment
# Report Segment
# Dashboard Segment
# Pin Report to Dashboard
# View the Report from Mobile App

Report Exploration
# Explore PowerBI Report in Web
# Explore PowerBI Report in Mobile App
# Explore PowerBI Report in Pad App

Data Refresh:
# Understand the Data Refresh
# Install Personal Gateway

Calculated Column and Table
# Basic Functions: Sum, Average, Min
# Date Functions: Year(), Month(), Day()
# The Powerful Format()
# The Super Cool Calculate Function
# Joining Two Column
# Lookup from other Table
# Calculated Table
# Data Type
# Number and Text Format
# Data Category
Visual Gallery
# Explore New Visuals
# Download a Visuals
# Import them in PowerBI Desktop
Sharing Your Data
# Invite Users
Refresh Data through Gateway

Related Courses

Md. Feroz Kibria
  • 9 - 10 Oct 2020 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

If you are the Data Scientist or Data Analyst of your organization then this course is undoubtedly for you. If you have completed the Business Intelligence with Excel Course then it’s a must.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.