Analyzing and Visualizing Data with Power BI Tools (Lahore)

Are you looking for new ways to find and visualize data and to share your discoveries? Power BI can help. This collection of tools and features from Microsoft transforms your company’s data into rich visuals for you to collect and organize, so you can spot trends, collaborate in new ways, and make sense of your data.

Microsoft Power BI allow end-users to store, analyze, and visualize big data.  Learn these game-changing technologies to analyze huge business data with ease. This course is designed with a practical, easy-to-learn approach towards unleashing the clout of Microsoft Power BI.

LEARNING OUTCOMES

At the end of this course participants will be able to:

• Get data from different sources and create their own datasets
• Transform data to fix anomalies
• Create custom fields and measures using DAX for in-depth analysis
• Produce and publish dashboard reports using Power BI Desktop
• Setup gateways to synchronize and refresh online dashboards

COURSE CONTENTS

• Fundamentals of BI
  • Introduction to BI and Big Data Analysis
  • Power BI Key Features
  • The Self-Service BI Model
• Get & Transform Data with Power Query
  • Getting Data with External Sources
  • Transforming Malformed Data
  • Merging & Appending Queries
• Modeling Big Data with DAX & PowerPivot
  • Introduction to Data Modeling
  • Setup and Manage Relationships
  • Creating Calculated Columns
  • Creating Measures & KPIs
  • Working with DAX
• Unleashing Power BI Visualizations
  • Creating Charts Visualizations
  • Tables, Matrices, KPI’s & Cards
  • Slicers & Timeline Slicers
  • Scatter & Bubble Charts & Play Axis
  • Drill Down/Up Charts
• Publishing and Sharing Dashboards
  • Power BI Cloud Service Setup
  • Setting Up Workspaces
  • Publishing Dashboard Reports to PBI service cloud
• Synchronizing and Refreshing Datasets
  • Introduction to PBI Gateways
  • Setting-up Gateways
  • Setting Refresh Schedule of Datasets