Learn PowerBI

Microsoft Power BI can help us to secure reports and workspaces by allowing us to share them to active directory users and groups. We can also share a single report but have users see different data according to their job role. We can configure raw level security by two method  1. Static Method 2. Dynamic Method 1.  Configure row-level security with the static method The static method in row-level security (RLS) uses a fixed value in the DAX filter, while the dynamic method uses a DAX function. RLS involves several configuration steps, which should be completed in the following order: Create a report in Microsoft Power BI Desktop. Import the data. Confirm the data model between both tables. Create the report visuals. Create RLS roles in Power BI Desktop by using DAX. Test the roles in Power BI Desktop. Deploy the report to Microsoft Power BI service. Add members to the role in Power BI service. Test the roles in Power BI service. 2.  Configure row-level security with the ...

DAX is a library of functions and operators that can be combined to build formulas and expression used by Microsoft BI Tools. Dax is also known as function language, where the full code is kept inside a function. We can use DAX 1. Power BI 2. Power Pivot For Excel 3. SSAS Tabular Model 4. Azure Analysis Service By using Data Analysis Expressions (DAX), you can add three types of calculations to your data model: Calculated tables Calculated columns Measures Date tables Date tables are required to apply special time filters known as  time intelligence . A family of DAX functions, known as time-intelligence functions, only work correctly when a date table is set up. When your source data doesn't include a date table, you can create one as calculated tables by using the  CALENDAR  or  CALENDARAUTO  DAX functions. Calculated columns You can write a DAX formula to add a calculated column to any table in your model. The formula is evaluated for each table row and it re...

Dynamic Reports Dynamic reports are reports in which the data can be changed by a developer according to user specifications. Dynamic reports are valuable because a single report can be used for multiple purposes. What If Parameter We can use  what-if   parameters to run scenarios and scenario-type analysis on our data. What-if parameters are powerful additions to our Power BI data models and reports because they enable you to look at historical data to analyze potential outcomes if a different scenario had occurred.  Additionally, what-if parameters can help us look forward, to predict or forecast what could happen in the future. We can use what-if parameters in multiple situations, such as to determine the effect of increased sales to deeper discounts, or to let sales consultants see their compensation if they meet certain sales goals or percentages. Power BI Gateway Gateway software acts like a bridge; it allows organizations to retain databases and other data sources ...

 Star schema design 1. Facts Table The role of a fact table is to store an accumulation of rows that represent observations or events that record a specific business activity.  Facts : Model purpose -It stores  events or observations Table structure - Includes dimension key columns and numeric measure columns that can be summarized Data volume - Typically, contains fewer rows Query purpose - To filter and group 2. Dimension Table Dimension tables describe our business entities, which commonly represent people, places, products, or concepts. A date dimension table, which contains one row for each date, is a common example of a concept dimension table. The columns in dimension tables allow filtering and grouping of fact table data. Facts:  Model purpose -It stores business entity Table structure - Includes a key column and descriptive columns for filtering and grouping. Data volume - Typically, contains fewer rows Query purpose - To filter and group Analytic Queries - ...

Workspace A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, and so on. Workspaces are  used to collaborate and share content with colleagues . We can add colleagues to our workspaces and collaborate on dashboards, reports, workbooks, and datasets. Different roles in workspace The abilities of role types in a workspace include: Admin Add/remove other users Publish, update, and/or share an app in a workspace Create, edit, delete, and publish reports and content in a workspace View and interact with reports and dashboards in a workspace Configure data refreshes Member Can complete all tasks that are associated with admins but can't add or remove users Can not delete the workspace Can not update the metadata about the workspace Contributor Can not add or remove users Cannot publish, update, or edit an app in a workspace unless given this ability by admins/members Can create, update,...

Power BI can help make our job easier and more effective at the same time by converting all that data into charts and graphs to help us visualize our data in meaningful ways. We can view data insights from colorful and compelling visuals instead of just lists and tables. O ur colleagues can work from the same trusted dashboards and reports from a browser or mobile device. Because our data updates and refreshes automatically, we always working with the freshest content. Safely interaction with  content We can explore and interact with our content, filter, slice, subscribe, and export, without affecting the underlying dataset or the original dashboards, reports, or apps. Show data and Export data Use the Show Data feature if we want to view data that Power BI is using to build a visual. The selected visual expands to fill the canvas, and the data displays below or alongside. In addition to showing the data that is used to create a visual, we can also export that data and view it in M...

  Data is the core of Power BI. As we explore reports, each visual draws its underlying data from sources that often contain far more data than we need. Power BI offers several ways to filter and highlight reports. Knowing how to filter data is the key to finding the right information. Slicers A simple type of filtering that we can use directly on the report page is called a  slicer . Slicers provide clues to ways we can filter the results in the visuals on a report page. There are several different types of slicers: numeric, categorical, and date. Slicers make it easy to filter all the visuals on the page at once. Exploring filter pane There are four types of filter 1.      Report  – Applies to all pages in the report. 2.      Page  – Applies to all the visuals on the current report page. 3.      Visual  – Applies to a single visual on a report page. You only see visual level filters if you've selected a visual on th...