POWER BI

COMPLETE PRACTICAL and REAL-TIME ORIENTED TRAINING WITH PROJECTS

UNIQUE FEATURES OF VINAYTECHHOUSE?

  •             In detail subject with clear diagrammatic explanation {Unique Style }.
  •         Full practical oriented classes with Real-time examples and situations.
  •         Certification based training and interview related practices.
  •         Exclusive project helps to under Power-BI Project Environment .
  •         Various documents discussion (used in real-time) to work effectively.

MANDATORY FUNDAMENTALS FOR POWER-BI DEVELOPERS:


IT Data Fundamentals & MSBI Existence

v  Data, Data Availability in IT
v  IT data storage areas
v  Data warehouse, BI definitions and layers
v  MSBI existence in IT, Product services
v  MSBI Tools and Components
v  MSBI Opportunities
Creative visualization through screen shots

MSBI and Competitiveness

v  What are BI, MSBI, and SSBI?  Importance in the current Enterprise? Competitive advantages
v  MSBI vs Other BI tools
v  MSBI 2016 Vs Others (2014, 2012, 2008, 2005)
v  Hardware, Software requirements
v  Instances and installation methods

Tools& Utilities to work with MSBI

v  SSDT, BIDS , SSMS, DQS Client /Server /Installer
v  Sqlserver Profiler, Deployment Wizards
v  Command Line Utilities
o    DTUTIL  b) DTUTILEXEC c) RS
§  RSCONFIG e) ASCMD etc…

Data warehousing fundamentals

v  Data definitions
o    (Data, Information, BI, Mining, ODS, DSS, Analysis, OLTP, OLAP, OLCP)
v  Dwh Characteristics, Principles
v  Dwh approaches (Top down/Bottom up)
v  Dwh Life Cycle steps
v  Data Mart & Types
v  Data Processing Types (OLAP)
v  Granularity and various granularities
v  Diff between OLTP and OLAP
Creative visualization through screen shots

Dimensional Modeling Fundamentals

v  Dimension, Dimension Table & types
v  Fact, Fact Table & measures types
v  Fact less fact table
v  Various schemas (Star, Snow Flake, Galaxy &   Hybrid )
v  Surrogate key and usages in real time
v  Model, Business, Conceptual, Logical, Physical Data Models
Real time project tables, models and tables

POWERBI SYLLABUS


  ü  Power BI introduction,Features 
        and installation:

ü  Installation of Power BI
      ü  Introduction to Power BI
      ü  Monthly updates of Power BI
      ü  Need of Power BI
      ü  Latest new features in PBI
      ü  Working with Power BI Desktop
      ü  Working with power BI Services
      ü  Power BI availability for.
      ü  Building blocks of PBI
      ü  Differences between Power BI and SSRS(MSBI)
      ü  Connecting to Database
      ü  Fetching data from different files
      ü  Working with different visualizations
      ü  Importing custom visualizations
      ü  Working with import and direct query options
      ü  Getting data from different external data source
      ü  Working with Query Editor
      ü  Creating custom table in the Power BI
      ü  Merge Queries and Append Queries
      ü  Remove columns and split columns
      ü  Choosing required columns in the data
      ü  Working with different transformations
      ü  Working with Applied steps in query editor

ü  Working with Power BI Views:

o  Report View
                  o   Data View
                  o   Relationship View

ü  Working with hierarchies and measures
      ü  Working with table and matrix visuals
      ü  Working with different level of filters

o   Visualization level
                  o   Page level
                  o   Report level

ü  Visualizations:

o   Column charts and bar charts
                  o   Line charts and area charts
                  o   Waterfall charts and tunnel charts
                  o   Pie charts and tree map charts
                  o   And remaining all visualizations

ü  Working with single row cards and multi row cards
     ü  Working with slicers
     ü  Publishing a report to Power BI Services
     ü  Managing report in Power BI services
     ü  Creating groups in Power BI Services
     ü  Different ways to share dashboards to Client and colleagues.
     ü  Working with multiple pages
     ü  Creating Power BI dashboards
     ü  Using social websites to create Dashboards


ü  Differences between old Power BI and new Power BI
     ü  Working with Pivot and Unpivot columns
     ü  Adding index column and custom column
     ü  Merging and appending queries
     ü  Working with Group By in Query Editor
     ü  Working with Replace Values and Replace Nulls
     ü  Managing data types in Query editor
     ü  Managing Relationships in Power BI Desktop
     ü  Adding image, text box and different shapes to reports in Desktop
     ü  Working with all query properties
      ü  Working with interactive drilldowns in the report visualizations

ü  Working with Excel BI add Ins:

o   Power view
                  o   Power query
                  o   Power map
                  o   Power pivot

ü  Creating calculated columns/fields and usage
      ü  Working with Power pivot data model
      ü  Working with data modeling
      ü  Developing KPIs and measures.
      ü  Defining relationships between tables
      ü  Power BI gateways and types

ü  Working with DAX functions

o   Text functions
                  o   Filter functions
                  o   Date functions
                  o   Logical functions
                  o   Information functions
                  o   Other functions

ü  Creating and working with calculated measures by using DAX.
      ü  Creating and working with calculated columns by using DAX.   
     ü  Implementing dynamic titles in the report.
     ü  Creating a custom table with range of dates.
     ü  Working with dynamic parameters.
     ü  Using dynamic parameters to filter the entire report.
    ü  Creating and publishing with Content packs.
    ü  Scheduling the Dashboards
    ü  Different ways to share dashboards
    ü  Creating groups and managing groups
   ü  Adding videos and pictures in the dashboards.



 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.