Final Exam: Decision Analyst

WHAT YOU WILL LEARN

• 

  Enable a matrix to drill down to a specific level and then disable the matrix from having a drill-down
  

  apply conditional formatting and add data bars with custom colors to a matrix, then replace the data in a matrix column with data bars
  

  create a slicer and add it to a power bi report and configure the slicer to filter the ui of the report
  

  edit the page view and page theme of a power bi page and optimize a power bi report for display on mobile devices using the mobile phone layout feature
  

  create a treemap control to visualize data from a matrix, configure the color scheme of a treemap, and edit the data contained within the treemap
  

  configure a treemap control to use another page as a custom tooltip
  

  retrieving data. wait a few seconds and try to cut or copy again.
  

  define the aesthetics of a tableau chart to make it easier to analyze
  

  import xml data to power bi, filter it, and change the data type
  

  install power bi from microsoft store and import data to it from an excel file
  

  recognize the different ways in which hierarchy definitions could lead to incorrect visualizations
  

  configure the appearance of a map and explore the use of map layers
  

  embed an interactive web page, navigation button, and text label in a dashboard
  

  combine files in an imported folder and perform basic data cleaning operations using power bi's ui and advanced editor
  

  import xml data to power bi, filter it, change the data type, and find and delete rows with errors
  

  enrich your visualizations by conveying additional information using text
  

  create a relationship between two tables in power bi and enable automatic detection of these relationships
  

  portray different characteristics of your data by using a variety of charts available in tableau
  

  create and edit a line chart in power bi by adding and configuring data labels, legends, markers, gridlines, and other chart elements
  

  edit a slicer so that all the options are represented by boxes to be selected, configure the slicer so that it can only have one item selected at a time, and create a range slider
  

  perform some basic data cleaning on your datasets using the tableau data interpreter
  

  enable users to drill down in your visualizations by arranging related fields in a hierarchy
  

  configure the filters pane in power bi to automatically filter based on the specified filter value
  

  use power bi to build and edit stacked line charts, configure aspects of them, such as the legend and axes, and create a basic filter in the filters pane
  

  illustrate different characteristics of your data by using a variety of charts available in tableau
  

  plot the changes in your data over time by using the pages feature
  

  create a dashboard and explore the various layouts available for the placement of objects such as charts
  

  load data from a variety of file types into tableau to perform an analysis
  

  analyze information in multiple data tables related to one another
  

  manually create and edit relationships between tables
• 

  generate a basic visualization to analyze categories of data
  

  analyze your data at a higher level and drill down to a lower level
  

  convey information from multiple fields in your dataset using a variety of markers
  

  download the public version of tableau and install it on your machine
  

  edit the aesthetics of a bar chart, changing the color, display units, orientation, height, width, and more
  

  recognize the properties of your data to choose the appropriate visualizations for analysis
  

  plot country-related information on a tableau map
  

  gather detailed information from tableau charts by interacting with them
  

  analyze your data at a higher level and drill down to a lower level based on a date field
  

  create bar charts in power bi, sort the values visualized in them, and edit the operations power bi performs on the visualized data
  

  prepare your data for visualization by applying transformations, which are more meaningful for data analysis
  

  perform various advanced power query operations, such as removing columns and top n and error rows, performing row filtering operations, and creating grouped bar charts
  

  perform operations in power bi using the ui and the advanced editor to sort data, change data types, rename columns, and use uppercase text
  

  develop a story to convey information in the form of visualizations by assembling charts and a dashboard
  

  set the aesthetics of a dashboard and include an option for the user to download the dashboard to a local file
  

  perform operations in power bi to remove columns and top rows, split columns by delimiter, filter rows, and delete a query
  

  use power query to create conditional calculated columns usingif-else-elif blocks and custom calculated columns using formulas to determine values
  

  use the power bi report view to visualize data that has been imported from an excel spreadsheet and instantiate a matrix visualization in the report view
  

  explore the use of map layers
  

  generate multiple charts based on the same dataset for use in a dashboard
  

  experiment many: many table relationships
  

  group related elements in your visualizations
  

  create a slicer and add it to a power bi report and configure the slicer to filter the ui of the report
  

  create a column calculated from a formula using a new measure
  

  perform sort operations on the rows and drill-down and drill-up operations on the rows and columns of matrix visualizations
  

  create basic and advanced filters in power bi to filter data using a condition on one or more columns
  

  create a foreign key relationship (a.k.a., a referential integrity constraint) between two tables in power bi
  

  gather together related elements in your visualizations using groups
  

  experiment with 1:1, many: many, 1:many, and many:1 table relationships and create relationships among tables by dragging and dropping columns
  

  import json data into power bi and use power query to convert json data into tabular data and change the column data types