Deep-Dive Into Microsoft Power BI (advanced)
- Dynamics GP Business Users
- Finance Managers
- Business Analysts
- Controllers
- IT Professionals
Course Description
- Power BI Advanced
- Using Power Pivot to model data
- Data sources and data discovery
- Power Query fundamentals
- Working with query editor window
- Combining queries
- Import data using SQL tables
- Import data using SQL views
- Import data from other sources
- Data modeling
- Creating calculated columns
- Integrating lookup tables
- Creating measures
- Dashboard Designing & Publishing
- Download 3rd party/custom visulations
- Dashboards
- Designing animated dashboards
- Natural language queries and the Q&A search box
- Deploying dashboards using content packs
- Managing Power BI Gateways & On-Premise Data
- Deciding when to use DirectQuery mode
- Understanding Power BI gateways
- Installing and configuring a personal gateway
- Installing and configuring an enterprise gateway
- Configuring a dataset with an auto refresh schedule