Power BI is a highly sought after skill for data folks. It makes the process of data analysis simple and easy. If you ever wanted to learn what all the fuss is about, this tweetorial is for you. 🧵
1) What is it? Power BI is a data analysis & visualization software. We can use it to load up and clean any data, analyze it, visualize it and share the outcomes with others easily.
2) How to get it - The Power BI Desktop software is FREE!. Download it from powerbi.micrsoft.com
3) Getting started: You can load up any of your datasets or use the built-in "sample data".
4) How to use it? The Power BI screen is divided into 5 main areas. 1️⃣Ribbon for all features & options 2️⃣ Canvas area for your graphs 3️⃣ Fields panel 4️⃣ Visuals panel for making graphs 5️⃣ to change the view.
5) Making your first visual: Select the visual type from fields panel 3️⃣ and add relevant axis & value fields (X & Y for most graphs). Customize it from Visuals panel 4️⃣. Here is a quick GIF demo 👇
6) Interactions: PowerBI graphs talk to each other🗣👂
If you click on one graph, the others show the relevant bits. See this demo 👇
7) Next steps:
☝ Try it out with your own data. It's easy!
✌ Watch this tutorial for your first 10 minutes -
👌 Read this for more examples & resources - chandoo.org/wp/powerbi-int…
🙏 Fav ❤ and Retweet to share this info with others
• • •
Missing some Tweet in this thread? You can try to
force a refresh
Excel has 100s of functions. Most them are not useful in day to day business setting. Here are the 10 most useful functions based on my 15 years of regular usage.
🧵
1) SUMIFS
Use it to add up values that meet one or more conditions.
=SUMIFS(A1:A100, B1:B100, "NZ", C1:C100, ">20") adds up all values in A1:A100 where column B is NZ and column C is more than 20.
2) XLOOKUP*
Use it to lookup a value and get corresponding value.
=XLOOKUP("Widget10", A1:A100, B1:B100)
looks the code Widget10 in column A and returns the price in column B.
* Works in Excel 365 / Web only