
Introduction
Microsoft Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organization
- You can use Power BI to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
- It produces beautiful reports, then publishes them for your organization to consume on the web and across mobile devices.
- Everyone can create personalised dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in
- Power BI is used to Analyse Business statistics that help to deliver insights to enable fast, informed decisions.
Course outline
- 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
- 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
- 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
- Filtering Data Sets
- Formatting Data Sets as Tables
- Using Table Slicers
- 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
- Using Pivot Charts
- Inserting Pivot Charts from Pivot Tables
- Creating Pivot Charts from Tables
- Data Visualization Tools
- Key Features of Data Visualization Tools
- Data Visualization Tools Setup Visualization Tool Environment
- Importing Data Sets from Spreadsheets
- 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
- Enhancing Data Analysis
- Enhancing Analysis with Customized Visuals and Pages
- Enhancing Analysis with Tooltips
- Modelling Data with Calculations
- Creating Calculations with Data Analysis Expressions (DAX)
- Creating Calculated Measures and Conditional Columns
- Creating Interactive Visualizations
- Creating and Managing Data Hierarchies
- Filter and Slice Reports
- Creating and Configuring Dashboards in Power BI
- Publishing and Sharing
- Preparing Reports to Share and Publish
- Sharing Dashboards
- Good Design Practice
- Evaluating Results