You’ve learned about first steps for getting into BI field in previous post. In this post I’ll continue with explaining some other components of Microsoft BI and resources to learn it. Previous post was about the overall picture of BI, Data Warehouse Design, Dimensional Modelling, ETL and SSIS. In this post I’ll explore components such as SQL Server Analysis Services (SSAS) Tabular and Multi-Dimensional.
Business Intelligence is hot topics still after years of first appearance of the world in the job market. Term changed many times; Data Warehouse, Business Intelligence, Data Analysis, and Cloud BI…. BI related jobs are still high paid jobs in the market. Demand for BI is pretty high, and number of BI professionals is not that high. So it creates a niche market section for high demand jobs with high salaries. On the other hand BI is not something out of the blue for DBAs, Database Developers, Software Developers, and many IT professionals. Most of software developers build reports and analysis elements on their everyday activities. However that experience in report writing and analysis isn’t that much helpful for them if they want to step into BI jobs. For getting into BI market, you don’t only need experience in report writing, but you also need conceptual and architectural points of BI and DW systems, understanding components of BI, and learning tools of it.
Fifa 2014 is not a hot topic these days, but it was the headline news June 2014. With new capabilities in Power BI Designer I tempted to use FIFA 2014 Worldcup data as a demo of it, and play with the tool to see how it works. Fortunately I was able to build some interesting dashboards with it. The demo work was interesting enough to say that I probably would write detailed information about how to build such demo, and would use it in some of my conference speakings.
I’ve used data from official Fifa.com website for most parts of this demo. you can reach FIFA.com official site for 2014 Brazil from here:
Previously in another post I’ve mentioned what Azure Data Factory is and a sample scenario of data transfer with it.
Microsoft recently published a new version of it, which has really interesting features. In a nutshell features are:
Have a read in details about these new features below;
December last year Power BI with new great features was announced to be only available for United States. Recently Microsoft announced that Power BI is now available worldwide (Preview yet), which is great news. In this post I would like to share some facts about Power BI; Power BI is cloud BI service of Microsoft. Read more about Power BI Now Available Worldwide[…]
Full Day Training of Power BI with the title of Power BI from Rookie to Rockstar has been ran in SQL Saturday Vienna.
RADACAD presented one pre-con on Power BI, and couple of sessions; A Journey to Power BI by Leila, and ETL on Cloud? Azure Data Factory by Reza.
Power BI pre-con includes Power Query, Power Pivot, Power View, Power Map, Power Q&A, and the new Power BI Designer.
Reza’s Session at SQL PASS Rally Nordic 2015 was about Comparing Azure Data Factory and SSIS. Listen to session recording above. Session details listed below:
It is with all regret that I cannot attend at the conference that is the largest SQL event in Europe, and always compared to SQLPASS Summit because of the high quality of content and large number of audience. I was honored to be selected to speak for couple of sessions in SQLBits 2015, and I Read more about SQLBits is Awesome, But I cannot Attend! Why?![…]
Today I got a very valued feedback from a reader of my SSIS 2012 book, and based on that feedback I’ve found that I had a mistake in one of the exersizes of the book. an important note was not mentioned there. So in this post I want to mention that and applogize for any Read more about Referring SSIS Variables from SSIS Script Task[…]
Many of you worked with SSIS and are familiar with term of ETL. Azure Data Factory is Microsoft Cloud based ETL technology, which has ability to work with large volume of data, working with data sources such as SQL Server on premises, SQL Server Azure, or Azure Blob storage. Data can be transformed with Azure Read more about Introduction to Azure Data Factory[…]