PowerBI Training

Upon the completion of this course you will gain the complete knowledge of the below concepts:

• Power Bi architecture 
• Power pivot, power query, and Power view. 
• Power BI installation and configuration 
• Using auto filters to report visualizations 
• Overview of DAX Expressions.
• Power Query Editor
• Drill-down reports and Hierarchies
• cloud operations and Power BI deployment 

• Candidates who wish to start their career as Business Development Manager, Business Analyst, etc. 
• Statisticians who wish to enhance their skills in data visualization 
• Marketing, sales, finance and other professionals who work with BI tools. 

There are specific prerequisites to learn this Power BI course.

• Organizations across the world are using business intelligence tools to leverage the benefits of data. 
• Power BI is one of the widely deployed tools and secured a large portion of the BI market. 
• According to Ziprecruiter.com, the average salary received by a Power BI professional is $141861 per annum.

Below are the job roles available for the Power BI professionals:

• Power BI developer
• Data Engineer
• Data Scientist
• Power BI Admin
• Data Architect
• Business Analyst
• Business Intelligence Developer

Yes, upon the successful completion of the Microsoft Power BI training you will receive the course completion certificate from SK Trainings. This certificate is valid across all the top MNCs and simplifies your job search process.

Yes, you will get all assistance from the Microsoft Power BI experts to clear your certification exam. Moreover you will be provided with the experts designed Power BI course material to clear your certification exam.

• Getting Data
• Getting started with Power BI Desktop
• Connect to data sources in Power BI desktop
• Clean and Transform you data with the query Editor
• More Advanced Data sources and transformation
• Cleansing Irregularly Formatted Data Data
• Additional features paid non paid features/comparision with other visualization tools

• Modeling
• How to manage your data relationships
• Create calculated columns
• Optimizing Data Models for Better visuals
• Create measures and work with time-based functions
• Create Calculated Tables
• Explore Time-Based Data

• Introduction to DAX
• DAX Calculation types
• DAX Functions
• Using variables in DAX Expressions
• Table Relationships and DAX
• DAX Tables and Filtering

• Create a dynamic Date Table: Preview
• Create a Dynamic Date Table in the Query Editor
• Create a Custom Date Table
• Create Year to Date, Month to Date and Week to Date Functions
• Compare Data between Custom Quarter Periods

• Visualizations
• Create and customize simple visualizations
• How to use Combination Charts
• Create and format slicers
• How to use map visualizations
• How to use tables and Matrixes
• How to used scatter charts
• How to use water fall and funnel charts
• How to use gauges and single number cards
• How to modify colors in charts and visuals
• Style your Reports with Shapes, Text boxes and Images
• Style your reports with page layout and formatting
• Create Complex Interaction between Visualizations
• Duplicate a Report Page
• Show categories with No Data
• Customize visuals with Summarization and Category Options
• Arrange the z-order of report elements
• Visual hierarchies and drill down behaviour
• R visuals in Power BI

• Exploring data
• Use quick insights in the Power BI Service
• Create and configure a dashboard
• Ask questions of your data with Natural language
• Create custom Q & A suggestions
• Share dashboards with your organization
• Display visuals and tiles full-screen
• Edit Title details
• Get more space on your dashboard

• Module Introduction
• Continuing our Work and why we need Power BI Service
• Comparing Power BI Free, Pro and Premium
• Logging in to Power BI Service
• Understanding the Interface
• Publishing and sharing
• Publish Reports from Power bi desktop
• Print and Export Power bi dashboard
• Importing our Data from Power BI Desktop to Power BI Service
• Understanding the Dataset Menu
• Working on Reports
• Introducing Dashboards
• Exploring our Workspace
• Data Refresh
• Understanding Gateways
• Comparing Personal and On-Premise Gateway and Installing a Gateway
• Creating a Scheduled Refresh
• Integrate OneDrive for business with Power BI
• Publish a Report to the web from Power BI
• Working alone or Collaborating with Colleagues
• Collaborating in App Workspaces
• Sharing the Results
• Publishing the App
• Create a content pack in power bi
• Connect to a content pack from a group in Power bi
• Edit content pack in power bi
• Content Packs from Online Services
• Power BI Mobile: Installing and Understanding the Mobile App
• One Last Thing: Excluding Datasets from Sharing
• Module Summary

• Power BI Finance Dashboard: Add Current Accounts, Income / Expense, Etc.
• Activity: Data Structure and Profitability Ratio's
• Power BI Finance Dashboards: Add Liquidity Ratios to Power BI Finance Dashboard
• Activity: Add Liquidity Ratio's to the Finance Dashboard
• Power BI Finance Dashboard: Add Activity Ratios to Power BI Finance Dashboard
• Activity: Add Activity Ratio's to your Finance Dashboard
• Power BI Finance Dashboard: Debt Ratio's
• Activity: Add Debt Ratio's to your Power BI Desktop.
• List of Financial Ratio's
• Publish your dashboard to the Power BI Service and Share with your teams.
• Activity: Publish and share your Power BI Report

Power BI Desktop is a free desktop application that can be installed right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and creating report with highly interactive visualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others.

Power BI is a cloud-based data sharing environment. Once you have developed reports using Power Query, Power Pivot and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which technically is an aspect of SharePoint online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers. Not only that, but your colleagues can interact with your reports to apply filters and slicers to highlight data. They are completed by Power BI, a simple way of sharing your analysis and insights from the Microsoft cloud. Power BI features allow you to:

