Microsoft Power BI - Dice Analytics
 

Microsoft Power BI

An Interactive Live Workshop

About Power BI Live Workshop

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.

Course Outline Register Now

Schedule

Starting

19 November ’22

Duration

4 Weeks

Timings

Saturday & Sunday

11AM – 04PM

Mode

Online (LIVE)

Meet your Instructor

qodef-fullwidth-slider

Abu Bakar Nisar Alvi

Senior IT consultant @ World Bank Group in Pakistan & Indonesia

Mr. Abu Bakar brings in 22+ years of extensive experience in working with multi-disciplinary teams & completing challenging projects. He has handled multi-million dollar projects as a Program/Project Manager in the Defense Sector and has been working as an ICT Consultant with various organizations. He is a Microsoft Certified Data Analyst, Tableau Desktop Specialist, Microsoft Certified Trainer (MCT), Certified Project Management Professional (PMP) & Agile Certified Practitioner (PMI-ACP). He is the Youngest Professional Engineer to be awarded 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
    • CALCULATE
    • 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

Pricing Details

  • Individual Price
    • PKR 15,000 Per Person
    • Total charges for complete Workshop
    • Book a seat
  • Group of 2
    • PKR 13,950 Per Person
    • Avail 7% Discount on Group of Two
    • Book 2 Seats
  • Group of 3
    • PKR 13,500 Per Person
    • Avail 10% Discount on Group of three
    • Book 3 Seats

Reserve your Seat

You can reserve your seat  by filling the form below!

     
    Are you a: 
    StudentWorking Professional

     

     

     

    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: Saturday & Sunday

    Timings: 11 AM to 04 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.

    Can I rejoin this training/workshop?

    Yes, you can rejoin the training within the span of an year of your registration. Please note following conditions in case you’re rejoining.
    1) There are only 5 seats specified for rejoiners in each iteration.
    2) These seats will be served on first come first basis.
    3) If you have not submitted your complete fee, you may not be able to rejoin. Your registration would be canceled.

    Will I get a certificate after this course?

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

    \