Power BI Training

Power BI Corporate Training in Chennai, Mumbai, Delhi, Bangalore, Hyderabad, Kolkata & Pune

Excel Prodigy is one of the Leading Excel & Power Bi Training Company in India. We have conducted 150+ Power Bi Training for Corporate's in Chennai, Mumbai, Delhi, Bangalore, Hyderabad, Kolkata, Pune and PAN India. 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 and Microsoft Certified.

Power BI is User-friendly Bi tool, very easy to learn and does not require any programming knowledge.

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
  • Overview of Data Visualizations
  • Tables and Matrix Views
  • Charts
    • Bar/Column Charts
      • Clustered
      • Stacked
      • 100% Stacked
    • Ribbon Charts
    • Waterfall Charts
    • Line Chart
    • Scatter Chart
    • Area Charts
    • Line-and-Column Charts
    • Pie Charts
    • Donut charts
    • Map Charts
    • Funnel Chart
    • 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
      • REALTED
      • DATEVALUE
    • Create Measures
      • SUM, COUNT, MAX, MIN
      • COUNTROWS, DIVIDE
      • DISTINCT COUNT
      • SUMX, COUNTX, AVERAGEX
      • CALCUATE
      • 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.

Request Callback

    ​how can we help you?

    Drop Email For Corporate Training Across India & International or Call

    +91 893989 8008

    Why Us

    • Microsoft Certified Trainer
    • Industry Expert Trainer
    • Practical Hand-on Session
    • Real World Examples
    • Microsoft Certification
    • Post Training Support

    Request Callback

      Few of our Corporate Clients:

      Our Corporate Clients

      Power Bi Corporate Training Feedback:


      "Excel Prodigy is a company with very dedicated trainers. I was amazed with the knowledge they have and the way they share it with students. I got an opportunity to attend a Power/BI class, and it was an eye opener for me. How well informed the trainer was and how beautifully they explained each and every concept. Thanks a lot. One of the best sessions ever" -Sarthak Gadoo

      "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

      "The training session was very valuable. We started from basic and moved on to some advanced techniques. The session was very informative and was made easy by the instructor" -Amar Agrahari

      "Overall good training session and useful session for making reports. training has planned in structured way. knowledge of the trainer is very well." -Srinivasarao Kothuru




      "Have created my own dashboards/reports before this training with help of Web tutorials, after this training I want to modify all my dashboards to improve performance and new ways of analysis - Kudos to the trainer for clarifying the core concepts which is not easily available over internet" -Vimal Kumar

      "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

      "Excellent training session with loads of practical exercises included. The trainer is also extremely patient in ensuring that he addresses all our queries." -Mamta Shah

      "Clear, comprehensive course covering all key aspects of PowerBI in a logical and structured manner. Highly recommended to all." -Radhakrishnan.R

      "Trainer is strong in the technical aspect and solved all queries asked from the trainees." -Deepanraj Rv

      To Conduct Power Bi Corporate Training, Please Contact : +91 893989 8008