POWER BI
Introduction
– Guided Learning for Power BI
– Using Power BI
– Building Blocks of Power BI
– A quick look at the Power BI service
Getting Data
– Getting Started with Power BI Desktop
– Connect to Data Sources in Power BI Desktop
– Clean and Transform your data with the Query Editor
– More Advanced Data Source and Transformation
– Type natural-language questions about your data on a dashboard
– Cleaning Irregularly Formatted Data
Modelling
– Modelling
– How to Manage Your Data Relationships
– Create Calculated Columns
– Optimizing Data Models for Better Visuals
– Create measures and work with time-based functions
– Create Calculated Tables
– Explore Time-Based data
Visualizations
– Create and Customize Simple Visualizations
– How to use combination charts
– Create and format slicers
– How to use Map Visualizations
– How to use Tables and Matrixes
– How to use Scatter Charts
– How to use Waterfall and Funnel Charts
– How to use Gauges and Single Number Cards
– How to modify colors in charts and visuals
– Style your Reports with Shapes, Text Boxes and Images
– Page Layout and Formatting
– Duplicate a page report
– Show categories with No Data
– Customize Visuals with Summarization and Category Options
– Arrange the Z-order of Report Elements
– Visual hierarchies and drill down behaviour
– R visuals in Power BI
Exploring Data
– Exploring data
– The Power BI service
– Create and Configure a Dashboard
– Create Custom Q&A Suggestions
– Share Dashboards with your organization
– Display Visuals and Tiles Full Screen
– Edit Tile Details
– Get More space on your Dashboard
– Install and Configure a personal gateway
Power BI Excel
– Power BI and Excel
– Import and Excel table into Power BI
– Import Excel files with data models and Power View sheets
– Connect One Drive for business to Power BI
Publishing and sharing
– Publishing and Sharing
– Publish Reports from Power BI Desktop to the Power BI Service
– Print and Export Power BI Dashboard
– Manually Republish and Refresh your Data
– Introducing Power BI Mobile
– Create a group in Power BI
– Create a content pack in Power BI
– Connect to a content pack in Power BI
– Connect to a content pack from groups in Power BI
– Edit a content pack in Power BI
– Integrate OneDrive for business with Power BI Publishing and Sharing
– Publish Reports from Power BI Desktop to the Power BI Service
– Print and Export Power BI Dashboard
– Manually Republish and Refresh your Data
– Introducing Power BI Mobile
– Create a group in Power BI
– Create a content pack in Power BI
– Connect to a content pack in Power BI
– Connect to a content pack from group in Power BI
– Edit a content pack in Power BI
Create a Tabular Model Project using DAX
– Import data from Source databases (Analysis Service or Power Pivot)
– Create Relationship between the Tables (Modelling)
– Create calculated Columns and Measures
– KPIs
– Hierarchies
– Perspectives
– Partitions
– Translations
– Roles
– Deploy tabular model solutions
DAX (Data Analysis eXpression language)
– Introduction to DAX
– Using DAX to create new models from existing data
– DAX Calculated Columns and Measures, Relationships and Hierarchies
– DAX Variable: Using variables in text, calculated columns, Measures and Calculated Tables
– DAX Context: Implicit and Explicit Filters, Row Context and Context Transition
– DAX Functions: Aggregation, Filter, Date and Time, Time Intelligence, Information, Counting, Logical, Mathematical, Statistical, Text Functions. Formulas
– Queries in DAX
– Table relationships
– DAX Table valued Functions and Filters