Microsoft Power BI - Dice Analytics

Microsoft Power BI

An Interactive Workshop

About Power BI Live Workshop

Turn the cluttered data into a visually compelling story through Microsoft Power BI! 


In order to take effective business decisions, analysts need to read gist of data closely and extract meaningful information out of it. Microsoft Power BI helps users to create their own dashboards and reports according to the needs and requirements of the business.


During the Four (4) weeks of the workshop, you will learn how to use Power BI to create actionable insights of the raw data. You will walk through different advanced techniques of Power BI such as DAX, Advanced DAX and Power BI Visuals.


At the end of the workshop, candidates will have in-depth understanding & hands-on related to Business Intelligence techniques for decision making.

View Course Outline

Our Approach for Live Classes

After establishing a reputable Physical Training Model, based on our stellar records and customer earned trust we gradually progressed to establish the same reputation in the Live Training Model. We are committed to empower you by making our trainings accessible, interactive, and well curated specifically to your objective.
live training process 2



23rd Feburary’22


4 Weeks


Monday to Friday

07:00 PM – 09:00 PM

Seats Availability

Limited slots available

Meet your Instructor


Mr. Abu Bakar Nisar Alvi

Senior Information Technology Consultant @ World Bank Group

Mr. Abu Bakar has 21+ years of extensive experience of working with multi-disciplinary teams & completing challenging projects. He handled multi-million dollar projects as a Program/Project Manager in the Defense Sector. He has been working as an ICT Consultant with various organizations including the World Bank Group. He is a Microsoft Certified Data Analyst, a Microsoft Certified Trainer (MCT), Certified Project Management Professional (PMP) & Agile Certified Practitioner (PMI-ACP). He is the Youngest Professional Engineer to be awarded with the 4th highest Civil Award 'Tamgha-e-Imtiaz' by the Govt of Pakistan in 2005.

Course Outline

Week 1

    • Introduction to Power BI
    • Power BI vs Other BI Tools
    • Power BI & Excel (Similar or Different)?
    • Architecture & Connectivity
      • Types of Data Connectors
      • Connectivity with Multiple Source Systems
      • Data Source Settings
      • Refreshing Queries
    • Transform shape and model data in Power BI
      • Power BI Data preparation through query editor
      • Add columns functionalities
      • Home tab Features
      • Transformation tools
      • Grouping and aggregating data
      • Calendar tables
      • Pro-tip Creating and rolling calendar
    • Front-End Development
      • Report and Dashboard Designing
      • Report View
      • Data view
      • Relationship view
      • Defining Hierarchies
      • Filters
      • Fixing incorrect sorts
      • Web Connectors
      • IMDB Analysis Lab
      • Measures and Calculated Column

Week 2

    • Active & Inactive Relationships
    • Visualizing Geospatial Data
    • Shape Maps in Power BI
    • Visualizing Pakistan
    • Dynamically Changing Measures
    • Advanced Tooltips
    • Analytics Pane (Data Forecasting)
    • Cumulative Sum and Power BI Animations
    • DrillThrough
    • Bookmarking
    • What if Parameters
    • Creating Calendar through DAX
    • Analyzing Data in Dynamic Time Periods
    • Using Python in Power BI
    • Covid 19 Lab
    • SDM Analysis Lab

Week 3

    • Basics of Visualizations
    • Types of Data for visualizing
    • Looking at the Programming Side of Power Query
    • Why visualizations give output the way they are doing?
    • Data Modeling
    • Power BI Modeling Schemas
    • Relationships (One to one, Many to Many, One to Many)
    • Filter Flows
    • Filter Flows in Parents or Childs
    • Two Way filter flow problem
    • Evaluation Context
    • Filter Context
    • Row Context
    • Programming Side of Power BI
    • DAX (Data Analysis Expression)
    • DAX Importance
    • Measures vs Calculated Columns
    • Aggregators vs Iterators
    • Table Functions
    • Answering Business Questions
    • Exploring Visualizations
    • Formatting
    • Key Performance Indicators
    • Pie/Donut Chart Use and Problems
    • Lab: Cricket Analysis Dataset

Week 4

    • Power Bi administration
    • Publishing on Microsoft Power BI service
    • Power BI dashboards
    • Sharing Report
    • Power BI Apps
    • Live Steaming
    • On-Premises Gateway
    • Personal vs Enterprise Gateway
    • Install and Configure Personal Gateway
    • Alerts
    • Data Automation
    • Self Service with Power BI
    • Quick Insights
    • Embedded Analytics
    • Reporting on Power BI service
    • Mobile Dashboard
    • Set geographic filters in Power BI for the mobile app
    • User Roles
    • Import and display KPIs
    • Search
    • Create reports and dashboards in Power BI
    • Overview
    • Tour the report editor
    • What are paginated reports?
    • Paginated reports
    • Create a paginated report and upload
    • Performance tuning
    • Best Practices
    • Parameters in Power BI Desktop
    • Looking at Power BI in a nutshell
    • Power BI Certification
    • Wrapping Up
    • PROJECT Analyze Panama Leaks Using Power BI


Online Banking details shall be shared via our representatives after you reserve your seat

Actual Training Price

Price for a Regular Member
PKR 10,000 Per Person

For [email protected] Members

20% OFF for [email protected] Members
PKR 8,000 Per Person

Frequently Asked Questions

Who should attend the course?

    • Recent graduates, third year and final year students from the business management degree
    • Professionals from any domain who want to learn Power BI tool to create effective reports and dashboards and assist Business Analytics department
    • Executives and Department Heads who want to build the knowledge about Power BI and implement it for organization growth.

Who is the Instructor?

What is the timing of the course?

Duration: 4 weeks

Class Days: Monday to Friday

Timings: 07:00 PM to 09:00 PM

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and also recommend the shinning students in industry for relevant positions.

How much hands-on will be performed in this course?

Since our courses are led by Industry Experts so it is made sure that content covered in course is designed with hand on knowledge of more than 70-75 % along with supporting theory.

What are the PC requirements?

For this professional workshop, you need to have a PC with minimum 4GB RAM and ideally 8GB RAM.

Will I get a certificate after this course?

Yes, you will be awarded with a workshop completion certificate by Dice Analytics.

Reserve your Seat

You can reserve your seat  by filling the form below!