WHY IT'S IMPORTANT?
With Microsoft Power BI , you can overcome all your data-related issues. You can keep track of your business in a visually pleasing manner. Further, make sure you have all the information you need to stay at top of your industry!
KNOW ABOUT YOUR TRAINER
Our Consultant A distinguished senior-level Information Technology trainer and Consultant, Our Consultant is an inspiration for provisioning of quality training since 1998, he is “Brainbench” certified for MS Excel 2010 Expert level and MS Project Expert level and expanding his career in Data Science and Big Data Field.
He has done several Data Analytics projects alone for various local and International Clients. His mastery on SQL Server Query Optimization, Excel and Power BI Reporting and Dashboard, and Data Analytical Skills is a key for his successful projects.
His Famous Quotes: if you are working on DATA just talk with DATA, DATA will tell you that what Secret he is hiding inside him
Currently, he is heading DMatrix Solutions – (Technology and Training Company) as a Chief Executive Officer. Working on Power BI, Big Data, and Data Analytics projects for USA and Africa Markets. Raheel has given training at various local and International organizations encompassing various industries, such as Banking and Finance, Manufacturing, IT, and Education with 95% positive remarks. He has worked for many companies for development and Training work which include national and international companies (Turkey, Saudia Arabia, Kenya, South Africa, USA, Australia, Dubai, Canada, New Zealand)
TESTIMONIALS
"A very competent trainer with full command on his work and delivered the session very efficiently
Alishba Jadoon – Senior HR Associate - Pakistan Refinery Ltd
He conducted a comprehensive training on advanced Excel, which was tailored made. It was well planned and focused. WELDONE.
Mukham Wali – HR Head – Aga Khan Planning & Building Services, Pakistan
Trainer was a good mentor. I've learned so much from him and also enjoyed learning. Will definitely attend some more sessions in future.
Faisal Javed - Corporate Accounts - Elixir Technologies
Good Training, great trainer! It sure will help in my career growth a lot.
Ali Jan Fidai – Manager – Human Resource – Brainchild Communication
COURSE OUTLINE
DAY ONE
POWER BI ESSENTIAL
- • Introduction to Power BI
• Licensing
• Power BI Free
• Power BI Pro
• Power BI Premium
• Getting Data from Excel
• Basic ETL Techniques using Power Query
• Data Modeling
• Basic Formulation with DAX
• Data Visualization
• Publishing Reports into Power BI Service
• Creating Dashboard in Power BI Service
• Sharing Dashboard
• Sharing Reports
DATA TRANSFORMATION IN POWER BI
-
• Get Data
• Different Data Sources
• What is Power Query?
• Power Query in Excel and Power BI
• Basic Transformations
• Get Data from Web
QUERY EDITOR
-
• Base structures in Power Query
• Query Editor in Details
• Get Data from SQL Server
• Get Data from CSV Files
• Get Data from Excel
• Get Data from JSON
• Transformation Pane
POWER QUERY SYNTAX
-
• Data Types in Power Query
• Query Properties
• Transformation Steps
• Query Operations; Duplicate, and
• Reference
• Managing Queries in Groups
COMBINE QUERIES
-
• Merge, Joining queries
• Append, creating a big list
• Combine Binaries; Looping through files in a folder
TRANSFORMATIONS
-
• Column Operations
• Row Operations
• Filtering
• Sorting
• Add as new query / Drill Down
TABLE TRANSFORMATIONS
-
• Group By
• Extending Group By with
• Expression Editor
• Transpose
• Pivot, Unpivot
TEXT TRANSFORMATIONS
-
• Split
• Merge (Concatenate)
• Parse
• Extract
MORE TRANSFORMATIONS
-
• Date Transformations
(Year, Month, Quarter)
• Extending Fiscal Date Column
• Time Transformations
• Adding Time/Date banding
• Structured Column
• Expand
• Aggregate
• Add Custom Column
• Add Conditional Columns (IF THEN ELSE)
DAY TWO
POWER BI MODELING
-
• Relationship in Power BI
• Relationship based on multiple
• Columns
• Formatting
• Hide/Unhide
• Basic Calculated Column and Measure INTRODUCTION TO DAX
- • Syntax of DAX
• Naming in DAX
• Logical Operations
• Data Types in Power BI Model
• Overview of Functions
FUNCTIONS IN DAX IN DETAILS
-
• Logical Functions
• Date and Time Functions
• Aggregation Functions
FILTER, VALUE, AND RELATIONSHIP FUNCTIONS
-
• ALL
• Examples of using ALL function
• Filter Function
• Related
• Related Table
EVALUATION CONTEXTS
-
• Row Context
• Filter Context
• Exception for Row Context
• Exception for Filter Context
• Calculate Function
TIME INTELLIGENCE FUNCTIONS
-
• Year to Date, Quarter to Date
• Fiscal Year to Date
• Same Period Last Year
• Running Total
• Rolling Month Sales
CALCULATED TABLES
-
• Role Playing Dimension
• Top 10 Customers
• Dynamic Date Table
BEST PRACTICES TIPS AND TRICKS
-
• Modeling Best Practices
• Advanced Time Intelligence
• Advanced Relationship in DAX
VISUALIZATION BASICS
-
• Basic Charts
• Clustered vs Stacked
• Quick Calcs in Power BI
• Interaction of Visuals
• Pages
SLICING AND DICING
-
• Filters
• Slicers
• Filtering Slicers
• Drill Down/Up
SPECIAL VISUALS
-
• Waterfall Chart; Cash flow
• Scatter Chart; Story Telling
• Line Chart; Powerful
• Table and Matrix with Conditional
• Formatting
• R Visualization
KPIS IN POWER BI
-
• KPI Default visual
• Dial Gauge
• Linear Gauge
• Bullet Chart
DAY THREE
GATEWAYS
-
• What is Gateway?
• Two types of Gateways
• Personal Gateway; an example On-premises Gateway; not only for Power BI ON-PREMISES GATEWAY IN DETAILS
-
• Requirements for on-premises gateway
• Architecture Flow diagram of the gateway
• Installation and Configuration considerations
• Install and Configure Gateway example
• Data Source Definition in Power BI Service Schedule Refresh
GATEWAY PERFORMANCE
-
• Performance Considerations
• Limitations of Gateway
DIRECT QUERY
-
• Step beyond 1/10GB Limitation in Power BI
• Limitations of Direct Query
• Performance Considerations
LIVE QUERY
-
• Difference of DirectQuery and Live Query
POWER BI SERVICE
-
• Dashboard vs Report
• Dashboard Tiles
• Data Classification
• Power Q&A
• Tips and Tricks for Power Q&A
SHARING
-
• Dashboard Sharing
• Work Groups in Power BI
• Content Packs
• Publish to Web
• Comparison of all Sharing methods
ADMINISTRATION
-
• Admin Portal
• Set Power BI Administrator
• Tenant Settings
• Audit Log
DAX OPTIMIZATION
-
• Use of DAX Studio
• DAX Query Profiling
• Evaluate DAX queries
• Optimization Techniques