Walk-through Steps: I’m New to BI, Where to Start? – Part 3 : Data Governance

bag-and-hands_w

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.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 2: Modelling with BISM

16227346893_7645a5f6f1_z

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.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 1

13903368609_760b4b4767_z

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.

[…]

Book Published: Microsoft SQL Server 2014 Business Intelligence Development

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[…]

Insert, Update, and Delete Destination table with SSIS

Previously I’ve wrote about design and implementation an UPSERT with SSIS. UPSERT is about Update existing records, and Insert new records. Today I want to extend this to cover DELETED records as well. So method used in this post can be used to find INSERTED / UPDATED / DELETED records from the source table and Read more about Insert, Update, and Delete Destination table with SSIS[…]

Script for Creating and Generating members for Time Dimension

Time Dimension is an important dimension in most of the Data Warehouses, especially when requirement for keeping hours, minutes, and seconds is vital for the business. Some blog and books and articles consider time dimension as a dimension that contains date columns, but in this post I only focus on the Time part of it, Read more about Script for Creating and Generating members for Time Dimension[…]

Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence

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[…]

Script for Creating and Generating members for Date Dimensions: General Purpose

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. Read more about Script for Creating and Generating members for Date Dimensions: General Purpose[…]