Power BI

Below topics will be covered:

1. Introduction to Power BI

- What is Power BI?

- Advantages of Power BI

- Dis-advantages of Power BI

- Competitors of Power BI.

- Importance of visualization

- What are Data Types

1. Categorical data

2. Numerical data

2. Connecting to Data

- Downloading and installing Power BI

- Getting started with data.

- Loading Data

- Touring the Power BI desktop

1. Header

2. Views

3. Panes

4. Canvas

5. Wallpaper

6. Pages

7. Footer

8. Ribbon

9. Formula Bar

3. Visual Analytics

- Generating Data.

- Creating a calculated table.

- Creating calculated columns.

- Formatting columns.

- Creating first visualization.

- Formatting visualization.

- Adding analytics to visualization.

- Creating and using a slicer.

- Creating more visualizations.

- Editing visual interactions.

- Getting additional data.

- Creating first query.

- Touring the Power Query Editor.

- Transforming data.

- Merging queries.

- Expanding tables.

- Disabling queries from being loaded.

- Copying queries.

- Changing sources.

- Appending queries.

- Organizing queries.

- Checking column quality, distribution and profiles.

- Touring the Model view.

- Modifying the layout.

- Creating and understanding relationships.

- Exploring the data model.

- Calculated columns.

- Measures.

- Boundary cases.

- Slicing.

- Grouping.

- Creating hierarchies.

- Buttons.

- Top-N filtering.

- Gauges and KPIs.

- What-if parameters.

- Conditional formatting.

- Quick measures.

- Report tool-tip pages.

- Key influencers.

4. Dashboards and Story

- Planning Dashboard report.

- Cleaning up.

- Using a theme.

- Creating a page template.

- Using Sync slicers.

- Adjusting the calendar.

- Adding report filters.

- Publishing and sharing.