Microsoft Power BI Certification Ready Workshop

Rs. 15,000

Starting in

Transform raw data into game-changing insights.
Start Date
Jun 17, 2023
End Date
Aug 13, 2023
Timing
Weekends
Location
Online
Type
Instructor Led
Duration
40 Hours
training image

Overview

Turn the cluttered data into a visually compelling story through Microsoft Power BI! 
 
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.

Tools Covered

  • 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.

  • The learning outcomes of this workshop include gaining the ability to transform raw data into actionable insights, creating impactful dashboards and reports using advanced techniques like DAX and Power BI Visuals
  • Developing a deep understanding of Business Intelligence techniques for confident decision-making.
  • Participants can expect to gain hands-on experience and practical skills that can be applied in real-world scenarios

Meet the Instructor

Ahmed Shoaib

Service Solution Management | COL Executive MBA | Motivational Speaker | Youtuber | Power BI Trainer

Ahmed Shoaib

Service Solution Management | COL Executive MBA | Motivational Speaker | Youtuber | Power BI Trainer



Course Outline

  • Introduction to Power BI
  • Power BI vs Other BI Tools
  • Power BI & Excel (Similar or Different)?
  • Architecture & Connectivity
  • Transform shape and model data in Power BI
  • Front-End Development

  • 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

  • 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
  • Two Way filter flow problem
  • Evaluation Context
  • Filter Context
  • Row Context
  • DAX (Data Analysis Expression)
  • 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

  • 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
  • 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
  • Create reports and dashboards in Power BI
  • Tour the report editor
  • Paginated reports
  • Create a paginated report and upload
  • Performance tuning
  • Parameters in Power BI Desktop
  • Power BI Certification
  • PROJECT Analyze Panama Leaks Using Power BI

Our Methodology

Industry Usecases

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.

Technical Support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.

Career Mentorship

You’ll have access to resume support, portfolio review and optimization to help you advance your career and land a high-paying role.

Frequently Asked Questions

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

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

There will be 80% hands-on and 20% theory in this workshop.

Don’t worry! We have got you covered. You shall be shared recorded lectures after each session, in case you want to revise your concepts or miss the lecture due to some personal or professional commitment
So, what's your plan?

Follow the footsteps of thousands of successful alumni...

Reserve Seat
svg img
Reserve Seat