ONLINE POWER BI TRAINING COURSE

Apply For Course

DURATION : 45 DAYS

FACULTY : Mr.Guna (15+Years exp)

FEE : 10500

SQL Server Basics

Data warehouse concepts

• What is OLTP?
• What is Data Warehouse? What is E-R MODELING?
• What is Start Schema and snowflake schema? What are dimensions and Facts?
• What is ETL?
• What is Architecture of DWH?

Power BI Introduction

• What is Power BI?
• What is Power BI Desktop?
• What is the Power BI service?
• Comparing Power BI Desktop and the service

Power BI Desktop

• Introduction to Power BI Desktop
• Different data sources (excel, csv, SQL server, SSAS, web, Azure)
• Data types and Categories
• Direct Query and Import and Live connection Parameters in power BI
• Calculate Column Vs Calculated Measures
• All Transformation Options in EDIT Query Window How to create Customer Function
• How to Invoke Custom Function Templates in power BI Synonyms in Power BI Hierarchies in Power BI
• Import Excel workbook content
• Modeling and Filters in Power BI
• MERGING AND APPENDING QURIES
• Data Modeling in Power BI
• Cross filter direction in modeling
• Bins and list in Grouping
• Different Kind of Theams in Powerbi
• How to import and use Custom visuals
• Different kind of filters in Power BI Desktop
• Report Level
• Page Level
• Visual Level
• Drill through
• Scatter chart by using play axis option Word cloud
Slicer
• ArcGIS maps enablement in power bi Desktop and service Power BI publisher for Excel
• Quick measures
• Publish reports to Power BI Online

Power BI Service (Online)

• Introduction to Power BI Service
• Different kind of licenses Free Pro and Premium
• How to create workspace
• How to create Dashboards
• Dashboards and Pins - Real-time Usage
• Delivery Methods of Dashboard
• How to create power BI Apps
• Datasets
• Reports
• What is Content Packs?
• Data Gateways and Schedule Refresh
• Row Level Security
• Row Level Security in Power BI Desktop
• Row level security in Power BI Service
• Row level security in power BI dynamic
• Power BI Reporting Services
• Q&A Natural Language Processing option in Power BI
• Quick Insights
• Dynamic Data Sources and Encryptions
• Personal and Organizational Content Packs
• Gateways
• Subscriptions
• Mobile Reports
• How to Schedule Data Refresh
• Cloud and On-Premise Data Sources
• Relation between Dashboards to Reports
• Relation between Datasets to Reports
• Relation between Datasets to Dashboards
• Page to Report - Mapping Options
• Admin portal
• Add title and image
• Screen shots
• High contrast colors
• Generate QR Code
• xport to excel
• Embed codes
• Alerts
• Notifications
• Get data

Data Analysis Expressions (DAX)

• DAX overview
• Use DAX in Power BI Desktop Learn path
• DAX function reference
• New DAX functions
• Date and time functions
• Filter functions
• Financial functions
• Information functions
• Logical functions
• Math and trig functions
• Other functions
• Parentand child functions
• Relationship functions
• Statistical functions
• Table manipulation functions
• Text functions
• Time intelligence functions
• DAX statements
• DAX Glossary
• DAX operators
• DAX queries
• DAX parameter naming
• DAX syntax

Power BI Reporting Services with SSRS

• Installation and configuration of Report Server
• Deploy Power BI Reports into Report Server
• Paginated Reports in Report Server
• Report Builder in Report server
• Mobile Reports in Report Server
• Create KPI in Report server
• How to schedule reports in Report Server
• Security in Report Server

Power BI Mobile

Power BI Report server

COURSES OFFERING

• 3DS MAX
• 3DS MAX & V-RAY
• ADOBE PHOTOSHOP
• ADOBE AFTER EFFECTS
• ADOBE PREMIERE PRO
• ADVANCE EXCEL
• ADVANCED JAVA
• MULTIMEDIA ADVANCED
• ANGULAR JS 1
• ANGULAR
• AUTOCAD 2D / 3D
• AWS
• BOOTSTRAP 5
• C LANGUAGE
• C++ LANGUAGE
• CODEIGNITER
• CORE JAVA
• DATA SCIENCE
• DATA STRUCTURES and ALGORITHMS in PYTHON
• DEVOPS
• DIGITAL MARKETING
• DTP
• DJANGO
• GRAPHIC DESIGNING
• HTML 4,5,6, CSS 2,3,4, JAVASCRIPT
• INFORMATICA
• JQUERY AJAX JSON
• LINUX ADMINISTRATION
• LINUX UNIX SHELLSCRIPTING
• MEAN ( FULLSTACK UI TECHNOLOGIES )
• MERN ( FULLSTACK UI TECHNOLOGIES )
• MS-OFFICE
• MS-OFFICE & ADVANCE EXCEL
• MS-OFFICE & ADVANCE EXCEL & VBA
• MS-PROJECT
• MULTIMEDIA ADVANCED
• ORACLE ADF
• ORACLE SQL PLSQL
• PHOTOSHOP
• PHP
• PRIMAVERA
• POWER BI
• PYTHON
• PYTHON + DJANGO
• REACT JS
• REVIT
• RUBY
• RUBY ON RAILS
• SALESFORCE CRM ADMINISTRATION & DEVELOPMENT
• SELENIUM
• SKETCHUP
• SPOKEN ENGLISH
• SPOKEN HINDI
• STAAD PRO
• Tally.ERP9 (GST)
• UI TECHNOLOGIES
• UI TECHNOLOGIES + ANGULAR 12
• UI TECHNOLOGIES + REACT JS
• MEAN ( FULLSTACK UI TECHNOLOGIES )
• MERN ( FULLSTACK UI TECHNOLOGIES )
• WEB / UI DESIGNING
• WEB / UI DESIGNING AND DEVELOPMENT
• WEB AND GRAPHIC DESIGNING

COURSE ENQUIRY

Apply For Course


Follow @SivaSoft1