Final Exam: Decision Analyst
- 1 Video | 32s
- Includes Assessment
- Earns a Badge
Final Exam: Decision Analyst will test your knowledge and application of the topics presented throughout the Decision Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
WHAT YOU WILL LEARN
enable a matrix to drill down to a specific level and then disable the matrix from having a drill-downapply conditional formatting and add data bars with custom colors to a matrix, then replace the data in a matrix column with data barscreate a slicer and add it to a Power BI report and configure the slicer to filter the UI of the reportedit 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 featurecreate a treemap control to visualize data from a matrix, configure the color scheme of a treemap, and edit the data contained within the treemapconfigure a treemap control to use another page as a custom tooltipRetrieving data. Wait a few seconds and try to cut or copy again.define the aesthetics of a Tableau chart to make it easier to analyzeimport XML data to Power BI, filter it, and change the data typeinstall Power BI from Microsoft Store and import data to it from an Excel filerecognize the different ways in which hierarchy definitions could lead to incorrect visualizationsconfigure the appearance of a map and explore the use of map layersembed an interactive web page, navigation button, and text label in a dashboardcombine files in an imported folder and perform basic data cleaning operations using Power BI's UI and Advanced Editorimport XML data to Power BI, filter it, change the data type, and find and delete rows with errorsenrich your visualizations by conveying additional information using textcreate a relationship between two tables in Power BI and enable automatic detection of these relationshipsportray different characteristics of your data by using a variety of charts available in Tableaucreate and edit a line chart in Power BI by adding and configuring data labels, legends, markers, gridlines, and other chart elementsedit 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 sliderperform some basic data cleaning on your datasets using the Tableau data interpreterenable users to drill down in your visualizations by arranging related fields in a hierarchyconfigure the filters pane in Power BI to automatically filter based on the specified filter valueUse 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 paneillustrate different characteristics of your data by using a variety of charts available in Tableauplot the changes in your data over time by using the Pages featurecreate a dashboard and explore the various layouts available for the placement of objects such as chartsload data from a variety of file types into Tableau to perform an analysisanalyze information in multiple data tables related to one anothermanually create and edit relationships between tables
generate a basic visualization to analyze categories of dataanalyze your data at a higher level and drill down to a lower levelconvey information from multiple fields in your dataset using a variety of markersdownload the public version of Tableau and install it on your machineedit the aesthetics of a bar chart, changing the color, display units, orientation, height, width, and morerecognize the properties of your data to choose the appropriate visualizations for analysisplot country-related information on a Tableau Mapgather detailed information from Tableau charts by interacting with themanalyze your data at a higher level and drill down to a lower level based on a date fieldcreate bar charts in Power BI, sort the values visualized in them, and edit the operations Power BI performs on the visualized dataprepare your data for visualization by applying transformations, which are more meaningful for data analysisperform various advanced Power Query operations, such as removing columns and Top N and error rows, performing row filtering operations, and creating grouped bar chartsperform operations in Power BI using the UI and the Advanced Editor to sort data, change data types, rename columns, and use uppercase textdevelop a story to convey information in the form of visualizations by assembling charts and a dashboardset the aesthetics of a dashboard and include an option for the user to download the dashboard to a local fileperform operations in Power BI to remove columns and top rows, split columns by delimiter, filter rows, and delete a queryuse Power Query to create conditional calculated columns usingif-else-elif blocks and custom calculated columns using formulas to determine valuesuse the Power BI Report View to visualize data that has been imported from an Excel spreadsheet and instantiate a matrix visualization in the report viewexplore the use of map layersgenerate multiple charts based on the same dataset for use in a dashboardexperiment Many: Many table relationshipsgroup related elements in your visualizationscreate a slicer and add it to a Power BI report and configure the slicer to filter the UI of the reportcreate a column calculated from a formula using a new measureperform sort operations on the rows and drill-down and drill-up operations on the rows and columns of matrix visualizationscreate basic and advanced filters in Power BI to filter data using a condition on one or more columnscreate a foreign key relationship (a.k.a., a referential integrity constraint) between two tables in Power BIgather together related elements in your visualizations using groupsexperiment with 1:1, Many: Many, 1:Many, and Many:1 table relationships and create relationships among tables by dragging and dropping columnsimport JSON data into Power BI and use Power Query to convert JSON data into tabular data and change the column data types
IN THIS COURSE
1.Decision Analyst33sUP NEXT
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platformDigital badges are yours to keep, forever.