Analyzing and Visualizing Data with Microsoft Power Excel & 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:

• Understand complete Microsoft Excel Power BI tool pack
• Analyze data from different data sources and create their own datasets
• Comfortably work with the different tools of the Power BI universe and know how the different tools work together
• Create reports with different interactive visualization in Power BI Desktop

COURSE CONTENTS

• Introducing Power BI Tools
  • Power BI Key Features
  • The Self-Service BI Model
• Using Power Query
  • Getting Data with External Sources
  • Transforming Malformed Data
  • Merging & Appending Queries
• Modeling Data with PowerPivot
  • Introduction to Modeling
  • Setup and Manage Relationships
  • Creating Calculated Columns
  • Creating Measures & KPIs
  • Working with DAX
• Power View for Excel
  • Creating Power View Reports
  • Understanding Table Visualizations
  • Chart Visualizations
• Power Map
  • Plotting Spatial Data Over Power Map
  • Formatting & Customizing Map
  • Creating Power Map Tours
• Power BI Desktop
  • Creating Charts Visualizations
  • Tables, Matrices, KPI’s & Cards
  • Slicers & Timeline Slicers
  • Scatter & Bubble Charts & Play Axis
  • Drill Down/Up Charts