DataSkills Address:
Flat#307, 3rd Floor, Topaz Building,
Hyderabad – 500082
www.dataskills.in
trainings@dataskills.in
+91-8008-828-777/8297-444-777
Power BI Course Content
Power BI Training Outline
1. Introduction to Power BI
2. Power Query (Extract, Transform &Load)
3. Reports & Dashboard
4. Modeling
5. RLS (Row Level Security)
6. Working with DAX Functions
7. Power BI Service
1. Introduction of Power BI
➢ What is BI
➢ Why data Visualization is important
Bring life to your data
➢ What all the Data Visualization tools
➢ Where Power BI stands in Gartner Report
➢ Power BI Products
➢ Power BI Pricing
➢ Downloading Power BI Desktop
➢ Power BI Extensions
2. Power Query_1
➢ Introduction to Power Query
Bring life to your data
➢ The Power Query Editor
➢ Working with Numbers in Power Query
➢ Working with text in Power Query
➢ Working with Date & Time in Power Query
➢ Adding Conditional Columns in Power Query
➢ Pivot & UnPivot data in Power Query
➢ Get data from website
➢ Get data from text, csv files
➢ Get data from Access
➢ Get data from SQL
➢ Drivers - https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites
2. Power Query_2
➢ Grouping & Aggregating Data in Power Query
➢ Split column in Power Query vs Text to Columns in
Excel
➢ Remove Duplicate Records Bring life to your data
➢ Transform data using Upper, Lower, Proper, Trim…
➢ Unique List & Unique List from a Range
➢ Appending Queries
➢ Merging Queries
➢ Consolidate all Excel files from a folder
➢ Refreshing Power Query settings
➢ “Close & Apply” vs “Apply” vs “Close”
3. Reports & Dashboard
➢ Field Pane, Visualization pane, Ribbon, Views, Pages
➢ Report Canvas, Report view, Data and Model View
➢ Create a New Pages
➢ Get Data from many sources, Excel, Sql, Access, CSV
➢ Create Visualizations and Reports, Ask a Question Bring life to your data
➢ Fields Pane, Format pane and Quick or performance
analyzer.
➢ Filters pane: Visual, page, report and Drill through
➢ Slicers (all option) , timeline slicer and Sync Slicers
➢ Insert Images, Text box and Buttons with Format
➢ Edit interactions
➢ Hiding Fields from Report View
➢ Bookmarks pane on visual and page, Selection pane,
Lock objects
4. Modeling
➢ Introduction to Modeling
➢ Fact Tables (Measures) vs Lookup (Dimension)
➢ Relationships vs Merged Tables Bring life to your data
➢ Creating Relationship between Tables
➢ Manage Relationships
➢ Active vs Inactive Relationships
➢ Direct Vs In-Direct Relationships
➢ Modeling best practices & tips
5. Row Level Security
➢ Manage roles
➢ View as
Bring life to your data
6. DAX Functions
➢ Introduction to DAX
➢ Understanding DAX Syntax (Power BI)
➢ DAX Operators
➢ DAX parameter-naming Bring life to your data
➢ Calculated Columns Vs Measures
➢ Add Calculated Column & Measures
➢ Implicit vs Explicit Measures
➢ Row Vs Query Vs Filter Context
➢ DAX Functions
➢ Time-intelligence
➢ Date and Time Functions
➢ More
7. Power BI Service
➢ Power BI Service Introduction, Power BI Cloud
Architecture
➢ Creating Power BI Service Account, SIGN IN to Power
BI Service Account Bring life to your data
➢ My Workspace / App Workspaces Tabs
➢ DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
➢ Working with Workbooks, working with Reports,
Sharing Reports
➢ Working with Workbooks, working with Reports,
Sharing Reports
➢ Analyse In Excel, Quick Insights
➢ Project on Power BI
Why DataSkills?
Learn from Experts Simplified way of Teaching Get Certificate from DataSkills
Post Training Support* Customizable Training Post Training Evaluation
