Power bi course in dilsukhnagar

Power bi Training in dilsukhnagar

Power bi course in dilsukhnagar

Power BI is very easy to learn tool and does not require any programming or scripting background. Anyone can work start working on this tool easily. Analyzing Data with Power BI certification course imparts skills and knowledge to analyze, visualize and report data using Microsoft PowerBI

Complete Real-time and Practical Power BI Training in Hyderabad with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, and forecast any type of data with greater speed and efficiency. Our Power BI course includes Basic to Advanced Report Design with DAX and Custom Visualizations with M Language for your day to day corporate business needs!

 

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 PowerPivo

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

Leave a Comment

Your email address will not be published.