fbpx

Upcoming Events

No Events on The List at This Time

 

Power BI Workshop

Presenting expert-led training in Lahore

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

In order to take effective business decisions, analysts need to read gist of data closely and extract meaningful information out of it. 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

Schedule

Starting

21st December’19

Duration

2 Weeks (Saturday and Sunday)

Timings

10:00AM to 06:00PM

Address

Management House, 95 J/1, Johar Town, Lahore

Meet the Instructors

Meet the instructors of Power BI Workshop

qodef-team-image
Expert FP&A, Business Analyst at Jazz
Mr. Saad Farid

Mr. Saad has been associated with the Telecom, Oil & Gas and Tobacco sectors. He brings with him more than 6 years of multi-disciplinary working experience in domains of Marketing, Human Resources, Customer Value Management and Commercial Business Partnering. He holds his Bachelors degree in Business Administration from Bahria University and Masters in Business Administration from Karachi School for Business & Leadership (KSBL).

qodef-team-image
Strategy & Products Analyst at Telenor
Ms. Hajirah Asif

Ms. Hajirah is a data enthusiast having 7 years of experience in Telecom Industry. Her key expertise are in planning, technology strategy, data analytics and business intelligence domain. Being part of Planning & Strategy teams, she has dealt with extensive data to derive business-growth centric insights, evaluated network performance parameters, prepared & forecasted network & spectrum growth requirements for multiple strategy periods.

Course Outline

Day 1: Fundamentals of Power BI

    • What is Power BI
    • Power BI Interface and Workflow
    • Connect & Import Data from multiple Data sources
    • Reshaping and Transforming using Query Editor
    • Query Editing Tools
    • Basic Table Transformations
    • Text, Number and Date Specific Tools in Query Editor
    • Custom Columns
    • Pivoting and Unpivoting Data
    • Merging Queries and Appending Queries
    • Defining Data Categories, Hierarchies
    • Connecting and Shaping Data Best Practices
    • Data Tables
    • Relationships
    • Table Relationships: Star Schema, Snowflake Schema
    • Active and Inactive Relationships
    • Relationship Cardinality
    • The Filter flow concept

Day 2: Working with DAX

    • What is DAX
    • Measures vs Calculated Columns
    • The Filter Context Concept
    • Step by Step Measure Calculation
    • DAX Syntax
    • Aggregation Functions
    • Logical Functions and Operators
    • Text Functions
    • Basic Math, Stat Functions and Basic Date/Time Functions
    • Iterator Functions
    • Understanding the row context
    • Related Function

Day 3: Advanced DAX

    • Table Functions (All, Related Table, DISTINCT)
    • Removing Filters
    • Mixing Filters
    • The Filter Function
    • The Calculate Function
    • Filter Context and Row Context
    • Making Complex Measures
    • Time Intelligence Functions
    • Using Variables in DAX
    • Creating Calendar Table Using DAX
    • When to use Measures
    • When to use Calculated Columns

Day 4: Power BI Visuals

    • Building Interactive Visualizations
    • KPI Charts, Donut Chart, Matrix Bar Chart, Bubble Chart details
    • Conditional Formatting
    • Visualizing different type of variables
    • Drill up and Drill Down Capabilities
    • Applying Filters on Visuals, Page level filters and Report Level Filters
    • Using Slicers to Filter Visuals
    • Edit Interactions
    • Custom Visuals in Power BI
    • Bookmarking
    • Power BI different themes
    • Animated Visualizations
    • Introduction to Power BI Service
    • Workspaces in Power BI Service
    • Power BI Service Developer Tab
    • Creating Dashboards
    • Sharing Dashboards on the web
    • Scheduling Automated Report Refresh
    • Asking Power BI to generate insights on data on its own
    • Introduction to Power BI Mobile Layout

Fee Structure

Following is fee structure for this extensive workshop on Power BI

Individual
Fee for an Individual Member
Rs 15,000 per person
Group of Two
7% Discount for a group of two people
Rs 13,950 per person
Group of Three
10% Discount for a group of Three people
Rs 13,500 per person
Group of Four
15% Discount for a group of Four people
Rs 12,750 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 are the Instructors?

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
    \