A Message from the owner of PowerBI.Tips
Thanks for stopping by PowerBI.tips. I hope you have enjoyed the content here. This site has been dedicated to helping both new and advanced users to become familiar with PowerBI. It is a log of my journey through learning the features of PowerBI. While working on Power BI, I usually found myself always making small demos or prototypes of a new DAX formula, or a new visual. I would spend hours out side of work trying to learn more about the tool. Simply because I was passionate about data. The more I noodled through my ideas the more I thought, I will have to start teaching others at my work about this amazing tool. It saves me time, and makes refreshing data easy, and it looks way cool. from there PowerBI.tips was born.
I started working on PowerBI about two years ago when it was originally called PBI designer. I started dabbling in the program because I was started using Power Query, Power Pivot and Power View within Excel. Coming from a background in mechanical engineering I was no stranger to large amounts of data. Often I would receive multiple csv files which I would weave into a decent looking dashboard within Excel. By far the most challenging part of developing dashboards is a repeatable way to ingest data. In 2015 I discovered the massive power that is Power Query and the M language. This feature in it’s self is amazing. It simplifies the ingestion process for reading multiple files into a data model that can be used in both Excel and PowerBI. At this point I was hooked. From there I quickly became a dash-boarding fiend with Power View. Later on I learned that the same ETL and data modeling was contained in Power BI. Since then I’ve been developing dashboards as a business user.
First off, let me say thank you to all the individuals who read articles from PowerBI.Tips. You have been immensely helpful and supportive of my articles. I’d like to take a moment and introduce a great friend and now, co-worker Seth Bauer. Seth and I have been running the local Milwaukee Power BI User Group called the “Brew City” PUG for over a year now. If you’d like to join our PUG you can do so here. During our time leading the PUG, we really hit it off and just had a blast working on Power BI projects, and keeping up with the incredibly fast paced development cycle of Power BI. Seth is a wealth of knowledge that I think would benefit many readers. Thus, I have asked Seth to kindly provide a series of blogs to address the new user, and to answer the question, “What is the high-level overview of Power BI?”
Important Announcement: New Addition to PowerBI.Tips Blogging team
Please welcome Seth to the Blog and I hope you find his insights as valuable as I have.
There are many reasons that I am excited to be contributing to PowerBI.tips, but the single best one revolves around helping create a platform for new and advanced users alike to learn and expand their skills and understanding of how to get the most out of Power BI. Unlike many tools, Power BI is constantly changing and adding new features and capabilities. While this is exciting, it can also be a daunting task to keep up with. I hope by condensing what I’ve learned into series of blogs here I can help others catch up or find the information they need quickly.
I come from a technical background in SQL and I was very familiar with the Microsoft suite of tools. SQL Server, SQL Server Integration Services, Reporting Services and I had begun working with Tabular models and using Power View to visualize. I fell in love with Power Maps, and pivot tables and some of the built-in capabilities in Excel left me trying to figure out how to put it all together in the Enterprise space. About this time, I remember looking at a new offering called Power BI in SharePoint Online, and just recall thinking it looked like mini Power View reports in a sliding bar, but wasn’t really excited about it.
I recall the first day that the new trial version of Power BI (v2) first showed up as a selection in the upper right of the page. Curiosity got the best of me, I clicked the link, and my life changed. You’ll have to introduce yourself sometime in person to get the rest of the story, but suffice to say, I think highly of Power BI and I believe it has grown to be one of the best analytics tools on the market. Unlike other analytics and reporting tools it also has capabilities that drive deeper into exciting areas of integration with Data Science, Natural Language Processing, live streaming, and machine learning to name a few. From that first day till now, I’m a PowerBI’er, and I don’t recall ever having more fun.