Microsoft Power BI Course

Introduction to Microsoft Power BI Course, the key features of Power Bl workflow, Desktop application, Bl service, and file data sources, sourcing data from the web (OData, Azure), building dashboard, data visualization, publishing to the cloud, DAX data computation, row context, filter context, Analytics Pane, creating columns and measures, data drill down and drill up, creating tables, binned tables, data modeling and relationships, the Power Bl components like Power View, Map, Query, Pivot, Power Q & A, understanding advanced visualization.

Learning about Power Query for self-service ETL functionalities, introduction to data mashup, working with Excel data, learning about Power Bl Personal Gateway, extracting data from files, folders, and databases, connecting to Analysis Services, SaaS functionalities of Power BI.

Installing Power BI, the various requirements and configuration settings, the Power Query, introduction to Query Editor, data transformation — column, row, text, data type, adding & filling columns and number columns, column formatting, transposing tables, appending, splitting, formatting data, Pivot and UnPivot, Merge Join, relational operators, date, time calculations, working with M functions, lists, records, tables, data types, generators, Filters and slicers, Index and Conditional

Introduction to Power Pivot, learning about the xVelocity engine, advantages of Power Pivot, various versions and relationships, strongly typed datasets, Data Analysis Expressions, Measures, Calculated Members, Row, Filter & Evaluation Context, Context Interactions, Context over Relations, Schema Relations, learning about Tables, Information, Logical, Text, Iterator, Table, and Time Intelligence Functions, Cumulative Charts, Calculated Tables, ranking and rank over groups, Power Pivot advanced functionalities, date and time functions, DAX advanced features, embedding Power Pivot in Power Bl Desktop.

Deep dive into Power Bl data visualization, understanding Power View and Power Map, Power Bl Desktop visualization, formatting, and customizing visuals, visualization interaction, SandDance visualization, deploying Power View on SharePoint and Excel, top-down and bottom-up analytics, comparing volume and value-based analytics, working with Power View to create Reports, Charts, Scorecards, and other visually rich formats, categorizing, filtering, and sorting data using Power View, Hierarchies, mastering the best practices, Custom Visualization, Authenticate a Power Bl web application, Embedding dashboards in applications

Introduction to Power Q & A, an intuitive tool to answer tough queries using natural language, getting answers in the form of charts, graphs, and data discovery methodologies, ad hoc analytics building, Power Q & A best practices, integrating with SaaS applications