Analyzing and Visualizing Data with Microsoft Power BI

About The Course

Microsoft Power has become No. 1 BI tool in the market in the reason past. Learn how to turn data into powerful actionable insights that direct and drive informed business decisions – giving your business the edge over competitors. By taking our Microsoft Power BI training course, anyone can become a competent in analysis of data for better decision making.

The Microsoft Power BI tool allows you to extract, analyze and comprehend large quantities of data – helping to ensure that you can present data in a logical manner and make informed business decisions. The Microsoft Power BI is the most user-friendly report-based analytical tools, that is transforming the way that businesses read their performance data.

During this extensive and interactive three-day Power BI course, candidates will learn how to build and publish reports directly onto the Power BI Service – enabling colleagues and stakeholders to appreciate the insightful data analysis from their phones, tablets, and laptops. Additionally, the flexibility of the Power BI Suite is demonstrated by the ability to unify your organization’s data by uploading and sharing information on Cloud-based platforms – our engaging trainers will show you how to share your data analysis with stakeholders on the Cloud too.

The Course Outcome

Upon completion of this course you will learn how to,

• • Extract Transform and Load (ETL) data from any source into Power BI and how to automate data loading procedures.
  • How to build a Data model in Power BI like a pro for better analysis
  • How to do in depth analysis in your data using Data Analysis Expressions (DAX)
  • How to easily create powerful data visualizations for reports and dashboards.
  • By the end of the course, you’ll have a Business Intelligence Model developed by your own and through the knowledge and skills you gained throughout this course you will able to apply same concepts to your own real-world analyses.

The Target Audience 

• If you spend more than 3 hours a day using Microsoft Excel for your reporting work
• For anyone who wants to automate their daily routine of work
• For all those who want to automate management reporting and wow their report consumers
• To perform advanced analytics using DAX for Microsoft Power BI
• To build amazing report solutions using Microsoft Power BI

Course Curriculum

Extract & Transform and Load (ETL) data into Power BI

• What is Power Query?
• The Query Editor tools
• Different Data Loading Options
• Basic Data Transformations
• Text Transformations Techniques
• Number related Calculations and Transformations
• Date Related Transformations
• How to build dynamic Calendar using Power Query M language.
• How to add Index & Conditional Columns
• How to Group & Aggregate Data
• Pivoting & Unpivoting techniques
• Invoke Custom Functions
• Column from Examples
• Manage Data Parameters
• How to Merge Queries
• Different Merging Techniques
• How to Append Queries
• Creating Hierarchies
• Connecting to a Folder of Files
• Connect to a SQL server
• Advanced Data Transformation Examples
• Get data from a website using parameters
• Power Query Best Practices

Build a Relational Data Model

• What is a Data Model in Power BI?
• What is the concept of Database Normalization?
• Fact Tables vs. Dimension Tables
• How to Create Table Relationships
• Star Scheme and Snowflake Schema database concepts
• Managing & Editing Relationships
• Active vs. Inactive Relationships
• What is Relationship Cardinality
• Connecting Multiple Data Tables
• What is Filter direction?
• BI Directional Filters in Power BI
• Hiding Fields from Report View
• Data Modeling Best Practices

Data Analysis Expressions (DAX)

• What is DAX?
• What is a Calculated Column?
• What is a Measure?
• Implicit vs. Explicit Measures
• What is Evaluation Context?
• Row context and Filter Context
• Beginners guide to Measure Calculation
• DAX Syntax & Operators in DAX
• DAX Function Categories
• Date & Time Functions – DATEDIF, DATEVALUE, NOW(), TODAY()
• Logical Functions – SWITCH & SWITCH(TRUE), IF, ISFILTERED, CROSSFILTERED
• Text Functions – LEFT, MID, RIGHT
• Joining Data with RELATED
• Basic Math & Stats Functions
• COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS, SUM, AVERAGE, MIN, MAX, DIVIDE
• The CALCULATE Function
• CALCULATE & ALL
• CALCULATED & ALLSELECTED
• CALCULATE & FILTER
• Iterating Functions – SUMX, COUNTX, AVERAGEX, MAXX, TOPN
• How to use HASONEVALUE, ALLEXCEPT, VALUES
• DAX Time Intelligence Formulas
• SAMEPERIODLASTYEAR, DATEADD, YTD, MTD, QTD, PARRALLELPERIOD, PREVIOUSPERIOD
• DAX Best Practices

Design Interactive Reports

• Intro to the Power BI Report View
• How to Images & Basic Objects
• Formatting & Filtering Options
• Slicers, Timelines, Cards & KPIs
• Map Visuals (Basic, Fill, ArcGIS)
• Tree maps, Lines, Areas & Gauges
• Decomposition Visual
• Q &A Visual, Key Influencer Visual
• How to use Custom Visuals
• BCS guide for Data Visualization
• Editing Report interactions & Drill through Filters
• Using Report Bookmarks & Parameters
• Selection Pane & Bookmarks for Advanced Visualizations
• Advanced Formatting Tips and Tricks
• Managing & Viewing Roles and RLS
• Publishing to PBI Service
• Data Visualization Best Practices