Microsoft Power BI Course – see the power of data

power-BI

Introduction

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