Power BI Online Training

 >>  Power BI Online Training

Power BI Online Training


 (5) | 1500 Ratings


Introduction


Power BI Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 35 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Introduction To Power BI

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

Getting Data

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data From Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data From Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

Power Query For Data Transformation

  • Installation, Requirements, and Configuration
  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

Power Pivot For Data Modelling

  • Power Pivot xVelocity engine basics and concepts
  • Different versions of Power Pivot
  • Relationships in Power Pivot
  • Best practices
  • Introduction to DAX
  • Calculated Members
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Functions
  • DAX Advanced
  • Power Pivot embedded in Power BI Desktop

Data Visualization With Power BI Desktop, Power View And Power Map

  • Data Visualization Best Practices
  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Power View for SharePoint
  • Power View for Excel
  • Charts, Scorecards, and other visualization items in Power View
  • Sorting, Filtering, and categorization with Power View
  • Best Practices to work with Power View
  • 3D geo-spatial visualization with Power Map
  • Different versions of Power Map
  • Best Practices to work with Power Map

Designing The Best Solution With Power Q&A

  • Power Q&A introduction
  • Design best practices for Power Q&A

Power BI Desktop; Combination Of Three Tools

  • Power BI Desktop Introduction
  • Getting data from different data sources
  • Differences of Power Query stand-alone with Power Query in Power BI Desktop
  • Modelling data, and relationships
  • Creating calculated measures
  • Power Pivot difference in Power BI Desktop
  • Visualizing data in Power BI Desktop
  • Power View difference in Power BI Desktop
  • Best practices of designing solutions with Power BI
  • Custom Visuals for Power BI Desktop

Administration

  • Power View for SharePoint Administration
  • Office 365 Administration
  • Deployment of files into Power BI website
  • Building dashboards in Power BI website
  • Mobile apps for Power BI on Apple, Android, and Windows Phone
  • Configuration and administration on Power BI website

Practice Test & Interview Questions

Power BI project

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Introduction To Power BI

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

Getting Data

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data From Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data From Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

Power Query For Data Transformation

  • Installation, Requirements, and Configuration
  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

Power Pivot For Data Modelling

  • Power Pivot xVelocity engine basics and concepts
  • Different versions of Power Pivot
  • Relationships in Power Pivot
  • Best practices
  • Introduction to DAX
  • Calculated Members
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Functions
  • DAX Advanced
  • Power Pivot embedded in Power BI Desktop

Data Visualization With Power BI Desktop, Power View And Power Map

  • Data Visualization Best Practices
  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Power View for SharePoint
  • Power View for Excel
  • Charts, Scorecards, and other visualization items in Power View
  • Sorting, Filtering, and categorization with Power View
  • Best Practices to work with Power View
  • 3D geo-spatial visualization with Power Map
  • Different versions of Power Map
  • Best Practices to work with Power Map

Designing The Best Solution With Power Q&A

  • Power Q&A introduction
  • Design best practices for Power Q&A

Power BI Desktop; Combination Of Three Tools

  • Power BI Desktop Introduction
  • Getting data from different data sources
  • Differences of Power Query stand-alone with Power Query in Power BI Desktop
  • Modelling data, and relationships
  • Creating calculated measures
  • Power Pivot difference in Power BI Desktop
  • Visualizing data in Power BI Desktop
  • Power View difference in Power BI Desktop
  • Best practices of designing solutions with Power BI
  • Custom Visuals for Power BI Desktop

Administration

  • Power View for SharePoint Administration
  • Office 365 Administration
  • Deployment of files into Power BI website
  • Building dashboards in Power BI website
  • Mobile apps for Power BI on Apple, Android, and Windows Phone
  • Configuration and administration on Power BI website

Practice Test & Interview Questions

Power BI project

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry