Power BI Training: Learn tools and techniques and drive strategic business outcomes

This Power BI Training helps you to connect with you data and access data from hundreds of supported on-premises and cloud-based sources, such as Dynamics 365, Salesforce, Azure SQL DB, Excel, and SharePoint. Helps you to be up to date with automated, incremental refreshes. Power BI Desktop enables you to develop deep, actionable insights for a broad range of scenarios. It saves your time and make data handling easier with data modeling tools. Explore your data, automatically find patterns, understand what your data means, and predict future outcomes to drive business results. Use features like quick measures, grouping, forecasting, and clustering. Give advanced users full control over their model using powerful DAX formula language. Power BI enables you to discover hidden, actionable insights and drive more strategic business outcomes. Design your report with theming, formatting, and layout tools.

Get visual analytics to the people who need it. Create mobile-optimized reports for viewers to consume on the go. Publish from Power BI Desktop to the cloud or on-premises. Embed reports created in Power BI Desktop into existing apps or websites.

Course Objective of Power BI Training:

After the completion of this training, the participants will accomplish the following objectives:
1. Understand the core principles of Power BI.
2. Understand Power BI tools and Techniques
3. Use Power BI to automate task
4. Understand creating Power BI Dashboard and Data Models
5. Explore the various techniques of new data analysis in Power BI

Learning Goals:

Pivot Table & Dashboards

• Pivot Table Basics
• Reporting Scenarios
• Dashboards In Excel
• Dashboards Scenarios

 Power Tools in Excel (Power Query)

• Introduction to ETL Process in Excel
• Power Query Introduction
• Consolidating Files (Tables, Workbooks, CSV files etc.)
• Transforming Data Examples (Unpivoting, Changing Cases, Splitting Data)
• Types of Joins in Power Query
• Appending Files

 Introduction

• What is Power BI?
• Why reporting in Power BI is better than in Excel?
• 4 Pillars of High-quality Power BI Solutions

 Query & Transforming Data

• What is the Query Editor?
• The Essential Way to Source data for Power BI
• Fundamentals of using the query Editor
• Querying multiple data sources in the same model
• Best Practices for transforming data in the query editor
• Rows & Column Transformation
• Making sure data types are correct
• Create groups for your queries
• What is ‘M’ and why do you need to have an understanding?
• Query Dependencies
• Importance of date tables

 Data Modeling

• Introduction to the importance of the data model
• Where to manage relationships for your data model?
• Understanding what types of tables, you have & setup techniques
• Setting up relationships in your models
• Difference between active and inactive relationships
• Building out additional dimensions in your data

DAX (New Language to Learn!)

• DAX explained & key techniques to learning it
• Getting started & naming conventions tips
• Calculated columns versus measures
• Creating a measure table & organizing your measures
• Context! – What is this?
• Evaluation (initial) context
• Aggregating formulas or filter context
• Iterating formula or row context
• Main table functions
• Building measures on measures (measure branching)
• CALCULATE function – the most important function in DAX
• Simple Time Intelligence functions

 Reports and Data Visualizations

• Design best practice tips
• Developing visualizations in Power BI
• How to create color themes for your reports?
• Visualization and report formatting
• Managing interactions between visuals
• Additional filtering across your reports
• Analytics automation features
• Importing custom visuals

 Power BI Online Service

• Power BI service explained
• Workspaces explained
• Reports vs Dashboards

Target Participants: 
Every Day Business Users:  

• HR Manager
• Operation Manager
• Financial Analysts
• Sales Manager
• Data Analyst
• Accountants
• Supervisors 

Time and Schedule:
Weekend Course: Every Saturday 4 hours ( Till 3 Week)
 Time : 8:00AM – 12:00PM (Including Break) 

Course Details:  Ultimate Power BI Training
Venue: Zoom Meeting App
Total Amount: Rs. 12,000+VAT  Rs. 5,000 +VAT 
Resources Provided: Course Materials, Recording videos of live session

About Trainers:

• A Qualified Professionals with 6+ years Corporate Experience in working with excel data base management, data analysis, data presentation, data consolidation and reporting.
• Core competencies lies in data analysis and data presentation and developing system in Excel which will make reporting automated, informative and effective.
• Worked in multinational work environment (Samsung India Electronics Nepal Liaison Office) as Sr. Position in MIS and Global Operation.
• Involved in Advance Excel session for more than 20 reputed corporate houses in Nepal since 2011 and has certified by Microsoft as Microsoft Office Specialist for Excel 2013.

Have Queries?

Contact No: +977-9801898004 (WhatsApp)
Email: training@frontline.com.np
URL: www.frontline.com.np