• Share presentations and queries with your colleagues.
• Update your Excel file from data sources that can be on-site or in the cloud.
• Display the output on multiple devices. This includes PCs, tablets, and HTML 5-enabled mobile devices that use the Power BI app.
• Query your data using natural language processing (or Q&A, as it is known).

The following are the Building Blocks (or) key components of Power BI: 1. Visualizations: Visualization is a visual representation of data. Example: Pie Chart, Line Graph, Side by Side Bar Charts, Graphical Presentation of the source data on top of Geographical Map, Tree Map, etc. 2. Datasets: Dataset is a collection of data that Power BI uses to create its visualizations. Example: Excel sheets, Oracle or SQL server tables. 3. Reports: Report is a collection of visualizations that appear together on one or more pages. Example: Sales by Country, State, City Report, Logistic Performance report, Profit by Products report etc. 4. Dashboards: Dashboard is single layer presentation of multiple visualizations, i.e we can integrate one or more visualizations into one page layer. Example: Sales dashboard can have pie charts, geographical maps and bar charts. 5. Tiles: Tile is a single visualization in a report or on a dashboard. Example: Pie Chart in Dashboard or Report.

Content packs for services are pre-built solutions for popular services as part of the Power BI experience. A subscriber to a supported service, can quickly connect to their account from Power BI to see their data through live dashboards and interactive reports that have been pre-built for them. Microsoft has released content packs for popular services such as Salesforce.com, Marketo, Adobe Analytics, Azure Mobile Engagement, CircuitID, comScore Digital Analytix, Quickbooks Online, SQL Sentry and tyGraph. Organizational content packs provide users, BI professionals, and system integrator the tools to build their own content packs to share purpose-built dashboards, reports, and datasets within their organization.

Below are some of the most commonly used DAX function:

• SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT
• IF, AND, OR, SWITCH
• ISBLANK, ISFILTERED, ISCROSSFILTERED
• VALUES, ALL, FILTER, CALCULATE,
• UNION, INTERSECT, EXCEPT, NATURALINNERJOIN, NATURALLEFTEROUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY,
• VAR (Variables)
• GEOMEAN, MEDIAN, DATEDIFF

These are the only functions that allow you modify filter context of measures or tables.

• Add to existing filter context of queries.
• Override filter context from queries.
• Remove existing filter context from queries. Limitations:
• Filter parameters can only operate on a single column at a time.
• Filter parameters cannot reference a metric.

Below are some of the benefits:

• By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, thus avoiding additional queries of the source database.
• Variables can make DAX expressions more intuitive/logical to interpret.
• Variables are only scoped to their measure or query, they cannot be shared among measures, queries or be defined at the model level.

Below are the most important BI add-in to Excel:

• Power Query: It helps in finding, editing and loading external data.
• Power Pivot: Its mainly used for data modeling and analysis.
• Power View: It is used to design visual and interactively reports.
• Power Map: It helps to display insights on 3D Map.

It is a model that is made up of data types, tables, columns, and table relations. These data tables are typically constructed for holding data for a business entity.

No, we cannot have more than one active relationship between two tables. However, can have more than one relationship between two tables but there will be only one active relationship and many inactive relationship. The dotted lines are inactive and continuous line are active.

There are two destinations for output we get from power query: 1. Load to a table in a worksheet. 2. Load to the Excel Data Model.

Changing Data Types, Filtering Rows, Choosing/Removing Columns, Grouping, Splitting a column into multiple columns, Adding new Columns, etc.

Query parameters can be used to provide users of a local Power BI Desktop report with a prompt, to specify the values they’re interested in.

• The parameter selection can then be used by the query and calculations.
• PBIX files can be exported as Templates (PBIT files).
• Templates contain everything in the PBIX except the data itself. Parameters and templates can make it possible to share/email smaller template files and limit the amount of data loaded into the local PBIX files, improving processing time and experience.

Power Query is a self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in. It allows users to pull data from various sources, manipulate said data into a form that suits their needs and load it into Excel. It is most optimum to use Power Query over Power Pivot as it lets you not only load the data but also manipulate it as per the users needs while loading.

For a data to be consumed in power map there should be location data like:

• Latitude/Longitude pair
• Street, City, Country/Region, Zip Code/Postal Code, and State/Province, which can be geolocated by Bing

Power View is a data visualization technology that lets you create interactive charts, graphs, maps, and other visuals which bring your data to life. Power View is available in Excel, SharePoint, SQL Server, and Power BI. The following pages provide details about different visualizations available in Power View:

• Charts
• Line charts
• Pie charts
• Maps
• Tiles
• Cards
• Images
• Tables
• Power View
• Multiples Visualizations
• Bubble and scatter charts
• Key performance indicators (KPIs)

Yes we can refresh our reports through Data Management gateway(for sharepoint), and Power BI Personal gateway(for Powerbi.com)

No, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services, and other data sources. You can also scheduled refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway – Personal.

Power BI Q&A is a natural language tool which helps in querying your data and get the results you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your questions and shows you a restated query of what it is looking from your data. Q&A was developed by Server and Tools, Microsoft Research and the Bing teams to give you a complete feeling of truly exploring your data.