Power BI Corporate Training in Dubai, Abu Dhabi, Sharjah - UAE
Excel Prodigy is one of the Leading Power Bi Training Company in India & Middle East. We have conducted 1500+ Excel & Power Bi Training for Corporate’s in Dubai, Abu Dhabi, Sharjah – UAE. Our training methodology is simple and easy to understand. We provide Instructor-led, Interactive and hands-on training with real time dataset / dashboard. Our instructors are knowledgeable, experienced and patient computer training professionals with both Industry Expert, Microsoft Certified Trainer & Microsoft Certified Data Analyst.
Power BI is User-friendly Bi tool, very easy to learn and does not require any programming knowledge.
Power BI Training Sample Dashboards:
How can we help you?
Why Us
- Microsoft Certified Trainer
- Industry Expert Trainer
- Advanced Excel Training course
- Real World Examples
- Microsoft Certification
- Post Training Support
Power Bi Training Course Outline:
LESSON 1:
Getting Started With Power Bi Desktop
- Introduction to Self-Service BI
- Introduction Power BI Desktop
- Power BI Workflow
- Power BI Architecture
- Power BI Services
- Power BI Components
- Visualizations, Filters & Fields Pane
LESSON 2:
Connecting To Data Sources With Power Bi Desktop
- Data Sources Power BI Desktop will connect to
- On-Premises Data FilesDatabases
- Online Databases
- Software as a Service (SaaS) Providers
- Internet Data
- Data Types and Properties in Power BI Desktop
- Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Use Append Queries
- Merge Data Tables
- Working with Relationships in Data
LESSON 3:
Querying And Shaping The Data
- Activities using Query Editor
- Filters
- Clean, Trim, Format and Replace
- Split Column or Extract Using Delimiters
- Column from Example
- UnPivot
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions and Formula
LESSON 4: Data Visualizations
Charts
- Bar/Column Charts
- Clustered
- Stacked
- 100% Stacked
- Ribbon Charts
- Pie Charts
- Donut charts
- Map Charts
- Funnel Chart
- Waterfall Charts
- Line Chart
- Scatter Chart
- Area Charts
- Line-and-Column Charts
- Gauge Chart
- Card Chart
- Multi-Row Card
- Tree Maps
Charts From Marketplace
- Aster Plot
- Bullet Plot
- Chord
- Histogram
- Stream Graph
- Tornado
- Sankey
- Chart Formatting
- Sort Visuals by Values / Fields
- Inserting Text Box, Shapes & Images
- Applying Conditional Formatting
- Color Scale
- Rules
- By Field Values
- Icon Set
- Interactive Slicers
- Date Slicers – dropdowns and searches
- Number Slicers with value ranges
- Date Slicers with Relative filters
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in
- Visualizations
- Analytics Lines in Visualizations
- Forecast
DAX
- Calculated Columns
- Format
- Related
- Date Value
Create Measures
- SUM, COUNT, MAX, MIN
- COUNTROWS, DIVIDE
- DISTINCT COUNT
- SUMX, COUNTX, AVERAGEX
- Calculate
- IF ELSE
- AND, OR, NOT
- Create a KPI Visualization
- Drill Visualizations to see underlying Data
- Visual Table and Data Point Table
- Date Hierarchies
- Q&A
- Decomposition Tree
- Data Categories, Geo-Data and Maps
LESSON 5:
Reports And Output Options
- Report Elements and Options
- Working with Pages
- Visual and Filter Settings
- Edit Interactions
- Bookmarks
- Synchronize Slicer
- Report Themes
- Buttons and Q&A
LESSON 6:
Publish & Sharing Reports
- Publish Report from Power Desktop
- Understanding Dashboards, Tiles, Reports, Datasets, workbooks
- Creating Dashboard
- Pinning Tiles to Dashboard
- Sharing Reports & Dashboards
- Publish Reports to Web
- Print or Save as PDF
- Exporting to Powerpoint
- Export Data from Visualization
- Refreshing Data Sets.
Few of our Corporate Clients:
Testimonial
The training was very useful for me as it helped me to improve my skills of finding the insights through Power BI in more advanced way. Trainer was very thorough with his knowledge in Power BI and same way he delivered his knowledge to us which will definitely help me to build better dashboards with very strong and useful insights for any case.
Som Nath Ghosh
The trainer had good knowledge of the course and was very patient while explaining the concepts and clearing doubts of the students participating in the workshop. The course content covered topics from basic level to advanced level, and the pace of the course was very good for even beginners. I would recommended Excel Prodigy to anyone who wants to learn Power BI and get an hands on experience with the tool.
Pranav Vikas Arora
Mohamed Yusuf, is a very professional trainer as far as i see with Power Bi and he has focus for all the trainees and had best ensured that everyone understands from fundamentals to advanced, even if you are a beginner. The most key part of this program, is Only practical exercise for the whole sessions.
Cj Bhaskar Babu
Excellent course. The presentation and method of teaching was really great. The resource person Mr Mohammed Yousaf had a through and in-depth knowledge in the subject. The hands-on training approach from the beginning of the training was great.
Renjith Joseph
The training was excellent, and I learned a great deal. The hands-on workshops are excellent. I gained a lot of confidence from the practical session. The flow you demonstrated was fantastic. It's quite valuable.
Janani G
This Power BI use training was excellent in terms of information management and display of data in order to provide decision-making analysis. The training was a step-wised one where basics were first mastered being going through more advanced tools of the software. I would highly recommend this training to anyone interested to move a step up in their analysis and career as a professional blending with analytic technology.
Jordan Ramburn
The Trainer had a high subject knowledge and was very helpful and patient with the needs of the participants. The training covered the entire width and scope of Power BI helped me to use Power BI to visualize data set with ease. Giving insights and the hacks that are used in the industry and also providing training on the latest updates in MS Power BI. Really useful and a must for MBA students.
Avinash Mendon
Great Trainer. Really i didn\'t expect this training sessions would be this effective. But Yousuf took the pace really great and allowed enough space for me to follow. I will surely recommend this to other\'s. Thanks for the wonderful knowledge and Training.
Mannar Mannan
This workshop been very helpful session. In depth teaching of Power BI along with many tips and tricks which can be used in future was shared. The practice sessions covered many day to day use cases in corporate world. I am confident to now join my internship with the knowledge imparted during this training. Also the trainer was very helpful and patient and he repeated concepts till it was very clear. He helped us create many dashboard during the training program and the variety of dashboards has made me confident enough to work on Power BI myself.