Data Analytics
前往频道在 Telegram
Perfect channel to learn Data Analytics Learn SQL, Python, Alteryx, Tableau, Power BI and many more For Promotions: @coderfun @love_data
显示更多📈 Telegram 频道 Data Analytics 的分析概览
频道 Data Analytics (@sqlspecialist) 英语 语言赛道中的 是活跃参与者。目前社区聚集了 109 775 名订阅者,在 技术与应用 类别中位列第 1 114,并在 印度 地区排名第 2 321 位。
📊 受众指标与增长动态
自 невідомо 创建以来,项目保持高速增长,吸引了 109 775 名订阅者。
根据 29 六月, 2026 的最新数据,频道保持稳定运转。过去 30 天订阅人数变化为 523,过去 24 小时变化为 6,整体触达仍然可观。
- 认证状态: 未认证
- 互动率 (ER): 平均受众互动率为 2.41%。内容发布后 24 小时内通常能获得 1.49% 的反应,占订阅者总量。
- 帖子覆盖: 每篇帖子平均可获得 2 646 次浏览,首日通常累积 1 630 次浏览。
- 互动与反馈: 受众积极参与,单帖平均反应数为 7。
- 主题关注点: 内容集中在 row, sql, analytic, analyst, visualization 等核心主题上。
📝 描述与内容策略
作者将该频道定位为表达主观观点的平台:
“Perfect channel to learn Data Analytics
Learn SQL, Python, Alteryx, Tableau, Power BI and many more
For Promotions: @coderfun @love_data”
凭借高频更新(最新数据采集于 30 六月, 2026),频道始终保持新鲜度与高覆盖。分析显示受众积极互动,使其成为 技术与应用 类别中的关键影响点。
109 775
订阅者
+624 小时
+1717 天
+52330 天
帖子存档
109 799
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.
109 799
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.
109 799
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
109 799
Now that you have gained all the right skills, you need to showcase your skills and stand out from others to land a job. Projects and Portfolios will do that for you, so invest an ample amount of time in preparing these. You can find enough and more datasets in Kaggle for doing projects. Do a bit research and start working on it. Once its done, prepare an insightful resume and start applying for jobs and internships.
109 799
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
109 799
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
109 799
Don't focus on learning too many things from multiple resources at a time. That's why i am sharing only limited resources ✅
109 799
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
109 799
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
109 799
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
109 799
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
现已上线!2025 年 Telegram 研究 — 年度关键洞察 
