Upgrade to remove ads
Only $35.99/year

ELEC 6 (SEMIS)

Terms in this set (50)

Charts
Allows users to transform tabular data into a graphical representation
Bar Charts
Represent data using horizontal rectangles. They are invaluable for quickly conveying a comparison between values of a series of data
Column Charts
Convey the same information as bar chart, only the orientation is different
Stacked Bar/Column Charts
Display the contribution of each data point to the total value
Line Charts
Provide e a useful means for displaying data over time
Combination Column-Line Chart
Combines the properties of both line charts and column charts. They allow for analyzing trends and comparisons at the same time.
Pie Charts
This is done by expressing the total as a circle, then partitioning it into different slices.
Scatter Charts
Show the relationship between two variables
Bubble Charts
These are a type of scatter chart, in which the size of the data marker corresponds to the value of a third variable. It is a way to plot three variables in two dimensions.
Microsoft Power BI
It is a Self-Service BI Solution developed by Microsoft
Microsoft Power BI
It was first released in 2011 and is now one of the premier BI Solutions in the world, implemented across over 35,000 companies all over the world spanning multiple different industries
Microsoft Power BI
It is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights
1. Power BI Desktop
2. Power BI Service
3. Power BI Mobile App
3 Ways to Access Microsoft Power BI
Power BI Desktop
The application is installed in the local machine, either by using a dedicated installer or downloading from the Microsoft Store
Power BI Service
The application is accessed via the Power BI Portal. The user will need to log on using his/her account and from there access the report creator.
Power BI Mobile App
A free-to-download app where the user can log in using the same account he uses for Power BI Service
Getting Started
In order to start using Power BI Service and its collaboration options, you will need a Power BI Account with a Pro License (this should have already been provided via e-mail).
1. Visualizations
2. Data Sets
3. Reports
4. Dashboards
5. Apps
For a Power BI Business user, there are 5 building blocks they will need to get familiar with:
Visualizations
A type of chart built in Power BI.
Data Sets
A container of data. These can come from a variety of sources, including files and databases.
Reports
One or more pages of interactive visuals, text, and graphics. A single page is often dedicated to answering a central area of interest
Dashboards
A single page that uses visualizations to tell a story. It contains much of the same elements as a Report.
Apps
A way to bundle and share related dashboards and reports together
Content
Collectively, these building blocks are referred to as ________
Designer
(yellow boxes) collects data from a dataset and creates a report. After which, they will publish the findings via creation of dashboards and apps so that the business user (black box) can take action.
Designer
Responsible for the creation of content
Business User
Responsible for its consumption and analysis.
Home
The default screen that appears after logging in
Favorites
You can put a star on certain content to tag it as a _________. Any content that is tagged as such will appear here
Recent
Contains the different content that has been recently accessed
Create
Allows the user to start making reports and other content.
Datasets
Contains s the different datasets that the user has access to
Scorecards
Allows the measurement of achievements towards goals and subgoals.
Apps
Contains the e different Apps that the user has access to
Shared with me
Contains the different reports and dashboards that you are granted access to by other users
Deployment Pipelines
Allows for the management of content creation and deployment.
Learn
A central hub for Power BI Training. Allows the user to access the technical documentation for Power BI.
Workspaces
Contains all the different Workspaces the user has access to. Including the ones they created themselves or assigned to them by other users
My Workspace
A personal workspace for the user. Any content created here can only be accessed by the user and no one else.
Workspace
A place for multiple users to collaborate with each other
CSV Files
Are basically text files that can be opened in Spreadsheet applications like Microsoft Excel.
Lineage View
As teams collaborate and more content is created inside a workspace, it can be a daunting task to keep track of which datasets affect which reports and dashboards. Luckily, there is an option to see this exact information in Power BI Service by using the __________
Reports
Are collections of visualized data. It is the main way of conveying information and analysis of datasets.
Menu Bar
Save the report using the File option, and the ability to change how the report is being viewed, along with allowing the user to insert some other elements in the report
Report Canvas
This is where visualizations are laid out and formatted
Filters Pane
Sets options on limiting the displayed data in the report
Visualizations Pane
Contains two parts:
1. Where the user can select visualizations to put into the Report Canvas.
2. Bottom part is where the properties of the selected visualizations can be changed.
Fields Pane
Contains all the data fields that were in the dataset. Power BI automatically assigns the field names as they appear in the top row of the data source
Page Options
Allows to add, delete, rename, and duplicate pages
Workspace Link
Allows the user to quickly go access the currently selected workspace
Sets found in the same folder