Business Analytics with Excel (I) Get Equipped!: A Multimedia Course on Data Analysis

By Z. Justin Ren

Watch video advent at:

About the writer

Z. Justin Ren is an affiliate Professor of industrial management within the Operations and expertise administration division, Dean’s learn Fellow, and Senior Fellow of healthiness coverage Institute at Boston collage college of administration. He was once additionally a vacationing student and study associate at Massachusetts Institute of expertise (MIT) Sloan university of administration from 2009-2013.

For nearly ten years, Professor Ren has been instructing analytics classes which makes a speciality of instruments and frameworks that support managers achieve industry intelligence and make strategic judgements. He additionally teaches in government schooling in monetary threat administration. he's a professional instructor by way of the Harvard enterprise tuition Case procedure dialogue management software.

Professor Ren has consulted for Fortune 500 businesses in addition to start-ups. His paintings has been pointed out in Sloan administration evaluate, China day-by-day, and the realm monetary evaluation. He has given lectures and shows world wide at associations akin to Harvard company institution, MIT, Duke, Dartmouth, Georgetown, Emory, as an alternative (France), Hong Kong college of technological know-how and know-how, Peking collage (China), and Tsinghua college (China).

Professor Ren has bought a number of recognitions, together with the INFORMS George B. Dantzig Dissertation Award, INFORMS Junior school Paper festival Award, and the construction and Operations administration Society (POMS) Wickham Skinner Early-Career study Accomplishments Award.

Professor Ren got his M.S. in Operations learn and Ph.D. in Operations and data administration from The Wharton tuition on the collage of Pennsylvania.

Description to the Multimedia sequence

This multimedia sequence isn't really approximately studying the entire strong functionalities of Excel. it's going to no longer make you a guru on Excel. in reality, it covers a slightly small subsets of features latest in Excel.

Rather, this e-book goals that will help you develop into a greater selection maker. a greater supervisor or govt. a greater homemaker or entrepreneur. a greater philosopher.

This introductory sequence on company analytics is designed for readers who're attracted to construction analytics talents and making use of them into company occasions reminiscent of:

-How to version call for for a brand new drug?
-How to foretell inventory costs? cost inventory ideas?
-How to judge danger and uncertainty?
-How to discover intercourse discrimination from repayment information?
-Does it pay to take a position long term?

It might help you construct a suite of crucial analytics talents corresponding to:

-Finding details successfully;
-Using generic math, statistical, and fiscal services;
-Building an accurate and transparent version to research an issue;
-Scenario research to make choice lower than uncertainty;
-Summarizing details (e.g., with pivot tables);
-Finding styles between information;
-Simulation and studying hazards;
-Optimization for greater selection making.

Some key function of this multimedia sequence:
1. every one key lesson is followed by means of a how-to video
2. Templates and solutions for every instance are downloadable
3. links are supplied all through for speedy referencing and suggestions
4. outfitted for either Mac and notebook
5. loose lifetime updates of recent video clips, templates and modules.

The complete sequence has seven modules, every one in book layout:

1: uncomplicated abilities
2. version development
3. strength Analytics with facts Tables and Pivot Tables
4. Visualizing information
5. development Finding,Curve becoming, and Regression
6. challenge fixing and Optimization
7. Simulation

Whether you learn (or watch or take heed to) this multimedia sequence on a working laptop or computer, a capsule, or a telephone, you can find this new studying event intriguing, profitable and enjoyable. chuffed studying!

Show description

Preview of Business Analytics with Excel (I) Get Equipped!: A Multimedia Course on Data Analysis PDF

Best Business books

Go It Alone!: The Secret to Building a Successful Business on Your Own

There's a virus of disappointment within the American place of work. a whole 70 percentage of employees within the usa file that they're disengaged from their jobs. whilst requested, "Do you've gotten the chance to do what you do most sensible on a daily basis? " in simple terms 20 percentage of approximately 2 million staff acknowledged convinced. it's no ask yourself that fifty six percentage of all american citizens dream of beginning their very own company.

Numbersense: How to Use Big Data to Your Advantage

