Sachin Kumar Profile picture
Mar 10 โ€ข 13 tweets โ€ข 8 min read
How should you ๐ฅ๐ž๐š๐ซ๐ง ๐๐จ๐ฐ๐ž๐ซ ๐๐ˆ? ๐Ÿš€

๐Ÿงต
It's easy to be overwhelmed by how broad #PowerBI is๐Ÿ˜–

If you're starting out, here's the path I recommendโฌ
๐Ÿ“Š ๐ƒ๐š๐ญ๐š ๐Œ๐จ๐๐ž๐ฅ๐ข๐ง๐ 
Begin by learning to organize data into tables, create relationships, and add calculated columns and measures.

This is the most important part of your journey, as understanding the #data is always the first step in Power BI development.
- Introduction to Data Modelling: lnkd.in/diBjpSwf
- MS Learn: Modelling: lnkd.in/dkNcrbdv
- #PowerBI Guidance Documentation (first 9 pages):
lnkd.in/dW4cmjSx
๐Ÿ‘€ ๐ƒ๐š๐ญ๐š ๐•๐ข๐ฌ๐ฎ๐š๐ฅ๐ข๐ณ๐š๐ญ๐ข๐จ๐ง
Here, you'll learn how to create effective charts, tables, and other #visualizations, and develop your design and layout skills.

Here, it's really about testing the tool, and learning what different visuals can do for you.
- MS Learn: Visualizations: lnkd.in/dRdgs47F
- Chart Guide: lnkd.in/daAxbQBx
๐Ÿ” ๐ƒ๐€๐— ๐ฅ๐š๐ง๐ ๐ฎ๐š๐ ๐ž
Learn to work with functions, syntax, and context, and create calculated tables.

- Introduction to DAX: lnkd.in/diBjpSwf
- Explanations on each function : dax.guide
๐Ÿงฐ ๐ƒ๐š๐ญ๐š ๐“๐ซ๐š๐ง๐ฌ๐Ÿ๐จ๐ซ๐ฆ๐š๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐๐จ๐ฐ๐ž๐ซ ๐๐ฎ๐ž๐ซ๐ฒ
Power #Query is a powerful tool for cleaning, transforming, and shaping data.

Learn merging #queries, unpivoting data, and creating custom functions.
- Beginner's guide: lnkd.in/dS9crJms
- MS documentation: lnkd.in/dDrDfytF
๐ŸŽจ ๐€๐๐ฏ๐š๐ง๐œ๐ž๐ ๐•๐ข๐ฌ๐ฎ๐š๐ฅ๐ข๐ณ๐š๐ญ๐ข๐จ๐ง ๐“๐ž๐œ๐ก๐ง๐ข๐ช๐ฎ๐ž๐ฌ
Custom visuals, working with themes, and incorporating interactive features like drill-through and slicers.

- My ๐Ÿ“ฝ๏ธ on Custom Visuals: lnkd.in/dxUbzMTx
- Themes and backgrounds: lnkd.in/dU8_SNxc
โœ…Guys It's my Linkedid Profile , Follow for more -
linkedin.com/in/sachintukumโ€ฆ
โœ…Guys Please Check my #Github ID for Data Analyst Projects ๐Ÿ˜

github.com/sachinkumar160โ€ฆ

โ€ข โ€ข โ€ข

Missing some Tweet in this thread? You can try to force a refresh
ใ€€

Keep Current with Sachin Kumar

Sachin Kumar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sachintukumar

Mar 12
Top 25 SQL Interview Questions and Answers

๐Ÿงต
There are certain SQL concepts which you should be familiar with if you plan to attend an #SQL interview. No matter which RDBMS you use wether it is MySQL, Oracle, Microsoft SQL Server, #PostgreSQL or any other, these SQL concepts are common for all of the popular RDBMS.
Read 5 tweets
Mar 12
Are you a wine enthusiast? If you are, then youโ€™ve probably heard of Wine Magazine.

๐Ÿ”ฅLet us solve one of the Advanced SQL interview questions on RANK function.

๐Ÿงต
โ“ Question is taken from Wine Magazine that involves clauses like PARTITION BY, UNION ALL, CASE statements, and Window functions.

We will use a 3-step framework to solve the problem that can be used to solve any coding problem.
Find the cheapest and the most expensive variety in each region. Output the region along with the corresponding most expensive and the cheapest variety. Be aware that there are 2 region columns, the price from that row applies to both of them.
Read 6 tweets
Mar 10
โ–ถ๏ธPractice Writing SQL Queries using Real
Dataset ๐Ÿ’ฏ

๐Ÿงต
โ€œThe very first thing, we must do when writing #SQL queries, is to understand the underlying data. Once we understand the data and how this data is stored across different tables, it becomes much simpler to write SQL #Queries to retrieve any information from that dataโ€
โœ…List of SQL Queries:

We shall write SQL #Queries using this data. For each of these queries, you would find the problem statement and then the screen shot of the expected output. Under each of these 20 problem statement
Read 9 tweets
Mar 8
๐Ÿ‘จโ€๐Ÿ’ป 10 different ways to remove duplicate records in SQL

๐Ÿงต
1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
Read 4 tweets
Mar 6
6 Must have line charts for business data analysis ๐Ÿ“ˆ๐Ÿ‘Œ ๐Ÿ’ฏ

๐Ÿงต
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
โ–ถ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
Feb 19
๐Ÿš€ You can become a data analyst in 90 days without spending a cent! Yes, you heard that right.

With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)

๐Ÿงต
Learn Excel - Time : 12 days
๐ŸŽ™๏ธ Tutorials -
lnkd.in/eWmC2vf8
๐Ÿ—๏ธ Projects -
lnkd.in/ew5y5KP7
Learn Basic Statistics - Time : 3 days
๐ŸŽ™๏ธ Tutorials -
lnkd.in/emKawHBs
Read 10 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(