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.