Tech stack of Data Analyst

3 Must-Learn Topics to Launch Your Data Analytics Career 📊

• SQL 💾
• Excel 📈
• Power BI 📊

Pro tip: Master these fundamentals, then expand your toolkit.

Everyone wants to jump to advanced topics, but these are your REAL foundation.

Start here. Crush it. 💪

#DataAnalytics

Don't stress too much on which tools to learn first.

Pickup 2-3 tools and master them. Skills are transferable.

For eg- If you can create an amazing dashboard in Power BI, you can make similar impressive dashboard in Tableau as well.

If you can run efficient queries in MySQL, it's going to be nearly same in PostgreSQL as well.

If you can manipulate fields in Excel, you can do the same stuff in Google Sheets as well.

Continuity is the key 😄

Never stop Learning ❤️

5 Data Analysis Projects ✅

Exploratory Data Analysis ( EDA)

3 Pillars of Data Analytics :

• Technical Skills :

- SQL
- Excel
- PowerBi

• Verbal Communication :

- Presentation
- Data Storytelling
- Stakeholder Analysis

• Written Communication :

- Reverse Brief
- Project Scoping
- Technical Documentation

Master these 3 pillars and you will become a great Data Analyst.

Hey guys,

Here is the list of best curated Telegram Channels for free education 👇👇

Free Courses with Certificate

Web Development Free Resources

Data Science & Machine Learning

Programming Free Books

Python Free Courses

Python Interview Resources

Ethical Hacking & Cyber Security

English Speaking & Communication

Stock Marketing & Investment Banking

Coding Projects

Jobs & Internship Opportunities

Learn Digital Marketing

Crack your coding Interviews

Udemy Free Courses with Certificate

Earn $10000 with ChatGPT

Google Jobs

Java Programming Free Resources

Learn Blockchain & Crypto

Data Analyst Jobs

Artificial Intelligence

Free access to all the Paid Channels
👇👇
https://t.iss.one/addlist/4q2PYC0pH_VjZDk5

Do react with ♥️ if you need more content like this

ENJOY LEARNING 👍👍

Data Analysis Interview Questions and Answers
👇👇

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.

————————————————————-

ENJOY LEARNING 👍👍

Join Biggest Telegram channel for data analysts
👇👇
https://t.iss.one/sqlspecialist