Upcoming Events

No Events on The List at This Time

 

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! 

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 Two (2) 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 Reserve Your Seat

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

Schedule

Starting

25th July’20

Duration

2 Weeks (Weekend Classes)

Timings

10:00 AM – 06:00 PM

Seats Availability

Limited slots available

Professional Trainer

Meet the trainer of this workshop who is a Power BI Expert!

qodef-fullwidth-slider

Mr. Nabeel Waqar Wyne

Business Intelligence Developer at Telenor

He is a passionate BI & Analytics developer with Information Systems & Management degree from ‘The University of London’ and has extensive experience in field of BI and Data Analytics. He has worked on multiple database projects while involving in design and development of database. His expertise includes Power BI, Tableau, Qlik, Hadoop and Hive

Course Outline

Day 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

Day 2

    • 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

Day 3

    • 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

Day 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

Fee Structure

Following is fee structure for this extensive workshop on Power BI

Slider

 

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: 2 weeks

Class Days: Saturday and Sunday

Timings: 10:00 AM to 06: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 course completion certificate by Dice Analytics. We also keenly conduct an annual convocation for the appreciation and recognition of our students.

Reserve your Seat

You can reserve your seat  by filling the form below!

 

Are you a: 
StudentWorking Professional

 

 

 


X