Data Analytics with Microsoft Power BI
Course Content
Introduction to Self-Service BI Solutions
- Introduction to Business Intelligence
- The importance of Business Intelligence
- Introduction to Data Analysis
- Introduction to Data Visualization
- Overview of self-service BI Considerations for self-service BI
- Introduction for Power BI
- Power BI and Excel
- Tools and Technologies in BI area
- Introduction and Power BI in Excel
- Why Choose Power BI over Excel
- Building Blocks and Product of Power BI
- Power BI Installation
- Starting with Power BI and different view of Power BI
- A Quick look at the Power BI service
Power BI – Getting Started with Power BI Desktop
- Connect to Data Sources in Power BI Desktop
- Importing Excel files into Power BI
Power BI – Query Editor
- Introduction to Power Query
- Query Editor
- Clean and Transform your data with the Query Editor
- More Advanced Data Source and Transformation
- Add, Delete Column/Rows
- Basic Transformation
- Modify Data types for fields
- Appending and Merging Queries
- Combine files
- Adding Custom Column
- Cleaning Irregularly Formatted Data
- A Quick walk through of creating visualization
- Create 1st Report: Category Analysis of Product
Power BI: Modelling
- Introduction to Normalization and Denormalization
- Introduction to data Modelling
- Lookup Tables
- Primary and Foreign Key
- Create Relationship
- How to Manage Data Relationships
- Cardinality and Cross Filtering
- Hide filed in Report view
- Optimizing Data Models for Better Visuals
- Default Summarization & Sort by
- Create Hierarchy in Power BI
- Categorized Fields
- Explore Time-Based data
- Drill in and Drill out of visualizations
- Report 2: Analyse Profit on basis of Returns for Products
Introduction to DAX
- Introduction to DAX
- DAX Calculation types
- DAX Functions
- Create Measures, Calculated Columns
- Difference between Calculated Column and Measures
- Implicit and Explicit measures
- Create Calculated Tables
- Filters
- Visual filters
- Page level filters
- Drill through filters
- Report level filters
- Grouping and creating Bin
- Forecast /Constant Lines
- Field and Conditional formatting
- Interaction between Visualizations
- Page display setting in Power BI
- Report 3: Calendar Report for Profit Analysis
- Hands on Practice for Visualization using simple DAX Functions
Advance DAX
- Logical functions
- IF ()
- AND ()
- OR ()
- Mathematical and Statistical functions
- SUM ()
- AVERAGE ()
- COUNTROWS ()
- SUMX ()
- COUNT ()
- COUNTA ()
- DISTINCTCOUNT ()
- Text functions
- CONCATENATE ()
- UPPER/LOWER/PROPER ()
- LEFT/MID/RIGHT ()
- Filter Function
- CALCULATE ()
- FILTER ()
- ALL ()
- DISTINCT ()
- RELATED ()
- Date and time functions
- DATEDIFF ()
- WEEKDAY ()
- YEAR () /MONTH () /DAY ()
- DATESYTD ()
- DATESQTD ()
- DATESMTD ()
- DATESINPERIOD ()
- Other Function
- GROUPBY ()
- Use of Parameters
- Create Measure Table
- Calendar Table with Power Query
- Concatenate with Power Query
- Publish report to Power BI Services
- Dashboard 1: Sales and Profit Analysis
Visualizations
- Create and Customize Simple Visualizations
- Best practice for good visualization and Dashboard.
- How to use combination charts
- Create and format slicers
- How to use Map Visualizations
- How to use Tables and Matrices
- How to use Scatter Charts
- How to use Waterfall and Funnel Charts
- How to use Gauges and Single Number Cards
- How to modify colours in charts and visuals
- Style your Reports with Shapes, Text Boxes and Images
- Page Layout and Formatting
- Button to next level
- Slicer Panel
- Duplicate a page report
- Show categories with No Data
- Custom Report Themes
- Selection Pane
- Bookmarks and a Navigation Panel
- Grouping Visuals in Power BI
- Manage Roles
- Use of Performance Analyzer
- Refresh Power BI desktop workbook for updated excel file
- Points to create a better dashboard
Exploring Data
- Different Customize Visuals with Summarization
- Create Customize Visuals in Power BI Desktop
- Chiclet Slicer
- Bullet chart
- Infographic Chart
- Dashboard 2: Executive Dashboard
Power BI Service
- The Power BI service
- Publishing and Sharing
- Publish Reports from Power BI Desktop to the Power BI Service
- Ask question of your data in Natural Language
- Print and Export Power BI Dashboard
- Display Visuals and Tiles Full Screen
- Edit Tile Details
- Load Data in Power BI Service
- Create Reports/Dashboard on Power BI Service
- Row Level Security
- Create Workspaces in Power BI Service
- Create a group in Power BI
- Create a content pack in Power BI
- Difference between Power BI Apps and Workspaces
- Introducing Power BI Mobile
- Connect One Drive for business to Power BI
- Understanding Data Refresh
- Install and Configure a personal gateway
● Manually and schedule refresh through Gateway
Power BI and Excel
- Introduction to Power BI and Excel
- Introduction to Power Query, Power Pivot and DAX
- Import Excel workbook file into Power BI
Power BI Desktop with different data sources
- Connect Power BI Desktop with SQL Server
- Connect Power BI Desktop with CSV file
- Connect Power BI Desktop with JSON data source
- Create a new data set by connecting different data sources
- Overview of Power BI Embedded and create web link using dashboard in different applications
- Overview of Power BI Report Server
- Integrate OneDrive for business with Power BI Publishing and Sharing
- Hands on Practice for creating Dashboards
