POWER BI Syllabus
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
POWER BI Course Online Payment: Rs 29,500/-(Rs 25,000 + Rs Rs 4,500 (18% GST))
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)
HTML
CSS
Java
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 functins
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 Reportserver
