Curriculum in Power Bi
Introduction to Power Bi
Data Extraction
Data Transformation – Shaping & Combining Data
Data Modelling & Dax
Data Visualization With Analytics
Power Bi Service (Cloud), Q & A and Data Insights
Power Bi Settings, Administration & Direct Connectivity
Embedded Power Bi With API & Power Bi Mobile
Power Bi Advance & Power Bi Premium
Curriculum in Power BI
Power BI Is Preferred by Over 35% of Developers. Power BI is the most widely used and in-demand programming language in the IT industry.
- Introduction to Business Intelligence (BI)
- Stages of business intelligence (BI)
- Use cases of BI
- Various BI tools
- Overview of Data warehouse & concepts
- Introduction to Power BI
- Why Power BI
- Power BI Components
- Power BI pricing structure
- Building blocks of Power BI
- Architecture of Power BI
- Power BI vs Tableau vs QlikView
- Introduction of Power BI Desktop
- Installation of Power BI Desktop
- The key features of Power BI workflow
- Process of creating reports in Power BI
- Overview of Power BI desktop
- Data sources in Power BI
- Using files (excel, pdf, csv, etc.) as a data source
- Using SaaS connectors
- Extracting data from folders, and databases
- Working with Azure SQL database and database sources
- Connecting to Analysis Services
- Other data sources (OData, web, SharePoint etc.)
- Python & R script in Power BI
- Introduction of power query editor
- Advance editor
- Query dependency editor
- Shaping data using Power Query Editor
- Formatting data
- Transformation of data
- Understanding of Data types
- Data profiling for data quality check
- Naming conventions & best practices to consider
- Identify and create appropriate keys for joins
- Working with Parameters
- Merge Query
- Append Query
- Group by of data (aggregation of data)
- Applied steps (query settings)
- Duplicate & Reference tables
- Transpose of data
- Fill
- Pivot & Un-pivot of data
- Custom columns
- Conditional columns
- Replace data from the tables
- Split columns values
- Move columns & sorting of data
- Detect data type, count rows & reverse rows
- Promote rows as column headers
- Hierarchies in Power BI
- M query
- Introduction of relationships
- Creating relationships
- Cardinality
- Cross filter direction
- Use of inactive relationships
- Introduction of DAX
- Why DAX is used
- DAX syntax
- DAX functions
- Context in DAX
- Calculated columns using DAX
- Measures using DAX
- Calculated tables using DAX
- Learning about table, information, logical, text, iterator
- Time intelligence functions (YTD, QTD, MTD)
- Cumulative values, calculated tables, and ranking and rank over groups
- Date and time functions
- identify poorly performing measures, relationships, and visuals
- DAX advanced features
- Deep dive into Power BI data visualization
- Understanding Power View and Power Map
- Data visualization techniques
- Page layout & Formatting
- Power BI Desktop visualization
- Formatting and customizing visuals
- Visualization interaction
- Custom visualization in Power BI
- Top-down and bottom-up analytics
- Drill down
- Drill through
- Page navigations
- Bookmarks
- Selection pane to show/hide visuals
- Comparing volume and value-based analytics
- Introduction to Power BI Service
- Introduction of workspaces
- Dashboard
- Creating & Configuring Dashboards
- Dashboard theme
- Reports vs Dashboards
- Building workspace Apps
- Sharing reports & dashboards
- configure subscriptions and data alerts
- Paginated report
- Introduction to Power Q & A
- Ask questions about your data using Natural Query Language
- Getting answers in the form of charts, graphs, and data discovery methodologies
- Configure custom questions for Q&A like FAQ
- Ad-hoc analytics building
- Power Q&A best practices
- Quick Ins
- Subscribe, Alerts, Usage statics, Related content
- Design reports on Power BI Service
- Collaboration using Power BI Service
- Getting to understand Power BI Desktop settings
- Aggregating data from multiple data sources
- Power BI Service settings
- Power BI Admin Portal
- Administration activities
- Power BI usage analysis
- Introduction of Office 365 admin activities
- Introduction of Data Gateway
- Installation & Configuration of data gateways
- Scheduling auto data refresh
- Managing groups, row-level security, datasets, reports, and dashboards
- Real time data analysis using Direct Connectivity
- Direct Query vs Import Mode
- Introduction to embedded Power BI
- Create embedded code
- Manage embedded code
- Integration of Power BI in SharePoint
- Introduction of Power BI API
- Power BI Embedded playground
- Introduction to Power BI Mobile
- Creating mobile based reports & dashboards
- Optimizing report for Power BI mobile app
- Features of Power BI mobile app
- Introduction of integrating Power BI & Excel
- Power BI Analyze in Excel
- Introduction of Power BI Premium
- Power BI Premium per user
- Power BI Premium features
- Introduction to Data Flow
- Create Data Flow
- Advantages of Data Flow
- Create reports using Data Flow
- Introduction to Power BI Deployment Pipelines
- Create Deployment Pipelines
- Benefits of Deployment Pipelines
- Introduction of Sensitivity Labels
- Introduction of Power BI Goals feature
- Incremental data load in Power BI
- use AI visuals
- use the Forecast feature
- Power BI best practice rules to improve performance