Business Intelligence Fall19

For Module 1, we started with Week 2, where we were introduced to the design process of data warehouses, the four step dimensional modeling process, and as well as the Balanced Scorecard. Data warehouses differ with databases in that it performs OLAP to analyze data over a period time, by performing complex joins, to try to make a business decision. Databases on the other hand, performs OLTP and is best used for transactional data for operational purposes. Data from databases are loaded into data warehouses by using ETL to extract data from the source database, transformed, and loaded into the data warehouse. The four steps of the dimensional modeling process includes selecting the business process to model, declaring the grain of the business case, choosing the dimension tables, and lastly identifying the attributes in a fact table. We also learned about the data cube as a representation of many attributes across its axis and the operations that can be performed including slice, dice,

Three major characteristics that describe Big Data are Volume, Velocity, and Variety. Volume refers to the huge volume of data that is said to exceed a few Zettabytes by the year 2020. Velocity refers to the high velocity or speed of data that's ingested every second from all different types of sources. Lastly, Variety represents the high variety of sources of data ranging from applications, websites, to social media platforms, to QR codes. The three paradigm shift caused by Big Data are Datafication, Rich & Dynamic Content, and Large Population of Data. Datafication defines everything we do in the form of data. By evaluating trends and patterns, businesses can use these data to make recommendations, promote products or make other business innovations. The paradigm shift of Rich & Dynamic Content describe where there is a highly dynamic content containing reviews, locations, purchases, and etc. This will allow businesses to predict consumer behavior based on spatial locatio

Hello Everyone, Welcome to my blog! My name is Nanting Zheng (Aileen) and I've recently moved to San Francisco from my beautiful hometown Philadelphia. Growing up on the East Coast, I have never thought to live on the West Coast! I've decided to move to San Francisco in search of more opportunities for women in technology and to get out of my comfort zone. Overall, it has been both exciting and nervous for me at the same time. But I gotta say, the dog-friendly beach at Crissy Fields is my absolute favorite! I graduated with a bachelor's degree in Biology with and intent of becoming a doctor. It took me some time to realize that it is not of my true passion. I like connecting with people and I also enjoy analyzing data and looking for trends. This is the reason why I've started the MIS Master's Program with University of Arizona. My favorite classes so far are Data Mining for Business Intelligence and Enterprise Data Management. I enjoy using the various t