Workshop on “Analyzing and Visualizing Data with Power Excel & Power BI” at PIM Karachi

Are you looking for new ways to find and visualize data and to share your discoveries? Power BI can help. This collection of tools and features from Microsoft transforms your company’s data into rich visuals for you to collect and organize, so you can spot trends, collaborate in new ways, and make sense of your data.

Microsoft Power BI allow end-users to store, analyze, and visualize big data.  Learn these game-changing technologies to analyze huge business data with ease. This course is designed with a practical, easy-to-learn approach towards unleashing the clout of Microsoft Power BI.


At the end of this course participants will be able to:

  • Understand complete Microsoft Excel Power BI tool pack
  • Analyze data from different data sources and create their own datasets
  • Comfortably work with the different tools of the Power BI universe and know how the different tools work together
  • Create reports with different interactive visualization in Power BI Desktop


  • Introducing Power BI Tools
    • Power BI Key Features
    • The Self-Service BI Model
  • Using Power Query
    • Getting Data with External Sources
    • Transforming Malformed Data
    • Merging & Appending Queries
  • Modeling Data with PowerPivot
    • Introduction to Modeling
    • Setup and Manage Relationships
    • Creating Calculated Columns
    • Creating Measures & KPIs
    • Working with DAX
  • Power View for Excel
    • Creating Power View Reports
    • Understanding Table Visualizations
    • Chart Visualizations
  • Power Map
    • Plotting Spatial Data Over Power Map
    • Formatting & Customizing Map
    • Creating Power Map Tours
  • Power BI Desktop
    • Creating Charts Visualizations
    • Tables, Matrices, KPI’s & Cards
    • Slicers & Timeline Slicers
    • Scatter & Bubble Charts & Play Axis
    • Drill Down/Up Charts


This course is most suited for participants who are:

  • People who never worked with Power BI and who want to understand how to use these tools
  • Anyone who is interested in learning how to connect the different Power BI tools with each other
  • People who want to understand how to create customized visuals with the Power BI tools

Date: Sep 20 – 21 , 2021
Venue: PIM, Karachi.
Investment: PKR 22,000/-
Event Link:

Leave a Reply