Power BI Course Content
Introduction to Power BI
Fundamentals of Microsoft Power BI, Desktop application, Power BI workflow, file data sources, and BI service, data sourcing from web, dashboard building, publishing to cloud, data visualization, row context, knowledge about Analytics pane, understanding DAX data computation methodologies, filter context, data drill down and drill up binned tables, how to create tables, data modeling, and relationships, Power BI Components such as Power View, Pivot, Power Q&A, map, query, view, and introduction to advanced visualization concepts.
Data Extraction
Introduction to service power BI ETL functionalities, Power BI gateway, working with Excel data, data extraction from files, databases, and folders, introduction to data mashup, working guidelines with Azure SQL database and other sources, connecting with SaaS functionalities, and Analytics Services Power BI.
Power Query for Data Transformation
Installation of Power BI configuring required tools, introduction to query Editor, Power Query, data transformation – row, column, text, data type, and filling & adding number column, transpose table, column formatting, appending, formatting data, splitting, Merge Join, Pivot, and UnPivot, relational operators, time calculations, date, working with M functions, records, lists, data types, tables, and generators, Filters & Slicers, Summary Tables, Index, and Conditional Columns, writing custom functions, M advanced data transformations and error handling.
Data Visualization
Introduction to multiple visuals in Power BI, Matrices and tables, charts on Power BI, Map visualizations, Slicers, Gauges and Single number cards, shapes, images, and text boxes color modifications in charts and visuals, z-order, KPI Visuals, custom visuals, page layout, ut, and formatting.
Pivot Data Modeling and Data Analysis Expression
Power Pivot Introduction, learning about Table, learning Velocity engine, advantages of Power Pivot, Data Analysis Expressions, strongly typed datasets, Measures, Row, Filter & Evaluation Context, Context Interactions, Logical, Schema Relations, Text, Iterator, Table, Information, and Time Intelligence Functions, Calculated Tables, ranking and rank over groups, Cumulative Charts, Calculated Members, Power Pivot next level functionalities, various versions and relationships, Context over Relations, date and time functions, DAX of features, implementing Power Pivot on Power BI Desktop.
Data Visualization with Analytics
Deep understanding of Power BI visualization, Power BI Desktop visualization, Awareness of Power Map, and Power View, customizing and formatting visuals, SandDance visualization, visualization interaction, Bottom-up, and top-down analytics, deploying Power View on Excel, and Sharepoint, Working with Power View for generating reports, Scorecards, Charts, and other visual best formats, filtering, categorizing, and data sorting with Power View, comparing volume and value-based analytics, mastering the best practices, Hierarchies, Custom visualization, embedding dashboards in applications, Power BI web application Authentication.
Power Q&A
Power Q&A introduction, answering tough questions with the help of natural language, receiving answers in the form of graphs, charts, and data discovery methodologies, Power Q&A best practices, ad hoc analytics building, integration methodologies with SaaS applications.
Modeling
Introduction to data modeling, managing data relationships, effective optimizations for better visualization, developing calculated tables, work with time-based functionalities, explore time-based data.
Power BI Desktop & Administration
Introduction to Power BI Desktop, combining data from multiple resources, Learning about data relationships and data modeling, Power query working process in Power BI Desktop environment, scheduling data refresh, deploying data gateways, maintaining groups and row-level security, reports and dashboards, Power Pivot on Power BI Desktop exosystem, Power View on Power Bi Desktop, Mastering visualization concepts, Solving real-time issues using Power BI, working with calculated measures, security, datasets, reports, and dashboards.
Power BI Report Services
Introduction to Power BI reports Report Server basics, paginated reports, web portal, data gateways, row-level security, resources.
Advanced Analytics in Power BI with Python & R
Integration of R in Power BI Desktop, R powered custom visuals, R visuals in Power BI, Creating visuals using R, creating R visuals in Power BI, Creating visuals using Python, R Scripts security, R scripts security.
Publishing and Sharing
Introduction to reports publishing, publish reports to Power BI Service. Exploring Power BI dashboard, Refresh and manually publishing data, Power BI mobile, creating power BI content pack, creating group, Integration of OneDrive with Power BI Publishing and sharing, exporting data to Power BI dashboard.