Top products from r/PowerBI
We found 30 product mentions on r/PowerBI. We ranked the 22 resulting products by number of redditors who mentioned them. Here are the top 20.
1. Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)
Sentiment score: 2
Number of reviews: 3
2. Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
Sentiment score: 3
Number of reviews: 3
Holy Macro Books
3. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Sentiment score: 1
Number of reviews: 2
4. What Does Your Data Say?: With Conversation-Centric Design™
Sentiment score: 1
Number of reviews: 1
5. Information Dashboard Design: The Effective Visual Communication of Data
Sentiment score: 0
Number of reviews: 1
Discounted
6. Storytelling with Data: A Data Visualization Guide for Business Professionals
Sentiment score: 1
Number of reviews: 1
7. Information Dashboard Design: Displaying Data for At-a-Glance Monitoring
Sentiment score: 0
Number of reviews: 1
Analytics Press
8. What Does Your Data Say?: With Conversation-Centric Design
Sentiment score: 1
Number of reviews: 1
9. Good Charts: The HBR Guide to Making Smarter, More Persuasive Data Visualizations
Sentiment score: 1
Number of reviews: 1
Good Charts The HBR Guide to Making Smarter More Persuasive Data Visualizations
10. Supercharge Power BI: Power BI Is Better When You Learn to Write DAX
Sentiment score: 1
Number of reviews: 1
11. Start with Why: How Great Leaders Inspire Everyone to Take Action
Sentiment score: 0
Number of reviews: 1
Start with Why How Great Leaders Inspire Everyone to Take Action
12. Analyzing and Visualizing Data by Using Microsoft Power BI Exam Ref 70-778
Sentiment score: 0
Number of reviews: 1
13. Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference)
Sentiment score: 0
Number of reviews: 1
Microsoft Press
14. Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)
Sentiment score: 2
Number of reviews: 1
Microsoft Press
16. Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
Sentiment score: 1
Number of reviews: 1
17. Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
Sentiment score: 1
Number of reviews: 1
18. The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Sentiment score: 0
Number of reviews: 1
WILEY
My journey started back in ~2012 and since then I've read every blog post from all SME's on the topic/related topics, so it's difficult to answer your last question but I'll try: becoming comfortable in this space, I would guess, is about a 60/40 split between: (1) physically using these tools to gain a competent understanding of how they work; and (2) following industry articles/studying to expand your knowledge and keep up with the fast changing pace of this technology.
Regarding your first question - if I were to master "Power BI" all over again, then I would do two things:
I deliver DIAD training all over the US. I’m also a Power BI MVP. My fellow mentors are on the road all the time, helping others on their data journey. Business intelligence is so much more than reporting and if all you are doing is moving a spreadsheet to a webpage, you are missing the value.
The DIAD has a very specific purpose to introduce people to Power BI and show off the features. In my opinion, it doesn’t replace the need for training or for our Managed Community of Practice services.
Let me outline the journey and why trying to get all of this via YouTube might not be the most efficient way to learn.
To use an analogy, the DIAD teaches you the parts of the boat. Our training classes teach you how to sail the boat. Our Managed Community of Practice service helps you to become a master sailor. Our Executive Seminars help your captains learn about the sea and to determine what benefits they get from “going to sea.” Our Conversation-Centric training helps you learn how to read the charts and determine your destination.
We released a book recently from our CCD classroom training materials, called “What Does Your Data Say?” It’s designed to help people think about what questions to answer.
https://www.amazon.com/What-Does-Your-Data-Conversation-Centric-ebook/dp/B07VFRMXSL
We’ve partnered with ManyWorlds.com to help companies go farther and turn data into learning and then into action. Learning faster than others is the only true competitive advantage. Their book describing the Data to Learning to Action process is here:
https://www.amazon.com/Optimizing-Data-Learning-Action-Performance-ebook/dp/B07CBMKMM5
Just knowing where to click is the beginning, not the journey. As you can see, there’s a lot of stuff to learn to be truly effective.
I’ll be conducting a DIAD in Dallas, TX on Sept 30. If you are interested in attending, shoot me a line via our contact form at https://marqueeinsights.com I’d love to meet more of the folks on this sub.
I’ll be discussing some of the “how to sail” aspects in the DIAD and we can do a AMA dinner afterward.
Hope this helps.
I regularly work with both, out internal reports are on report server and our client reports are on the cloud service. There really isn't any training, but I'm not convinced that you need any training for report development differences.
If you are in a position to manage resources or in an admin role, there is a good bit to learn.
There is a pretty good book on power bi architecture [link|https://www.amazon.com/dp/1484240146/ref=cm_sw_r_cp_apa_i_hkLEDbCTCNS41] that is a good starting place- but for the most part it's stuff you can easily Google and learn as you go.
Good luck and we are all here to help if you ever get stuck
Agree completely the Purple Book is the Bible! And yes, wait for the 2nd edition at this point as it's very close. They also just released version 2 of their Mastering DAX video class on SQLBI as well which I'm looking forward to going back over.
DAX patterns is amazing as well, but maybe easier to access via web and I'm sure that will be seeing a new edition soon.
I cant' stress enough how useful the Analyzing Data/Orange Book was for me personally. It was more of a high-level overview of best practices for constructing data models which was crucial for me coming from unrelated backgrounds.
u/psykobunnyto, it sounds like you're looking to Power BI to offload operational reporting from your CRM. Lots of folks are doing that now, whereas traditionally BI folks have stuck to ad hoc or historical analysis. I've been doing LOTS of operational reporting. As Russo and Ferrari say in the latest edition of their Definitive Guide to DAX, development in DAX requires a solid grasp of theory. Googling or redditing answers will not be enough.
CRMs and other transactional databases are designed for logging transactions. Power BI needs to be optimized for reporting instead. So, when creating a reporting model for a CRM, don't recreate the relationships from the source. Instead, find your transactions, which are your fact tables. The lookup tables are then your dimensions. In this case, both User and Account are dimensions. The fact tables would be transaction tables, tables with dates and amounts on them. In CRMs, these are typically Sales tables and Service Calls tables.
CRM Data Model
The creator, owner, and specialist for the account may or may not be the same person who handles an individual transaction. What I would do is de-normalize your Account dimension (de-normalize here means to duplicate the user name in the Account dimension). Power BI dimensions are typically short and fat, with relatively few records and many columns. This enables transaction tables to stay tall and thin and perform quickly. You could bring in the names using Power Query or calc columns.
Creator Name =
^(// calculated column)LOOKUPVALUE (Users[Name],Users[User Id],Account[Creator])
Using the account table, then, you can view all transactions by creator, owner, specialist, or the user who actually handles the transaction. If you want the Account Creator, put the Account[Creator Name] on rows. If you are looking at transactional info, then put Users[Name] on rows.
For Power BI data modeling theory, I recommend two options.
One of the best resources I found for visualization design was a book named Good Charts. Rather than just giving visual examples to choose from, it goes into visual design theory and explains why some work better than others.
Good Charts
amazon has some great books on this. You can also search YouTube for dimensional modeling. Follow William McKnight for great info on this too.
Practice, practice, practice. The more DAX you wrote the more you will know...and the more you will know you don't know ;).
By the way, the book you need to read is The Definitive Guide to DAX, if you learn from this book you will know "everything". Another good source is sqlbi.com, you can find useful articles about the language.
Try our book? It's primarily about DAX and people have seemed to really like it over the years. https://www.amazon.com/dp/1615470395/ref=cm_sw_r_cp_api_i_bgT7CbMKF1V50
This is the one I got.
https://www.amazon.com/Analyzing-Visualizing-Using-Microsoft-70-778/dp/1509307028
Which one of these are you talking about?
https://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167
https://www.amazon.com/Information-Dashboard-Design-At-Glance/dp/1938377001
I found this useful>Big Book of Dashboard Design
Is the paperback version scripted in Gold Leaf by Monks?....Paperback £198.94 ($248.60)
Wow...
https://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447
Your fundamental problem is that you need to start with what you are trying to do, then work to get the data in the right shape to meet this need.
GOALS:
Show the availability of resources with a given skillset over time. You want to allow for resources to learn new skills.
DIMENSION TABLES
Now that we know what your goal is, let's look at the actors that you have defined to determine what dimensions you need.
"Show the availability of resources with a given skillset over time" The nouns in your goal will give you the dimensions that you need.
Employee- DIM_EMPLOYEE (don't call people resources... they just don't like it :) )
Skillset- DIM_SKILLSET
Time- DIM_DATE (if you are calculating availability down to the hour, then you will also need a DIM_TIME table)
FACT TABLES
"Show the availability of resources with a given skillset over time. You want to allow for resources to learn new skills." The verbs will give you what needs to go into your fact tables.
These fact tables will be a little tricky depending on how complex you want to make them.
Availability- you are looking to capture the availability of a resource and compare it to the demand for a given skill.
​
​
but... unfortunately, I have to go. I will try to add some more to this later. Hopefully, this is enough to help you a little.