Power BI

Power BI

RR Technosoft provides Power BI Training In Hyderabad. Power Bi is a powerful cloud-based suite of business analytics tools that make it easy to combine data from multiple

WHAT ARE THE PREREQUISITES FOR TAKING THIS TRAINING COURSE?

You don’t need any prior knowledge to benefit from this Power BI training. Add-on advantage if any knowledge in reporting service.

WHO SHOULD TAKE THIS POWER BI TRAINING COURSE?

Individuals looking for jobs as BI Developers, Business Analysts, Business Development Manager and etc. Marketing, Finance, Sales, and other domain individuals who need extensive business intelligence.

WHY SHOULD YOU TAKE THIS POWER BI COURSE TRAINING?

  • Power BI helps Business Analysts, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data.
  • Global Business Intelligence and Analytics Market to Reach $16.9 Billion in 2016
  • 70% of leading companies say analytics are integral to how they make decisions
  • A Senior Business Intelligence Analyst can earn $89,000 to $1,04,000 in the United States
  • Today every business enterprise and department needs extensive business insights and Power BI puts the power in your hands. You can easily work with multiple sources of data, convert it into a report, graph, or data visualization of your choice. Get real-time insights and deploy it faster than any other BI tool available in the market. It is open source and highly intuitive and does not need technical knowledge or IT support.

WHAT ARE THE SYSTEM REQUIREMENTS FOR THIS COURSE?

  • Windows 7 / Windows Server 2008 R2, or later, .NET 4.5, Internet Explorer 9 or later,1 GB RAM
  • To install Power BI Desktop, download URL (https://powerbi.microsoft.com/en-us/)

POWER BI COURSE CONTENT

  • Power BI Interdiction & Over view
  • Compotators and Demand in the Market
  • Power Bi Architecture

POWER BI DESKTOP

  • Power BI desktop Software installation
  • Power Bi Desktop Sign in Process
  • Types of Sources availble in Power Bi to connect
  • Types of Connectivity Mentiodes
  • 1. Import Method/mode
  • 2. Direct Method/mode
  • 3. Live connection
  • Power Bi Desktop Over view(Visual pane,data pane,model pane)
  • Authentication Methods in desktop
  • Trasform Data while Loading

  • Model pane over view
  • Data modelling and relations ships
  • Filters and Slicers
  • Visual Pane
  • Bar chat visuals
  • pie chart and Other visuals
  • Map Related Visuals
  • Table and Matrx Visuals
  • Custom Visuals ,import and use of CV
  • Power Apps visual and Integration
  • Drill down and Drill through Options
  • Edit Intractions & Corss Filter Direction

POWER QUERY EDITOR

  • Transform Data & Data source Settings
  • Discussion about Advance Editor and M-code uses
  • Different kind of Options in Transform data
  • Parameters in Power Bi
  • Incremental Refresh in Power Bi
  • Custom Column Creations
  • Visual Contional Formatting
  • Pivot and Unpivot Data in the power Query







     
  • Invoke Function uses
  • Native Query & Query Folding
  • Dicussion about top ribbon Icons like File,Home,Insert,Modelling ,view ect..
  • How to Create custom Table
  • How to create Calender table
  • Join and merge & Append & Group by operations
  • Refresh single connection and whoel report

POWER BI SERVICE

  • Power Bi Service Over view
  • Power BI Service Sign in Process
  • Power Bi Workspace overview
  • How to create custom Worksapce
  • How to publish reports to service
  • What is report and Dataset and Dashbaords
  • How to create Dashboards
  • Access Levels In Power Bi







     
  • How to Share reports to end users with in Org or outside Org
  • Usage Metiecs for Report/Dashbaord
  • What is APP and Publish/Update APP
  • what is Share with Me and uses
  • What is Deployemnet Pipeline and uses
  • what is Liniage(How to identify source and destination)
  • What is Dataflow and use of dataflow

POWER BI GATEWAYS

  • Interduction of Gateways
  • Installation of Gateways
  • Type of Gateways and uses
  • adding connection to gateways
  • Mapping Gateways to Datasets
  • Schedule and manual configuraiton
  • Options under Gateways
  • Configuring the Fialure notification email to user
  • Gateway maintance

DAX

  • What is DAX Expressions Use of DAX
  • What is Calculated Measures and Calculated columns
  • Aggrigate Dax(Sum,SumX,Count,CountX,etc..)
  • Time & Date Realated DAX(Now,Today,date diff,date add)
  • YTD,MTD,QTD expressions
  • Other Dax Functions
  • RLS in Power BI
  • Book Marks in Power BI