What is this course?
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.
Who should go for this course?
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.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, PowerQuery and PowerView. Then we will also take a small look at PowerBI, Sounds Cool, right?
Part 1 Introduction:
What is Business Intelligence (BI)?
How excel is used as a Business Intelligence Tool?
Understanding the BI Terminologies
Advanced Pivot Tables
After Reviewing Pivot Table Session, we shall dive into some of the Advanced Features. These lessons will help you to full up and running with a 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
Advance
- Create Measure
- Consolidate Multiple Data Source
- Generate Multiple Reports
PowerPivot
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 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
PowerView
PowerView is the next level visualization tool within Excel, it provides a beautiful data visualization experience for your data.
- Here we shall learn:
- Building Dashboard
- Understand different types of filters
- Display Interactive Image Report
- And many more..
PowerBI
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

āĻāĻāĻžā§āĻž āĻā§āϰā§āϏāĻāĻŋ āĻļā§āώ āĻāϰāĻžāϰ āĻĒāϰ āĻāĻĒāύāĻŋ āĻā§āϰā§āϏ āĻāĻŽāĻĒā§āϞāĻŋāĻļāύ āϏāĻžāϰā§āĻāĻŋāĻĢāĻŋāĻā§āĻāĻ āĻĒā§ā§ā§ āϝāĻžāĻŦā§āύāĨ¤
āĻāĻŋāĻāĻžāĻŦā§ āĻā§ā§āύ āĻāϰāĻŦā§ āĻā§āϰā§āϏāĻāĻŋāϤā§?
âTake This Courseâ āĻŦāĻžāĻāύ⧠āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤ āĻāĻĒāύāĻŋ āϞāĻžāϰā§āύāĻŋāĻ āĻŦāĻžāĻāϞāĻžāĻĻā§āĻļ āĻĒā§āϞā§āϝāĻžāĻāĻĢāϰā§āĻŽā§āϰ āĻĒā§āĻŽā§āύā§āĻ āĻā§āĻāĻā§ā§ āĻāĻŋāϏāĻž/āĻŽāĻžāϏā§āĻāĻžāϰāĻāĻžāϰā§āĻĄ āĻŦāĻž āĻŽā§āĻŦāĻžāĻāϞ āĻā§āĻžāϞā§āĻ āĻŦāĻŋāĻāĻžāĻļ/āϰāĻā§āĻā§āϰ āĻŽāĻžāϧā§āϝāĻŽā§ āĻĒā§āĻŽā§āύā§āĻ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύāĨ¤
āĻāϰ āĻĒāĻžāĻļāĻžāĻĒāĻžāĻļāĻŋ āϝāĻĻāĻŋ āĻāĻĒāύāĻŋ āĻā§āĻāύāĻŋāĻā§āϝāĻžāϞ āĻāϏā§āϝ⧠āĻĢā§āĻāϏ āĻāϰ⧠āĻĨāĻžāĻā§āύ āϤāĻžāĻšāϞ⧠āĻāĻŽāĻžāĻĻā§āϰ āĻĒāĻžāϰā§āϏā§āύāĻžāϞ āĻŦāĻŋāĻāĻžāĻļ, āύāĻāĻĻ āĻāĻŋāĻāĻŦāĻž āϰāĻā§āĻā§ āĻā§āϰā§āϏ āĻĢāĻŋ āϏā§āύā§āĻĄ āĻŽāĻžāύāĻŋ āĻāϰāϤ⧠āĻĒāĻžāϰā§āύ āĻāĻĒāύāĻžāϰ āĻŽā§āĻŦāĻžāĻāϞ āύāĻžāĻŽā§āĻŦāĻžāϰ āϰā§āĻĢāĻžāϰā§āύā§āϏ⧠āĻāϞā§āϞā§āĻ āĻāϰā§āĨ¤
āĻŦāĻŋāĻāĻžāĻļ: +8801711283732 āĨ¤Â āύāĻāĻĻ: +8801711283732  āĨ¤Â āϰāĻā§āĻ: +88017112837329
āϤāĻŦā§ āĻāĻāĻžāĻŦā§ āĻŽā§āϝāĻžāύā§ā§āĻžāϞāĻŋ āĻĒā§āĻŽā§āύā§āĻ āĻāϰāϞ⧠āĻāĻĒāύāĻžāĻā§ āĻ
āĻŦāĻļā§āϝāĻ āĻāĻ āĻĢāϰā§āĻŽ āĻāĻŋ āĻĒā§āϰāĻŖ āĻāϰāϤ⧠āĻšāĻŦā§ āϏāĻ āĻŋāĻ āϤāĻĨā§āϝ āĻĻāĻŋā§ā§āĨ¤
āĻĢāϰā§āĻŽ āĻ āϝā§āϤ⧠āĻāĻāĻžāύ⧠āĻā§āϞāĻŋāĻ āĻāϰā§āύ – āĻĒāĻžāϰāϏā§āύāĻžāϞāĻŋ āĻāĻžāĻāĻž āĻĒāĻžāĻ āĻžāύā§āϰ āĻĒāϰāĻŦāϰā§āϤ⧠āĻĢāϰā§āĻŽ
āĻāĻŽāϰāĻž āĻĢāĻŋāϰāϤāĻŋ āĻāϞ⧠āĻāĻĒāύāĻžāϰ āĻāĻžāĻ āĻĨā§āĻā§ āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻā§āύ⧠āĻāύāϰā§āϞ āĻāϰāĻŋā§ā§ āĻĻāĻŋāĻŦāĨ¤
āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻāĻžāύāϤ⧠āĻāϞ āĻāϰā§āύ
What is this course?
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.
Who should go for this course?
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.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, PowerQuery and PowerView. Then we will also take a small look at PowerBI, Sounds Cool, right?
Part 1 Introduction:
What is Business Intelligence (BI)?
How excel is used as a Business Intelligence Tool?
Understanding the BI Terminologies
Advanced Pivot Tables
After Reviewing Pivot Table Session, we shall dive into some of the Advanced Features. These lessons will help you to full up and running with a 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
Advance
- Create Measure
- Consolidate Multiple Data Source
- Generate Multiple Reports
PowerPivot
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 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
PowerView
PowerView is the next level visualization tool within Excel, it provides a beautiful data visualization experience for your data.
- Here we shall learn:
- Building Dashboard
- Understand different types of filters
- Display Interactive Image Report
- And many more..
PowerBI
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

