Power BI
Features of Power BI
1. transform data into visuals and share 2. allows users to explore and analyze data from many sources 3. Display dashboard or reports on multiples devices. 4. low to no coding 5. low cost per user. 6. range of power bi tools 7. anyone that can use excel can use it.
Why are you interested in Power BI? What makes you think that Power BI would be a great career option?
A cloud-based data reporting and visualization tool, Power BI makes it possible for users to generate reports online. Once reports are generated, users can share them with their colleagues in their workplace. This aspect of Power BI makes it quite popular among business users. And therefore, Power BI is both an interesting and promising career option.
What is Advanced Editor in Power BI?
Advanced Editor can be used to see the query that Power BI runs against data sources to import data. The query is written in M-code, the Power Query Formula Language
What is Bidirectional Cross-filtering in Power BI?
Bidirectional cross-filtering in Power BI Desktop allows data modelers to determine how they want filters to flow for data using relationships between tables. With bidirectional cross-filtering, the filter context is propagated to a second related table on the other side of a table relationship. This can help data modelers solve the many-to-many problem without writing complicated DAX formulas. Thus, bidirectional cross-filtering simplifies the job for data modelers.
What is Power BI?
Business Intelligence and Data visualization tool that allows us to covert data from various sources and create interactive reports and dashboards.
Why should General Formatting be applied to data in Power BI?
By formatting data, users can help Power BI categorize and identify data, making it much easier to work with. Enter a custom formula to create a new column, including calculations using values from the other columns To create a new column, click on Add Custom Column In the new column name box, type the name of the column and add the formula to the custom column formula box; for example, [ShipDate] - [OrderDate] Select a column from the available columns list and click on Insert or double-click to add it to the custom column formula text box. Then, click on OK The new column is appended to the table, and the formula is visible in the Formula Bar
What do you know about Power BI Query Editor?
By using Power BI Query Editor, users can load data from a wider number of data sources and apply transformations on them, including adding new columns and measures.
Explain what a calculated column is and why you would use it.
Calculated columns are a type of DAX function used to efficiently add data to a table in Excel. They're computed during a model's processing phase and evaluated for each row. In my previous role, we used calculated columns frequently to add new data to our existing models and to enter formulas more efficiently."
Other tools
Called power platform 1. Power Bi 2. Microsoft flow - workforce automation 3. power apps - rapid development application, allows communication/ critiquing.
What are Power BI content packs?
Content packs provide a way to share Power BI objects, such as reports, datasets, or dashboards with individuals within your organization. The sharing takes places on the Power BI website and can be shared with just one individual or with multiple groups.
. What is DAX? What are the benefits of using variables in DAX?
Data Analysis Expressions It is a formula language that is used to perform basic calculations and data analysis on the data in Power Pivot. Also, it is used to compute calculated columns, calculated fields, and measures.
How can we filter data in Power BI?
Data can be filtered using various filters that are available in Power BI, implicitly. There are basically three types of filters, namely, Page-level filters, Drillthrough filters, and Report-level filters.
Have you ever refreshed data reports on the Cloud? Can you explain how?
In my last job, I worked on a project that required me to refresh data after the upload. At the time, I used the Power BI Personal Gateway to access and refresh content. The Data Management Gateway has the same capability
What is Power Pivot Data Model?
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.
How are relationships defined in Power BI Desktop?
Manually: Users can manually define relationships between tables using primary and foreign keys. With the autodetect feature: When enabled, this inherent feature of Power BI detects relationships between tables and creates them automatically.
What gateways are available in Power BI and why use them?
Personal Gateway: Data can be imported and valid on Power BI Service only. Also, this gateway can only be used by a single person. On-premises Gateway: This gateway is the advanced form of Personal gateway. It supports Direct Query, and multiple users can use this for refreshing data.
What is Power BI Designer?
Power BI Designer empowers users to create intuitive reports and dashboards, easily and quickly, and also lets users change visual views of their data at fingertips for better analytics and informed decision-making.
versions of PBI
Power BI Desktop: The on-premise version for Windows 10 Power BI Service: For publishing to the cloud Mobile Power BI: For mobile users Gateway: depending on data location. on premises or cloud
What is Power Pivot?
Power Pivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook. It lets you create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts. You can then further analyze the data so that you can make timely business decisions without requiring IT assistance.
What is Power Query?
Power Query is an ETL tool, meaning that it's used for extracting, transforming and loading data. It helps import data from multiple sources, and it allows you to join, append and shape this data.
What is Row-level Security?
Row-level security restricts the data that a user can view and has access to, based on filters.
What is SQL and how does it work?
SQL stands for Structured Query Language. A query language is a kind of programming language that's designed to facilitate retrieving specific information from databases - update data on a database, or retrieve data from a database
What is self-service business intelligence?(SSBI)
SSBI is an approach to data analytics that enables business users to filter, segment, and, analyze their data, without the in-depth technical knowledge in statistical analysis, business intelligence (BI). Anybody who has a basic understanding of the data can create reports to build intuitive and shareable dashboards.
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,SUMMARIZECOLUMNS, ISEMPTY, VAR (Variables) GEOMEAN, MEDIAN, DATEDIFF
What are the most common data shaping techniques?
The most common data shaping techniques are: Removing Columns and Rows Adding Indexes Applying a Sort Order
major components of Power BI?
There are five different components of Power BI. -Power Pivot: Fetches and cleans data and loads on to Power Query -Power Query: Operates on the loaded data -Power Q&A: Makes it possible for users to interact with reports using simple English language -Power View: Lets users create interactive charts, graphs, maps, and other visuals -Power Map: Enables the processing of accurate geographic locations in datasets
What is the prerequisite for connecting to a database in Azure SQL Database?
There is only one prerequisite for this. Before connecting to a database in Azure SQL Database, users should configure firewall settings to allow remote connections.
How can geographic data be mapped into Power BI Reports?
Through map chart and filled map chart, Power BI makes it possible for users to visually map geographic data, both globally and regionally. Power BI integrates with Bing Maps to find default coordinates for locations in a process known as geocoding. This integration means that users do not need to provide longitude and latitude coordinates.
What happens when you click on a single data point in one of the multiple visuals in a report?
When we do that, data gets selected and copied to the clipboard. Further, the copied data can be pasted anywhere as per the requirement of the user.
Is it possible to refresh Power BI Reports after they are published to the cloud?
Yes, it is possible. Gateways can be used to do so. For SharePoint: Data Management Gateway For Powerbi.com: Power BI Personal Gateway
What is z-order in Power BI?
Z-order is a design strategy that is used for arranging visuals over shapes. Also, z-order can be defined as an implementation method that can be applied when reports have multiple elements.
What is the difference between Calculated Columns, Calculated Tables, and Measures?
column - Added to tables by applying DAX formula on the existing data Measures - Use other DAX functions to create complex calculations
steps
getting data data modeling - power query data visualization
In your own words, what are the advantages of the Direct Query method?
n my experience, I've found that I can build massive datasets using Direct Query. For example, it was helpful when working with a large hotel membership database. Normally, Power BI only supports smaller sets, but using this, I can include as much data as necessary for my objective."