POWER BI

Complete Practical Real-time Training Sessions

A Unit of SequelGate Innovative Technologies Pvt. Ltd.

What is Power BI?

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.

In our training course, we provide complete information on Power BI Architecture, Working, DAX, MDX and End User Report Access using Power BI including Mobile Reports, Google Analytics, YouTube and Microsoft One Drive Integration.

All Training Sessions are Completely Practical Real-time .
Every session includes Study Material and Practice Material. Session Handouts.


POWER BI LIVE Training - Course Curriculum

Module I: Power BI Basics, Visuals

Chapter 1: Introduction to Power BI

ü  Need for Big Data and BI Technologies
ü  Purpose of BI & Power BI Suite of Tools
ü  Power BI as a Self-Service BI, Scope
ü  Comparing Power BI with Micrsoft MSBI
ü  Comparing Power BI @ Tableu, QlickView
ü  Power BI as an End-to-End BI Tool
ü  Microsoft Data Platform Technologies
ü  Colloboration, Visualization and IOT
ü  Power BI with Reporting Services (SSRS)
ü  Power BI For Data Scientists, AI Scope
ü  Power BI For Business Analysts
ü  Power BI Job Roles and Responsibilities
ü  Power BI Component :Overview, Lab Plan
ü  MCSA Examination for Power BI: 70-778 /

Chapter 2: Power BI Architecture

ü  Power BI Architecture - in Detail, Tools
ü  Power BI - Integrations in Real-time
ü  Need for Power BI Service and Cloud
ü  Need for Power BI Report Server, SSDT
ü  Power BI Report Server & Report Builder
ü  Power BI Mobile Report Publisher Tool
ü  Types of Reports in Power BI - Ineractive
ü  Analytical, Paginated & Mobile Reports
ü  Office Online Server & SharePoint Server
ü  Content Packs, Cortana - Q&A Features
ü  API Integration: LIVE Streaming DataSets
ü  Configure Power BI Cloud, Basic Usage
ü  Installing Power BI Desktop, Gateways
ü  Installing Excel Publisher & Analyser

Chapter 3: Using Power BI Desktop

ü  Install and Configure Power BI Desktop
ü  Understanding Power BI Desktop Tool
ü  In-Memory, SMDL and Vertipaq Options
ü  Visuals, Fields, Pages and Filters
ü  Report, Data and Relationship Options
ü  Concept & Use of PBIX and PBIT Files
ü  Designing Simple / Basics Reports in PBI
ü  Get Data from DAT Files, Basic Reports
ü  Enter Data from Excel Files, Basic Reports
ü  Creating PBIX Files and Re-Use
ü  Creating PBIT Files & Data Import Options
ü  Database Connections with Power BI
ü  Import and Direct Query - Data Loads
ü  Table Reports, Matrix and Chart Reports
ü  Interactive Visuals and Focus Mode /

Chapter 4: Hierarchies and Filters

ü  Creating Hierarchies with Report Fields
ü  Data / Drill Options - Auto & Manual
ü  Data Explore Options : Spotlight, Focus
ü  Expand, Goto Next Level and Drill-up
ü  See Data, Export Data, See Records
ü  Include and Exclude Options, Multi-Field
ü  Filters and Real-time Usage with Power BI
ü  Using Report Filters and Page Filters
ü  Using Drill-down Filters and Visual Filters
ü  Apply and Clear Options with Value Filters
ü  Adding Text Box, Images, Buttons Shapes
ü  Big Data Access with Power BI

Chapter 5: Power BI Visual Properties - 1

ü  Fields, Formats and Analytics Options
ü  Table Visuals & Properties, Filters
ü  Data Bar and Data Scaling Options
ü  Divergent Property, Data Labels
ü  Matrix : Sub Totals, Grand Totals
ü  Drilldown Options : Row and Column
ü  Stacked Bar Chart, Clustered Colum Chart
ü  Stacked and Clustered Colum Chart
ü  100% Stacked Bar and Column Charts
ü  Area & Stacked Area Chart. Ribbon Chart
ü  Waterfall Chart, Scatter Chart, Pie Chart
ü  Line, Doughnut Tree Map, Funnel, Gauge
ü  DETAILED Properties of Every Visual
ü  General, Lables, Values, Legend Options
ü  Axis, Title, Markers, Filter Options /

Chapter 6: Power BI Visual Properties - 2

