Power Bi Dev & Admin

Power Bi Dev & Admin

Course Learning Path

  • What is Power BI 
  • Why Power BI? 
  • Key Benefits of Power BI 
  • Flow of Power BI 
  • Components of Power BI 
  • Architecture of Power BI 
  • Building Blocks of Power BI 
  • Power BI Desktop Installation
  • Overview of Power BI Desktop 
  • Data Sources in Power BI Desktop 
  • Connecting to a data Sources 
  • Connecting to SQL Database
  • Connecting to Azure
  • Connecting to MS Access Database
  • Query Editor in Power BI 
  • Clean and Transform your data with Query Editor 
  • Combining Data – Merging and Appending 
  • Cleaning irregularly formatted data 
  • Views in Power BI Desktop 
  • Modelling Data 
  • Manage Data Relationship 
  • Cross Filter Direction 
  • Create calculated tables and measures 
  • Optimizing Data Models 

 

  • Introduction to visuals in Power BI 
  • Charts in Power BI 
  • Matrixes and tables 
  • Slicers 
  • Map Visualizations 
  • Gauges and Single Number Cards 
  • Modifying colors in charts and visuals 
  • Shapes, text boxes, and images 
  • What Are Custom Visuals? 
  • Page layout and formatting 
  • KPI Visuals 
  • Essential concepts in DAX 
  • Why is DAX important? 
  • DAX Syntax 
  • Data Types in DAX 
  • Calculation Types 
  • DAX Functions 
  • Measures in DAX 
  • DAX Operators 
  • DAX tables and filtering 
  • DAX queries 
  • DAX Parameter Naming
  • Power BI Service (Cloud) Registration
  • Power BI Service (Cloud) Architecture
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Dashboard vs. Reports 
  • Quick Insights in Power BI 
  • Creating Dashboards 
  • Configuring a Dashboard 
  • Power BI Q&A 
  • Introduction to using Excel data in Power BI 
  • Exploring live connections to data with Power BI 
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL 
  • Introduction to Power BI Development API 
  • Import Power View and Power Pivot to Power BI 
  • Power BI Publisher for Excel 
  • Content packs 
  • Introducing Power BI Mobile 
  • Report Server Basics 
  • Web Portal 
  • Paginated Reports 
  • Row level Security 
  • Data Gateways 
  • Scheduled Refresh 
  • Resources (Rest API/ SOAP API’s/ URL Access) 
  • R Integration in Power BI Desktop 
  • R visuals in Power BI 
  • R Powered Custom Visuals 
  • Creating R visuals in Power BI 
  • R Visuals in Power BI Service 
  • R Scripts Security 
  • Creating visual using Python 

Similar Courses

Reach Us

Call or use the form to request a free initial consultation.

Office 1.05, 1st Floor, Building 2,Croxely Business Park, Watford, WD18 8YA

enquiries@bsbitraining.co.uk

    Leave A Message

    15 + 8 =