āĻāĻāĻžā§āĻž āĻā§āϰā§āϏāĻāĻŋ āĻļā§āώ āĻāϰāĻžāϰ āĻĒāϰ āĻāĻĒāύāĻŋ āĻā§āϰā§āϏ āĻāĻŽāĻĒā§āϞāĻŋāĻļāύ āϏāĻžāϰā§āĻāĻŋāĻĢāĻŋāĻā§āĻāĻ āĻĒā§ā§ā§ āϝāĻžāĻŦā§āύāĨ¤
āĻāĻŋāĻāĻžāĻŦā§ āĻā§ā§āύ āĻāϰāĻŦā§ āĻā§āϰā§āϏāĻāĻŋāϤā§?
âTake This Courseâ āĻŦāĻžāĻāύ⧠āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤ āĻāĻĒāύāĻŋ āϞāĻžāϰā§āύāĻŋāĻ āĻŦāĻžāĻāϞāĻžāĻĻā§āĻļ āĻĒā§āϞā§āϝāĻžāĻāĻĢāϰā§āĻŽā§āϰ āĻĒā§āĻŽā§āύā§āĻ āĻā§āĻāĻā§ā§ āĻāĻŋāϏāĻž/āĻŽāĻžāϏā§āĻāĻžāϰāĻāĻžāϰā§āĻĄ āĻŦāĻž āĻŽā§āĻŦāĻžāĻāϞ āĻā§āĻžāϞā§āĻ āĻŦāĻŋāĻāĻžāĻļ/āϰāĻā§āĻā§āϰ āĻŽāĻžāϧā§āϝāĻŽā§ āĻĒā§āĻŽā§āύā§āĻ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύāĨ¤
āĻāϰ āĻĒāĻžāĻļāĻžāĻĒāĻžāĻļāĻŋ āϝāĻĻāĻŋ āĻāĻĒāύāĻŋ āĻā§āĻāύāĻŋāĻā§āϝāĻžāϞ āĻāϏā§āϝ⧠āĻĢā§āĻāϏ āĻāϰ⧠āĻĨāĻžāĻā§āύ āϤāĻžāĻšāϞ⧠āĻāĻŽāĻžāĻĻā§āϰ āĻĒāĻžāϰā§āϏā§āύāĻžāϞ āĻŦāĻŋāĻāĻžāĻļ, āύāĻāĻĻ āĻāĻŋāĻāĻŦāĻž āϰāĻā§āĻā§ āĻā§āϰā§āϏ āĻĢāĻŋ āϏā§āύā§āĻĄ āĻŽāĻžāύāĻŋ āĻāϰāϤ⧠āĻĒāĻžāϰā§āύ āĻāĻĒāύāĻžāϰ āĻŽā§āĻŦāĻžāĻāϞ āύāĻžāĻŽā§āĻŦāĻžāϰ āϰā§āĻĢāĻžāϰā§āύā§āϏ⧠āĻāϞā§āϞā§āĻ āĻāϰā§āĨ¤
āĻŦāĻŋāĻāĻžāĻļ: +8801711283732 āĨ¤Â āύāĻāĻĻ: +8801711283732  āĨ¤Â āϰāĻā§āĻ: +88017112837329
āϤāĻŦā§ āĻāĻāĻžāĻŦā§ āĻŽā§āϝāĻžāύā§ā§āĻžāϞāĻŋ āĻĒā§āĻŽā§āύā§āĻ āĻāϰāϞ⧠āĻāĻĒāύāĻžāĻā§ āĻ
āĻŦāĻļā§āϝāĻ āĻāĻ āĻĢāϰā§āĻŽ āĻāĻŋ āĻĒā§āϰāĻŖ āĻāϰāϤ⧠āĻšāĻŦā§ āϏāĻ āĻŋāĻ āϤāĻĨā§āϝ āĻĻāĻŋā§ā§āĨ¤
āĻĢāϰā§āĻŽ āĻ āϝā§āϤ⧠āĻāĻāĻžāύ⧠āĻā§āϞāĻŋāĻ āĻāϰā§āύ – āĻĒāĻžāϰāϏā§āύāĻžāϞāĻŋ āĻāĻžāĻāĻž āĻĒāĻžāĻ āĻžāύā§āϰ āĻĒāϰāĻŦāϰā§āϤ⧠āĻĢāϰā§āĻŽ
āĻāĻŽāϰāĻž āĻĢāĻŋāϰāϤāĻŋ āĻāϞ⧠āĻāĻĒāύāĻžāϰ āĻāĻžāĻ āĻĨā§āĻā§ āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻā§āύ⧠āĻāύāϰā§āϞ āĻāϰāĻŋā§ā§ āĻĻāĻŋāĻŦāĨ¤
āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻāĻžāύāϤ⧠āĻāϞ āĻāϰā§āύ
Course Reviews
4.7
- 5 stars2
- 4 stars1
- 3 stars0
- 2 stars0
- 1 stars0
Useful and Effective
I really enjoyed the course with practical tools that you can implemented and enhance your skill.
I would like thank the trainer Mr Sami Huq very much as well as the Learning Bangladesh team for coming up with this advance level course. I would request the the team to upload the excel files so that we can practice on our own. Also we need more advanced level courses like this.
I am grateful to have the chance to participate in an online course like this!
Great experience
Good learning indeed…
Great learning
very useful for learning.