The first document GDP, and the data is cleaned then the visualization is done to get insights on the countries' GDP. Using this insight, other plans in terms of investments can be made using this information.
In merging sheets, you should use two unique rows in the instance that the data in them is not the same
- Pivotig can only be done on two columns
- This makes the operation faster - they are ordered in transaction tables made up of dimensions that are static tables
- Merge cells, create index column, create a column, merge cells
- Cardinality data and how to choose based on the data which one suits the project
- Use of tables to carry out the calculations including COUNT(DISTINCT) etc which will be used to obtain the data, don't summarize etc
- difference between visualization tools and the use of tables
- the table, one can be also able to edit
- The mode of aggregation can be changed in the value setting
- every data in the table can be formatted using conditional formatting
- select setting to show just the bars
- visuals iN data using symbols on the charts
- Pie charts - used for showing a percentage (Most commonly used ) Only use it if there is 100%
- Tooltips is used to give additional information
- use of slicers to filter the year data
in visualization when creating slicers, the filter pane after the visualizations pane, should be used to filter the blanks and null sections in the slier. There are three types of filtering namely:
- Basic filtering - normal
- Advanced filtering
- Top N - top values
- how to change the slicer - horizontal
- Removing interactions between the visualization, highlight or filter
- The advanced filter enables the settings to be adapted immediately for syncronisation
- Expand all down enables the data to be narrown b etter than drill
- The use of edit interaction determines whether the two tables will have a relation/connection to them
- Decomposition tree -- determine the aggregation data used -- help the user to analyse that data easier
- Matrix table - enables the visuals to be more in depth and informative
- In the editing of the dashboards, deselect the sync slicers
- Use of buttons for animations using action and tootip for a hover on the animation
- line graphs -- if you have two lines, you can use teh secondary value to enable both to be demonstrated
- using line graphs you can also have the analytica and forecast wich is a prediction
- the code is: iris_id <- iris (# 1. Convert iris to a data.table) iris_id <- setDt(iris_id, keep.rownames= TRUE)[] ( Keep row names (optional) setnames(iris_id, 1,"id") ( Rename the first column to "id") iris_id$id <- as.integer(iris_id$id) (Convert the "id" column to integer (if necessary)
- use of the second code
library(ggplot2) ggplot(data=dataset,aes(x=Sepal.Width, y=Sepal.Length, color=Species)) + geom_point() + geom_smooth() + theme_minimal() --##### use of Q&A IN THE r scripts
- Use of plt.plot (datasets needed then, 'go' -- this returns Os the g-- gives lines as output
- statistical analysis, violin chart is used via the seaborn package
- measure and column diff is the measure is a virtual column
- CALENDARAUTO - i is used in determining the automated dates that may be missing based on the dataset
- DAX LANGUAGE to carry out functions such as SUM, COUNT, COUNTROWS, COUNTBLANK, DISTINCTCOUNT, COUNTA, CONTX, COUNTAX
- COUNTA deals with boolean
-
to enable constant refreshing opf the published reports, there is need for a gateway
-
The steps include: downloading the gateway and connect the Power Bi cloud acount
-
In the data source credentials, ensure all is done including signing in
-
Get quick installs - creates a summary of the report/dataset
-
Creating a dashboard is done via pinning the page or the image
-
Workspaces are used to collaborate with other users
-
this enables filtering so that one person can only view what is relevant to tehm
-
to do this effectively, it is necessary to ensure there is a both way connection in the table
-
use of dynamic row level security to share a diff visualization based on the email address
-
this is done by establishing a security table
-
Heirarchical table
-
How to convert a json table to a detailed table