ü  Map Reports and Filled Map Reports
ü  ArcGIS Maps and Real-time Usage. Options
ü  Longitudes and Latitudes. Bing Maps
ü  Color Analytical Maps, Styles, Options
ü  KPI Reports - Target, Value and Trend
ü  Plot Area & Responsiveness Properties
ü  Sentiment Colors, Color Saturations
ü  Breakdowns, Title, Axis Properties
ü  Category & Data Labels, Constant Lines
ü  Working with SLICER Visual : Value Filters
ü  Horizontal and Vertical Slicer Filters
ü  Single Select and MultiSelect Options
ü  Frown (Errors), Details. Lock Aspects
ü  Custom Visuals and PBIVIZ File
ü  PBI : Options and Settings, VM Settings

Module II: ETL and Data Modeling

Chapter 7: Power Query & M Language - 1

ü  Power Query [M Language] - Purpose
ü  Power Query Usage & Operation Types
ü  Power Query Architecture and Usage
ü  QUERY Concept, Properties, Validations
ü  Power Query for Data Mashup Operations
ü  Basic Data Types, Literals and Values
ü  Expressions and Primitives in M Lanuage
ü  LIST : Syntax, Examples and Usage
ü  RECORD : Syntax, Examples and Usage
ü  TABLE : Syntax, Examples and Usage
ü  Power Query Connection Formats, Settings
ü  let, source & in statements in M Lang
ü  Power BI Canvas: Edits, Applied Steps
ü  Queries and Applied Steps, Edit Queries /

Chapter 8: Power Query & M Language - 2

ü  Data Sources with Excel, File Formats
ü  Data Sources with Database Connections
ü  BLANK Data Sources Creation & Scope
ü  Creating LIST, RECORD, TABLE Queries
ü  Functions in Power Query and Usage
ü  Defining Functions and Invoke Options
ü  Mashup Operations in Powe Query Editor
ü  Row Filters, Column Filters, Renames
ü  Promoting Headers and Query Settings
ü  MERGE Queries For Combining Queries
ü  Inner Join and Left/Right Outer Joins
ü  Left Anti Join, Right Anti Join, Full Join
ü  UNION All, Group By and Aggregations
ü  Close and Apply Options. Data Imports

Chapter 9: Power Query & M Language - 3

ü  Creating Parameters in Power Query
ü  Intrinsic & Query Parameters, Usage
ü  Paramter Data Types, Default Value Lists
ü  Static Lists, Dynamic Lists For Parameters
ü  Reports with Range Values - Usage
ü  Parameters with PBIT Reports, Prompts
ü  New Queries from Datset Fields, Usage
ü  Removing Duplicate Rows and Columns
ü  Column Delimters and Field Formattting
ü  Change Type and Transform Operations
ü  Replace Values & Errors, Transpose
ü  Group By Aggregations, Fill, Reverse Rows
ü  Format Options in M Language
ü  Pivot and Unpivot Options in Power Query
ü  Data Type Conversions & Format Options /

Chapter 10: Power Query & M Language - 4

ü  Data Modelling Options with Power Query
ü  Modelling Operations - Custom Columns
ü  Query Transforms, Sort Direction, Statistics
ü  Enabling / Disabling Loads. ToList Options
ü  Creating Parmeters & Variables. Functions
ü  Date and Time Columns. String Functions
ü  Advanced Edit Options, Custom Queries
ü  Custom Functions in Power Query M Lang
ü  Grouping and Sub Groups with Quries
ü  Binning with Groups and Query Formats
ü  SubString Functions, Splits (Row, Column)
ü  Parsing XML and JSON Files. Formatting

Chapter 11: DAX Basics

ü  DAX : Importance and Real-time Usage
ü  DAX Data Types and DAX Calculations
ü  Syntax, Functions, Context Options
ü  ROW Context and Filter Context in DAX
ü  DAX Functions. Aggregates and Usage
ü  Creating and Using Measures with DAX
ü  Creating and Using Columns with DAX
ü  Vertipaq Engine & Special Characters
ü  Operators in DAX - Real-time Usage
ü  Quick Measures in DAX - Auto validations
ü  PowerPivot xVelocity & Vertipaq Store
ü  In-Memory Processing : DAX Performance
ü  Date and Time & Text Functions
ü  Time Intelligence Functions in DAX
ü  Logical & Mathematical Functions /

Chapter 12: DAX Functions, Expressions

