hrs practical material chapter wise theory, diagrams … · dax detailed classes 7 hrs power bi...
TRANSCRIPT
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
COMPONENT DURATION SOFTWARE AND MATERIALS (FREE)
DEMO SOFTWARE FOR PRACTICE
PRACTICAL MATERIAL CHAPTER WISE
SOFTCOPY MATERIAL WITH EACH TOPIC
THEORY, DIAGRAMS AND OPTIMIZATIONS
PDFS AND PPTS WITH DIAGRAMETIC PRESENTATIONS.
VIDEOS FOR MAXIMUM / MISSING CLASSES ***
WEBSITE
WWW.VINAYTECHHOUSE.COM
Case Study 1:
Get Data, Extract, Transform, and Modeling
Case Study 2:
Analysis Services Cube Calculations using in Power BI
A) RETAIL PROJECT ANALY TICS AND INSIGHTS
[MORE DAX AND MANY VISUALS]
B) BANKING PROJECT with strategic and tactical
reporting
C) Many Corporate Data Warehouse based Dash Boards
with DAX calculations and Data Models.
POWER BI DESKTOPS
[Cloud & On-premises]
5 HRS
POWER QUERY & MASHUP 6 HRS
POWER VIEW & OPTIONS 10 HRS
DAX DETAILED CLASSES 7 HRS
POWER BI SERVICE 5 HRS
PBI MOBILE REPORT 2 HRS
PBI DEVELOPER & EMBED 2 HRS
PBI REPORT SERVER [DP] 2 HRS
RESUME PREP & FAQS 4 HRS
DWH & MODEL FUNDAS 3 HRS
SSAS [TABULAR] 2 HRS
PROJECTS ( 2 PROJECTS)
AZURE (INTRO, ADF, LAKE)
4 HRS
4 HRS
Additional Details @ Reception:
Complete Real-Time Training
Very Detailed Training
Real-time and Real world examples suitable for ultimate learnin
Duration: 40 Hours Type: Normal / Fast Track / One : One/Custom FEE: 10000(online) 8000(classroom)
POWER-BI PROJECTS
POWER-BI PROJECTS
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
Power BI Demo content
Data, Data Availability types in IT
IT data storage areas [File stream, Database]
Data warehouse, BI definitions and layers
Power BI existence in IT, Product services
Power BI Features, Self Service BI
Power BI Tools and Components
On-Premises vs. Cloud computing [Azure]
Power BI Opportunities and Support
Legacy vs. Modern BI tools
OLAP vs. OLTP vs. Insights and Analytics
Power BI challenging Data Science
Power BI History, releases and blogs
Installation process and challenges
Data warehouse Fundamentals
Data warehouse, Data Mart and differences
Types of data marts and real-time usage
ODS, Stage, EDW, and DW definitions
Data Lake and Blob Storages
DWH Life Cycles
DWH Approaches (INMON and KIMBALL)
Data Granularity, Data movement stages
Creative visualization through software
[Theory and Complete Practical]
Dimension, Dimension Table & types
Fact, Fact Table & measures types
Fact less fact table
Schemas (Star, Snow Flake, Galaxy & Hybrid )
Surrogate key and usages in real time
Business, Conceptual, Logical, Physical Data
Models
1:1, 1: Many, Many: Many relationships
Active, Inactive relationships
Single and Bidirectional relationships
Cross filtering relationship
Role Playing real-time usage
Surrogate key live usages with practical
MANDATORY Topic 1: POWER BI DEMO AND DATAWAREHOUSE FUNDAMENTALS
MANDATORY Topic 2: DATA MODEL FUNDAMENTALS [E-R MODEL AND DIMENSIONAL MODEL]
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
Various windows versions Software components
Release impact on installation
Power BI Cloud Desktop installation
Power BI Report Server Desktop installation
DAX Studio installation
Report Server Installation
Gateway Installation
Working on data modes [very detailed]
o Import
o Direct Query
o Connect Live
Genera reports using SQL, SQL
Procedures and Views.
Generate reports using MDX and DAX
Queries
Control retrieval rows and time.
Differences between Load and Edit
options.
Desktop over view and Building blocks of PBI Desktop
Differences between Power BI and SSRS(MSBI)
Connecting to various sources and retrieving data 1. Flat files
2. CSV files
3. JSON files
4. Databases (Sql Server & Oracle)
5. Excel files
6. Web
7. Analysis Services [Tabular &
Multi-dimensional model]
8. Azure SQL database and DWH
9. Python Script
10. M- Retrieval
TOPIC 1: INSTALLATION [DESKTOPS, GATEWAY, SERVER, & STUDIO]
TOPIC 2: WORKNG WITH POWER BI DESKTOP AND CONNECTING TO MANY DATA SOURCES
TOPIC 3: WORKING WITH EXCEL BI ADD INS
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
a) Power view
b) Power query
c) Power map
d) Power pivot
File Menu [All options-Detailed Practical]
a)New Report Creation and Opening Existing Report
b)Save report with PBIX extension
c)Export Power BI Template (PBIT)
d)Import Power BI Template, Power Query, View, Model, and others
e)Working on Options and Settings for additional
Home Menu [All options- Detailed Practical]
a)External Data:
Get Data, Recent Sources, Enter Data
Edit Queries and Refresh
b)Insert New Page, New Visual, Ask a question
And Buttons [Back, Q &A, Book Mark, URL]
Text Box, ImageShapes[ Oval, Rectangle, Line, etc…]
c)Custom Visuals : From Market Place, From File
d) Themes: Switch themes [using corporate theme]
e) Calculations creation using
New Measure / Column / Quick Measure
f) Publishing to cloud service
View Menu [All options -Detailed Practical]
Report Phone Layout / Desktop View
Show Gridlines, Snap Objects to Grid
Locking Objects on the surface
Bookmarks creation, viewing, & using in Dashboard
Selection Pane [Hiding and showing objects]
Slicer and Sync Slicers explanation with practical
Performance analyzer test run
Modeling Menu [All options-Detailed Practical]
a) Changing Data types, formats, and sort order
b) Create roles and implement row-level security and
dynamic row-level security
c)Working on Linguistic schemas
Help Menu [All options-Detailed Practical]
a)Guided learning, documentation, training videos
b) Blogs, Communities, Power BI for developers
c) Support and Consulting Services
Help Menu [All options-Detailed Practical]
a)Edit interactions for the visual for cross
highlighting, cross filtering, and none options.
b) Bring forward, send backward etc…visual options
Data / Drill Menu [All options-Detailed Practical]
a)Drill down report creation
b) Drill one level down, multiple levels, and data drill
TOPIC 4: WORKNG ON POWER BI MODES [ IMPORT, DIRECT QUERY, AND CONNECT LIVE]
TOPIC 5: WORKING WITH VARIOUS RIBBON OPTIONS AND IMPORTANT REAL-TIME TOPICS COVERED
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
Create Hierarchies and analyzing data
Create Groups (List, Bin)
Hide / Unhide columns usage in real-time
Consider table as Date Table
Expand and collapse columns
Queries properties [All options –Detailed Practica]
a)Real-time practical on duplicates and references
b)Create groups to classify tables
c)Refreshing table data and enabling data to tables
d)Creating reusable functions
Query Properties
a)Perform data transformations by adding, removing
and retaining columns, duplicates, errors.
b) Working on reusable functions
c) Merging multiple queries
d) Joining multiple queries to get matched,
unmatched and both matched and unmatched rows.
Column Properties
Different types of data transformations on
a) Numeric columns
b) String columns (split strings)
c) Date columns
Full real-time examples on the data
transformations
TOPIC 6: POWER BI DATASET PROPERTIES
TOPIC 7: POWER QUERY PROPERTIES [ 5 types of properties and M-Language]
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
Types of views in PBI Desktop
a) Report View
b) Data View
c) Relationship View
Working with different level of filters
a) Visualization level
b) Page level
c) Report level
d) Drill though page level
e) Drill through cross report level
Filter properties
Working on Number, String, and Date
Various filter options
Parameters properties
Working on Any, List, and Query Parameters
Working on multiple parameters
Working on cascading parameters
Mash up (M) language
Syntax, protocols, variables and conventions
Let, In, semicolon, and other functions
Miscellaneous Transformations
Transpose rows, reverse rows, Pivot and Unpivot
View options [monospaced font, column profiling,
Column distribution, and performance monitoring]
TOPIC 8: POWER BI VIEWS , FILTERS, VISUALS AND VISUAL FORMATING OPTIONS
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
Working with various display panes
a) Visualization Pane
b) Fields Pane
c) Query Settings Pane
d) Steps Pane
Working on different single and multi-visuals
a) Table usage and properties
b) Matrix usage and properties
c) Column or bar charts [Stacked and
Clustered and 100% stacked]
d) Line charts and area charts
e) Waterfall charts and funnel charts
f) Pie charts and tree map charts
g) Slicers, Cards [Single and Multi Row]
h) Bubble Chart, Table Sort Order
i) Maps [Area, Filled, Shape, and
ArcGIS]
j) Custom visuals practice
[Market place, Files]
Many reports and Dashboards based on visuals and DAX
PBI Cloud Introduction and Differences with Power
BI Desktop
CREATE NEW WORKSPACE
Create new workspace & template workspace
Add users and provide roles ( four roles)
Add dashboards, reports, and work books
GET DATA
Organizational content packs
Service content packs
Work books
Reports
OneDrive applications
Dataflows
TOPIC 9: POWER BI CLOUD SERVICE
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
APP WORKSPACES
Create app workspace
Add collaborators
Add dashboards, reports, and work books
Publish workspace
Sharing app workspace
Access on app workspace
Install mobile app workspace
Browsing in mobile app
Commenting in app workspace
Modifying and deleting the app workspace
Republish app workspace
REPORTS AND MANAGEMENT
Browsing in Mobile and Desktop view
Get Metrics and View related
Create Book Marks and Selections
Drill through cross reporting
Exporting data [Excel, CSV] , Persistent filters
Visual options
Row-level & Dynamic Row Level Security
POWER BI GATEWAYS [PERSONAL AND DATA]
Download and Install Power BI Gateway
Install & Configure Personal Gateway for PBI
Install & Configure Data Gateway
Gateway connections for On-Demand Refresh
Gateway configuration for Scheduled Refresh
Parameters and Endorsement for Gateway
DASHBOARD AND WORKBOOK MANAGEMENT
Explaining all available options
DATAFLOWS
Create dataflow using entities
Implement Power Query Operations
Common Data Model [CDM] usage
Save Dataflow
Using Data Flow in Power BI Desktop
DASH BOARDS
Create dash board
Add the below tiles
a) Image tile
b) Text box tile
c) Video tile
d) Streaming tile
e) Live page tile
f) Visual tile
g) Book mark tile
h) Workbook tile
i) Insight tile
j) Usage Metrics tile
Sharing dash board
Subscribing dash board & Alerts Creation
Comments on dash board
Replying for customer comments
Metrics, View Related
Mobile view of dash board
Real-Time dashboards practice with more DAX
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
CONTENT PACKS
Create content pack and view content packs
Add dashboard, reports, and work books
Share content pack
Provide access on content packs
Working with Content from Others
POWER BI MOBILE AND REPORT PUBLISHER
Download mobile publisher
Create mobile report and customer support
Mobile view
Desktop, Service, and Mobile App
Measures, Calculations and Tables
Mobile app with SSRS and Power BI reports
POWER BI REPORT BULDER, REPORT SERVER
[ON-PREMISE], AND PAGINATED REPORTS
Explain RDL (.rdl) Technology and SSDT
Install report builder and create paginated
reports with .RDL
Install and configure report server
Place SSRS and Power BI reports in Server
Upload On-Premise reports to Cloud
Integrate RDL and PBIX reports
Mobile app access for On-Premise reports
POWER BI ENHANCED [ADVANCED] SUPPORT
Microsoft Flow
Power Apps
Power BI Embedding
Power BI Developer
Power BI REST API
.NET API
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
DAX Language General Topics
Syntax and usage
Naming conventions
Operators and Naming
Parameters
Functions
DAX Queries
Tools --DAX Studio and SSMS
DAX Functions [ Very Detailed Practice]
Good material provided for all the functions
a)Text b) Filter c) Date d) Logical e)Information
f)Time g) Parent Child h) Statistical i)Math and
Trig j)Other functions
DATE FUNCTIONS
CALENDAR, CALENDARAUTO, DAY, MONTH, YEAR YEARFRAC, DATE, TIME, DATEVALUE, TIMEVALUE EDATE, EOMONTH, WEEKDAY, WEEKOFMONTH TODAY, UTCTODAY, NOW, UTCNOW, DATEDIFF
TIME INTELLIGENCE FUNCTIONS
DATESBETWEEN, DATESINPERIOD, ClosingBalanceofmonth, ClosingBalanceOfQuarter, ClosingBalanceOfYear, OpeningBalanceOfMonth, OpeningBalanceOfQuarter, OpeningBalanceOfyear, DATESYTD, DATESQTD, DATESMTD TOTALQTD, TOTALMTD, TOTALYTD ,FIRSTDATE, FIRSTNONBLANKDATE, LASTDATE, LASTNONBLANKDATE, NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, PARALLEL PERIOD, SAMEPERIODLASTYEAR, PREVIOUSDAY, PREVIOUSMONTH, PEVIOUSQUARTER,PREVIOUSYEAR, STARTOFMONTH, STARTOFQUARTER,STARTOFYEAR
LOGICAL FUNCTIONS
AND, OR, NOT, IFERROR, IF, SWITCH, IN TRUE ,FALSE
FILTER FUNCTIONS
ADDMISSINGITEMS, FILTER, FILTERS,Distinct, VALUES COUNTROWS, ALL, ALLEXCEPT, Earlier, Earliest, HASONEFILTER, RELATED, RELATEDTABLE, KEEPFILTERS, CROSSFILTER, ISCROSSFILTERED, CALCULATE, CALCULATE TABLE, AllSelected, AllNoBlankRow, USERELATIONSHIP,
INFORMATION FUNCTIONS
CONTAINS ROW, CONTAINS, ISEVEN, ISODD, ISTEXT, USERNAME, USERPRICIPALNAME, LOOKUPVALUE, ISERROR, ISNONTEXT, ISNUMBER, ISLOGICAL, ISINSCOPE,ISONORAFTER
MATH AND TRIG FUNCTIONS
SUM,SUMX,ROUND,MROUND,ROUNDUP, ROUNDDOWN,RAND,RANDBETWEEN , SQRT, TRUNC, PI,LOG, LOG10,LN,ISO.CEILING, CEILING, FLOOR, ISO.FLOOR, GCD,LCD,EXP,FACT, Even, ODD, PRODUCT, PRODUCTX
OTHER FUNCTIONS DATA TABLE,EXCEPT, INTERSECT, UNION, GROUP, SUMMARIZECOLUMN, GENERATE SERIES, NATURAL JOIN TREATAS, ISEMPTY, VAR
MATH AND TRIG FUNCTIONS
path, pathlength, pathcontains ,pathreverse, PathItem
STATISTICAL FUNCTIONS ADDCOLUMNS, AVERAGE, AVERAGEX, AVERAGEA COUNT, COUNTA ,COUNTAX ,COUNTBLANK, COUNTROWS, COUNTX, CROSSJOIN, DISTINCTCOUNT GENERATE, GENERATEALL, GEOMEAN, MAX, MAXA ,MAXX,MEDIAN,MEDIANX, MIN, MINA, MINX, PERMUT, RANK.EQ, RANKX, ROW, SAMPLE, SELECTCOLUMNS, SUMMARIZE, TOPN
TEXTUAL FUNCTIONS
BLANK, CODE,UNICHAR,CONCATINATE COMBINEVALUES , CACATINATEX, TRIM REPT, REPLACE, SUBSTITUTE, FIND, SEARCH FORMAT, MID, LEFT, RIGHT, VALUE
Good material with Real-time scenarios covered
A project with most of the DAX functions
TOPIC 10: DAX [DATA ANALYSIS EXPRESSIONS]
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]
ANALYSIS SERVICES –TABULAR MODEL
Workspace Database , Workspace Server ,
Direct Query , Backup to disk
Installation steps , error mechanisms
Creating a tabular model and setting
model
Data to the model , renaming tables,
filtering columns
Rename Columns
Monitoring relationships , Providing
relationships
Create Hierarchies
Create partitions
Create perspectives
Create Roles
Create KPIs
Deployment
AZURE SESSIONS
Azure cloud and introduction
Azure portal, resources, and resource
groups
Azure account creation and pay-as-you-
go
Azure Sql Database, Data warehouse, and
Analysis Services Databases
Aure Blob and Data Lake Storages
Introduction
Azure Data Factory [ADF] Introduction
ADF- Pipelines, Sources, Sync, and
Transformations
ADF- Copy Activity practice
ADF Data Bricks Introduction
TOPIC 11: ADDITIONAL SESSIONS [ANALYSIS SERVICES TABULAR MODEL AND AZURE SESSIONS]
VINAY TECH HOUSE
Email:[email protected] Contact: +91 9573168449/7989477983 Website:www.vinaytechhouse.com
# 506B, Nilgiri Block, Aditya Encalve, Ameerpet, Hyd. Ph: 040 66638869/ 9573168449
POWER BI COURSE CONTENT [BASICS-ADVANCED]