As we get ready to turn the page on another year, what steps are you taking to set your business up for success? Your data is central to your business and having the right analytics in place to capture and interpret this data is critical. To help you prepare, we compiled a list of questionsRead more
On the first day of Christmas my technology experts at SCS gave to me analytics environment design and development. (This means I don’t have to try and make meaningful comparisons out of siloed data!) On the second day of Christmas my technology experts at SCS gave to me PowerBI training. (Now I can learnRead more
Interview with Wendy Rinaldi at McGraw-Hill In anticipation of the upcoming release of one of our newest books, Data Analysis with Microsoft Power BI, currently being written by our very own, Brian Larson, we decided to reach out to McGraw-Hill Editorial Director, and longtime friend of Brian, Wendy Rinaldi. This interview will give you aRead more
It’s been just over a year since we started working with FIMC and in that amount of time the data warehouse project has come a long way! Through an iterative process, we have incorporated data covering almost all aspects of operations at FIMC, growing it into a tool that can provide comprehensive views of theRead more
We’re receiving excellent feedback on our end-of-the-year SharePoint install at FIMC. Everyone seems to be commenting on improved communication and easier project collaboration. It was a smart move by John and Dustin and is really propelling FIMC forward in terms of connectivity and efficiency. As John and Dustin update their technology and iron out operationalRead more
Welcome back! This is part 2 of our Dashboard In a Blog (or Two) series. If you missed part 1, click here [CD1] to catch up and then come back here to continue with part 1. Go ahead and open up Power BI and the file you saved in part 1. When it opens, you willRead more
If you’ve been watching the Power BI space for some time, I’m sure you’ve seen many offers to go to a seminar or watch a webinar to show you how easy it is to build a “Dashboard in a Day” or even a “Dashboard in an Hour” with Power BI. I’ve seen many of theseRead more
Power BI Query Editor Value and Table Columns Data stored as part of a transactional data processing system, for example a database to information on package deliveries, is often difficult to work with when it comes time to explore that data or create reports. This is because of a process called normalization. Data Normalization WhenRead more
One of the most intriguing features added in April 2017 is the Column From Examples functionality. You can use this feature to have Power BI craft a data transformation for you based examples of what you want the content of the new column to look like. Creating a Sample Model To demonstrate the Column FromRead more
I recently read a post on the Power BI blog about a new enhancement to the scheduled cache refresh process with DirectQuery. The post does a great job of explaining how to implement it, but I wanted to write about why you may want to consider this for your environment. As you have probably noticed,Read more
