Categories
|
Tableau
|
Power BI
|
Start by Importing the Data |
Launch Tableau, proceed further to tap on “Connect,” and choose the data source (SQL Server, Excel, etc.). This will load your dataset. |
Open Power BI, and navigate to the “Get Data” button. This will load the dataset further. |
Prepare Your Data |
Upon loading the data, select the “Data Source” option to clean the data by changing data types or filtering out unnecessary data. |
Next up, type “Query Editor” to clean your recorded data. This can effectively eliminate duplicates, format data types, and filter rows. |
Filtering Out Your Data |
Navigate further to choose the “Filters” tab, allowing you to focus on relevant data only. |
Utilize the “Filters” option on the right side of the screen to add impressive visualizations. |
Generate Calculated Fields |
It’s time to implement KPI metrics, by right-clicking in the data pane to choose “Create Calculated Field.” Here, input the formula to create a custom calculation. |
Next, in the “Modeling” option, choose any of the options – “New Measure” or “New Column” to generate custom calculations by utilizing Data Analysis Expressions (DAX). This option allows you to tailor metrics based on your audience preferences. |
Sign Up for Appropriate Visualization |
Drag your opted fields into the “Columns” or “Rows” to generate engaging visualizations. Here you can also select varied options like line graphs, bar charts, pie charts, etc. |
Here, drag fields into the areas like “Axis”, “Values”, and “Legend” accessible in the visualizations pane. After this, choose your visualization type for optimum results. |
Options for Customizing Visualizations |
In Tableau, choose the option “Marks” to change labels and colors. |
Use the option “Format” from the visualization pane to edit fonts, tooltips, colors, and more to tailor the visualization. |
Develop a Dashboard |
Search for the “New Dashboard” option and tap on it. Now, drag and drop your chosen visualizations and arrange them onto the dashboard. |
Add multiple visualizations in Power BI and arrange them according to the accessibility of the most critical data. |
Publish Your Report |
After completing the dashboard, hit “File”, then “Save to Tableau”, and lastly, hit the button “Publish to Tableau Server.” |
Finally, tap on “File”, and then choose “Publish” to upload your final report. |