Business Intelligence
with PowerBI and Excel
Samiul Huq
Training
2/26/25
Analyzing Data with PowerBI
This is a Five Day instructor-led course provides students with the knowledge and skills to
analyze data with Power BI and Excel. Each Sessions will be around 2.5 to 3 hours and after each
lessons assignment will be distributed.
Audience profile
The primary audience for this course is BI professionals who need to analyze data
utilizing Power BI and excel. The secondary audiences for this course are technically
proficient business users.
Audience Size: 20 [recommended]
Skills gained.
• Learn to Analyze data with Pivot Table
• Learn to Analyze data with PowerPivot
• Learn to Describe self-service BI.
• Learn to Describe the Power BI and Excel suite of products.
• Learn to Connect to data sources and optimize data models.
• Learn to create several data visuals
• Learn to transform Data
• Learn to use the Powerful DAX
• Learn to Publish PowerBI in Web
• Learn to Automate PowerBI using Gateway Setup
Prerequisites
In addition to their professional experience, students who attend this training should already
have the following technical knowledge:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Basic knowledge of data warehouse will come handy.
An awareness of key business priorities such as revenue, profitability, and financial accounting is
desirable.
Instructor Profile:
Samiul Huq, is the first one to introduce PowerBI training since the
technology appeared since 2015. He is a MCT [Microsoft Certified
Trainer] and one of the renown data analyst trainer. He has been in
corporate training since 2011 and is associated with many online and
offline training centers. He is the founder of Bithut Limited Software
Firm and Ilal Kaaba Hajj and Umra Agency.
Course Outline Excel
Formula
vLookup
xLookup
multiple lookup trick
Handling error
Sumifs/Countifs
Sorting & Filtering
• Data Preparation
• Sorting
Pivot Tables
• Creating a Pivot Table
• Updating a Pivot Table
• Pivot Table Formatting
• Drill Down
• Pivot Calculations
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Pivot Chart
• Slicers on Multiple Pivot Tables
• Building Dashboard
Pivot Table Trick
Understanding Business Intelligence PowerPivot
• What is BI
• What is PowerPivot
• Why PowerPivot
• Exploring the PowerPivot
• Importing billion rows in excel
• Create Models
• Dax [If, Date, Related]
• Dashboard using PowerPivot
Understanding Business Intelligence PowerQuery
• Import Data from a Folder
• Import Data using Load To Option
• Clean Your Unstructured Data through Data Transform
Course Outline PowerBI
Session 1: Data Visuals
PowerBI Introduction
Show How to import from Excel
Explore Data Tab
Explore and Create Data Models
Create Hierarchy
Explain the naming phenomenon
Explore visuals, tables, charts, cards, slicers
Learn how to format the visuals
Session 2: Data Visualization
Learn Timeline Chart and Analyze Options
Learn Using Map through Latitude and Longitude
Learn Using Decomposition Tree
Learn to Add Trend Lines and Forecast
Show Multiple Charts
Filter, top N
Session 3: Data Visualization Continues
Learn Matrix Visuals
Multiple to show multiple fields and
Learn to show the percentage of totals in the table
Conditional Format
Learn to import cool Visuals from Store and use one •
Export Data
bins and groups
Learn to Control and Edit Filter connection
Course Outline Continue..
Session 3: Power Query & Data Transformation
Learn to load data from a folder automatically
Learn to transformation Ugly Data
Learn to Unpivot Date
Learn to Use Data Quality
Session 4: Formula Functions & Dax
Learn Dax Time Intelligence Functions
Learn how Related function can replace vlookup
learn how the if() is more stronger than that of excel
Learn to use calculate functions to replace Sumifs
Learn Measures
Session 5 PowerBI Web
Introduce PowerBI Service
Publish a report on Web
Build a Dashboard
Ask Questions to Dashboard
Learn to create workspaces
Learn to share Reports and Dashboards with others
Analyze with Excel
Export to PDF and PowerPoint
Session 6 PowerBI Web
Build a Mobile App
Learn how to collaborate report and dashboard with
colleagues
Learn to Setup PowerBI Gateway for Automatic Data Refresh
Learn to use PowerBI App Option [Not Mobile App]
Samiul Huq
Date: To:
26 Feb 2025 HR
Marico
Sharing On Premises Pricing Proposal.
Sl Service Type Sessions Amount Taka Remarks
Business Intelligence with
1 2 80,000
Excel
Business Intelligence with
2 3 120,000
PowerBi
Total: One Lak and Fifty
200,000
Thousand Taka
NOTE: THE PRICING DOES NOT INCLUDE TAX or VAT
Other Courses:
Sl Service Type Sessions Amount Total
1 Leadership Training 6 300,000 50K Per Half Day
Batch Size: 20
