Best Power BI Training in Bangalore
K2K technologies is a leading IT Training Institute located in Marathahalli, Bangalore Providing Quality Training and Placements for Students and Working Professionals who are looking to Upgrade their career. We Provide Training and Course Materials with a Free Demo for Power BI Training.
We Provide the Best Power BI Training in Bangalore, Our Trainers are Working Professionals having 10+ Years of experience in Power BI Domain, We Provide Real-time training with Live Projects and Placement Assistance.
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
Course Contents For Power BI Training
Introduction to Power BI
- Explain Power BI Desktop
- Power BI Desktop – Installation
- Data Sources and Connections
- Connect to Data In Power BI Desktop
- Creating Datasets from Data Models and Data Files
- Getting Started with Power BI
- Using Quick Insights to Explore a Dataset
- Viewing Reports
- Exploring a Dashboard
- History of Power BI
- Web and Other Sources
- Azure and Software as a Service
- Manual Entry
- Azure Blob Storage
- Azure Data lake store
- Azure consumption Insights
- Share point folder
- Query Editor in Power BI
- Renaming Queries
- Combining Queries: Append
- Fixing Metadata
- Filtering Rows
- Eliminating Columns
- Combining Queries: Merge
- Adding a Column
Modeling Data for Analysis
- Creating Relationships
- Defining New Columns
- Performing a Look up to a Related Table
- Translating a Value
Enhancing the Data Model
- Defining Hierarchies
- Configuring Properties
- Defining New Measures
- Reports in Power BI
- Adding Visuals (Charts, Maps etc)
- Slicer Filtering
- Setting Properties
- Drilling Within a Hierarchy
- Custom Visualization in Power BI
Introduction to Power BI Q&A and Data Insights
- Power BI Q&A
- Dashboard vs Reports
- Creating a Dashboard
- Dashboard Tiles
- Pinning Tiles
- Quick Insights with Power BI
- Refreshing Data
- Publishing Datasets
- Refreshing Imported Data
Power BI Integration and Administration
- Data Gateways – Personal and Enterprise
- Content packs
- Power BI Report Server
- Power BI pro Vs Power BI Premium
- Work spaces
Power BI Interview Questions
1). What is self-service business intelligence?
2). What are the parts of Microsoft self-service business intelligence solution?
Excel BI Toolkit – It allows users to create interactive report by importing data from different sources and model data according to report requirement.
Power BI – It is the online solution that enables you to share the interactive reports and queries that you have created using Excel BI Toolkit.
3). What is power BI?
Ans: 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.
4). What is Power BI Desktop?
5). What data sources can Power BI connect to?
Ans: The list of data sources for Power BI is extensive, but it can be grouped into the following:
- Files:Data can be imported from Excel (.xlsx, xlxm), Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
- Content Packs:It is a collection of related documents or files that are stored as a group. In Power BI, there are two types of content packs, firstly those from services providers like Google Analytics, Marketo or Salesforce and secondly those created and shared by other users in your organization.
- Connectorsto databases and other datasets such as Azure SQL, Databaseand SQL, Server Analysis Services tabular data, etc.
6). What are Building Blocks in Power BI?
Ans: The following are the Building Blocks (or) key components of Power BI:
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.
Datasets: Dataset is a collection of data that Power BI uses to create its visualizations.
- Example: Excel sheets, Oracle or SQL server tables.
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.
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.
Tiles: Tile is a single visualization in a report or on a dashboard.
- Example: Pie Chart in Dashboard or Report.
7). What are content packs in Power BI?
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.
Power BI Interview Questions – DAX
8). What is DAX?
DAX works on column values.
DAX can not modify or insert data.
We can create calculated column and measures with DAX but we can not calculate rows using DAX.
Sample DAX formula syntax:
For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount] column in the Sales table.
DAX – Power BI Interview Questions – Edureka
A- Measure Name
B- = – indicate beginning of formula
C- DAX Function
D- Parenthesis for Sum Function
E- Referenced Table
F- Referenced column name
9). What are the most common DAX Functions used?
SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT
IF, AND, OR, SWITCH
ISBLANK, ISFILTERED, ISCROSSFILTERED
VALUES, ALL, FILTER, CALCULATE,
UNION, INTERSECT, EXCEPT, NATURALINNERJOIN, NATURALLEFTEROUTERJOIN,
GEOMEAN, MEDIAN, DATEDIFF
10). How is the FILTER function used?
FILTER is an iterator and thus can negatively impact performance over large source tables.
Complex filtering logic can be applied such as referencing a measure in a filter expression.
FILTER(MyTable,[SalesMetric] > 500)
11). What is special or unique about the CALCULATE and CALCULATETABLE functions?
Ans: 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.
Filter parameters can only operate on a single column at a time.
Filter parameters cannot reference a metric.
12). What is the common table function for grouping data?
Main groupby function in SSAS.
Recommended practice is to specify table and group by columns but not metrics.You can use ADDCOLUMNS function.
New group by function for SSAS and Power BI Desktop; more efficient.
Specify group by columns, table, and expressions.
13). What are some benefits of using Variables in DAX ?
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.
14). How would you create trailing X month metrics via DAX against a non-standard calendar?
CALCULATE function to control (take over) filter context of measures.
ALL to remove existing filters on the date dimension.
FILTER to identify which rows of the date dimension to use.
Alternatively, CONTAINS may be used:
15). What are the different Excel BI add-in?
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.
Power BI Interview Questions – Power Pivot
16). What is Power Pivot?
17). What is Power Pivot Data Model?
18). What is xVelocity in-memory analytics engine used in Power Pivot?
19). What are some of differences in data modeling between Power BI Desktop and Power Pivot for Excel?
Power BI Desktop supports bi-directional cross filtering relationships, security, calculated tables, and Direct Query options.
Power Pivot for Excel has single direction (one to many) relationships, calculated columns only, and supports import mode only. Security roles cannot be defined in Power Pivot for Excel.
20). Can we have more than one active relationship between two tables in data model of power pivot?
21). What is Power Query?
Import Data from wide range of sources from files, databases, big data, social media data, etc.
Join and append data from multiple data sources.
Shape data as per requirement by removing and adding data.
22). What are the data destinations for Power Queries?
Load to a table in a worksheet.
Load to the Excel Data Model.
23). What is query folding in Power Query?
24). What are some common Power Query/Editor Transforms?
25). Can SQL and Power Query/Query Editor be used together?
by the client machine and M function.
Book a Free Demo Today
3rd Floor, Krishna Tower, Outer Ring Road,
Next to Vijaya Bank, Aswath Nagar,
Marathahalli, Bengaluru, Karnataka 560037.
Mob +9188844 54948 |88844 94935
K2K Technologies © 2019 | All Rights Reserved.