Power BI training in pune

power bi etlhive


Course Features

 

 

One Stop Solution!

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance

Syllabus

 

  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

  • A 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 IntroductionQuery 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 
 

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 & 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 best solution with Power Q&A

 

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

     

 

Power BI Desktop

 

  • 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

CLICK HERE TO PAY REGISTRATION FEES ONLINE

Gallery

More

Power BI Training in Pune

ETLHive Power BI Training lets you master the Microsoft Power BI tool also helps data scientists visualize and share insights from their organizations data. The user friendly Power BI reporting application has been designed to help users, produce insightful data analysis hence our interactive and highly engaging BI training course helps candidates across the departments, communicate performance related data in a visually understandable manner. Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data. The Microsoft Power BI tool allows you to extract, analyse and comprehend large quantities of data which helping to ensure that you can present data in a logical manner and make informed business decisions. Classes are Conducted by Power BI Working Professionals having 10+ years of industry experience with 100 % Quality Assurance.

top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
15th Dec - Demo Session - P.Saudagar - Hadoop : 4.00 pm | Data Science : 4.00 pm | Python : 4.00 pm | Informatica : 11.00 am | DevOps : 6.00 pm | Digital Marketing : 10.00 am | Angular jS : 11.30 am | Tableau : 5.00 pm | AWS : 4.00 pm | Nal Stop - AWS : 12.30 pm | Data Science : 10.45 am | Hadoop : 3.00 pm | AWS : 12.30 pm | Digital Marketing : 2.00 pm | Python : 4.00 pm | Data Science : 6.30 pm (Friday) | Kharadi - Data Science : 3.00 pm | Tableau : 11.00 am | Digital Marketing : 5.00 pm | Vashi - DevOps : 11.00 am | Data Science : 5.30 pm | Python : 5.30 pm | AWS : 11.00 am