This event is now over

Event Details

About

We Provides Call@7993762900.best Power Bi, Certification,Training,Coaching Classes,Online Trainings in Hyderabad, Ameerpet,USA,Uk,Canada,Australi,Dubai,Middle East,Pune,Bangalore,Chennai

Genius tech delivers Microsoft Excel Excel Power BI Training in Hyderabad, Ameerpet  We deliver Power BI Training in Hyderabad, Ameerpet also in We also deliver MS Excel Power BI Trainings in Hyderabad, Ameerpet.Genius tech also delivers MS Power BI Training in  Hyderabad, Ameerpet  ,Ahmedabad, Nagpur, Chennai, Thane, Vashi, Pimpri Chinchwad & also in Kolkata Baroda Surat. 

Power Bi Training in Hyderabad@ 7993762900

Excel Power BI Training

The business intelligence tool for Excel.
Designed for Excel 365, 2016, & also in 2013, 2010. 

Excel Power BI 365 Training

Excel Power BI 2016 Training

Power BI 2013 Training

Excel Power BI 2010 Training


Excel Power BI Training Course Content

This training course will cover the following: 
Preparing for Power BI

  • Version of Excel needed
  • Installing add-ins
  • Basic multi-table pivot tables

 
PowerPivot data models

  • Importing SQL Server tables
  • Filtering rows & also columns
  • Data and also diagram view
  • Hiding from client view
  • Relationships

 
Pivot tables using PowerPivot

  • Drill-down vs Quick Explore
  • Slicers and also timelines
  • Controlling what you see

 

Using Excel tables

  • Creating and also naming tables
  • Adding to data models

 
Using other data sources

  • Importing Access and also Excel
  • Importing cubes
  • Pasting from the clipboard

 Power Query sources

  • Querying databases
  • Web pages and also XML files

 
Transforming data in Power Query

  • Splitting columns
  • Merging and also inserting columns
  • Other transforms

 
Calculated columns

  • Creating calculated columns
  • Using the RELATED function
  • BLANK and also SWITCH

 
Calculated fields (measures)

  • The all-important query context
  • Implicit calculated fields
  • AutoSum fields
  • Creating in Excel and also PowerPivot

 
DAX basics

  • The DAX Studio add-in
  • Calculating ratios
  • Aggregate X functions

 
The CALCULATE function

  • Replacing filters
  • Using ALL
  • Using VALUES to edit filters

 
More advanced DAX functions

  • Using FILTER to filter tables
  • Ranking
  • The EARLIER function

 
Calendars

  • Creating in Excel or SQL
  • Linking to calendars
  • Sorting months & also weeks
  • Multiple date tables

 
Date functions

  • Period to date
  • Fiscal year calculations
  • Parallel periods
  • Semi-additive measures

 
Hierarchies

  • Creating hierarchies
  • Pros and also cons

 KPIs

  • Relative KPIs
  • Absolute KPIs

 Power View basics

  • The data model again
  • Creating visualisations

 Power View Filters

 

  • Slicers
  • Using tiles
  • Filtering data

 Other visualisations

  • Creating matrices and cards
  • Chart multiples
  • Chart drill-down
  • Scatter and also bubble charts


The Power View maps

  • Assembling your data
  • Creating maps
  • Drill-down in maps


The Power Map (GeoFlow)

  • Creating maps
  • Scenes, tours and also layers
  • Creating videos
  • Reasons not to use



Kindly contact us for more details.
Please browse further for other Excel courses in Powerpivot, Adv Excel, Excel Macros

Power Bi Training in Hyderabad, Power Bi Training in Ameerpet, Power Bi  Certification Training in hyderabad, Power Bi  Certification Training in ameerpet, power bi certification training in hyderabad, power bi certification training in ameerpet, power bi classroom training in hyderabad, microsoft power bi certification training in hyderabad, online Power Bi Training in Hyderabad

Schedule

February 26, 2018 — 9:00 am to
July 03, 2019 — 6:00 pm

Add to your calendar

Venue

Powerbi Training @ 7993762900