Overview:
Power BI is a cloud-based business analytics service by Microsoft enabling anyone to visualize and analyze data with greater speed, efficiency, and high understanding. Interactive data visualization tool which makes it easy to share data across the organization. Delivers valuable insights to make quick and informed decisions transforms raw and unprocessed data into insightful and stunning visuals for officials to communicate and understand the business better. Provides access to the customized reports and interactive dashboards which help to have a complete 360-degree view of the business. Used by professionals of all domain to:
• Create interactive data visualization from multiple data sources
• Deliver real-time insights across the organization

Learning Outcomes:
• Perform Power BI Desktop Data Transformation
• Power BI Desktop Modelling
• Create A Power BI Desktop Visualization
• Implement the Power BI Service
• To Connect to Excel Data
• To Collaborate with Power BI Data

Content
• Power BI Desktop – Overview
• Power BI Desktop – Data Extraction
• Data Visualization In Power BI Desktop
• Power BI Desktop – Data Transformation / Edit Queries
• Combine Queries
• Power BI Desktop – Data Modelling
• Introduction To DAX
• Core DAX Function
• Power BI Service & Power BI Service – Dashboards
• Gateways

Course Prerequisites
• Some basic knowledge of data warehouse schema
topology (including star and snowflake schemas)
• Some exposure to basic programming constructs
(such as looping and branching)
• An awareness of key business priorities such as
revenue, profitability, and financial accounting is
desirable
• Familiarity with MS Excel

Who should Attend?
• Anyone Who Loves Data
• Excel Users Wishing To Upgrade Their Reporting
Capabilities
• Data Analysts
• Business Analysts
• Information Analysts
• DB Administrators
• Project Managers
• Financial Analysts
• Marketers

Facilitator’s Profile
Mr. Irfan Bakaly, who got Pakistan's first Microsoft Most Valuable Professional (MVP) award in Excel category, is also having 18+ years of experience in technology training field.He is motivated and enthusiastic by new challenges and tasks and takes excellent approach to achieve success in all projects. He also likes to work in a complex projects which have scope for learning and challenge. Apart from holding a Bachelor’s Degree in Computer Science, Microsoft Analyzing and Visualizing Data with Power BI, Microsoft Certificated Professional & Microsoft Certified for Excel 2013, he has been into training profession for, 18+ years and served many institutions & organizations of repute. His courses contains both content & delivery methodologies which enables participants to learn more in less time. His signature courses include Presentation Skills in Business using Microsoft PowerPoint, Power BI, Excel for Business Users, Excel Basic, Intermediate & Advanced, Microsoft Access for Creating Database Applications, Dashboard Reporting using Excel, Excel Macros using VBA. Currently, he is associated to a Business Application Development and Training Company “Viftech Solution Pvt. Ltd.”, heavily involved in corporate training activities for their Software Division at national and international level. He is also a YouTube celebrity with an active tutorial channel by the name of “Irfan Wazir Ali”. He has more than 525+ videos, most of which are getting thousands of views. His video tutorials have been widely shared on YouTube and other video tutorial websites by other users. He is author of 6 DVD’s name, Mastering in Excel (Basic to Advanced), Financial Modeling using Excel & Excel Dashboard, Microsoft Power BI & Excel VBA Macros & MS Office 2013. He has given trainings at various local organizations encompassing various industries,such as: Banking and Finance, Manufacturing, IT and Education.