Microsoft Power  BI Projects + Realtime Scenarios+ Assignments

Pre-Requisite coverage:

• Introduction to Business Intelligence
• Understanding Table structure and schema modelling
• Introduction to Basic SQL
• Concepts of Analysis (Trend Analysis,What-if, As is, predictive)
• Data Aggregations ,groupings and drill downs

Course Syllabus

Data Transformations:

• Introduction to Power BI Desktop
• Changing Locale
• Connecting to a Database
• Basic Transformations
• Managing Query Groups
• Splitting Columns, Changing Data Types, Working with Dates
• Removing and Reordering Columns
• Conditional Columns
• Merge Queries
• Query Dependency View
• Transforming Less Structured Data
• Query Parameters

Data Modelling:

• Managing Data Relationships
• Creating Calculated Columns
• Optimizing Models for Reporting
• Creating Calculated Measures
• Creating and Managing Hierarchies
• Using Calculated Tables
• Time Intelligence
• Include and Exclude features
• Grouping and Binning

Visualizing your Data:

• Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI
• Filter (Including TopN), Date Slicer
• Coloring Charts
• Page Layout, Positioning, Aligning, Sorting Visuals and Formatting
• Visual Relationship
• Custom Hierarchies

Working with PBI Service:

• Overview of Dashboards and Service
• Uploading to Power BI Service
• Configuring a Dashboard
• Dashboard Settings
• In-Focus Mode
• Pinning a Live Page
• Custom URL and Title
• Export to CSV and Excel
• Power BI Notifications
• Publishing to Web

Working with Excel:

• Importing Excel Data using Simple Table
• Connecting to Excel Workbook on OneDrive for Business
• Pinning Excel Tables or Visuals

Organization Packs, Security and Groups:

• Creating a Group
• Creating, Using and Editing a Content Pack
• Row Level Security
• Data Classification
• Creating and Using Custom Visuals