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.
Enquiry Now
Power BI is User-friendly Bi tool, very easy to learn and does not require any programming knowledge.
Power BI Training Sample Dashboards:
Power Bi Training Course Outline:
- Introduction to Self-Service BI
- Standard Business Intelligence Process
- Introduction Power BI Desktop & Workflow
- Power BI Architecture & Power BI Services
- Excel Vs Power BI Desktop & Advantage
- Power BI Components:
- Power Pivot, Power Query
- Power Map, Power View, Q&A
- Power BI User Interface:
- Report View
- Data (Tables) View
- Relationship (Model) View
- Report Canvas, Visualizations, Filters & Fields Pane
- Connect and Load data from CSV, Excel & Web
- Exploring Report View & Understanding Chart Elements
- Adding Chart to the Canvas
- Inserting basic Charts/Visuals and Creating Simple Report:
- Cluster Column Chart
- Cluster Bar Chart, TreeMap
- Line Chart, Pie Chart, Donut Chart
- Funnel Chart
- CARD Visual
- Table Vs Matrix
- Essential Formatting: Text Size, Legends, Values, Title
- Inserting Text Box, Shapes & Images
- Slicers: Vertical List Vs. Horizontal Tiles
- Tooltip – On hover Text
- Sort Visuals by Values/Fields
- Focus Mode, Explore & Export Data
- Exploring Power Query Editor
- Importing Data
- Preparing/Transforming Data for Power BI Dashboard
- Promoting First Row as Headers
- Renaming the Table and Column Names
- Remove Unwanted and Empty Columns
- Remove Top Rows, Blank Rows, Errors, Duplicate Rows
- Split Column by Delimiter, Characters, Positions
- Choosing the right Data Types – Whole Number, Date, Text
- Replacing Values and Column Formatting: Clean, Trim, Change Case
- Fill Blank Data with Above or Below Text
- Filtering Data, Removing, Reordering and Merging Columns
- Applied Steps – Its Usage & Revert Options
- Overview of M-Query Language
- Introduction to Data Model
- Data Tables (FACT Tables) Vs Lookup Tables (Dimension Tables)
- Creating and Managing Table Relationship
- Active & Inactive Relationship
- “Snowflake” Schemas Vs Star Schemas
- Understanding Relationship Cardinality
- One to Many
- One to One
- Many to Many
- Creating Custom Column from Examples (Excel Flash Fill)
- Working with Conditional Columns
- Transpose Data (Rows to Columns)
- Unpivot Columns to convert unstructured data set to columnar table
- Grouping & Binning
- Merge Queries Vs Append Queries
- Merge Queries - Joins
- Left Outer, Right Outer
- Inner Join
- Full Outer Join
- Left Anti
- Right Anti
- Append Queries
- From Different Sheets
- From Csv Files
- From Excel Files
- From Folder
- Creating Dimension Table using M-Query Language
- Enable Data load, Enable Data Refresh, Close and Apply
- What is DAX?
- Creating Simple Calculated Column & Calculated Measure
- Implicit Measure Vs Explicit Measure
- Calculated Columns Vs DAX Measure
- Row Context & Filter Context
- DAX - Calculated Columns
- RELATED
- FORMAT
- DATEVALUE
- DAY, MONTH, YEAR
- DAX - Calculated Measures
- SUM, COUNT, MAX, MIN
- COUNTROWS, DIVIDE
- DISTINCT COUNT
- DAX - Calculated Tables
- CALENDARAUTO
- CALENDAR, DATE
- Working with Multi-row Card
- Visualizing Data with Multiple Fields
- Stacked Bar, 100% Stacked Column
- Area Chart, Stacked Area
- Combo Chart
- Line & Cluster Column
- Line & Stacked Column
- Secondary Axis Chart
- Scatter (Bubble) Chart
- Visualizing Time Series Data
- Multi-Line Chart
- Ribbon Chart
- Waterfall Chart
- Visualizing Geospatial Data with Maps
- Point Map
- Fill Map
- Showing Key metrics with Cards, KPI Visuals & Gauge Chart
- Applying Condition Formatting
- Data Color
- Color Scale
- Rules
- By Field Values
- Table Formatting
- Background & Font Color
- Data Bar
- Icon Set
- Working with different Level of Filters
- Report Level
- Page Level
- Visual Level
- Top N
- Analytics Tab
- Adding Target Line
- Average, Median & Percentile Line
- Q&A - Ask Question (Natural Language)
- Hierarchies
- Timeline Slicer
- Creating Table for Measure (Measure Table)
- DAX - ADVANCED
- SUMX, COUNTX, AVERAGEX
- CALCULATE
- IF ELSE IF
- SWITCH
- AND, OR, NOT
- FILTER
- ALL
- HASONEVALUE
- SAMEPERIODLASTYEAR
- PARALLELPERIOD
- DATEADD
- DATEDIFF
- Understanding "xVelocity in-memory Analytical Engine" - Vertipaq
- Different Modes of Connection
- Live Connection
- Imported (Cashed)
- DirectQuery
- Get Data from
- Csv, Excel
- Access
- SQL Server
- Web
- ERP, CRM
- Cloud Services
- Update & Refreshing Dataset
- Changing Data Source
- Configuring Data for Q&A
- Adding Trendline & Forecasting
- Editing Power BI Report Interaction
- Adding and Updating Bookmarks
- Inserting Buttons
- Using Selection Panes to Control Visibility
- Assigning Bookmarks to Button through Actions
- Synchronize Slicer Across Pages
- Displaying Report Page in Tooltips
- Importing Custom Visual from Marketplace
- Using Custom Visuals
- Creating Customized Color Themes and Templates
- Mobile Layout & Desktop Layout
- 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
- Refreshing Data Sets
- Workspace and Apps (Power BI Pro)
- Row Level Security (Power BI Pro)