Power BI Basic To Advanced Level

Learn from Microsoft Certified Trainer & Power BI Analyst

Learn at your own Schedule

Learn at your own Pace

Date

Learn at your own Time

TIME

Basic to Adv Level

Workshop

Who is this workshop for?

Those who work in Excel

Interested in Dashboard Designing

Data Analyst

Those who wish to Upgrade Skill for Better Future

What will you learn in this workshop?

DATA VISUALIZATION

Day 1 : Getting Start with Power BI

Introduction to Power BI
Importing data and Creating Chart
Formatting Column Chart
Creating Pie & Line Chart
Creating Heading for Dashboard

Day 2 : Adding Slicers & Cards

Creating Tree Map & Bar Chart
Creating Beautiful Cards
Getting Distinct Count
Creating Slicers for Interactivity

Day 3 : Refresh Data and Interaction

Creating Page Navigation
Refresh Data
Edit Interaction
Animated Scroller Visual
Making Horizontal Slicer
Power BI Shortcuts

Day 4 : Reset Filter

Create Decomposition Tree
Reset all Filters

Day 5 : Publish Your 1st Power BI Dashboard

Using Natural Language
Publish Dashboard
Mobile View
Importing Multiple Files
HR Dashboard Project Explanation

POWER BI SERVICE

Day 6 : Exploring Power BI Service

Introduction to Power BI Service
Creating Power BI Service Account
Publish report to Power BI Service
Pinning your reports to Dashboard
Understanding Workspace
Linking Dashboard to PowerPoint
Export to PPT & PDF
Subscribe your Power BI Reports
Other ways of Sharing Dashboard
Generate QR Code for your Dashboard

POWER QUERY

Day 7 : Cleaning Messy Data With Power Query

What is Power Query and how to launch it from Excel and Power BI?
Cleaning Messy Data while Importing in Power BI
Common Transformations : Combining Names, Fill Gaps, Extract Day & Month from date
Cleaning Messy Data while importing
Project 1
Project 2
Project 3
Combining Data from Multiple Sheets in the same Excel Workbook
Combining Excel Files and creating Reports
Adding New Data & Deleting Query
Adding Conditional Column
Adding Conditional Column – Participant Query
Column from Examples

DATA MODELING

Day 8 : Creating Relation Between Data

Introduction to Data Modelling
How does Power BI automatically establish relationships on loading
Creating our First Relationship between 2 tables
Edit a relationship in Power BI

DAX CALCULATION IN POWER BI

Day 9 : Introduction to DAX

What is DAX
About Calculated Table, Calculated Column & Measures
Basic DAX : Aggregation Functions à Sum, Count, Min, Max & Average

Day 10 : Understanding Measure and Text Function

Create & Calculate measure
Text Function

Day 11 : Time Intelligence Functions

Day 12 : Calculate Function

Time is running out!

Meet your Trainer

Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI.

17+ years of experience in managing large databases, from requirements gathering through implementation and support.
Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI

Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback.
Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations.
Ramzan helps answering business questions using data in creative ways.

Power BI is quickly becoming the world's most
powerful self-service business intelligence tool
for data professionals and beginners
Get Certified in POWER BI Now

Yes, you will receive Power BI Participation Certificate, which lends a lot of credibility to your certificate and resume.

You may not believe me, but you can believe them

Experiences shared by people who previously attended this workshop

I'll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way

Frequently Asked Questions

We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at contact@upgradeskill.ae

I made the payment but didn’t receive any email

Write to us at contact@upgradeskill.ae and our support team will be able to resolve your issue in the shortest amount of time.

Will this be live or pre-recorded?

All the Videos are Pre-Recorded so that you can watch anytime – anywhere.

How much experience do I need for this workshop?

There is no prior experience required for this workshop, however its better to know Excel Basic Formulas.

Can I get a refund?

No. We do not offer refunds in any case. If you are unsure about the workshop, read testimonials, learn more about the trainer, and make an informed decision.

Will I get a certificate after completion?

Yes, you will receive a certificate of completion from a Microsoft Certified Trainer after completing the workshop.

What is the time zone?

As Videos are Pre-Recorded so that you can watch anytime – anywhere.