Introduction
- Get Power BI Desktop
- Getting started with Power BI Desktop Connect to data
- Data Sources
Connect to data
- Import Excel Workbooks
- Analysis Services Multidimensional data
- Analysis Services Tabular data
- Use Direct Query
- Third party service: Facebook Connector,
- Google Analytics Connector
- Project Online: Connect to Data
Transform and Shape Data
- Data Types
- Query Overview
- Shape and Combine Data
- Common Query Tasks
Data Modelling
- Data View
- Relationship View
- Create and manage relationships
- DAX Functions
- Import and display KPIs (Preview)
- Data Categorization
- Calculated Columns
- Calculated Tables
- Measures
Create Reports
- Report View
- Sort by Column
- Create Power BI Visuals
- Add a Custom Visual to a Report
- Create Power BI Answer Cards for Cortana
- Tips and Tricks for Creating Reports
Advanced Analyzing
- Importing & Analyzing data from Web Page
- Analyzing sales data from Excel
- Create Customized Measures
- Create Calculated Columns
- Facebook Analytics
Publishing and Sharing
- Introduction
- Sharing Options Overview
- Publish from Power BI Desktop
- Publish to Web
- Share Dashboard with Power BI Service
- My Workspace vs Groups
- Content Packs
- Print or Save as PDF
- Row Level Security
- Export Data from a Visualization
- Publishing for Mobile Apps
- Export to PowerPoint
- Sharing Options Summar
Introduction to R
- Overview of R
- R Data Types, Objectives & Classes
- Reading and Writing Data
- Sub setting Objects
- Control Structures
- Dates in R
- Functions
- Conditions and Loops
- Graphics and Visualizations( GGPLOT2, PLOTLY)
- Data Manipulation (dplyr, reshape2 packages)
- Regression
- Linear Regression
- Logistic Regression