Power BI for the Business Analyst

Power BI in a Day

8:45  | Check-in

9:00  | Introductions

  * Overview of Power BI, PowerPivot and Power Query

               * What is Data Modellin and why it matters     

9:30  | Power Pivot for Excel

 * Loading Data with Power Query

              * Data Tables vs. Lookup Tables

              * Relationship: the end of VLOOKUP

              * Assignment

10:30 | 1st Break

10:45 | Intoduction to DAX

   * Measures vs. Calculated Columns

              * Assignment

              Introduction to Power BI

  * Building Visuals, Drill Through, Cross Filter

              * Inbuilt Date Hierarchies

              * Analytics

              * Bookmarks

12:00 | Lunch

1:00   | Power BI Visuals Continued

   * Formatting/ Conditional Formatting

             * Top N filtering

             * Drill through reports

             * Display Configuration (Mobile & Tablets)

2:00 | 2nd Break

2:15 | Power BI Service

          * Creating Workspaces

          * Sharing Reports & Dashboards

          * Q&A/ Quick Insights

          * Analyze in Excel

4:00 | Power Query

          * When to use it and why

          * Data Cleansing & Profiling

          * Using Power Query to solve real world problem

5:00 | End of the session

 

 All students will receive Certificate of Participation from Impact Education.

Prerequisites

Recommended Experience

* Experience using Excel Pivot Table

* Familiarity with Excel funtions like SUMIF & VLOOKUP

Note: Anyone with Database,BI,Programming, or similar experience are quite qualified to take this course,even if lacing in Excel experience.

This training course can be taken as a stand alone introduction to Power BI.This course is suitable for anyone that wants to understand the capabiliites and use of Power BI.

 Course Fees: Rs.700/- 

 Register Now