SSAS Tabular and Power BI are two cornerstones of Microsoft’s new generation of BI tools, and play quite well together out of the box. For these tips, I’ll assume you have a properly connected gateway up and running linked to a tabular model in Power BI, and that the model has been properly designed so […]
This blog was originally posted to the Piraeus Consulting blog on September 2nd, 2015 and may contain out-of-date information. Depending on the insights desired, presenting data models as cumulative, rolling totals – as opposed to showing a Grand Total broken out over periods of time – can be an invaluable tool in analyzing key business […]
This blog was originally posted to the Piraeus Consulting blog on November 24th, 2015 and may contain out-of-date information. BI in Layers This is an exciting and difficult time in Business Intelligence. The tools available are advancing at a breathtaking rate while best practices are changing equally as fast. While the tools promise to take […]
This blog was originally posted to the Piraeus Consulting blog on February 22nd, 2016 and may contain out-of-date information. For those who have followed my previous posts on the new Power BI application from Microsoft, you’ve probably already created some fantastic-looking visuals to tell the story of your data. If the art of tapping […]
This blog was originally posted to the Piraeus Consulting blog on March 14th, 2016 and may contain out-of-date information. At their October user conference, Tableau unveiled their new visualization app: Vizable. Vizable is built for the iPad and promises to empower non-professionals to represent spreadsheets visually and to manipulate data in easy-to-use charts and graphs. Dave […]
Recently, I have been working on a project involving tabular models. For the uninitiated, tabular models are a recent development in SQL/Excel PowerPivot that combine the flexibility of a conventional database with the data density of a multidimensional cube. One of the asks was to see a week over week view of the data.
This blog was originally posted to the Piraeus Consulting blog on May 31st, 2016 and may contain out-of-date information. Recently, I attended a brown bag where one of our senior consultants, let’s call her Michelle, outlined the basics of conceptual and logical data models. I’m nowhere near Michelle’s level of technical expertise, but I still […]
This blog was originally posted to the Piraeus Consulting blog on August 21st, 2014 and may contain out-of-date information. As BI professionals, we rarely lack software to support our work, but we often do lack information relevant to helping us select the right software for the right need. In its 2013 rollout of Power BI, […]
Business Intelligence (BI) is not a new concept, but technologies working in or around the BI space continue to crop up every year. As this niche of computer science continues to grow and mature, so does the credibility of the technology – enter certifications.
In the Business Intelligence (BI) world, there’s a great deal of focus on long-term report development without much focus on ad hoc as a unique development process. As new tools such as power BI, PowerPivot, and tabular models now allow for significantly improved self-service BI experiences, some of the need traditionally served by ad hoc […]
Learn How Your Company Should Go about Implementing a BI Practice and Developing A Strategy
Introduction to Big Data Frameworks for Beginners: Under the Hood of Hortonworks and Cloudera