Here is the Power BI Syllabus we cover at Aimore Technologies. Join PowerBI Training in Chennai Now with 100% placement.
Introduction – Power BI Syllabus Desktop
Overview of Power BI
Installation
Settings
Data Transformations – Power BI Syllabus Desktop
Types of Data Connectors
The Query Editor
Loading Data
Sorting a column or data
Date Filter
Text Filter
Date Transformation Columns
Remove Top Rows & Promote Headers
Keep Errors and Remove Errors
Replace Values and Errors
Add Index Number
Text to Column
Remove Excess Space
Time Transformation
Fill Down and Fill Up
Change Text to Upper, the Lower, and Proper Case
Creating Custom Columns
Using If Statement
Try Otherwise Statement
Rename Steps and Describe the Query
Introduction of M Queries and Variables
Working with Table Functions
Extract Columns from Tables
Extract Rows from Table
Extract a Single Value from Tables
Group by Feature
Adding Conditional Formulas
Table Expansions
Adding Rank to Customise Table
Appending Query
Merge Query – All Joins
Combine All Worksheets in a Workbook
Combine All Workbooks from Folder
Date Source Settings
Query Refresh Settings
Pivot and Unpivot
User Function
Adding Parameter
Data Modelling – Power BI Syllabus Desktop
Introduction
Data Normalization
Fact Tables vs Dimension Tables
Managing Data Relationships
Relationships vs Merged Tables
Snowflake vs Star Schemas
Active vs Inactive Relationships
Understanding Filter Flow
Two-way Filters
Hiding Fields and Tables
Creating Calculated Columns
Creating Calculated Measures
Implicit vs Explicit Measures
Filter Context
DAX Syntax & Operators
Basic Date & Time Functions
Logical Functions
Text Functions
Joining Data with Related
Calculate & All Functions
Calculate & Filter Functions
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence
Manually Typing in a Data Table
Include Exclude
Visualizing Data with Reports – Power BI Syllabus Desktop
Introduction to Report View
Adding Simple Objects
Inserting Basic Charts & Visuals
Hierarchical Axis and Concatenating
Analytics Pane
Formatting Options
Focus Mode and See Data
Map & Filled Map
ESRI Map
Waterfall Chart
Report Filtering Options
Table and Matrix Visuals
Date Slicers
Cards & KPIs
Text Cards
Treemaps
Line & Area Charts
Trend Lines & Forecasts
Gauge Charts
Editing Reporting Interactions
Adding Drillthrough Filters
Adding Report Bookmarks
What if Parameters
Managing & Viewing Roles
Power BI Service – Power BI Syllabus
Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Configuring a Dashboard
Adding Textbox, Image Widgets
Featured and Favorite Dashboard
Filtering Dashboard
Dashboard Settings
Natural Language Queries
Featured Questions
Sharing a Dashboard
In-Focus Mode
Pinning a Live Page
Custom URL and Title
TV Mode and Collapse Navigation
Printing Dashboard and Exporting Data
Export to CSV and Excel
Power BI Notifications
Alerts in the Power BI Service
Personal Gateway
Publishing to Web
Admin Portal
Introduction to Power BI Mobile
Scheduled Refresh
Row-level Security
Working with Excel
Importing Excel Data using Simple Table
Excel Workbook with Excel Data Model
Connecting to Excel Workbook on OneDrive for Business
Pinning Excel Tables or Visuals
Analyzing Data in Excel
Direct Connectivity
Direct Connectivity to SQL Azure
Direct Connectivity to SQL Database
Interactive API Console
Connecting a web page
Connecting with pdf
No Comments
Aimore Technologies
Aimore Technologies is the best software training institute in Chennai. We prepare you for the digital future with tailored IT programs in key areas like Web Development, Software Testing, Python, AWS, and Data Science. Guided by skilled trainers, you'll learn not just to understand technology, but to apply it practically.
Aimore Technologies is the best software training institute in Chennai. We prepare you for the digital future with tailored IT programs in key areas like Web Development, Software Testing, Python, AWS, and Data Science. Guided by skilled trainers, you'll learn not just to understand technology, but to apply it practically.
Medavakkam Branch
3/165, Sumangali Second floor, Perumbakkam Main Rd, Medavakkam, Chennai, Tamil Nadu - 600100