Data Visualization is the front end of your BI system. It will be seen from the user’s point of view as the whole BI system! The reason for that is users only will see this part of the BI system, they won’t see Data Warehouse, ETL, andData Governance… What they see is only dashboards and charts explaining data values. So it is essential to do the data visualization right and effective. A good data visualization should be able to tell story behind the data. A bad data visualization won’t help users even if you have a good data warehouse or ETL design. So you should spent time to analyze ever dashboard, chart, and table and make that a good story teller to the user.
Data Governance is one of the most important aspects of BI systems, that unfortunately seen less important in many organizations. All usefulness and gratefulness of BI system will only be seen if there is a good data governance in place. If you build superb dashboards and data visualizations it won’t help until the quality of data is high. your ETL scenario won’t be so much great when there are more than one source for the same data but with different versions of it.
Data Governance and Enterprise Information Management (EIM) are concepts that needs to be covered in every organization working with the data, despite the fact that they use BI system or not. So in nutshell EIM and Data Governance are not components of BI system, they are separate systems, that can be used side by side of a BI system. However because of their very close relationship with BI system (especially because BI system is based on the data and information) we would cover them here. I would like to comment here that there won’t be a good BI system without good EIM or data governance in place.
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.
To download the Session slides click below link : A-Journey To Power BI My session God turn out in SQL Saturday Vienna An Interesting Keynote speech by Mark Souza Have fun the day after SQL Saturday around Vienna with other Speakers I have Talked about Power BI in SQL Saturday Vienna , Special Read more about SQL Saturday Vienna 2015- A Journey to Power BI[…]
I am happy to announce that my new book published today. (both paper and eBook version are available now) Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide This book covers introduction to all components of Microsoft Business Intelligence (one chapter for each component). topics that covered in the book are Dimensional Modeling, SQL Server Read more about Book Published: Microsoft SQL Server 2014 Business Intelligence Development[…]
Thank you all for attending at my presentation in TechDays 2013 Hong Kong at morning of 3rd day of conference. here you can find presentation file of my speaking session about Choosing the right Visualization Tool with Microsoft Business Intelligence Title: Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI) Description: Microsoft BI stack Read more about Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence[…]