Power bi Online Training Course Details

Course Duration

45 Days

Mon-Fri

8 pm to 9 pm (IST)

Mode of Training

Online

Power Bi Course Content

Power BI can connect with a wide variety of data sources. For any data analysis project, data consumption process starts with an understanding of business requirements and data sources available to us. Data connectivity mode is defined after analyzing all these above

  • Installation
  • Overview of Power BI Desktop
  • Data Sources in Power BI Desktop (Excel,Web, Sql, Json)
  • Connecting to a data Sources
  • 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
  • Import Power View and Power Pivot to Power BI

 

Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis.

 

  • Query Editor in Power BI
  • Query Ribbon
  • Clean and Transform your data with Query Editor
  • Group By, Pivot & Unpivot
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
  • Views in Power BI Desktop
  • Modelling Data
  • Manage Data Relationship
  • Automatic Relationship Updates
  • Cross Filter Direction

It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports. Lastly, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report

  • Introduction to visuals in Power BI
  • Charts in Power BI 
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards 
  • Create scatter, waterfall, and funnel charts
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • Page layout and formatting  
  • KPI Visuals
  • Drill Down
  • Drill Through
  • Bookmarks & Selections
  • Edit Interactions

 

In this chapter, you’ll learn how to create customized calculations using Microsoft’s formula language, DAX (Data Analysis Expressions). Very similar to how formulas are written in Excel, you’ll learn how to create calculated columns and tables—and when you should use them. You’ll then progress to writing powerful calculated measures, leveraging Power BI’s Quick Measures, to create complex DAX calculations like year over year change.

  • Essential concepts in DAX
  • Why is DAX important?
  • DAX Syntax
  • Data Types in DAX
  • Ranking and rank over groups
  • Filter and evaluation context
  • Context interactions
  • Create calculated tables and measures
  • DAX Functions 
  • Measures in DAX
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • Create simple and compound measures
  • Schema relations
  • Star schema design
  • DAX Parameter Naming

 

The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is the SaaS (Software as a Service) part of Power BI. In the Power BI service, dashboards help you keep a finger on the pulse of your business. Dashboards display tiles, which you can select to open reports for exploring further. Dashboards and reports connect to datasets that bring all the relevant data together in one place.

  • Introduction to Power BI Service
  • Introduction to using workspaces
  • Dashboard vs. Reports
  • Creating Dashboards
  • Configuring a Dashboard
  • Content packs
  • Data caching and refresh
  • Power BI Q&A
  • Ask questions of your data with natural language
  • Power BI embedded
  • Create custom Q&A suggestions
  • Edit tile details and add widgets
  • Build apps
  • Integrate OneDrive for Business with Power BI

 

Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs. Along with it come the tools to create Power BI reports, paginated reports, mobile reports, and KPIs

  • Report Server Basics
  • Web Portal
  • Paginated Reports
  • Row level Security
  • Data Gateways
  • Scheduled Refresh
  • Configure scheduled refresh
  • Create a publish-to-web embed code

 

  • Comprehensive project covers all essentials of the course.

Note: You do not need any prior knowledge to benefit from this Microsoft Power BI online training.

PowerBI Demo Videos By Narendhra

Register Now for PowerBI Live Demo