• Learn Power BI from scratch
• Build Reports
• Use DAX
• Create Visualizations
• Clean Data with PowerQuery
• Connect to data sources
  

Course content

• What is Power BI
• All Files for Download
• Download & Installation
• Navigate the Interface
• The Interface
• Tip: Efficient Pane Switching
• Important: Initial Settings
• Getting Data
• Our Project Data
• Working with the Query Editor
• The Query Editor
• Important: Using Attached Project Files
• Editing Rows & Columns
• Changing Data Types
• Chaning Data Types Using Locales
• Data Types, Replace & Edit rows
• Replacing Values
• Summary of the Day
• Welcome challenge!
• Final project for today
  

Prep & Data Model Fundamentals (Beginner)

• Goals Day 2
• Exctracting values
• Split columns
• Text operations
• Numerical operations
• Data Model & Relationships
• Practice: Data Cleaning & Relationship
• Solution: Data Cleaning & Relationship
• Solution: Data Cleaning & Relationship
• Stacked column chart
• The Format Pane
• Data Labels
• Pie Chart – Guidelines
• Pie chart
  

Data Preparation,Modeling & Visualization

• Goals Day 3
• Append Queries
• Append Queries
• Merge & Group
• Hide Tables
• Date Hierarchies
• Drill Down & Hierarchies
• Line Charts
• Project: Day 3
• Files from folder
• Fact-Dimension model
• Fact-Dimension model
• Edit relationships
• Activate & Deactivate relationships
• Audo-detect & manage relationships

   Data Transformation (intermediate)

  • Tables
  • Customizing Tables
  • Conditional Formatting (Rules)
  • Practice Project
  • Merge Queries
  • Pivot & Unpivot
  • Many-to-Many relationships & Crossfilter Direction

  Interactive Visualizations (intermediate)

  • Slicer Visual
  • Edit Page
  • Practice Project
  • Filter Pane
  • TopN & Relative Date Filter
  • Sync Slicers
  • Treemap Visual
  • Edit Interactions
  • Drillthrough
  • Tooltips
  • Practice Project

  Advanced Transformation & Visualizations (Advanced)

  • Custom Columns
  • Enable & Disable Load
  • References & Duplicates
  • Columns from Example
  • Project
  • Visual Header & Sorting
  • Conditional Columns
  • Maps
  • Filled Maps
  • Forecasts
  • Find Anomalies

  Advanced Dashboard Enhancements

  • Drillthrough with Button
  • Clear & Apply Slicers
  • Back & Reset Buttons
  • Bookmarks
  • Challenge: Bookmark & TopN
  • Solution: Bookmark & TopN
  • Card Visual
  • Multi-Row-Card
  • Final project for today!
  • Report Page Tooltip
  • Working with Themes

  DAX Essentials

  • Calculated Columns
  • Measures
  • AVERAGE
  • Measure Table
  • COUNT, DISTINCTCOUNT & More
  • SUMX & Iterative Functions
  • AVERAGEX
  • ROUND
  • RELATED

   DAX -Calculate & Filtering

  • CALCULATE
  • FILTER
  • Operators & Comments
  • DAX Challenges
  • Solutions
  • ALL
  • ALL on Columns
  • ALLEXCEPT
  • ALLSELECTED

  Conditions

  PC running Windows. Power BI cannot be installed natively on Linux or Mac.
  In just 15 days, the training is intended to take students from beginner to expert. Over the course of 15 days, we begin with the fundamentals and follow a step-by-step guided approach.

  Description

  Discover how to visualize data using Microsoft Power BI, and give yourself and other important decision-makers the chance to identify patterns in data like customer purchasing patterns, sales trends, or production bottlenecks.

  You will gain knowledge of all the features of Power BI that enable you to quickly, simply, and elegantly explore, experiment with, fix, prepare, and display data.

  Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond Accordingly

  Link Power BI to Multiple Datasets

  Investigate Deeper Into Your Visualization and Compute Data

  Display Data with a Range of Plots, Charts, and Maps

  Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI

  You’ll find challenging exercises in each lesson to help you learn by doing real-world application of what you’re learning.

  As new iterations of Power BI are launched, content gets updated. As you maintain an advantage over the competitors, you may always come back to the course to refine your abilities even more.