Posts

What is Data from Business Intelligence prespective?

-
Image
       Every newbie in the Business Intelligence domain has these questions, What is Data? Why everything revolves around Data? What is the importance of Data?     The key to understand Business Intelligence is through understanding data. The first thing you should know is anything can be data. It can be a document or any comment posted on social media or any video even movement of your cursor can also be stored as data. Data is a value or information about any entity that has various forms, can be stored and used to get an insightful picture of the entity.      We are in a digital world today where people are more connected to each other through phones and computers. Everything we type or record or hover is the source of data nowadays. Once the data is captured then we try to understand it with various processes and tools. When we understand it we notice the different insights of the entity which lead us to make better future decisions. Humans make decisions on facts and experience an
2 comments
Read more

Qlikview Business Intelligence Reporting Tool Overview

-
Image
    All the basic things you need to know about Qlikview are on this page. If you wish to learn anything new always start with three questions What? Why? and How? I call it my 'WWH'. Let us start with the first W. What is Qlikview?     Qlikview is a Business Intelligence reporting tool. The important features you require to know about Qlikview are: Association Rule:   Enables real-time associative search and analysis. It works like a human brain it creates its own associations. It gives us in-depth insights into the data that amaze us. Multiple Data source conn ectivity: Easily consolidate multiple data sources. In Memory processing: Loads all data into in-memory. Data compression: Massive data compression (10-to-1). Create dynamic graphs and tables. Qlikview has two proprietary file formats QVW (Qlikview workbook) and QVD (Qlikview data).  Qlikview is a product of the Qlik community. Qlik also has one more product called Qlik Sense. Qlikview is the first generation analy
Post a Comment
Read more

Data Warehouse Concepts Overview

-
Image
       If you are thinking of becoming a Business Intelligence developer you need to be good at data warehousing concepts. Commonly people take concepts of data warehousing very casually, which eventually becomes a hurdle in gaining expertise in business intelligence concepts.      Features of data warehousing that had made it so popular are: Subject-orientedness, Non-volatile data, Integrated and Organised data store. The data is segregated and stored with respect to the different subjects also called Data mart which makes it subject-oriented. We also store the historical data in a data warehouse and ideally never delete anything which makes it Non-volatile. It also establishes or Integrates a common unit of measurement after collecting data from different sources and different types. We have various schemas which makes it more organize and help us to access the data warehouse easily.       Data warehousing is a process of connecting and managing different data sources to analyze the
3 comments
Read more

Business Intelligence tools and its Categories

-
Image
 Which Business Intelligence tool I should study?  This is my client's requirement which tools are most suitable for this requirement?     These are the primary questions that every Business Intelligence developer face during the requirement understanding and planning phase. To take a precise decision in choosing the tool is very crucial. Because a lot of company cost is involved based on this decision.      To make the right choice awareness about all available tools and their features is important. From all the  available Business Intelligence tools I classify them into three broad categories based on their features. Those three categories are as follows: ETL (Extract Transform Load) Analytics  Reporting. 1. ETL (Extract Transform Load):     ETL tools will help you do the initial processing of your data. Like cleaning, removing redundant data, applying normalization forms if required, Transforming your data and making it ready for analysis or reporting. Once the extracting from s
3 comments
Read more

Introduction to Business Intelligence in simple language

-
Image
        I always get many requests to teach and guide people about how to start a career in the Business Intelligence domain or what tool I should study. There is one main question from all and that is 'where should we start?' That is the reason I got inspired to write this blog.   I have been working in this domain for many years and the most important thing I learned to became a good Business Intelligence developer is 'Vision towards your data'. It is always about the data! As we know in this digital age we collect a tremendous amount of data every second. And all you need to know about the business is in the data that you have received. To have that vision towards the data first you need to know What is Business Intelligence? and Why Business Intelligence? What is Business Intelligence?     If we break this word 'Business Intelligence' into two then, Business tells us about your work, trade, sales, employees, and numerous perspectives of your business which w
1 comment
Location: Pune, Maharashtra, India
Read more