Microsoft Power BI Course – see the power of data



Master the art of data analysis and statistics with Microsoft Power BI—a suite of dynamic and interactive business analytics tools. Power BI empowers you to seamlessly connect with a myriad of data sources, streamline data preparation, and conduct on-the-fly analysis. Create visually stunning reports that can be effortlessly shared across your organization via the web and mobile devices. Power BI allows every user to craft personalized dashboards, offering a unique and comprehensive 360-degree perspective of their business. With governance and security embedded, scale the power of analytics across your enterprise. Harness the capabilities of Power BI for in-depth business statistical analysis, providing swift and well-informed decision-making insights. Enroll in our Power BI course to navigate the landscape of real-world data and gain proficiency in leveraging this essential programming language for robust data analysis.

Course outline

  1. Analyzing Data with Self-Service BI
    • Data Analysis and Visualization for Business Intelligence
    • Self-Service BI with Microsoft Power BI
    • Measurement and Calculation of Central Tendency
    • Measures and Calculating Variation
  1. Importing and Connecting to Data
    • Importing Data Sets from Text Files, Spreadsheets, Websites and Database Tables, SQL Server Analysis Services Multidimensional and Tabular
    • Creating Data Connections
    • Modelling Data with Relationships
    • Save Power BI Files
  1. Performing Advanced Data Modeling and Shaping
    • Removing Duplicate Data
    • Cleaning and Transforming Data with the Query Editor
    • Shaping Data with the Query Editor
    • Validating Data using VLOOKUP and IF
    • Extracting Values using Text Functions
    • Combining and Managing Data Rows
    • Viewing and Creating Relationships
  1. Filtering Data Sets
    • Formatting Data Sets as Tables
    • Using Table Slicers
  1. Pivot Table Data Aggregation and Frequency Analysis
    • Changing Aggregation Methods
    • Displaying Multiple Aggregation Values
    • Using Built-in Calculations
    • Grouping Data, Time and Numeric Data
    • Creating Custom Groups
    • Ungrouping Data
    • Using Report Filters, Pivot Table Slicers, Timelines
  2. Using Pivot Charts
    • Inserting Pivot Charts from Pivot Tables
    • Creating Pivot Charts from Tables
  1. Data Visualization Tools
    • Key Features of Data Visualization Tools
    • Data Visualization Tools Setup Visualization Tool Environment
    • Importing Data Sets from Spreadsheets
  2. Visualizing Data with Power BI
    • Creating Table and Chart Visualizations in Power BI
    • Creating Map, Card and Matrix Visualizations
    • Enhancing Visualizations Using Conditional Formatting
    • Using Visual Level Filters
    • Creating Visualizations Using Maps
    • Chart Data in Power BI
  3. Enhancing Data Analysis
    • Enhancing Analysis with Customized Visuals and Pages
    • Enhancing Analysis with Tooltips
  4. Modelling Data with Calculations
    • Creating Calculations with Data Analysis Expressions (DAX)
    • Creating Calculated Measures and Conditional Columns
  5. Creating Interactive Visualizations
    • Creating and Managing Data Hierarchies
    • Filter and Slice Reports
    • Creating and Configuring Dashboards in Power BI
  6. Publishing and Sharing
    • Preparing Reports to Share and Publish
    • Sharing Dashboards
    • Good Design Practice
    • Evaluating Results