Business Intelligence and Data Analytics
13 important questions on Business Intelligence and Data Analytics
What is data warehousing?
- data from operational (OLTP) databases
- and enriched with data from external sources
Organized around the most important subjects of a company instead of applications and systems
What are OLTP databases?
- ensure fast concurrent acces to data for: transactions, concurrency control, recovery techniques
- normalization crucial: must support heavy transaction loads, should prevent update anomalies
Therefore: poor performance for executing complex queries (joining many relational tables together)
What are the key properties of a data warehouse?
- data warehouse offers a series of historical snapshots
Non-volatile:
- new data are always added
- old data remain
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
For my 1st exam I got a C. Then, I started looking for ways to learn better and I came across Study Smart. Since then I have scored a A+, A, A- and another A. I highly recommend it to everyone who wants to hear it. I am so happy with it!!
I was struggling to finish all my first-year subjects for 3 years. Then I discovered Study Smart, which helped me to finish all of them within 3 months.
Because of StudySmart, things are going well in many ways. Before, I always had study stress and no time for anything. Now I feel calm and confident (because of the program). I used to score a B, now I usually score an A or A+.
Hey Chris, I really want to thank you very much for developing the platform, I usually got around C for my exams, now I scored an A+, an A and a A- !!
Since using Study Smart, my average has increased significantly. I even completed a statistics course with a A+ while I'm bad at statistics. I took on extra courses this year, because of Study Smart. Thanks so much!
Ever since I started studying with StudySmart I passed all my exams !!! No more re-sits!! At first, I was happy with a pass and now I only get good grades. Many thanks!
I aced all the courses I studied with Study Smart. For law, I first scored a D, and now an A! I’m 100% sure that I’ll pass all the courses I study with Study Smart.
I always thought I studied well. My grades were fine. I could never have imagined that applying these study skills would have such a huge and direct impact on my grades, my speed and the pleasure I have in learning.
For the first time, I finally feel totally confident about the way I learn. I have the perfect overview and make great progress in terms of speed and the grades I get. Thanks, Chris!
I immediately started to enjoy learning again, and my grades soared. All of a sudden, everything went better. I highly recommend Study Smart to all students..
Being able to create my materials online made the process of studying so much smoother and quicker. I no longer have to spend a huge amount of my time on creating my summaries.
At first, my notes were a mess. Now I use Study Smart to take my notes in a perfectly structured way. It helps me to save a lot of time and do other things I enjoy.
Students that study with Study Smart get better grades. The system applies all the learning methods in such a way that both well-performing students and students who struggle perform much better.
Hi Chris, I would like to thank you very much. Last year I scored C on a course, and this year I got an A+ thanks to your method! Thank you very much!
The largest effect is that my child is more enthusiastic about school! Every parent wants their children to be happy at school, Study Smart made it happen.
In high school, I failed several exams, and that has really changed now. I actually needed this tool very much back then. Since I started studying with StudySmart, I haven't had any D's. My average score is now an A and those are results I would have never had in the past
With my old method, I passed only 3 out of 8 courses. Since I started taking my notes digitally in Study Smart, I have passed all my courses on the first try. For me, StudySmart takes away the stress of wondering if I will pass or not.
Thanks to StudySmart, I passed all my exams, and with better grades than before! On top of that, I have mastered a very good study method now, which I am confident will help me earn my degree.
What are the differences betwen data warehouse database vs. OLTP database?
- support of tactical and strategic decisions
- integrated: internal and external data input
- non volatile: data only read, never changed or deleted
- time dependent: data can be analyzed over time
- subject oriented: data organized around business objects
- data are often aggregated
OLTP
- support of operational processes
- not integrated
- volatile
- time independent
- transaction oriented
- data are detailed
What is the multidimensional model?
- N dimensional space: data cube or hyper cube
Dimension level or granularity level
- determined by the level of detail for each dimension
- dimensions have a hierarchical nature
Facts = cells of the data cube
- measures (value in each cell)
What is the conceptual data warehouse design?
- no well established and universally adopted conceptual model for multidimensional data
- therefore, often data warehouse design is usually directly performed at the logical level
Note
- main goal of conceptual model: communication between stakeholders
- main goal of logical model: implementation
So for datawarehousing; often difficult exercise
What logical data warehousing designs are there?
- data stored in relational tables
- pre computed aggregations stored for performance
- large space required
- OLAP performed with complex SQL statements
- relational DBMS: well standardized + large storage
Multidimensional OLAP (MOLAP)
- data cubes stored in multidimensional arrays
- verry efficient OLAP operations: performant querying
- MOLAP enginers typically support less storage
- often used for smaller "data marts" (<10 dimensions)
Hybrid OLAP (HOLAP)
- combines both previous approaches
- large volumes of data stored in a relational database
- aggregations are kept in a seprate MOLAP store
What relational data warehouse designs are there?
2, types of tables
- facts tables: normalized
- dimension tables: generally not normalized
Snowflake schema
- avoids redudancy by normalizing dimension tables
What is data staging?
- database in which the extracted data undergoes successive modifications
Steps
- data cleaning
- data transformation
- load
- refresh
What is a data warehouse tier?
What architectural variations are there?
Data mart: supporting the decisions of a specific group
1. Direct acces to the data warehouse by client tools
2. Virtual data warehouse = defines a set of views over operational databases, materialized for efficient acces
What types of data warehouse usages are there?
- ad hoc querying an reporting
- online analytival processing (OLAP0
Discovery-oriented tools (data mining)
- knowledge discovery: search for hidden patterns
- supports associations, constructing analytical models, performing classification and prediction, and presenting the mining results using visualization tools
What OLAP operations are there?
- from city -> country
Drill-down
- from year -> month
Slice
- from cube of cities to 1 city
Dice
- from cube to 2 cities and 2 months
What advanced topics are there in data warehousing?
- Trajectory data warehouses
- In memory database systems
- Real time data warehouses
- Semantic web technologies
- Multimedia data warehouses
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
