enosislearning
Creating Software Professionals
Apply for job Upload resume Request demo Quiz
7750712052
Log in

Microsoft Power BI Training Modules

EL ENOSIS LEARNING

POWER BI

From Foundations to Master Level - Analyze. Build. Code. Deploy.

11 Chapters
DAX MASTERY
REAL PROJECTS
JOB READY

Course Curriculum - 11 Chapters

7757012051 | 7757012052 courses@enosislearning.com
01 CHAPTER 1: Introduction to Power BI
  • Introduction to Power BI
  • Power BI Architecture
  • Components of Power BI
  • Downloading and installing Power BI
  • Power BI Desktop &Power BI Services
  • Building blocks of Power BI
  • Power BI IDE(Editor
  • Power BI Data Sources
  • Connecting to different file systems like flat file, excel etc.
  • Loading Data
  • Relationship between Data/Tables in Power BI
  • Editing Relationship in Power BI
  • Defining relationships between tables
02 CHAPTER 2: Visualization in Power BI
  • Working with different visualization
  • Data Visualizations with Power BI
  • Binding Charts with Data
  • Bar Charts
  • Slicers, Card
  • Charting Features
  • Data fields, Formatting & Analytics
  • Data Field Properties: Axis, Legend, Value, Tooltip
  • Formatting: Legend, Axis, Data Labels, Plot Area
  • Data Labels : Visibility, Color and Display Units
  • Analytics: Constant Line, Min Line, Max Line
03 CHAPTER 3 : Types of Visualizations
  • STACKED BAR CHART, STACKED COLUMN CHART
  • CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
  • 100% STACKED BAR CHART, 100% STACKED COLUMN CHART
  • LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
  • LINE AND STACKED ROW CHARTS
  • LINE AND STACKED COLUMN CHARTS
  • WATERFALL CHART, SCATTER CHART, PIE CHART
  • Working with table and matrix visuals
  • Gauge and KPI
  • Maps
  • Power BI Question & Answers
04 CHAPTER 4: Power BI Advanced Features
  • Filters
  • Types of Filters
  • Visualization filters
  • Page Filters
  • Report Filters
  • BookMarks
  • Creating Navigation in Power BI
  • Interactions in Power BI
  • Edition Interactions in Power BI
  • Selection Pane in Power BI
  • Hiding / UnHiding Using Selection Pane
  • Power BI Q & A
05 CHAPTER 5: Power BI Data Transformation
  • Data Transformation in Power BI
  • Editing Data Sources
  • Editing Datasets
  • Applying Changes to Datasets
  • Cleaning Datasets in Power
  • Reverting changes to Datasets
  • Remove Rows
  • Remove error records , blank rows
  • Remove error records , blank rows
  • Split columns and Merge Columns
  • Choosing required columns in the data
  • Choosing required columns in the data
  • Changing Columns DataType
  • Working with different transformations
  • Applied steps in query editor
  • Arithmatics Functions
  • DateTime Functions
  • Rounding
  • Creating Calculated Columns
  • Creating index and custom columns
  • Creating Conditional Columns
  • Group By functionality in Query Editor
  • Merge Queries and Append Queries
  • Merging Data from different data sources
  • Append Data from different data sources
  • Power BI Question and answer
06 CHAPTER 6: Power BI Data Sources
  • Connecting Different File Data Sources (PDF,JSON etc)
  • Connecting to different database like sql server, mysql etc.
  • Power BI Web Sources
  • Connecting to Web Sites, Web API
  • Fetching data from different files
  • Connecting to SQL SERVER Data Sources
  • Working with import and direct query
  • Connecting with Views, Stored Procedures etc
  • Difference between Import and DirectQuery
  • Connected to Different web sources
  • Connecting to JSON , XML etc
  • Connecting to OData
  • Creating custom table
  • Import Folder
  • Importing Multiple Files
  • Combine Files
  • Power BI Question and answer
07 CHAPTER 7 : DAX in Power BI
  • Working with DAX Functions
  • Understanding Calculated Column
  • Creating Calculated Columns
  • Understanding Measures
  • Creating Measures
  • Difference between Columns & Measures
  • Difference between Columns & Measures
  • Difference between Columns & Measures
  • Parameters with DAX
  • Variables
  • Date functions
  • String functions
  • Arithmetic Functions
  • Logical Functions
  • Relationship functions
  • Math/Statistics function
  • Information functions
  • Power BI Question and answer
08 CHAPTER 8 : Advanced DAX Functions
  • Table Functions(ALL, ALLEXCEPT, FILTER)
  • UNION, EXCEPT, INTERSECT
  • CALENDAR, DATESBETWEEN
  • DAX Calculations and Measures
  • ISTEXT, FORMAT
  • Time Intelligence Functions with DAX
  • YTD, QTD, MTD Calculations with DAX
  • Data Analysis Expressions and Functions
  • ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN
  • SAMEPERIODLAST YEAR, PARALLEL PERIOD
  • DATESYTD, DATEADD
  • FILTER FUNCTIONS
  • Using RANKX
  • Power BI Question and answer
09 CHAPTER 9 : Advanced Data Analytics & Forecasting in Power BI
  • Clustering Analysis
  • Forecasting
  • Pareto Analysis
  • Power BI Question and answer
10 CHAPTER 10 : Power BI Deployment
  • Introduction to Power BI Web/ Cloud/Services
  • Different between Power BI DeskTop/ Web / Mobile
  • Understanding PowerBI Cloud Architecture/ Services
  • Power BI Server Configuration
  • PowerBI Services and Workspace
  • Creating Account in Power BI Services
  • Power BI Users
  • Types of Users -> Free, Pro, Premium
  • Deployment Power BI Desktop Reports
  • Managing report in Power BI Services
  • Editing Reports in Power BI Servers
  • Editing Reports in Power BI Servers
  • Downloading PBIX files from Server
  • Exporting Power
  • Share dashboards to Client /Users
  • Power BI Question and answer
11 CHAPTER 11 : Gateway,Data Refresh, Security
  • Gateways
  • PowerBI Gateway -Download and Installation
  • Data Refresh with Power BI Architecture
  • PowerBI Settings : Dataset -Gateway Integration
  • PowerBI Settings : Dataset -Gateway Integration
  • Configuring Dataset for Manual Refresh of Data
  • Configuring Automatic Refresh and Schedules
  • Security Features in Power BI
  • Power BI Mobile Apps
  • Power BI Question and answer

PROJECT IMPLEMENTATION IN POWER BI

Work on end-to-end real-world projects covering industry standards, hands-on architecture, code implementation & deployment.

100% Practical

Enquiry Form

Interview Questions