Analyzing and Visualizing Data with Microsoft Power BI (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
• 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
  • Creating Calculated Columns, Measures & KPIs
  • Working with DAX
• Unleashing Power BI Visualizations
  • Creating & Customizing Visualizations
  • Tables, Matrices, KPI & Cards
  • Slicers, Page & Visual Level Filters
  • Scatter. Treemap, Ribbon & Bubble Charts
  • Drill Down/Up Charts
  • AI Visuals: Q&As, Decomposition Tree, Key Influencers, and Smart Narrative
  • Drill Through and Custom Tooltip Pages
  • Creating Custom Navigation Menus
• Publishing and Sharing Dashboards
  • Power BI Cloud Service Setup
  • Setting Up Workspaces
  • Publishing & Sharing Reports on PBI service cloud
• Synchronizing and Refreshing Datasets
  • Setting-up Gateways
  • Setting Refresh Schedule of Datasets