If you’re worked in the wide and diverse field of information technology for almost any amount of time, it probably hasn’t taken you long to discover that the one thing constant about IT is that the technologies and strategies involved change faster than you can learn them. And if you work in business intelligence like … Continue reading Power BI and Big Data
In the July 2015 update for Power BI Desktop there were a load of improvements to the tool including new data sources, new transformations, direct querying of SSAS Tabular Models, new Data and Relationship view, publishing directly to your Power BI site and some new visualization types. The new visualization types added to Power BI … Continue reading New Visualization Types in Power BI Desktop
If PowerPivot, Power Query, and Power View had a baby (don’t ask how) that baby would be called Power BI Desktop Designer. Yesterday the Power BI Desktop Designer was released for general availability, which I promptly downloaded last night at 11:30 PM EST and started playing with. Even as my wife turned out the light … Continue reading Power BI Desktop: My First Run Through
With an estimated 500 million Excel users in the world, it’s no wonder that Excel is the #1 business intelligence too in many organizations around the globe. And with the release of Excel 2013, the collection of powerful and flexible data analysis tools built into Excel has only continued to grow. Microsoft is constantly adding … Continue reading Choose Your Weapon: Power BI Edition
Yesterday I was working on a requirement for a client that asked me to show a list of Organizational Units and the every single parent Organization above every Organization. The source table gave each Org Unit’s ID with their parent Org Unit’s ID. In Oracle’s PSQL, this requirement was met using the Start With and … Continue reading Recursive Queries and The Power of Common Table Expressions
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful of new chart types and since I’m a huge fan of awesome data visualizations, I thought I’d take a few moments to play around with them and share my experience with you so you can … Continue reading Here’s the New #Excel 2016 Chart Types!
As a Business Intelligence Consultant, I do a decent amount of speaking, interacting with the community, and have written and contributed on a few SQL Server books. A question I’m often asked is if I can recommend any good books which brings me to this blog post. I wanted to make you aware of four … Continue reading My Top Four Books for the MS Business Intelligence Professional
This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson (blog | twitter) and I presented our session, Designing a Data Warehouse from the Ground Up. We had a great crowd and lots of great questions from the audience! Watch Designing a … Continue reading 10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )
Thanks to everyone that attended my webinar on Navigating Hierarchies with MDX! We looked at a bunch of different ways we can navigate up, down, and side to side in our hierarchies in order to do some really neat things with calculations. If you would like to view the recording, you can do that here … Continue reading Navigating Hierarchies with MDX webinar recording is now available!
Thanks to everyone that attended Devin’s and my webinar called Choosing The Right Analysis Services: MOLAP vs. Tabular. I’m pleased to announce that the recording is now available to watch for free over at PragmaticWorks.com, so please go check it out. It’s a little less than an hour so you can watch it during your … Continue reading Recording Now Available For The Webinar, Choosing The Right Analysis Services: MOLAP Vs. Tabular