Easy methods to make basic feel of complicated statistics--from the writer of Numbers Rule Your global we are living in a global of huge Data--and it truly is getting higher each day. nearly each selection we make hinges on how somebody generates facts . . . and the way another individual translates it--whether we know it or now not. the place do you ship your baby for the easiest schooling?

The Innovator's Hypothesis: How Cheap Experiments Are Worth More than Good Ideas (MIT Press)

What's the top approach for a corporation to innovate? suggestion recommending "innovation vacation trips" and the luxurious of failure can be exceptional for companies with time to spend and funds to waste. The Innovator's speculation addresses the innovation priorities of businesses that stay within the actual global of limits.

Business Practice for Therapists

A useful source for college students and certified complementary therapists alike, enterprise perform for Therapists covers the foremost enterprise and perform administration parts of ITEC and NVQ skills in healing disciplines. it's crucial studying for a person contemplating constructing their very own complementary remedies enterprise.

Additional info for Business Analytics with Excel (I) Get Equipped!: A Multimedia Course on Data Analysis

Show sample text content

Find out how to upload their task functionality effectively by means of its aspect in column D? In telephone D4 of the desk less than, for instance, input =VLOOKUP(B4, $G$4:$H$9, 2, FALSE). What this does it to get the content material from B4, that is “Tom”, visit the opposite desk in $G$4:$H$9 and spot if it will probably locate an actual fit -- the final fake within the above signifies that an actual fit is needed. If there exists an actual fit, it unearths that row, and go back the content material within the 2d column - that's the “2” within the above formulation approximately - in that row. So during this instance, for “Tom”, Excel unearths it within the final row of the desk and returns “Accounting”, that is what we'd like. because we used right telephone referencing within the formulation, we will simply apply it to all different cells in column D. venture comprehensive. Approximate fit for Processing facts based on a suite of standards whilst choice standards develop into a variety of, nested IF can develop into rather bulky. We additionally want a larger manner of looking through an extended record. right here we offer instance to demonstrate how search for features in Excel will help us do this. instance (Stock Markets circulation, half II) within the Nasdaq instance mentioned prior, consider we're attracted to a extra fascinating method of visualizing the per 30 days adjustments, which variety commonly among -700 to greater than seven-hundred. specifically, we need Excel to create a brand new column and use the next symbols to symbolize various significance of alterations. goo. gl/MKb5tb goo. gl/tQut9X this fashion, one doesn't need to learn the numbers of per thirty days alterations and get a brief experience of ways the marketplace is relocating (Some may possibly discover conditional formatting can do that even more properly inside of each one telephone. that's precise. This workout in basic terms illustrate what search for features can do. ) answer lets use IF services - yet think the variety of IFs there'll be within the formulation! the finished formulation will glance anything like this: =IF(I3>=800,”|********”, IF(AND(I3>=700, I3<800),”|*******”, IF(AND(I3>=600, I3<700),”|******”, IF(AND(I3>=500, I3<600),”|*****”, IF(AND(I3>=400, I3<500),”|****”, IF(AND(I3>=300, I3<400),”|***”, IF(AND(I3>=200, I3<300),”|**”, IF(AND(I3>=100, I3<200),”|*”, IF(AND(I3>=0, I3<100), ”|”, IF(AND(I3>=-100, I3<0),”|”, IF(AND(I3>=-200, I3<-100),”*|”, IF(AND(I3>=-300, I3<-200),”**|”, IF(AND(I3>=-400, I3<-300),”***|”, IF(AND(I3>=-500, I3<-400),”****|”, IF(AND(I3>=-600, I3<-500),”*****|”, IF(AND(I3>=-700, I3<-600),”******|”, IF(AND(I3<-700), ”*******|”, ””) )))))))))))))))) think typing that right into a formulation field! and picture checking what number “)” there could be on the finish of that formulation! sincerely, IF functionality doesn't paintings the following. we want whatever larger. thankfully, Excel has presciently equipped into features referred to as VLOOKUP and HLOOKUP to house such events. using VLOOKUP comprises a number of parameters: VLOOKUP(lookup worth, the place to look up, column index,[TRUE- approximate fit, fake - distinct fit) To get a greater experience of the way to take advantage of it, allow us to use it on the matter handy right here.

Download PDF sample

Rated 4.90 of 5 – based on 50 votes