ü  Data Modelling with DAX. Creating Roles
ü  Currency Conversions, Field Formatting
ü  SUM and SUMX Functions: Differences
ü  CALCULATE(), CALCULATEX() Functions
ü  CALCULATETABLE Functions. VAR, VARP
ü  DATESMTD, DATESQTD, DATESYTD
ü  ENDOF(), FirstDay(), LastDay()
ü  SAMEPERIODLASTYEAR, STARTOF()
ü  Other DAX Functions and Examples
ü  DAX Expressions with Quick Measure
ü  DAX Usage for Row Level Security
ü  Creating Roles with Power BI Desktop
ü  DAX Filters and Multi Value Conditions
ü  Manage Roles and Membership Options
ü  VIEW AS ROLE. Information Functions

Chapter 13: Power BI Service (Cloud) - 1

ü  Power BI Cloud Account and Workflow
ü  Power BI Workspace : Options and Use
ü  App Workspace Creation in Real-time
ü  Publish Reports from Power BI Desktop
ü  Reports and Datasets in Power BI Cloud
ü  Pinning Report Pages and Visuals
ü  Dashboard Creation and End User Access
ü  Creating Tiles in Dashboards. Web, Mobile
ü  Creating Mobile Reports with Tiles
ü  Adding Images, Web Content and Videos
ü  Q & A (Cortana) for Visuals. QR Codes
ü  Enabling Interactive Visuals. Embed Codes
ü  Report Shares and Dashboard Shares
ü  App Publish Options andApp Updates /

Chapter 14: Power BI Service (Cloud) - 2

ü  Power BI Report Edits in Cloud, Visuals
ü  Download PBIX Reports from Cloud
ü  SharePoint Integration, PPTX and Excel
ü  Dashboard Properties and Operations
ü  Report properties and Operations
ü  Dataset properties and Operations
ü  Report Insights, Related Items and Metrics
ü  Quick Insights and Shared. URLs
ü  Analyse in Excel Options, Pins
ü  Excel Publishing to Power BI Cloud
ü  Excel Pivot Reports with Power BI
ü  File Import, Upload and Worksheets
ü  Excel Publisher and Pins - Dashboards
ü  Excel Analyser and Pivot Reports

Chapter 15: Power BI Service (Cloud) - 3

ü  Content Packs : Creation and Use
ü  Organizational and Service Level
ü  Content Packs from Azure MarketPlace
ü  Worksheets and Dasboards with Excel
ü  Gateways - Installation, Configuration
ü  Personal and Enterprise Gateways
ü  NT SERVICE\PBIEgwSERVICE Account
ü  Dataset Refresh Options and Schedules
ü  Managing Gateways - Gateway Clusters
ü  Azure Databus Integration, ODG Logs
ü  Dataset Security and Management Options
ü  Power BI Reports with Azure Data Sources
ü  Power BI Reports with Microsoft OneDrive
ü  Power BI Reports with Google Analytics
ü  SaaS Components, OneDrive with PowerBI /

Chapter 16: REST APIs & Power BI Admin

ü  REST APIs with Power BI Cloud
ü  Steaming Datasets Creation in Power BI
ü  API: Usage. Sub Keys and Channels
ü  Push and Pubnub Datasets in Power BI
ü  Azure Stream for Real-time Data Reports
ü  Using Streaming Sets in Tiles
ü  Real-time Data Tracking Visuals (Interactive)
ü  Power BI Report Server & Integration
ü  Tenant IDs, Subscriptions. Paginated Reports
ü  Power BI Mobile Publisher
ü  Power BI Vs Tableau, SSRS, SharePoint
ü  Licensing & Pricing Plans

Module III: Power BI Service (Cloud)

Project 1:
For Everyone Real-time Project Implementation @ Climate Control Environment
Project 2:
For SQL Server T-SQL Registrations : Real-time Project Implementation @ ERP Database / Course Includes: Project Solution Explanations, Handouts
Course includes: Resume Preparation, Mock Interviews
Course Includes: FAQs: Chapter wise, Study Material, POCs

Reach us for Free demo today.

Course Curriculum @ http://sqlschool.com/PowerBI-Training.html

Website: www.sqlschool.com

Email:

Call Us: +91-9666440801, +91-(0)40 64577244 (India) 24x7

Call Us: +1-510-400-4845 (USA) 24x7

ISO Certified Training Institute Microsoft Certified Partner

______

ALL OUR TRAININGS SESSIONS ARE COMPLETELY PRACTICAL REALTIME

SQL School (SequelGate Innovative Technologies Pvt. Ltd.), #108/2RT, Street No 2, Road No 1, Landmark :Beside SR Nagar Bus Stop, SR Nagar, Hyderabad - 38, India.

CREDITS: ISO Certified Learning Center. Microsoft Certified Learning Partner. www.sqlschool.com