Data Analytics

1.How to create filters in Power BI? Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways. Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries. Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters) 2.How to sort data in Power BI? Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available. 3.How to convert pdf to excel? Open the PDF document you want to convert in XLSX format in Acrobat DC. Go to the right pane and click on the “Export PDF” option. Choose spreadsheet as the Export format. Select “Microsoft Excel Workbook.” Now click “Export.” Download the converted file or share it. 4. How to enable macros in excel? Click the file tab and then click “Options.” A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.” Go to the “Macro Settings” and select “enable all macros.” Click OK to apply the macro settings.

1.What is quick filter in tableau? Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet. 2.How to calculate percentage in tableau? To calculate the percentage of data on your worksheet. Go to Analysis pane and select Percentages of, there you will see a lot percentage options such as percentage of table, column, row, pane, row in pane, column in pane and cell. Select any of the above options then define the total value o which percentage is to be calculated. The option you choose will be uniform to all the rows and columns and there is no way to specify different options to rows and columns. 3. What is Power Pivot? The Power Pivot is an in-memory data modeling component. It provides highly compressed data storage with fast calculation. It helps you build a data model, relationships, creating formulas, calculated columns, Pivot Tables, and Pivot Charts from multiple resources. 4. What is x-velocity in Power Pivot? X-Velocity is the in-memory analytics engine behind Power Pivot that loads and handles huge data in Power BI. It stores data in columnar storage that results in faster processing.

Python Deep Learning Second Edition 👇 book

Data Analyst Resume Template- https://www.dayjob.com/downloads/CV_examples/data_analyst_CV_template.pdf Kaggle exploratory data analysis * Notebooks: https://www.kaggle.com/notebooks * Datasets: https://www.kaggle.com/datasets Project ideas: Alex the Analyst Portfolio Project Series: https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&t=0s

Free Resources for Numpy and Pandas: Codebasics Numpy playlist:  https://www.youtube.com/playlist?list=PLeo1K3hjS3uset9zIVzJWqplaWBiacTEU Codebasics pandas playlist (first 9):  https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy Freecodecamp matplotlib playlist:  https://youtu.be/3Xc3CA655Y4 Seaborn tutorials:  https://youtu.be/GcXcSZ0gQps Pandas for beginners https://t.me/datasciencefun/660 Numpy for beginners https://t.me/datasciencefree/156

Free Resources for Python Codebasics python tutorials (first 16) —  https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0 Practice Python course https://dabeaz-course.github.io/practical-python/Notes/Contents.html Codebasics python HINDI tutorials —  https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO Useful Python resources for beginners https://t.me/programming_guide/8 Python 3 Book for beginners https://t.me/pythondevelopersindia/272?single

Don't focus on learning too many things from multiple resources at a time. That's why i am sharing only limited resources ✅

Free Resources to learn BI tools: Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9 Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ Tableau Book https://t.me/sqlspecialist/51 Power BI Book https://t.me/sqlspecialist/85

SQL Cheatsheet https://www.sqltutorial.org/wp-content/uploads/2016/04/SQL-cheat-sheet.pdf Free Resources to learn SQL: kudavenkat playlist (first 16): https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB khanacademy SQL course: https://www.khanacademy.org/computing/computer-programming/sql SQL Book for Beginners https://t.me/sqlspecialist/52

Resources for Advanced Excel: Datacamp course:  https://learn.datacamp.com/skill-tracks/spreadsheet-fundamentals?version=1 Chandoo’s youtube channel:  https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA Free Excel Book https://t.me/sqlspecialist/87

FREE Resources to learn Statistics 👇👇 Khan academy:  https://www.khanacademy.org/math/statistics-probability Khan academy YouTube:  https://www.youtube.com/playlist?list=PL1328115D3D8A2566 Statistics by Marin :  https://www.youtube.com/playlist?list=PLqzoL9-eJTNBZDG8jaNuhap1C9q6VHyVa Statquest YouTube channel:  https://www.youtube.com/user/joshstarmer Free Statistics Books http://www.sherrytowers.com/cowan_statistical_data_analysis.pdf https://t.me/sqlspecialist/90

Data Analyst Roadmap