The Microsoft Full Stack Power BI Training at DeepNeuron is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. It is best suited for:

• Business Analysts
• Business Intelligence Manager
• Statisticians and Analysts
• Data Scientists
• Project Managers

• Introduction to Business Intelligence
• Self-Service Business Intelligence (SSBI)
• Introduction to Power BI
• Traditional BI vs. Power BI
• Uses of Power BI
• The Flow of Work in Power BI
• Working with Power BI
• Basic Components of Power BI
• Comparison of Power BI Version
• Introduction to Building Blocks of Power BI
• Data model and importance of Data Modeling

Hands-on Exercise:

• Installation of Power BI



Skills You will Learn:



• Concepts of Business Intelligence
• Power BI installation

• Data Sources in Power BI Desktop
• Loading Data in Power BI Desktop
• Views in Power BI Desktop
• Data Sources Supported in Power BI
• Exploring Live Connections to Data Sources
• Connecting to SQL Server
• Import Power View and Power Pivot
• Data Gateways
• Direct Query vs. Import Connectivity modes
• Connecting Power BI in Excel

Hands-on Exercise:

• Setting Up On-Premise Data Gateway
• Connecting Power BI with SQL Server Database
• Connecting Reports on Power BI Service with Local Data Files

Skills You will Learn:

• On-Premise Data Gateway
• Connecting Power BI with Databases
• Connecting Power BI Service with Local Data Sources

• Query Editor In Power BI
• Transform, Clean, Shape, and Model Data
• Manage Data Relationship
• Editing a Relationship
• Cross Filter Direction
• Saving Workfile
• Measures

Hands-on Exercise:

• Data Cleaning using Power BI query editor
• Creating Measures
• Transform, Clean, Shape, and Model Data for further analysis

Skills You will Learn:

• Data transformation using the query editor
• Shaping data with measures
• Managing Data Relationships

• Introduction to Visuals In Power BI
• Visualization Charts in Power BI
• Matrixes and Tables
• Slicers and Map Visualizations
• Gauges and Single Number Cards
• Modifying Colors in Charts And Visuals
• Shapes, Text Boxes, and Images
• Custom Visuals
• Page Layout and Formatting
• Bookmarks and Selection Pane
• KPI Visuals
• Z-order
• Grouping and Bining

Hands-on Exercise:

• Creating different visuals
• Creating cards, measures, KPI, reference line, and slicers



Skills You will Learn:



• Visuals in Power BI
• Report creation
• Visuals modification
• Z-order and KPI in visuals

• Introduction to Power BI Service
• Creating a Dashboard
• Quick Insights in Power BI
• Configuring a Dashboard
• Power BI Q&A
• Ask Questions about your Data
• Power BI Embedded
• Bookmarks and buttons

Hands-on Exercise:

• Creating reports and dashboard
• Publishing reports on Power BI Service
• Using Power BI Service for operations on reports
• use date hierarchies
• use business hierarchies
• resolve hierarchy issues

Skills You will Learn:

• Report and dashboard creation
• Designing stories with dashboards

• Introduction to DAX
• Importance of DAX
• Data Types in DAX
• DAX Calculation Types
• Steps to Create Calculated Columns
• Measures in DAX
• DAX Syntax
• DAX Functions
• DAX Operators
• DAX Tables and Filtering

Hands-on Exercise:

• Creating Calculated Columns and Measures
• Performing Data Analysis using DAX



Skills You will Learn:



• Data Analysis using DAX
• Creating Calculated Measures and Columns

• Use Parameters
• Create a data flow
• Introduction to Smart Narrative
• Introduction to Sensitivity labels in Power BI
• Deployment Pipeline

Hands-on Exercise:

• Connecting with Power BI service
• Creating dataflow
• Creating scorecard



Skills You will Learn:



• Data flow creation
• Smart Narrative implementation

• Power BI Service
• Row Level Security
• Visuals and Charts
• Power BI Desktop
• Handling Workspaces

Report on Student Survey

A survey was conducted among many stores, in which data based on students, i.e., how much they are spending on different kinds of purchases, such as video games, indoor games, toys, books, gadgets, etc., was collected. You have to create a Power BI report. You will get hands-on experience in Tabular visualization, matrix visualization, funnel chart, pie chart, scatter plot, SandDance plot, etc.

Case Study 1 - Power BI Desktop, Cloud Service, and End-to-end Workflow

The case study deals with ways to design a dashboard with a basic set of visualizations and deploy it on the Power BI cloud service. Further, a brief top-level overview of Transport Corp Data is shown using aggregated key performance indicators (KPIs), trends, Gio distributions, and filters.

Case Study 2 - Visualizations, Configuring Extended Properties, and Data Calculations DAX - Introduction

This case study explains the way to design a dashboard and perform calculations by making use of Power BI DAX formulas. The scheduled deliveries of loads are analyzed using correlation across measures. Moreover, drill-up/drill-down capabilities and reference lines are implemented.

Case Study 3 - Combination Visualizations for Correlated Value Columns

Here, the dashboard is designed by making use of Power BI DAX formulas to perform calculations. Bucketed categories are created to represent value measures on the categories axis. Furthermore, a scatter plot is used to identify outliers or outperformers.

Case Study 4 - Data Transformations

The case study involves designing an audit dashboard by making use of Power Query and using Query Editor to perform data modeling by applying data transformations, in turn, by managing relationships.

Case Study 5 - Data Transformations (Cont.)

Here, the dashboard is designed to analyze the trend of admissions into a State University. Query Editor is used to perform data modeling by applying transformations, such as append data, split data, column formatting, transpose table, pivot/unpivot, fill columns, merge join, conditional columns, index columns, and summary tables.

DDL (Data Definitions Language) Commands

Goal: Data Definition Commands define the syntax of a database and manipulate database objects.

Module Objectives:

• RDBMS (Relational Database Management System) Introduction
• Normalization in RDBMS
• Create database objects i.e. Create Table
• Delete database objects i. e. Delete Database
• Alter database objects i.e. Change Column Name
• Create, alter and delete constraints

Topics :

Relation Database Management System (RDBMS)

• Normalization
• Create Database objects
• Data Types in SQL
• Alter Table Statements
• Drop-Table Statements
• Various Constraints
• Creating Views

Hands-on/Demo/Use-case:

• Create Table With Predefine Columns
• Add New Column to Existing Table
• Check the constraints on a table
• Add Primary key and Foreign Key on Table
• Remove Unique Constraint
• ODML (Data Manipulation Language) Commands
• Retrieve data from multiple tables
• Inbuilt Functions in SQL
• Create Advance database objects

What is BI?

• Introduction to Business Intelligence
• understanding the concept of Data Modeling
• Data Cleaning
• learning about Data Analysis
• Data Representation
• Data Transformation

ETL Overview

• Introduction to ETL
• The various steps involved Extract, Transform, Load
• Using a user's email ID to read a flat file
• Extracting the user ID from the email ID
• Loading the data into a database table.

Working with Connection Managers

• Introduction to Connection Managers
• Logical representation of a connection
• The various types of Connection Managers
• Flat file, database, understanding how to load faster with OLE DB
• Comparing the performance of OLE DB and ADO.net
• Learning about Bulk Insert
• Working with Excel Connection Managers and identifying the problems