Jun 22, 2017 | Azure, Big Data, Cloud Technology
By: Jason Bacani Business Intelligence Consultant @ Key2 Consulting Trying to master Microsoft Azure can be a daunting task. I’ve spent the majority of my IT career in the SQL Server world and the database offerings alone under Azure can still be...
Jun 8, 2017 | Featured, Microsoft Power BI, Technical Information
By: Andy Kim An important part in preparing data for business intelligence is manipulating the data into usable standard formats. In PowerBI, data can be manipulated both as it’s being brought into your report as well as after you’re bringing the data into...
May 22, 2017 | Fantasy Football, Microsoft Power BI
By: Matt Wollner In my previous post, I showed how you can use Microsoft Power BI Desktop to pull data from the web and use it to create simple charts. Also, in another previous post, we laid out the steps for sharing Power BI reports. But what if you...
May 9, 2017 | SQL Server, Tech Tips
By: Matt Wollner Keyboard shortcuts play an important role in increasing the productivity of any development environment. There are myriad shortcuts that are highly beneficial in SQL Server Management Studio (SSMS), and SSMS also allows you to easily add...
May 8, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Senior BI Consultant at Key2 Consulting As was mentioned in a previous blog post comparing the pros and cons of Microsoft Azure SQL Database versus SQL Data Warehouse, Microsoft announced at SQL PASS 2016 that they are offering a free, 1-month...
