This blog provides a journey starting with Excel and its promotion to BI, it moves on to Power BI version 2 and concludes with a much larger Azure analytical story.
Building custom controls or dataflow components for SQL Server Integration Services (SSIS) can be a bit of a “black art” for business intelligence developers or DBAs, without VB/C# application development experience. The task is not made any easier by the fact that the install procedure for MS BI development tools, and even the tool names(!), seem to keep changing with each new version of SQL Server. The original SSIS dev tool was released with SQL Server 2005 install as part of BIDS, short for Business Intelligence Development Studio. BIDS was then followed by SSDT – SQL Server Data Tools and required Visual Studio install as pre-requisite. Now with 2014, we have what is known as SSDT-BI, SQL Server Data Tools – Business Intelligence. A separate Visual Studio install is still required.
Hack what? GovHack is an international competition that brings over 1800 people together to innovate, collaborate and apply their creative skills to open government data.
What follows is the sequence of events that led to our glorious wins @ Adelaide Unleashed 2015. Chamonix IT Consulting competed in the Adelaide Unleashed 2015 (aka GovHack 2015) and subsequently having won a few glorious awards, this blog endeavours to share our approach to the competition.
Several years ago I was working at a law firm managing the BI team. It was a law firm that was really trying to push the boundaries of technology and to leverage technology as a differentiator with their competitors.
Connecting to big data Hadoop clusters from Excel is now relatively simple. But those who have tried would have noticed multiple ways to achieve what seems to be the same thing. This post aims to clear these muddy waters a bit.
In many projects the need for getting the right people to sponsor, lead and influence a change is often overlooked. People are given roles and titles within a project without the understanding of what responsibility comes with that position. This can lead to poor adoption, lack of ownership and ultimately even project failure.
What do yellow elephants, hives and pigs have in common? Is Cassandra the Zookeeper? because if so the cats need to be herded! No, stay with me, I haven’t lost it just yet! if I had, i could find it using HDFS and MapReduce processes.
